/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 vote409 views1 answer
Travis deployment script for django applications to heroku
Python Django
0 vote364 views1 answer
Como tornar uma string numa lista
Python
4 votes314 views2 answers
How to count range in django template
Python
0 vote370 views1 answer
Python get how many days in current month
Python
0 vote367 views1 answer
Solve system of linear equations numpy
Python
37 votes333 views5 answers
Get requests python
Python
20 votes324 views3 answers
Matplotlib custom legend
Python
0 vote334 views1 answer
Bash: line 1: templates/addtask.html: No such file or directory in flask app
Python
0 vote328 views2 answers
How to create fibonacci sequence in python
Python
0 vote324 views1 answer
Python print os command output -1
Python