RANK DISTRIBUTORS MARKET SHARE
1 AB 17.02%
2 NEO 17.00%
3 EVE 14.3%
我有一个包含这3列的数据帧。我想从"MARKET SHARE"列中删除%,并将数据类型更改为float。
df['MARKET SHARE'].replace('%','',inplace=True)
期望结果
RANK DISTRIBUTORS MARKET SHARE
1 AB 17.02
2 NEO 17.00
3 EVE 14.3
您已接近,请使用Series.str.replace
或Series.str.rstrip
和casting来浮动:
df['MARKET SHARE'] = df['MARKET SHARE'].str.replace('%','').astype(float)
或者:
df['MARKET SHARE'] = df['MARKET SHARE'].str.rstrip('%').astype(float)