使用python pandas将Json转换为csv

Question

我有一个json文件，格式如下，我需要在python中转换为csv。

{
"data": {
"clientApplicationRsaKeyss": [
{
"clientId": "abc-efg",
"createdOn": "2021-02-26T08:45:43.2746397Z"
},
{
"clientId": "xyz-lmn",
"createdOn": "2022-05-23T16:11:59.435729Z"
},
]
}
}

我需要将上面的内容转换为具有以下字段的csv:

clientID          createdon
abc-efg          2021-02-26T08:45:43.2746397Z
xyz-lmn          2022-05-23T16:11:59.435729Z

我如何使用python/dataframe做到这一点?

Answer 1

这很容易做到

>>> df = pd.DataFrame(json.load(open("test.json"))["data"]["clientApplicationRsaKeyss"])
>>> df 
clientId                     createdOn
0  abc-efg  2021-02-26T08:45:43.2746397Z
1  xyz-lmn   2022-05-23T16:11:59.435729Z
>>> df.to_csv(".....", index=False)