/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

57 votes241 views6 answers
Train test split sklearn
Python
2 votes210 views2 answers
Python replace first
Python
0 vote205 views1 answer
Rotate matrix 90 degrees clockwise in python
Python
1 vote225 views1 answer
Python sympy solve equation equal to 0
Python
1 vote223 views1 answer
Conda python 3.8
Python
1 vote207 views1 answer
How to print not equal to in python
Python
0 vote226 views1 answer
Cool codes for python
Python
0 vote220 views1 answer
Import libraries to Jupyter notebook
Python
5 votes220 views1 answer
What is seaborn in python
Python
1 vote199 views1 answer
Pip install django celery results
Python