Normalize JSON data into a flat table. data=[{'id':1, 'name':{'first':'Coleen', 'last':'Volk'}}, {'name':{'given':'Mose','family':'Regner'}}, {'id':2, 'name':'Faye Raker'}] pd.json_normalize(data) >>> idname.firstname.lastname.givenname.familyname 01.0ColeenVolkNaNNaNNaN 1NaNNaNNaNMoseRegnerNaN 22.0NaNNaNNaNNaNFaye Raker data=[{'state':'florida', 'shortname':'FL', 'info':{'governor':'rick scott'..