/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 vote163 views1 answer
Matplotlib bold
Python
3 votes106 views2 answers
Numpy stdev
Python
2 votes120 views1 answer
DEPRECATION: The default format will switch to columns in the future. You can use --format=(legacy|columns) (or define a format=(legacy|columns) in your pip.conf under the [list] section) to disable this warning.
Python
1 vote128 views1 answer
Seaborn jointplot regression
Python
3 votes124 views2 answers
AttributeError: module 'tensorflow' has no attribute 'placeholder'
Python
2 votes140 views2 answers
Django template array index
Python
0 vote119 views1 answer
Modeltranslation
Python
40 votes113 views5 answers
Round decimal to 2 places python
Python
0 vote120 views1 answer
How to make a button open a new window in python
Python
1 vote116 views1 answer
Wheter
Python