读写 csv 文件也有现成的库
dialect 就是某个格式的 csv 的 pattern 分析器
a.txt
-------------------------------------------------
a,b,c,d,e
1,2,,
-------------------------------------------------
csv.reader()
-------------------------------------------------
import csv
f = csv.reader(open('a.txt', 'rb')) # delimiter = ','
for row in f:
print row
['a', 'b', 'c', 'd', 'e']
['1', '2', '', '']
-------------------------------------------------
csv.writer()
-------------------------------------------------
import csv
f = csv.writer(open('a.txt', 'wb')) # delimiter = ','
f.writerow(['a', 'b', 'c', 'd', 'e'])
f.writerow(['1', '2', '', ''])
-------------------------------------------------
csv.Sniffer, 自动分析.csv文件的pattern, 生成 dialect
-------------------------------------------------
csvfile = open("example.csv", "rb")
dialect = csv.Sniffer().sniff(csvfile.read(1024))
csvfile.seek(0)
reader = csv.reader(csvfile, dialect)
-------------------------------------------------
评论