/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 vote131 views1 answer
Create a file in a specific directory
Python
0 vote107 views1 answer
Menubar pyqt
Python
0 vote132 views1 answer
Una esfera solida de radio 40 cm tiene una carga positiva
Python
16 votes119 views1 answer
Python reload function from file
Python
1 vote113 views2 answers
Open word document python
Python
0 vote138 views1 answer
AttributeError: Can't get attribute '' on <module '__main__'> pickle
Python
2 votes108 views1 answer
Make tkinter window look less blury
Python
13 votes116 views6 answers
Character in python
Python
0 vote111 views1 answer
Matlab filter in python
Python
0 vote120 views2 answers
Python dictionary append value if key exists
Python