回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我试图从JSON格式的数据中写出一个csv文件。我可以获取要写入csv文件的字段名,但不能获取所需的项值。这是我第一次用python编写代码,所以任何帮助都将不胜感激。json文件可在下面找到以供参考:</p>
<p><a href="https://data.ny.gov/api/views/nqur-w4p7/rows.json?accessType=DOWNLOAD" rel="nofollow noreferrer">https://data.ny.gov/api/views/nqur-w4p7/rows.json?accessType=DOWNLOAD</a></p>
<p>这是我的错误:</p>
<pre><code>Traceback (most recent call last):
File "ChangeDataType.py", line 5, in <module>
data = json.dumps(inputFile)
File "/usr/lib64/python3.4/json/__init__.py", line 230, in dumps
return _default_encoder.encode(obj)
File "/usr/lib64/python3.4/json/encoder.py", line 192, in encode
chunks = self.iterencode(o, _one_shot=True)
File "/usr/lib64/python3.4/json/encoder.py", line 250, in iterencode
return _iterencode(o, 0)
File "/usr/lib64/python3.4/json/encoder.py", line 173, in default
raise TypeError(repr(o) + " is not JSON serializable")
TypeError: <_io.TextIOWrapper name='rows.json?accessType=DOWNLOAD' mode='r' encoding='UTF-8'> is not JSON serializable
</code></pre>
<p>这是我的密码:</p>
<pre><code>import json
import csv
inputFile = open("rows.json?accessType=DOWNLOAD", "r")
data = json.dumps(inputFile)
with open("Data.csv","w") as csvfile:
writer = csv.DictWriter(csvfile, extrasaction='ignore', fieldnames=["date", "new_york_state_average_gal", "albany_average_gal", "binghamton_average_gal",\
"buffalo_average_gal", "nassau_average_gal", "new_york_city_average_gal", "rochester_average_gal", "syracuse_average_gal","utica_average_gal"])
writer.writeheader()
for row in data:
writer.writerow([row["date"], row["new_york_state_average_gal"], row["albany_average_gal"], row["binghamton_average_gal"],\
row["buffalo_average_gal"], row["nassau_average_gal"], row["new_york_city_average_gal"], row["rochester_average_gal"], row["syracuse\
_average_gal"],row["utica_average_gal"]])
</code></pre>