csv - 从 csv 中删除不需要的逗号

Question

例如有“2,881,423”，如何从中删除“，”。我有数百万的数据需要完成。是否可以执行批处理操作？因此，我可以将任何工具用于 PC 或 Mac。

"Position","Value",
"1","1",
"2","1",
"3","1",
"4","2",
"5","2",

...

"2,881,423","19",
"2,881,424","22",
"2,881,425","23",
"2,881,426","23",
"2,881,427","25",
"2,881,428","25",
"2,881,429","25",

...

像上面一样是来自 csv 的一些片段。

Answer 1

在 Python 中:

import csv
with open("myfile.csv", "rb") as infile, open("output.csv", "wb") as outfile:
    reader = csv.reader(infile)
    writer = csv.writer(outfile)
    for row in reader:
        writer.writerow(item.replace(",", "") for item in row)