将excel或csv文件转换为pandas多级数据帧

I've been given a reasonably large Excel file (5k rows), also as a CSV, that I would like to make into a pandas multilevel DataFame. The file is structured like this:I've been given a reasonably large Excel file (