csv文件的读写

# -*- coding: utf-8 -*-

"""

Spyder Editor

This is a temporary script file.

"""

import csv

#读取csv文件

csv_file = csv.reader(open('F:/csv/XXXXXX.csv'))

print(csv_file)

"""

#输出csv中的内容

for item in csv_file:

    print(item)

"""

#创建csv文件并写入

out = open('F:/csv/out.csv','a', newline = '') #'a'代表允许在现有数据上进行读写

csv_write = csv.writer(out, dialect = 'excel') #编程风格默认为excel格式,即用逗号分隔.

for item in csv_file:

    csv_write.writerow(item)

print('write over')#用缩进来控制是否为其循环体