/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 vote189 views1 answer
How to get location using python
Python
0 vote158 views1 answer
Access value of posted object python
Python
0 vote175 views1 answer
Python Remove all occurrences of a character from a string
Python
0 vote179 views1 answer
Django builtin signals
Python
1 vote179 views1 answer
Python get object attribute by string
Python
12 votes183 views2 answers
Python input integer only
Python
2 votes173 views1 answer
Directory name python
Python
5 votes193 views2 answers
Python string replace by index
Python
1 vote178 views1 answer
Plot specific columns pandas
Python
0 vote196 views1 answer
`distplot` is a deprecated function and will be removed in a future version. Please adapt your code to use either `displot` (a figure-level function with similar flexibility) or `histplot` (an axes-level function for histograms).
Python