/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 vote158 views2 answers
Reverse a list in python using recursion
Python
0 vote158 views1 answer
Tkinter how to move Button
Python
1 vote148 views1 answer
Export PyTorch model in the ONNX Runtime format
Python
0 vote163 views1 answer
Numpy randomly swap lines
Python
-2 votes149 views3 answers
Else if in pyton
Python
-1 vote169 views1 answer
Popup window python tkinter
Python
0 vote168 views1 answer
How to import axes3D
Python
0 vote167 views1 answer
Discord.py get server id
Python
3 votes154 views1 answer
Change plot size matplotlib python
Python
2 votes168 views2 answers
Big comments python
Python