#问题,python3.7在使用open写入文件时,出现写入文件后,每一行都会出现跟随空行的情况。
原因: python3更改了二级制写入方式,需要添加新参数,newline
with open('data3.csv', 'w') as csvfile:
fieldnames = ['id','name','age']
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
writer.writeheader()
writer.writerow({'id': '10001', 'name':'Mike', 'age':20})
writer.writerow({'id': '10002', 'name':'Bob', 'age':22})
--在未添加newline参数前,写入后的文件如下:
id name age
10001 Mike 20
10002 Bob 22
with open('data3.csv', 'w', newline='') as csvfile:
fieldnames = ['id','name','age']
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
writer.writeheader()
writer.writerow({'id': '10001', 'name':'Mike', 'age':20})
writer.writerow({'id': '10002', 'name':'Bob', 'age':22})