/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

1 vote85 views1 answer
Python read entire file to string
Python
8 votes138 views2 answers
How to read excel file in jupyter notebook
Python
0 vote124 views1 answer
Get return value from transaction in brownie
Python
0 vote139 views1 answer
Where to import render in django
Python
27 votes115 views2 answers
Python date get day
Python
39 votes141 views6 answers
Pandas print all columns
Python
20 votes136 views3 answers
How to convert all items in a list to integer python
Python
1 vote125 views1 answer
Python for/else
Python
0 vote127 views1 answer
How to download a project from pythonanywhere
Python
0 vote131 views1 answer
List comprehesion python
Python