如何在python中将json的内容写入csv文件？

Question

我有一个json文件返回值的列表

2020-09-08 - 11290
2020-09-09 - 11290
2020-09-10 - 11290
2020-09-11 - 12290

我将上述值保存到变量“data”中。这些值通过使用print（data）从json列表返回

print(f"{node['X']} - {node['Y']}") #print(data)

我希望将此返回值列表放入一个csv文件，文件头为“X”和“Y”

fieldnames = ['X', 'Y']
with open('mydata.csv', 'w') as f:
    writer = csv.DictWriter(f, fieldnames=fieldnames)
    writer.writeheader()
    writer.writerows(chain.from_iterable(data))

这段代码只返回两个标题为“X”和“Y”的空数据 如果我能得到一个建议或一个有一些例子的解决方案，那就太好了。 谢谢你的帮助

Answer 1

我认为值得一提的是您的previous question，或者至少提供与您试图编写的数据相关的更多详细信息

无论如何，这应该能满足你的需求：

import csv
import requests

response = requests.get('https://www.prisjakt.nu/_internal/graphql?release=2020-11-20T07:33:45Z|db08e4bc&version=6f2bf5&main=product&variables={"id":5183925,"offset":0,"section":"statistics","statisticsTime":"1970-01-02","marketCode":"se","personalizationExcludeCategories":[],"userActions":true,"badges":true,"media":true,"campaign":true,"relatedProducts":true,"campaignDeals":true,"priceHistory":true,"recommendations":true,"campaignId":2,"personalizationClientId":"","pulseEnvironmentId":"sdrn:schibsted:environment:undefined"}').json()

with open("your_data.csv", "w") as output:
    w = csv.DictWriter(output, fieldnames={"date", "lowestPrice"})
    w.writeheader()
    for node in response["data"]["product"]["statistics"]["nodes"]:
        w.writerow(node)

.csv文件的输出：

lowestPrice,date
13195,2019-09-10
12990,2019-09-11
12990,2019-09-12
12605,2019-09-13
12605,2019-09-14
12605,2019-09-15
12970,2019-09-16
12970,2019-09-17
12970,2019-09-18
...