Python Forum
Filling in missing values
Thread Rating:
  • 1 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Filling in missing values
#3
Thanks! here is the code to normalize the json table. From there fillna(method='bfill') does not fill in missing values in the 'name' column

import pandas as pd
import json
from pandas.io.json import json_normalize
import numpy as np
#loading data in file 
file = "world_bank_projects.json"
with open(file) as json_file:
    json_data = json.load(json_file)
#normalizing data with project name column. 
fill = json_normalize(json_data,'mjtheme_namecode', 'project_name')
fill.head(25)
Reply


Messages In This Thread
Filling in missing values - by melm0 - Aug-08-2017, 08:44 PM
RE: Filling in missing values - by Bass - Aug-08-2017, 08:46 PM
RE: Filling in missing values - by melm0 - Aug-09-2017, 12:52 AM
RE: Filling in missing values - by sparkz_alot - Aug-09-2017, 11:50 AM
RE: Filling in missing values - by radioactive9 - Aug-09-2017, 03:59 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Filling NaNs in a financial dataset larzz 11 2,151 Jun-07-2023, 03:40 PM
Last Post: snippsat
  groupby on var with missing values error zenvega 0 1,808 May-07-2021, 07:40 PM
Last Post: zenvega

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020