首先,我用记事本打开的文件是这样的。
下面介绍步骤:
-先用可读的方式打开文件 with open(“xxxx”, “r”) as f:
-再用readlines() 读取每一行(字符串)保存在列表里,再遍历列表去掉收尾的换行符,追加到新的列表里。
-最后把列表写入到csv文件中。下面附上代码:
import csv
list1 = []
with open("pima-indians-diabetes.data", "r") as f:
str1 = f.readlines()
for l in str1:
line = l.strip()
list1.append(line)
with open ("new.csv","w",newline="") as ff:
writer = csv.writer(ff)
for i in range(len(list1)):
writer.writerow(list1[i].split(","))
print("已成功转换为CSV文件!")