How to Normalize JSON data into a pandas dataframe with json_normalize

Question

I'm trying to transform this complex object into a pandas dataframe

data={
    "customers": [
        {
            "a": 'true',
            "addresses": [{"city": "Park"}],
            "c": { "address1": "200"},
            "d": "[email protected]",
            "e": {"f": "sub"},
            "h": 100,
           
        }
    ]
}

I've tried several ways but none of them work.

df = pd.json_normalize(data,record_path='addresses',meta=['h'] ,record_prefix='adr'
                               ,errors='ignore')

I always get the same error

KeyError: "Key 'addresses' not found. If specifying a record_path, all elements of data should have the path."

Jason Baker · Accepted Answer · 2023-09-28 20:26:17Z

1

Your first key is "customers":

df = pd.json_normalize(
    data=data.get("customers"),
    record_path="addresses",
    meta="h",
    record_prefix="adr"
)

print(df)

answered Sep 28, 2023 at 20:26

Jason Baker

3,7262 gold badges14 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Normalize JSON data into a pandas dataframe with json_normalize

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related