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()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()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)Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
