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)