Unnesting json data from a DataFrame with missing values

Question

I'm new to python. I have a simple DataFrame with a .json string I'd like to unnest.

import pandas as pd
df = pd.DataFrame([None, {'name': 'Charlie'}], columns=['A'])
pd.json_normalize(df, record_path=['A'], meta=['name'])

The following is giving me a "TypeError: string indices must be integers" error.

I have not had any luck with similar fixes such as making my df into a dict[1] or by using a lambda function[2].

I wanted the column to be replace by the values. Thanks @not_speshal that's correct! — John-Henry
– John-Henry, Commented May 5, 2022 at 17:56

not_speshal · Accepted Answer · 2022-05-05 17:58:29Z

1

Try:

df = pd.json_normalize(df["A"].fillna("").apply(dict).tolist())

answered May 5, 2022 at 17:58

not_speshal

23.2k2 gold badges18 silver badges33 bronze badges

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

1 Answer 1