CODE EXAMPLE FOR PYTHON

python pandas trim values in dataframe

# Trim all whitespaces in dataframe
df = df.replace(r's*(.*?)s*', r'1', regex=True)

# Trim all whitespaces in a column or series
df = df["column"].str.strip()