how to strip whitespace from column code example

Example 1: remove whitespace from column values

# Delete any Whitespaces within the Column Names:

# Remove Spaces at the beginning and at the end of Column Name:
dete_survey_updated.columns = dete_survey_updated.columns.str.strip()

Example 2: remove whitespace from column values

# Delete any Whitespaces within the Values of the Columns:

# cat_columns is the List of Categorical Column Names in Dataframe

cat_columns = []

for column in df.columns:
    if df[column].dtype == 'object':
        cat_columns.append(column)

def strip_whitespace(s):
    return s.strip()

for col in cat_columns:
    df[col] = df[col].astype('str')
    
for col in cat_columns:
    df[col+'_stripped'] = df[col].apply(strip_whitespace)