How to read and write csv files in python

To read and write CSV files in Python, you need to import the CSV module that comes with Python, and then perform CSV through the functions csv.reader() and csv.writer() in the CSV module. Reading and writing of files.

Write CSV file

import csv     # 需要import csv的文件包
out=open("aa.csv",'wb')         # 注意这里如果以‘w’的形式打开，每次写入的数据中间就会多一个空行，所以要用‘wb’
csv_write=csv.write(out,dialect='excel')
# 下面进行具体的内容写入
ss=['a',3]
csv_write.writerow(ss)      #这样ss里面的信息就被写入到aa.csv文件中了，而且是在两列中
                               #这里如果需要写入多行，那么就采用循环进行循环输入就可以了
out.close()

Read CSV file

import csv
out=open("aa.csv",'r')
read_csv=csv.reader(out,dialect='excel')
for line in read_csv:     #循环输出csv中的所有数据
    print line
out.close()

For more Python related technical articles, please visit Python Tutorialcolumn for learning!

The above is the detailed content of How to read and write csv files in python. For more information, please follow other related articles on the PHP Chinese website!