/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 vote172 views2 answers
Use reshape in python with zeros
Python
0 vote161 views1 answer
Scikit learn library in python
Python
26 votes160 views6 answers
Convert list of strings to ints python
Python
0 vote214 views1 answer
How to run django server outside world
Python Django
3 votes198 views2 answers
Boolean python example
Python
2 votes145 views1 answer
How to add headers in csv file using python
Python
0 vote165 views2 answers
Terneray operator in python
Python
6 votes146 views3 answers
If you have the following data structure, which of the following evaluates to 8? array = [[5,4,2],[4,4,1],[8,9,0],3];
Python
0 vote135 views1 answer
Ignore pytest errors or warnings
Python
0 vote143 views1 answer
Torch distributed address already in use
Python