I have an Excel file with a hidden column. I need to read the data in that column and add it to a list. How can I do this?
df = pd.read_excel("L.xlsx", sheet_name=0)
customer_GROUP = list(df['GROUP2']) #this column is hidden
SAMEH
0
I have an Excel file with a hidden column. I need to read the data in that column and add it to a list. How can I do this?
df = pd.read_excel("L.xlsx", sheet_name=0)
customer_GROUP = list(df['GROUP2']) #this column is hidden