带千分号的数据在python中不能直接用于计算
需要先将千分号剔除
import numpy as np
import pandas as pd
df = pd.DataFrame({'Price':['999','3,999','2,399,300','5,299,199']})
df
def con(column):
column = column.replace(',', '')
column = int(column)
return column
df['Price'] = df['Price'].map(con)
df
这样price列就可以用于计算啦~