1.从CSV文件中读取数据
#!/usr/bin/env python
import csv
filename = 'ch02-data.csv'
data = []
try:
with open(filename) as f:
reader = csv.reader(f)
c = 0
for row in reader:
#读取文件头
if c == 0:
header = row
#读取剩余行
else:
data.append(row)
c += 1
#异常处理
except csv.Error as e:
print ("Error reading CSV file at line %s: %s" % (reader.line_num, e))
sys.exit(-1)
#打印结果
if header:
print (header)
print ('==================')
for datarow in data:
print (datarow)
结果:
2.