How to filter out numbers from a dataframe column in pandas

Asked Aug 04 '23 at 12:05

Active Aug 04 '23 at 12:05

Viewed 21 times

I've got a pandas dataframe that I've almost cleaned with its various functions.

The bit I can't work out is what is the apply function to remove numbers from the 'region' column.

England6 should be England.

    region  admissions_total    admissions_count_men    admissions_count_women  adm_per_100_000_all adm_per_male    adm_per_female  year
11  England6    710562  243565  466978  1322.8  963.1   1685.2  2019
13  North East  24410   8645    15765   932 684 1177    2019
14  Darlington  645 295 355

Can you help, please?

asked Aug 04 '23 at 12:05

elksie5000

7,084
12
57
87

2

`df['region'] = df['region'].str.replace(r'\d+', '', regex=True)`? – mozway Aug 04 '23 at 12:09
I knew i it was simple but I'm unnerved with regex. – elksie5000 Aug 04 '23 at 12:11
1

If you prefer: `df['region'] = df['region'].str.replace(r'[0-9]+', '', regex=True)` ;) – mozway Aug 04 '23 at 12:13

How to filter out numbers from a dataframe column in pandas

0 Answers0