Python json to CSV

Question

I am trying to convert a json data set file into csv. I am really new to python, and have been looking on the forums and cannot seem to resolve my issues. I have attached the json data url link in below along with my code. Thanks in advance!

https://data.ny.gov/api/views/nqur-w4p7/rows.json?accessType=DOWNLOAD

import json
import csv

    inputFile = ("rows.json?accessType=DOWNLOAD", "r")
    data = json.load(inputFile)

    with open("Data.csv","wb") as csvfile:
      csv_writer = csv.DictWriter(csvfile,delimiter=",", fieldnames=["data", "new_york_state_average_gal", "albany_average_gal", "binghamton_average_gal", "bu\
    ffalo_average_gal", "nassau_average_gal", "new_york_city_average_gal", "rochester_average_gal", "utica_average_gal"])
      csv_writer.writerheader()
      csv_writer.writerows(data)

Here is the error I am getting:

  File "ChangeDataType.py", line 5, in <module>
    data = json.load(inputFile)
  File "/usr/lib64/python3.4/json/__init__.py", line 265, in load
    return loads(fp.read(),
AttributeError: 'tuple' object has no attribute 'read'

You're missing the word open...

jonrsharpe
– jonrsharpe

2017-11-30 17:33:26 +00:00
Commented Nov 30, 2017 at 17:33 — jonrsharpe
– jonrsharpe, Commented Nov 30, 2017 at 17:33
Change it to data = json.load(open(inputFile))

ayrusme
– ayrusme

2017-11-30 17:34:17 +00:00
Commented Nov 30, 2017 at 17:34 — ayrusme
– ayrusme, Commented Nov 30, 2017 at 17:34
@DustinSmith that should be a separate question.

Pike D.
– Pike D.

2017-11-30 17:37:40 +00:00
Commented Nov 30, 2017 at 17:37 — Pike D.
– Pike D., Commented Nov 30, 2017 at 17:37

nosklo · Accepted Answer · 2017-11-30 17:39:33Z

0

Your error happens because you made a tuple:

inputFile = ("rows.json?accessType=DOWNLOAD", "r")

And you're trying to use json.load in that tuple. Since json.load works only on files, you need to call the open function:

inputFile = open("rows.json?accessType=DOWNLOAD", "r")

The "r" part indicates you're opening the file for reading.

answered Nov 30, 2017 at 17:39

nosklo

224k58 gold badges300 silver badges299 bronze badges

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

Collectives™ on Stack Overflow

Python json to CSV

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related