Python - CSV模块,跳过行
问题描述:
我试图用python创建一个.csv文件。 .csv文件已成功创建,但它在输入以下结果的条目之间跳过一行。Python - CSV模块,跳过行
['Name', 'Profession']
[]
['Derek', 'Software Developer']
[]
['Steve', 'Software Developer']
[]
['Paul', 'Manager']
[]
任何帮助解决这个问题将不胜感激。
import csv
with open('persons.csv', 'w') as csvfile:
filewriter = csv.writer(csvfile, delimiter=',',
quotechar='|', quoting=csv.QUOTE_MINIMAL)
filewriter.writerow(['Name', 'Profession'])
filewriter.writerow(['Derek', 'Software Developer'])
filewriter.writerow(['Steve', 'Software Developer'])
filewriter.writerow(['Paul', 'Manager'])
with open('persons.csv', 'rt') as f:
reader = csv.reader(f)
# read file row by row
for row in reader:
print(row)
答
我被错误地使用Python 2语法,而不是pythonn 3,我应该有newline=''
为with open('persons.csv', 'w') as csvfile:
参数给with open('persons.csv', 'w', newline='') as csvfile:
检查这个答案:https://stackoverflow.com/questions/3348460/CSV文件写入与 - 蟒-具有空白线之间 - 的每行 –