我有一個 csv 資料集,它在 python 中使用 DictReader 打開,我希望將鍵和值分開。
import csv
with open ('student_marks.txt') as csv_file:
csv_reader = csv.DictReader(csv_file)
for keys in csv_reader:
print(keys)
我有這個輸出,我希望將輸出中的鍵和值分開
{'Student ID': '4665178', 'Homework Total (20%)': '95.9', 'Project 1 (10%)': '91.9', 'Midterm (20%)': '91.2', 'Project 2 (10%)': '90.9', 'Final (40%)': '99'}
{'Student ID': '4665187', 'Homework Total (20%)': '83.1', 'Project 1 (10%)': '83', 'Midterm (20%)': '75.7', 'Project 2 (10%)': '92', 'Final (40%)': '78.6'}
{'Student ID': '4665203', 'Homework Total (20%)': '89.9', 'Project 1 (10%)': '73.6', 'Midterm (20%)': '98.9', 'Project 2 (10%)': '84.1', 'Final (40%)': '95.2'}
{'Student ID': '4665219', 'Homework Total (20%)': '81.3', 'Project 1 (10%)': '88.5', 'Midterm (20%)': '84.8', 'Project 2 (10%)': '81.2', 'Final (40%)': '91.1'}
uj5u.com熱心網友回復:
您可以像這樣使用內置方法:
import csv
with open('student_marks.txt') as csv_file:
csv_reader = csv.DictReader(csv_file)
for i in csv_reader:
print(list(i.keys()))
print(list(i.values()))
i.keys 方法將始終在每次迭代中回傳相同的標題或 csv 檔案的第一行。
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/373890.html
上一篇:什么時候參考鑄造切片物件?
下一篇:追加時的奇怪格式-JSON
