纯属记录自己的问题,先摆出2种情况,主要是解决生成的CSV文件里空格的问题
# 1、现有如下图1所示的data.csv文件数据,请使用python读取该csv文件数据,并添加一条记录后输出如图2所示的output.csv文件
import csv
def gaindata():
with open('./data.csv','r') as csvfile:
reader = csv.reader(csvfile)
result = []
for row in reader:
result.append(row)
return result
def addone():
with open ('./output.csv','w') as csvfile:
data = gaindata()
data.append(['Jack',104])
writer = csv.writer(csvfile)
for row in data:
writer.writerow(row)
if __name__ =='__main__':
addone()
运行结果:
name, stuNo
ZhangSan, 101
LiSi, 102
WangWu, 103
Jack,104
很明显,每一行都有空行,我们需要这些数据中间是没有空格的
def addone():
with open ('./output.csv','w',newline ='') as csvfile:
data = gaindata()
data.append(['Jack',104])
writer = csv.writer(csvfile)
for row in data:
writer.writerow(row)
if __name__ =='__main__':
addone()
需要添加的是newline=' ' ,表示写入csv文件,如果不加上参数 newline='' 表示以空格作为换行符,则生成的表格中会出现空行。
name, stuNo
ZhangSan, 101
LiSi, 102
WangWu, 103
Jack,104