Pandas Column Values Replace

Question

I have dataset. A name of column is wage. Column's element contain K values. I want to replace K values.

data['Wage']=data['Wage'].replace("K","")

But it doesn't work.

anky · Accepted Answer · 2019-03-09 11:53:48Z

2

You can use:

data['Wage']=data['Wage'].replace("K","",regex=True)

Or:

data['Wage']=data['Wage'].astype(str).str.replace("K","")

answered Mar 9, 2019 at 11:48

anky

75.3k11 gold badges46 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@Raşitİri check this too: df['Wage'].str.strip('k')

heena bawa · Accepted Answer · 2019-03-09 12:05:18Z

0

You can also use:

df = pd.DataFrame({'Wage': ['$200k', '$500']})
df['Wage'] = df['Wage'].str.split('k', expand=True)[0]
print(df)

Output:

   Wage
0  $200
1  $500

OR

df['Wage'] = df['Wage'].str.replace(r'k', '')
print(df)

Output:

   Wage
0  $200
1  $500

answered Mar 9, 2019 at 12:05

heena bawa

8286 silver badges5 bronze badges