我需要知道如何將抓取的數(shù)據(jù)保存到 csv 文件中，這是代碼import requestsimport jsonparameters = ['a:1','a:2','a:3','a:4','a:3','a:4','a:5','a:6','a:7','a:8','a:9','a:10',]for item in parameters: key, value = item.split(':')[0], item.split(':')[1] url = "https://xxxx.000webhostapp.com/getNamesEnc02Motasel2.php?keyword=%s&type=2&limit=%s" %(key, value) r = requests.get(url) cont = json.loads(r.content) print(cont)和輸出一樣[{'name': 'Absz', 'phone': '66343212'}, {'name': 'ddd ', 'phone': '545432211'}, {'name': 'ezd' 'phone':'54856886'}]我想將所有數(shù)據(jù)存儲在CSV文件或文本文件中我怎么能做到這一點？
1 回答
牧羊人nacy
TA貢獻1862條經(jīng)驗 獲得超7個贊
比較簡單的任務。你沒有嘗試搜索這個，因為有很多將字典轉換為 csv 文件的例子嗎？
import requests
import json
import pandas as pd
parameters = ['a:1','a:2','a:3','a:4','a:3','a:4','a:5','a:6','a:7','a:8','a:9','a:10']
results = pd.DataFrame()
for item in parameters:
key, value = item.split(':')
url = "https://xxxx.000webhostapp.com/getNamesEnc02Motasel2.php?keyword=%s&type=2&limit=%s" %(key, value)
try:
r = requests.get(url)
cont = json.loads(r.content)
temp_df = pd.DataFrame(cont)
results = results.append(temp_df)
except:
continue
results.to_csv('path/to/filename.csv', index=False)
添加回答
舉報
0/150
提交
取消