這是csv的一些行。我查看了幾個 stackexchange 問題和其他資源，但未能提出明確的解決方案。我使用 DictReader 將我的 csv 轉換為字典。我不確定如何將特定列轉換為元組鍵。我還需要過濾 2020 年。如果沒有 pandas，我也不知道該怎么做。
"year","state","state_po","county_name","county_fips","office","candidate","party","candidatevotes","totalvotes","version","mode"
2000,"ALABAMA","AL","AUTAUGA","1001","PRESIDENT","AL GORE","DEMOCRAT",4942,17208,20191203,"TOTAL"
2000,"ALABAMA","AL","AUTAUGA","1001","PRESIDENT","GEORGE W. BUSH","REPUBLICAN",11993,17208,20191203,"TOTAL"
2000,"ALABAMA","AL","AUTAUGA","1001","PRESIDENT","RALPH NADER","GREEN",160,17208,20191203,"TOTAL"
uj5u.com熱心網友回復：
字典理解可能是最 Pythonic 的方式。
import csv
with open('csv') as file:
reader = csv.DictReader(file)
data = {(i['year'], i['state_po'], i['candidate']): i['candidatevotes'] for i in reader}
之后data是：
{('2000', 'AL', 'AL GORE'): '4942',
('2000', 'AL', 'GEORGE W. BUSH'): '11993',
('2000', 'AL', 'RALPH NADER'): '160'}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/432394.html
上一篇：如何將矩陣轉換為字符？
下一篇：在python中查找字串的平均值