Pandas replace integer to empty string (Python)

Question

I want to replace column integer values to empty strings (''). But, can not find appropriate way.

Current data     

     0
0  asd
1  9
2  gfs
3  45
4  4
5  dsf

Expected result

     0
0  asd
1  
2  gfs
3  
4  
5  dsf

Yes, I want only string values on my data. Other values need to change to empty string. — Abdulla Salimov
– Abdulla Salimov, Commented Aug 11, 2020 at 4:26

Sayandip Dutta · Accepted Answer · 2020-08-11 04:27:37Z

3

Use str.isnumeric and df.where:

>>> series
0    asd
1      9
2    gfs
3     45
4      4
5    dsf
Name: 0, dtype: object

>>> series.where(~series.str.isnumeric(), '')
0    asd
1       
2    gfs
3       
4       
5    dsf
Name: 0, dtype: object

If it's a dataframe, then:

>>> df.where(~df['0'].str.isnumeric(), '')
     0
0  asd
1     
2  gfs
3     
4     
5  dsf

edited Aug 11, 2020 at 4:27

answered Aug 11, 2020 at 4:22

Sayandip Dutta

15.9k4 gold badges27 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Pandas replace integer to empty string (Python)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related