delete numeric numbers in all columns python

Question

I want delete all numeric number in columns ,

Exemple :

ABC *12547 NDFRE12 -> ABC * NDFRE
12aRE 15P -> aRE P

I want a code with python. I talk about all columns and not only one row.

Using Excel file .xlsx

Column A for example

avarice · Accepted Answer · 2020-10-11 01:20:36Z

2

Try this for entire dataframe:

df = df.replace(to_replace=r'\d+', value='', regex=True)

For only one column:

df['COLUMN'] = df['COLUMN'].str.replace('\d+', '')

answered Oct 11, 2020 at 1:20

avarice

15.6k3 gold badges19 silver badges38 bronze badges

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

10 Comments

tradebigshort Over a year ago

Wasif Hasan , Thanks ! it's exactly what I want !

avarice Over a year ago

If it works for you then please accept it as answer by clicking the big check mark and upvote with the ^ looking button

tradebigshort Over a year ago

if I want delete too (*PO, *INV, * ) I need whrite new line ?

avarice Over a year ago

Then replace with a newline (\n) instead

tradebigshort Over a year ago

df['COLUMN'] = df['COLUMN'].str.replace('*INV', '') ? I can white all in same line ?

|

BENY · Accepted Answer · 2020-10-11 01:20:25Z

1

Try with replace

l=['ABC *12547 NDFRE12',
'12aRE 15P -> aRE P']
s = pd.Series(l)
0    ABC *12547 NDFRE12
1    12aRE 15P -> aRE P
s = s.str.replace('\d+','')
0       ABC * NDFRE
1    aRE P -> aRE P
dtype: object

answered Oct 11, 2020 at 1:20

BENY

324k22 gold badges176 silver badges250 bronze badges

Collectives™ on Stack Overflow

delete numeric numbers in all columns python

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related