查了好多篇博客文章,试了半天终于找到了自己满意的代码~~~
对于大多数的CSV格式的数据读写问题,都可以使用 csv
库。 例如:假设你在一个名叫stocks.csv文件中有一些股票市场数据,就像这样:
Symbol,Price,Date,Time,Change,Volume
"AA",39.48,"6/11/2007","9:36am",-0.18,181800
"AIG",71.38,"6/11/2007","9:36am",-0.15,195500
"AXP",62.58,"6/11/2007","9:36am",-0.46,935000
"BA",98.31,"6/11/2007","9:36am",+0.12,104800
"C",53.08,"6/11/2007","9:36am",-0.25,360900
"CAT",78.29,"6/11/2007","9:36am",-0.23,225400
下面向你展示如何将这些数据读取为一个元组的序列:
import csv
with open('stocks.csv') as f:
f_csv = csv.reader(f)
headers = next(f_csv)
for row in f_csv:
# Process row
...
在上面的代码中, row
会是一个列表。因此,为了访问某个字段,你需要使用下标,如 row[0]
访问Symbol, row[4]
访问Change。
由于这种下标访问通常会引起混淆,你可以考虑使用命名元组。例如: