Pandas: reading in excel files, reading values, manipulating keys

The actual excel file is as shown below.