pandas strip whitespace from column names 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 whitespace from start of string

'     hello world!    '.strip()
'hello world!'


'     hello world!    '.lstrip()
'hello world!    '

'     hello world!    '.rstrip()
'    hello world!'