我正在try 创建一个(或两个)模块来将文件从dat转换为csv,然后再转换回来.我遇到的问题是,转换会向数据的每个"单元格"添加许多引号.
我目前使用以下代码来完成此操作:
with open(file_dat_new, 'r') as dat_file:
with open(file_csv_new, 'w', newline='') as csv_file:
csv_writer = csv.writer(csv_file)
for row in dat_file:
row = [value.strip() for value in row.split(',')]
csv_writer.writerow(row)
以下是第一行输入的示例:
"TOA5","STA332","CR6","10318","CR6.Std.12.02 CR6-WIFI.05.03","CPU:Sta-332_2022-10-03.cr6","3367","FSDATA"
我得到的结果是:
"""""""TOA5""""""","""""""STA332""""""","""""""CR6""""""","""""""10318""""""","""""""CR6.Std.12.02 CR6-WIFI.05.03""""""","""""""CPU:Sta-332_2022-10-03.cr6""""""","""""""3367""""""","""""""FSDATA"""""""
所以我的问题是:为什么要添加额外的引号,以及如何在转换时删除它们?