python处理csv文件 sql_Python读写CSV文件

csv模块方法

csv.readerimport csv

with open('temp.csv','rb') as f:

reader = csv.reader(f)

for row in reader:

print row

csv.writerimport csv

with open('temp.csv','wb') as f:

writer = csv.writer(f)

writer.writerow(['a','b','c'])

writer.writerow(['d','e','f'])

csv模块类

csv.DictReaderimport csv

with open('temp.csv') as f:

reader = csv.DictReader(f)

for row in reader

print(row['first_name'],row['last_name'])

csv.DictWriterimport csv

with open('temp.csv','w') as f:

fieldnames = ['first_name','last_name']

writer = csv.DictWriter(f, fieldnames=fieldnames)

writer.writeheader()

writer.writerow({'first_name':'ryan', 'last_name':'xu'})

writer.writerow({'first_name':'koko', 'last_name':'xu'})

csv模块异常

csv.Errorimport csv, sys

filename = 'some.csv'

with open(filename, 'rb') as f:

reader = csv.reader(f)

try:

for row in reader:

print row

except csv.Error as e:

sys.exit('file %s, line %d: %s' % (filename, reader.line_num, e))

读对象（DictReader实例和reader()函数返回的对象）公共方法csvreader.next()

csvreader.line_num

csvreader.fieldnames

写对象（DictWriter实例和writer()函数返回的对象）公共方法csvwriter.writerow(row)

csvwriter.writerows(rows)

csvwriter.writeheader()