/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

35 votes105 views4 answers
Get request python
Python
0 vote107 views1 answer
Numpy rolling
Python
12 votes146 views5 answers
Django-cors-headers
Python Django
0 vote104 views1 answer
Remove punctuation and special charaacters nltk
Python
0 vote146 views1 answer
Static Assets in Django
Python Django
7 votes110 views2 answers
Your models have changes that are not yet reflected in a migration, and so won't be applied. Run 'manage.py makemigrations' to make new migrations, and then re-run 'manage.py migrate' to apply them.
Python
0 vote104 views1 answer
Skcuda pip
Python
0 vote109 views1 answer
Multiple args for pandas apply
Python
1 vote104 views1 answer
Python find string in list
Python
2 votes107 views3 answers
Python check if number contains digit
Python