Unable to convert JSON file to CSV using Python

Question

I was trying to convert the below JSON file into a csv file.

JSON file

[{
"SubmitID":1, "Worksheet":3, "UserID":65,
 "Q1":"395",
 "Q2":"2178",
 "Q3":"2699",
 "Q4":"1494"},{
 "SubmitID":2, "Worksheet":3, "UserID":65,
  "Q4":"1394"},{
 "SubmitID":3, "Worksheet":4, "UserID":65,
  "Q1":"1629",
  "Q2":"1950",
  "Q3":"0117",
  "Q4":"1816",
 "Empty":" "}]

However, my Python code below gives the error message "TypeError: Expected String or Unicode". May I know how should I modify my program to make it work?

import json
import pandas as pd

f2 = open('temp.json')
useful_input = json.load(f2)
df=pd.read_json(useful_input)
print(df)
df.to_csv('results.csv')

Akavall · Accepted Answer · 2015-11-08 02:59:27Z

4

You just need to pass the address string to pd.read_json():

df=pd.read_json("temp.json")

edited Nov 8, 2015 at 2:59

answered Nov 8, 2015 at 2:51

Akavall

86.8k58 gold badges214 silver badges261 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martín Muñoz del Río · Accepted Answer · 2015-11-08 02:56:16Z

4

You have not to use json module:

Try:

import pandas as pd

df=pd.read_json("temp.json")
print(df)
df.to_csv('results.csv')

answered Nov 8, 2015 at 2:56

Martín Muñoz del Río

1,96813 silver badges14 bronze badges

Comments

KS HARSHA · Accepted Answer · 2017-09-16 03:22:05Z

1

import pandas as pd
df = pd.read_json('data.json')
df.to_csv('data.csv', index=False, columns=['title', 'subtitle', 'date', 'description'])

import pandas as pd
df = pd.read_csv("data.csv")
df = df[df.columns[:4]]
df.dropna(how='all')
df.to_json('data.json', orient='records')

answered Sep 16, 2017 at 3:22

KS HARSHA

673 silver badges7 bronze badges

Collectives™ on Stack Overflow

Unable to convert JSON file to CSV using Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related