回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个JSON文件,我正试图转换成CSV来获取数据。然而,我得到的结果远远不正确。你知道吗</p>
<p>到目前为止,我已经:</p>
<pre><code>import csv
import json
infile = open("top40nl.json", "r")
outfile = open("top40nl.csv", "w")
writer = csv.writer(outfile)
for row in json.loads(infile.read()):
writer.writerow(row)
</code></pre>
<p>使用这种类型的JSON数据(例如):</p>
<pre><code>{
"info": "SQLite Pro Result Set",
"data": [
{
"top40_SK": "118899",
"song_title": "Sorry",
"artist": "Justin Bieber",
"year_released": "2015",
"year": "2016",
"week": "1",
"position": "1",
"prev_position": "1",
"weeks_in_top40_v1": "10",
"weeks_in_top40_v2": "10",
"highest_reached_position": "1",
"total_points": "775",
"top40url": "https://www.top40.nl/top40/2016/week-1"
},
{
"top40_SK": "118900",
"song_title": "Love yourself",
"artist": "Justin Bieber",
"year_released": "2015",
"year": "2016",
"week": "1",
"position": "2",
"prev_position": "2",
"weeks_in_top40_v1": "6",
"weeks_in_top40_v2": "6",
"highest_reached_position": "1",
"total_points": "764",
"top40url": "https://www.top40.nl/top40/2016/week-1"
}
]
}
</code></pre>
<p>到目前为止,上述所有方法都有效,但这是我的成果:
<code>i,n,f,o</code>
<code>d,a,t,a</code></p>
<p>你知道怎么解决这个问题吗?你知道吗</p>