How to read and write csv files in python

Release: 2019-07-05 13:43:21
Original
5847 people have browsed it

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()
Copy after login

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()
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template