title: Python - Pandas delete specific rows/columns in excel
body: <p>i have the following excel file, and i would like to clean specific rows/columns so that i can further process the file.</p>
  
  <p><a href="https://i.stack.imgur.com/HDy2c.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HDy2c.png" alt="enter image description here"></a></p>
  
  <p>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.</p>
  
  <pre><code>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()
  </code></pre>
  
  <p>I specifically want to remove rows 1, 3 (the empty ones) and the first column, so that i can pivot it. Is there a way to do this? Thank you.</p>