/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

4 votes248 views5 answers
Fibonacci function python
Python
0 vote195 views1 answer
Get pixel color pygame
Python
0 vote220 views1 answer
Django auto complete light styling
Python
7 votes201 views1 answer
Import settings
Python
-2 votes200 views1 answer
Stats.norm.cdf(2,loc=mean, scale=std_dev)
Python
29 votes200 views9 answers
Traduttore
Python
1 vote230 views1 answer
Python print unicode character
Python
0 vote188 views1 answer
Error tokenizing data. C error: Calling read(nbytes) on source failed. Try engine='python'.
Python
0 vote227 views1 answer
Not want to assign all values of a collection of values in python
Python
13 votes205 views1 answer
Bg white tkinter
Python