title: Python extract data from a semi-structured .xlsx file
body: <p>I have a .xlsx file which looks as the attached file. What is the most common way to extract the different data parts from this excel file in Python?</p>
  
  <p>Ideally there would be a method that is defined as : </p>
  
  <p><code>pd.read_part_csv(columns=['data1', 'data2','data3'], rows=['val1', 'val2', 'val3'])</code>
  and returns an iterator over <code>pandas</code> dataframes which hold the values in the given table.</p>
  
  <p><a href="https://i.stack.imgur.com/87stT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/87stT.png" alt="table"></a></p>