Convert a Json to csv using python pandas

Question

I have a json file in the below format that I need to convert to csv in python.

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

I need to convert the above into a csv with the below fields:

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

How do I do this using python / dataframe?

What have you tried so far? Convert JSON to DataFrame, then DataFrame to CSV. — Irfanuddin, Jul 12 '22 at 22:47
Does this answer your question? [Writing a pandas DataFrame to CSV file](https://stackoverflow.com/questions/16923281/writing-a-pandas-dataframe-to-csv-file) — Irfanuddin, Jul 12 '22 at 22:49
https://stackoverflow.com/questions/63505055/save-dataframe-as-csv-in-python — Irfanuddin, Jul 12 '22 at 22:50

score 2 · Accepted Answer · answered Jul 12 '22 at 22:58

Its easy to do

>>> 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)

Convert a Json to csv using python pandas

1 Answers1