/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

2 votes148 views2 answers
Python sentence splitter
Python
-2 votes149 views2 answers
Float() argument must be a string or a number, not 'dict_values'
Python
0 vote147 views1 answer
Uninstalling/removing a package is very easy with pip:
Python
0 vote156 views1 answer
Matplotlib plt.sapect
Python
0 vote150 views1 answer
%d%m%y python
Python
0 vote183 views1 answer
DJANGO model instance get by variable
Python Django
6 votes185 views4 answers
Extract numbers from string python
Python
1 vote147 views2 answers
Python merge pdfs
Python
3 votes139 views9 answers
Creating environment variable in python
Python
0 vote141 views2 answers
Iterate through a list and print from index x to y using for loop python
Python