/Python/Remove leading and lagging spaces dataframe python

Remove leading and lagging spaces dataframe python

cols = df.select_dtypes(['object']).columns
df[cols] = df[cols].apply(lambda x: x.str.strip())
print (df)
                     A    B     C
0                  A b  NaN   3.0
1                  NaN  NaN   3.0
2               random  NaN   4.0
3  any txt is possible  2 1  22.0
4                       NaN  99.0
5                 help  NaN   NaN

Source: stackoverflow.com

Remove leading and lagging spaces dataframe python

df = df.applymap(lambda x: x.strip() if isinstance(x, str) else x)
print (df)
                     A    B     C
0                  A b    2   3.0
1                  NaN    2   3.0
2               random   43   4.0
3  any txt is possible  2 1  22.0
4                        23  99.0
5                 help   23   NaN

Source: stackoverflow.com

Similar codes

1 vote333 views1 answer
Python find smallest value in 2d list
Python
0 vote351 views1 answer
Assert vs validate in python
Python
3 votes357 views3 answers
How to make my jupyter prin full array
Python
11 votes337 views2 answers
How to push item to array python
Python
5 votes347 views1 answer
Python leap year solution
Python
3 votes351 views1 answer
Import py to exe
Python
2 votes412 views2 answers
Cv2 crop image
Python
0 vote374 views1 answer
Selenium.common.exceptions.elementclickinterceptedexception: message: element click intercepted:
Python
0 vote367 views1 answer
Python calling method from constructor
Python
0 vote355 views1 answer
Get array from h5py dataset
Python