怎样用python将csv文件中某一列数据的千位分隔符去掉?
测试文件: test.csv
小红,"5,561",2022/4/3
小明,"1,021,253",2022/4/2
小东,"21,165",2022/4/2
操作:
import pandas as pd
df = pd.read_csv(r'd:\test.csv', header = None)
#print(df)
for n,d in enumerate(df[1]):
df[1][n] = d.replace(',','')
#print(df)
df.to_csv(r'd:\test.csv', header = None, index = None)
结果:
小红,5561,2022/4/3
小明,1021253,2022/4/2
小东,21165,2022/4/2