我试图得到导出一个列表到csv,但它一直给我额外的报价。这是我尝试导出行时的外观:
草莓红的
我希望它看起来像:
草莓色,红色
这是我的代码:import csv
def writeToCSV(fileName,writeRow):
f = open(fileName, 'ab')
outputFile = csv.writer(f)
outputFile.writerow(writeRow)
def csv_to_list_NoHeaders(user_File):
listOfFruits = []
with open(user_File) as output:
reader = csv.reader(output)
next(reader, None)
for each_line in output:
listOfFruits.append(each_line)
return listOfFruits
fileName1 = 'yesterdayfruits.csv'
fileName2 = 'todaysfruits.csv'
fileOutput = 'fruitsMissing.csv'
todaysfruits = csv_to_list_NoHeaders('todaysfruits.csv')
yesterdayfruits1 = csv_to_list_NoHeaders('yesterdayfruits.csv')
yesterdayfruits2 = []
missingFruits = []
for yesterday in range(len(yesterdayfruits1) - 1, -1, -1):
for today in range(0, len(todaysfruits), 1):
if (yesterdayfruits1[yesterday].split(',')[0].strip() ==
todaysfruits[today].split(',')[0].strip()):
yesterdayfruits2.append(yesterdayfruits1[yesterday])
for x in yesterdayfruits1:
if x in yesterdayfruits2:
pass
else:
missingFruits.append(x)
for y in missingFruits:
writeToCSV('fruitsMissing.csv', [y.strip()])
我尝试过:
^{pr2}$
但我得到的只是:
_在csv.错误:需要退出,但没有设置escapechar
在昨天水果.csv文件包含:Fruit Name, Fruit Color
apple, red
orange, orange
banana, yellow
watermelon, green
strawberry, red
在今日水果.csv文件包含:Fruit Name, Fruit Color
apple, red
orange, orange
banana, yellow
watermelon, green