擅长:python、mysql、java
<p>如果您的真正目标是将数据存储在电子表格中,请尝试以下程序:</p>
<pre><code>import requests
import csv
import json
base_url="https://represent.opennorth.ca/candidates/house-of-commons/?limit=250&offset={}"
#base_filename=r"F:\electoral_map\candidates_python\candidates{0}_to_{1}.csv"
base_filename=r"candidates{0}_to_{1}.csv"
keys = [
'name',
'first_name',
'last_name',
'election_name',
'elected_office',
'district_name',
'email',
'incumbent',
'party_name',
'personal_url',
'photo_url',
'source_url',
'url',
]
for i in range(0, 2000, 250):
url = base_url.format(i)
filename=base_filename.format(i, i+250)
data = requests.get(url)
data = data.text
data = json.loads(data)
data = data['objects']
with open(filename, 'wt', encoding='utf-8') as f:
w = csv.DictWriter(f, keys, extrasaction='ignore')
w.writeheader()
w.writerows(data)
</code></pre>
<p>注意:这个程序需要Python3。如果你用的是Python2,告诉我,我会给你一个在那里工作的版本。在</p>