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)
dataframe.columns = list(map(lambda x: x.replace(' ', '_'),
dataframe.columns))