Python json到CSV

Question

我正在尝试将json数据集文件转换为csv。我对python很陌生，一直在论坛上找，似乎无法解决我的问题。我在下面的代码中附加了json数据url链接。提前谢谢！在

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)

以下是我得到的错误：

^{pr2}$

Answer 1

发生错误是因为您创建了一个元组：

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

您正试图在元组中使用json.load。由于json.load只对文件有效，因此需要调用open函数：

^{pr2}$

"r"部分表示正在打开文件进行读取。在