/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

3 votes229 views1 answer
Nlargest
Python
0 vote228 views1 answer
Find highest value in array python
Python
6 votes230 views3 answers
Flask get ip of user
Python
0 vote234 views1 answer
How to make a numpy array of certain values
Python
0 vote235 views1 answer
Introduction python graphviz simple graph examples
Python
0 vote259 views1 answer
Open spreadsheet by key
Python
1 vote230 views2 answers
Python 7zip extract
Python
0 vote276 views1 answer
Write a python program to find fibonacci series upto a certain limit using while loop
Python
0 vote227 views1 answer
How to define a functio in python
Python
0 vote230 views1 answer
Save changes flask sqlalchemy
Python