Re: pandas - get subelements

2021-07-12 Thread Marchello
Hi team, It worked for me this way: df3 = pd.json_normalize(json2["value"], "Addresses") print(df3) ContactId AssociatedEntity 0 35aa05d1-21c7-493d-96e3-3c966732 ac7a9ec8-b71b-486b-8b3b-41b6bc11f936 1 ca717463-734d-4f2f-a01e-6ff0c806 bda08493-7ae0-47cf-8d3

pandas - get subelements

2021-07-12 Thread Marchello
Hi team, My need is to extract particular sub-elements (ContactId and AssociatedEntity) from below json using pandas. Json: { "odata.metadata": "https://example1.com/odata/$metadata#Contacts";, "value": [ { "Addresses": [ { "ContactId": "35aa05d1-21c7-493d-96e