CODE EXAMPLE FOR PYTHON

python read excel set index

data = pd.read_excel(r'File_Path', index_col='Name_of_Index_Column')