rafaan

import json
from pandas.io.json import json_normalize
import pandas as pd

with open('C:\filename.json') as f:
    data = json.load(f)

df = pd.DataFrame(data)   

normalized_df = json_normalize(df['nested_json_object'])