/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

0 vote185 views2 answers
Make a gif with images python
Python
3 votes195 views2 answers
Check if a variable is empty python
Python
11 votes179 views2 answers
Add pip to path
Python
1 vote186 views1 answer
Python reference script directory
Python
0 vote172 views1 answer
How to load multiple list of dictionary values which is stored in python file and load into another python file in python over loop
Python
0 vote174 views1 answer
If short for python
Python
0 vote173 views1 answer
Python odbc access database
Python
0 vote186 views1 answer
Python shortest distance between two points
Python
0 vote244 views1 answer
Numpy move columns
Python
0 vote172 views1 answer
Datetime.timedelta format to string python
Python