/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 vote304 views1 answer
Using csv module how to read perticular lines in csv
Python
7 votes328 views4 answers
Force utf-8 encoding python
Python
1 vote351 views1 answer
How to convert async function to sync function in python
Python
0 vote308 views1 answer
Python matplotlib pyplot set axis equals
Python
26 votes323 views4 answers
Python ceiling
Python
0 vote304 views1 answer
Foreignkey as users from a user group django
Python
0 vote323 views1 answer
Concat with zero array numpy
Python
0 vote329 views1 answer
Python console width
Python
0 vote294 views4 answers
Client network socket disconnected before secure TLS connection was established
Python
0 vote314 views1 answer
Python extract mails from string
Python