reme all after whitesapce colum pandas code example

Example 1: Python function remove all whitespace from all character columns in dataframe

df.columns = df.columns.str.replace(' ', '')

Example 2: replace all spacec column with underscore in pandas

import pandas as pd 

# remove spaces in columns name
df.columns = df.columns.str.replace(' ','_')

Example 3: python - remove exta space in column

df.Name = df.Column_Name.replace('\s+', ' ', regex=True)