python删除excel指定行_Python-熊猫删除Excel中的特定行/列

i have the following excel file, and i would like to clean specific rows/columns so that i can further process the file.

I have tried this, but i have not managed to remove any of the blank lines, i ve only managed to trim from those containing data. Here, i was trying to only save the data from the third row and on.

xl = pd.ExcelFile("MRD.xlsx")

df = xl.parse("Sheet3")

df2 = df.iloc[3:]

writer4 = pd.ExcelWriter('pandas3.out.no3lines.xlsx', engine='xlsxwriter')

table5 = pd.DataFrame(df2)

table5.to_excel(writer4, sheet_name='Sheet1')

writer4.save()

I specifically want to remove rows 1, 3 (the empty ones) and the first column, so that i can pivo