remove all spaces from column 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(' ','_')