Python Remove specific string in dataframe column

Question

I have a df with a one specific column like this:

var
100 asc
200 asc
150 asc
75  asc

I want to remove asc and retain as number so to get

Running

number =df['var'].replace('\asc',regex=True)

Yet nothing happens resulting df is exactly the same as the original one, yet no error are shown...

Any ideas?

Does this answer your question? [Remove unwanted parts from strings in a column](https://stackoverflow.com/questions/13682044/remove-unwanted-parts-from-strings-in-a-column) — huy, Apr 08 '20 at 03:08

score 3 · Accepted Answer · edited Apr 08 '20 at 03:15

3

Let us try

df['var'] = df['var'].str.strip(' asc')

edited Apr 08 '20 at 03:15

anky

answered Apr 08 '20 at 03:07

BENY

1 Answers1