使用请求模块导出csv-Usingrequestsmoduletoexportcsv

6  

Since the response is a Json, load the json data with:

由于响应是Json，因此使用以下命令加载json数据：

data = r.json()["results"] # read the json response and keep the results part

and then write to the csv file:

然后写入csv文件：

with open("guns.csv", "wb") as csvfile:
    f = csv.writer(csvfile)
    f.writerow(["Count", "Month"]) # write the headers if you like
    for elem in data:
        f.writerow([elem["count"], elem["month"]])

1  

if CSV package is not mandatory you can use the normal output operation and save the file with CSV. CSV is just a txt file with cols seperated by comma.

如果CSV包不是必需的，您可以使用正常输出操作并使用CSV保存文件。 CSV只是一个txt文件，其中cols由逗号分隔。

here how you can do this.

在这里你如何做到这一点。

with open("abc.csv","w+") as fh:
    str = "count: 62.0"

    str = str + ",month: 201212" 

    fh.writeline(str)

1  

I'd like to add a bit of explanation to what @thikonom has said above.

我想对@thikonom上面所说的内容添加一些解释。

r.json()

When you're using r.json(), you're interpreting what is in r as json. A hint was given to your data being json in the query string you sent. If you're familiar with json, the results also look like json.

当你使用r.json（）时，你正在将r中的内容解释为json。在您发送的查询字符串中，您的数据被提示为json。如果你熟悉json，结果也看起来像json。

r.json()["results"]

You're now telling json to search your results r for the dictionary with the key: results. Being able to see what you're expecting from the query is a big help here, where results is shown in the results you've pasted into the window above. We also recognize that it's displayed in the standard way that a dictionary is shown:

您现在告诉json使用关键字搜索结果r中的字典：结果。能够看到您对查询的期望是一个很大的帮助，其中结果显示在您粘贴到上面窗口的结果中。我们也认识到它以标准方式显示字典：

{'results': [{'month': '201212', 'count': 62.0}...

and so on. results in this case is the key, the rest of the data after the : is considered the key's value. Using ~> r.json()["results"] <~ returns results value. However, you'll notice that 'month' and 'count' are also wrapped in {}, meaning they are each in themselves key, value pairs. This means you've got dictionaries nested within dictionaries!

等等。在这种情况下结果是关键，其后的数据是：被认为是键的值。使用〜> r.json（）[“results”] <〜返回结果值。但是，您会注意到'month'和'count'也包含在{}中，这意味着它们本身就是键值对。这意味着你有词典嵌套在词典中！

f.writerow([elem["count"], elem["month"]])

Going through, row by row, pulling out the value for both keys: count and month, which you then store into your *.csv file.

逐行完成，拉出两个键的值：count和month，然后存储到* .csv文件中。

Hope this may help somebody else!

希望这可以帮助别人！