How to save json response to csv with columns

Question

How to save this json response to csv with columns CVE | RISKMETERScore | RiskMeterHistory

{
  "CVE-2022-22721": {
    "id": 9864403,
    "risk_meter_score": 33,
    "risk_meter_score_history": [
      {
        "changed_at": "2022-03-15T04:05:32.000Z",
        "from": 25,
        "to": 34
      },
      {
        "changed_at": "2022-03-19T05:15:12.000Z",
        "from": 34,
        "to": 30
      },
      {
        "changed_at": "2022-06-29T04:34:45.000Z",
        "from": 30,
        "to": 33
      }
    ]
  }
}

Answer 1

Using pandas, you can try this out:

#!/usr/bin/python3

import pandas as pd

pdObj = pd.read_json('cve.json', orient='index')
pdObj.to_csv('cve.csv', index=False)

firstly, prepare the JSON file. Then, use the read_json() function to convert it into a Pandas object. In the last line, you need to use the Pandas to_csv() function to convert Pandas object to CSV data or export it into a file.

checkout this stackoverflow question

In the above code, I have passed orient=’index’.

Orient is an indication of the expected JSON string format. Compatible JSON strings can be produced by to_json() with a corresponding orient value. The set of possible orients is:

‘split‘: dict like {index -> [index], columns ->
, data -> [values]}
‘records‘: list like [{column -> value}, … , {column -> value}]
‘index‘: dict like {index -> {column -> value}}
‘columns‘: dict like {column -> {index -> value}}
‘values‘: just the values array

You can go through the above options to achieve your desired result.