Python read/write CSV file

CSV Module method

Csv.reader

Import csv with open (' temp.csv ', ' RB ') as F:reader = Csv.reader (f) for row in Reader:print row

Csv.writer

Import csv with open (' Temp.csv ', ' WB ') as F:writer = Csv.writer (f) writer.writerow ([' A ', ' B ', ' C ']) W Riter.writerow ([' d ', ' e ', ' f '])

CSV Module class

Csv. Dictreader

Import csv with open (' temp.csv ') as F:reader = csv. Dictreader (f) for row in reader print (row[' first_name '],row[' last_name ')

Csv. Dictwriter

Import Csvwith 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 Module exception

Csv. Error

Import 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))

Read objects (Dictreader instances and objects returned by the reader () function) public methods

Csvreader.next () Csvreader.line_num csvreader.fieldnames

Write Objects (Dictwriter instances and objects returned by the writer () function) public methods

Csvwriter.writerow (Row) csvwriter.writerows (rows) Csvwriter.writeheader ()

This article is from the SQL Server deep dives blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1704615

Python read/write CSV file