Remove spaces in column data without loosing their original data in python pandas dataframe

Question

import pandas as pd
df=pd.read_excel('test.xlsx')
ab= df.MobileNum.str.replace(' ','')
print ab

As in the screenshot you can see first four row shows nan which is my 10 digit original number without space and other has spaces . so i want to show first four row data with this result.

you need strip (https://stackoverflow.com/questions/13013734/string-strip-in-python) i think..please post an instance — iamklaus, Sep 25 '19 at 10:41
What do you mean by "remove my original data"? Your command keeps the original column in `df`. By "data", do you mean column, row, cell content, string content? — PlasmaBinturong, Sep 25 '19 at 10:52

score 0 · Answer 1 · answered Sep 25 '19 at 11:05

0

You can always do this:

new = df.MobileNum.str.replace(r"\s+", "")
print(new)

answered Sep 25 '19 at 11:05

Venkatesh Prabhu

36
3

Try this: df['mobile'].apply(lambda x: x.replace(' ', '')) – Venkatesh Prabhu Sep 25 '19 at 11:20

Remove spaces in column data without loosing their original data in python pandas dataframe

1 Answers1