python - Parse JSON array into csv file

Question

I have a JSON response in the form of a JSON object from a request in the pattern:

{"a":[1,2,3,4,5],"b":[I,II,III,IV,V],"c":[p,q,r,s,t]}

How can I parse this json object into a csv file in python containing a,b,c as column names and the values as data in rows as:

a    b      c
1    I      p
2    II     q
3    III    r
4    IV     s
5    V      t

Code for json response:

url="some url"

page=requests.get(url)
output = page.json()

The closest answer I got to was in How can I convert JSON to CSV?

I have tried to convert it into a pandas dataframe and iterate through it but I can't get the work around with it with my JSON object.

question from:https://stackoverflow.com/questions/65923419/parse-json-array-into-csv-file

Answer 1

pip3 install pandas

Install the Pandas library with the above command.

import pandas as pd

output = {
    "a": [1, 2, 3, 4, 5],
    "b": ["I", "II", "III", "IV", "V"],
    "c": ["p", "q", "r", "s", "t"],
}

df = pd.DataFrame(output)
df.to_csv("filename.csv", index=False, encoding="utf-8")

Output: