我有一个包含以下格式的行的文件
aaa=A;bbb=B;ccc=C
我想将其转换为 csv 格式,以便方程两边的文字将是列,分号将作为行分隔符。我尝试做这样的事情
f = open("aaa.txt", "r")
with open("ccc.csv", 'w') as csvFile:
writer = csv.writer(csvFile)
rows = []
if f.mode == 'r':
single = f.readline()
lns = single.split(";")
for item in lns:
rows.append(item.replace("=", ","))
writer.writerows(rows)
f.close()
csvFile.close()
但我将每个字母作为一列,所以结果如下:
a,a,a,",",A
b,b,b,",",B
c,c,c,",",C,"
预期的结果应该是这样的
aaa,A
bbb,B
ccc,C