objectif

Aplatir des objets JSON imbriqués en colonnes.

code minimal

import pandas as pd
data = [{"id":1,"user":{"name":"a"}},{"id":2,"user":{"name":"b"}}]
df = pd.json_normalize(data)
print("user.name" in df.columns)

utilisation

import pandas as pd
d = [{"a":{"b":1}}, {"a":{"b":2}}]
print(pd.json_normalize(d, sep="_").columns.tolist())

variante(s) utile(s)

import pandas as pd
d = [{"id":1,"items":[{"k":1},{"k":2}]}]
print(pd.json_normalize(d, record_path="items", meta=["id"]).shape[0])

notes

• Utiliser record_path pour listes imbriquées.