Nest In A Nest Json Model To Sql Table
here is an example json. Previously, I was able to solve for Attachments and tags not being nested and as induvidual columns. Any help is deeply appreaciated! { 'Volumes': [{
Solution 1:
you can do it this way:
In [1]: fn = r'D:\temp\.data\40454898.json'
In [2]: withopen(fn) as f:
...: data = json.load(f)
...:
In [14]: t = pd.io.json.json_normalize(data['Volumes'],
...: ['Attachments','Tags'],
...: [['Attachments', 'VolumeId'],
...: ['Attachments', 'InstanceId']])
...:
In [15]: t
Out[15]:
Key Value Attachments.InstanceId Attachments.VolumeId
0 Name DBJanitor-Private i-1234567890abcdef0 vol-049df61146c4d7901
1 Owner DBJanitor i-1234567890abcdef0 vol-049df61146c4d7901
2 Product Database i-1234567890abcdef0 vol-049df61146c4d7901
3 Portfolio DB Janitor i-1234567890abcdef0 vol-049df61146c4d7901
4 Service DB Service i-1234567890abcdef0 vol-049df61146c4d7901
NOTE: second argument ['Attachments','Tags']
is a path to to our nested record (data['Values']->Attachments->Tags
) and third argument [['Attachments', 'VolumeId'], ['Attachments', 'InstanceId']]
is a path to outer metadata (data['Values']->Attachments->VolumeId
, data['Values']->Attachments->InstanceId
)
Post a Comment for "Nest In A Nest Json Model To Sql Table"