源文件:
next,那么就相当于把指针fp向下移动一行
import csv
headers = ['class','name','sex','height','year']
rows = [{'class':1,'name':'xiaoming','sex':'male','height':168,'year':23},
{'class':1,'name':'xiaohong','sex':'female','height':162,'year':22},
{'class':2,'name':'xiaozhang','sex':'female','height':163,'year':21},
{'class':2,'name':'xiaoli','sex':'male','height':158,'year':21},
]
with open('test2.csv','w',newline='')as f:
f_csv = csv.DictWriter(f,headers)
f_csv.writeheader()
f_csv.writerows(rows)
tmp_arr = []
with open('test2.csv',encoding='utf-8')as f:
f_csv = csv.reader(f)
for row in f_csv:
tmp_arr.append(row)
print(row)
header=['姓名',2,3,4,5]
# ANSI、UTF-8
with open('tmp_arr1.csv','w',newline='',encoding='UTF-8-SIG')as f:
#newline=" "是为了避免写入之后有空行 默认是UTF-8编码
ff=csv.writer(f)
ff.writerow(header)
ff.writerow(header)
ff.writerow(header)
ff.writerows(tmp_arr)
import csv
def read_file1():
with open('tmp_arr1.csv','r',encoding='UTF-8-SIG') as fp:
# reader相当于一个迭代器
reader = csv.reader(fp)
# 使用next,那么就相当于把指针fp向下移动一行
next(reader)
next(reader)
next(reader)
next(reader)
for read in reader:
print(read)
read_file1(