text_plain_output_1.png
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

df = pd.read_excel('/kaggle/input/social-profile-of-customers/Social profile of customers_without header.xlsx')

df.columns = [c.replace(' ', '_') for c in df.columns]

df.drop(columns=['Name_', 'Profile', 'Profession_', 'Location', 'Prority__level_1', 'Priority_level_2', 'Priority_level_3'], inplace=True)
df.head(2)