pandas - Can not remove white spaces from DataFrame

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/66059610/can-not-remove-white-spaces-from-dataframe

Answer 1

For replacing the white space from a string in series or dataframe object use the str.replace() method.

For Ex:

>>> import pandas as pd
>>> ser = pd.Series(['aaa ','aac vf','cc  '])
>>> ser
0      aaa 
1    aac vf
2      cc  
dtype: object

>>> ser[0]
'aaa '

>>> len(ser[0])
4

>>> ser.str.replace(" ", "")
0      aaa
1    aacvf
2       cc
dtype: object

As you can see, the replace method removed the white spaces form string.