/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 vote307 views1 answer
Consider a string note: "welcome" statment will rais error
Python
0 vote178 views2 answers
Python union type
Python
0 vote293 views1 answer
Flask get uploaded file size
Python Flask
2 votes222 views1 answer
YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details.
Python
0 vote219 views1 answer
Python Split list into chunks using List Comprehension
Python
0 vote185 views1 answer
Ion Flux Relabeling
Python
0 vote183 views1 answer
How to rescale data pandas
Python
-3 votes225 views5 answers
Multiplication table in python
Python
0 vote173 views1 answer
Restart computer py
Python
0 vote184 views1 answer
Create image tkinter set active background
Python