如何在csv文件的所有行中删除逗号python

问题描述：

我知道有一些话题告诉我们使用.strip（）或.rstrip（）函数来做到这一点，但它不适合我。我有一个程序，追加到csv文件的新行，但不幸的是，它会生成一个尾随的逗号... 我试图删除它在Python中的.strip（）函数，但它不能很好地工作，我做错了什么？这是什么发生的例子，当我输入 'T123' 的Bike_No和'05/08/2017' 用于PURCHASE_DATE如何在csv文件的所有行中删除逗号python

from datetime import datetime 
    td= datetime.now() 
    initial_bike_detaillist=[] 
    deBatt =100 
    deKM = 0.00 
    deDate = str(td)[8:10] + "/"+ str(td)[5:7] + "/"+ str(td)[0:4] 
    print("Option 4: Add abicycle \n") 
    Bike_No=input("Bike No. :") 
    Purchase_Date=str(input("Purchase Date:")) 
    initial_bike_detaillist=[str(Bike_No),str(Purchase_Date),str(deBatt),str(deDate),str(deKM)]#because there is no write function for int 
    filename="Assignment_Data1.csv" 
    file=open(filepath + filename,"a") 
    file.write("\n") 
    for k in initial_bike_detaillist: 
     file.write("{},".format(k)) 
    print("Bicycle ({}) has been created".format(Bike_No)) 
    file.close() 
    file=open(filepath + filename,"r") 
    for line in file: 
     line.strip() 
     print(line)

预期输出=

Bike No.,Purchase Date,Batt %,Last Maintenance,KM since Last 

T101,10/04/2016,55,10/01/2017,25.08 

T102,01/07/2016,10,15/05/2017,30.94 

T103,15/11/2016,94,13/06/2017,83.16 

T104,25/04/2017,58,10/01/2017,25.08 

T105,24/05/2017,5,20/06/2017,93.80 

T123,04/04/2017,100,05/08/2017,0.0

实际输出：

Bike No.,Purchase Date,Batt %,Last Maintenance,KM since Last 

T101,10/04/2016,55,10/01/2017,25.08 

T102,01/07/2016,10,15/05/2017,30.94 

T103,15/11/2016,94,13/06/2017,83.16 

T104,25/04/2017,58,10/01/2017,25.08 

T105,24/05/2017,5,20/06/2017,93.80 

T123,04/04/2017,100,05/08/2017,0.0,

使用'line.strip（ ''）' – Gerrat

您可能需要使用[csv.DictWriter ]（https://docs.python.org/3/library/csv.html#csv.DictWriter）它是一个标准库，它使用起来更容易。不要重新发明*！ – Adonis

在这段代码中可以修复很多东西。但是，为了回答你的问题，用'''file.write（'，'。join（initial_bike_detaillist）''将file.write（“{}，”。格式（k））''' –

答

代替此行：

for k in initial_bike_detaillist: 
    file.write("{},".format(k))

使用以下行：

file.write(','.join(initial_bike_detaillist))

代码：

from datetime import datetime 

td = datetime.now() 
initial_bike_detaillist = [] 
deBatt = 100 
deKM = 0.00 
deDate = str(td)[8:10] + "/" + str(td)[5:7] + "/" + str(td)[0:4] 
print("Option 4: Add abicycle \n") 
Bike_No = input("Bike No. :") 
Purchase_Date = str(input("Purchase Date:")) 
initial_bike_detaillist = [str(Bike_No), str(Purchase_Date), str(deBatt), str(deDate), 
          str(deKM)] # because there is no write function for int 
filename = "Assignment_Data1.csv" 
file = open(filepath + filename, "a") 
file.write("\n") 
# for k in initial_bike_detaillist: 
# file.write("{},".format(k)) 
file.write(','.join(initial_bike_detaillist)) # use this line . 

print("Bicycle ({}) has been created".format(Bike_No)) 
file.close() 
file = open(filepath + filename, "r") 
for line in file: 
    # line.strip() # Then, not need this line 
    print(line)

如何在csv文件的所有行中删除逗号python

相关推荐