Python读取CSV使用next，那么就相当于把指针fp向下移动一行

源文件：

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(