import pandas as pd # remove spaces in columns name df.columns = df.columns.str.replace(' ','_')
df.rename(columns=lambda x: x.strip().replace(" ", "_"), inplace=True)