/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

19 votes271 views6 answers
Pop function in python
Python
0 vote289 views1 answer
Ask for sudo privilege from python in macos
Python
0 vote236 views1 answer
Which day is today
Python
0 vote273 views1 answer
Create numpy array with ones
Python
2 votes324 views1 answer
How store list in django session
Python Django
0 vote273 views1 answer
Json on desktop python
Python
0 vote299 views1 answer
How to standardize the image data to have values between 0 and 1
Python
4 votes280 views1 answer
What's the equivalent to System.nanotime in python
Python
0 vote262 views1 answer
Swap two lists without using third variable python
Python
0 vote280 views1 answer
Phone no validate
Python