/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 votes156 views4 answers
Difference between 2 dataframes
Python
0 vote154 views1 answer
Python list inster 0
Python
0 vote150 views2 answers
Iqr in python
Python
0 vote172 views1 answer
Add timestamp csv python
Python
62 votes159 views5 answers
How to pick a random number in a list python
Python
0 vote143 views1 answer
Import re def check_time(text): pattern = ___ result = re.search(pattern, text) return result != None print(check_time("12:45pm")) # True print(check_time("9:59 AM")) # True print(check_time("6:60am")) # False print(chec
Python
0 vote140 views1 answer
Fullscreen cmd with python
Python
37 votes155 views6 answers
Lambda functions python
Python
0 vote155 views1 answer
Scipy.signal lfilter
Python
0 vote151 views1 answer
Sort rows in csv file using python pandas
Python