json_规格化的反转

2024-09-27 21:26:18 发布

您现在位置:Python中文网/ 问答频道 /正文

可以使用pandas.io.json.json_normalize从嵌套的json文件中读取。是否可以从列具有适当名称的pd.DataFrame写入嵌套json

MWE(来自链接页面的文档):

>>> from pandas.io.json import json_normalize
>>> data = [{'id': 1, 'name': {'first': 'Coleen', 'last': 'Volk'}},
...         {'name': {'given': 'Mose', 'family': 'Regner'}},
...         {'id': 2, 'name': 'Faye Raker'}]
>>> df = json_normalize(data)
    id        name name.family name.first name.given name.last
0  1.0         NaN         NaN     Coleen        NaN      Volk
1  NaN         NaN      Regner        NaN       Mose       NaN
2  2.0  Faye Raker         NaN        NaN        NaN       NaN
>>> # Here I would like to do "to_json_normalize(df)" to recover "data"

Tags: tonameioidjsonpandasdatanan

热门问题