I have a data-frame that I am trying to transpose, My original data-frame looks like this in excel

I was able to partially transpose the data and index the Locations, which I would like to be my first column and not the index.

df_transposed = df.T

df_transposed

df_transposed.reset_index(drop = True, inplace = True)

I would like to have the Location, Assessment, Subject, Grade, Percent Met, Total Met as columns in the dataframe.