/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 vote330 views1 answer
Jinja flask
Python Flask
1 vote318 views1 answer
A function to create a null correlation heatmap in python
Python
6 votes327 views3 answers
How to get all links text from a website python beautifulsoup
Python
1 vote333 views1 answer
Number of times a value occurs in dataframne
Python
0 vote332 views3 answers
Dataset for cancer analysis in python
Python
55 votes339 views5 answers
How to clear the console python
Python
1 vote356 views1 answer
Python covid data
Python
0 vote362 views1 answer
Pretty size python
Python
1 vote360 views3 answers
Tabula python
Python
0 vote325 views1 answer
Remove stopwords from list of strings python
Python