/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

5 votes317 views3 answers
How to run flask in port 80
Python
1 vote265 views1 answer
Pandas add flag if value is above certain value
Python
0 vote305 views1 answer
Matplotlib boxplot remove outliers
Python
0 vote297 views1 answer
Count repeated strings map python
Python
0 vote294 views1 answer
I want to add a new column to the DataFrame containing only the month of the measurement
Python
1 vote248 views1 answer
Python if elif else in one line
Python
0 vote282 views1 answer
Python code pycharm
Python
1 vote288 views1 answer
Keras import optimizer adam
Python
0 vote250 views1 answer
How to colour a specific cell in pandas dataframe
Python
3 votes270 views2 answers
Get columns containing string
Python