title: How to read multiple tables from .xls file in python?
body: <p>I need to read multiple tables from a sheet in an Excel file with python. The sheet looks something like this:
  <a href="https://i.stack.imgur.com/TaLgj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TaLgj.png" alt="enter image description here"></a></p>
  
  <p>I want to get a python object containing the information in First_Table and the same for Second_Table. 
  I tried using pandas and Dataframe.iloc this way:</p>
  
  <pre><code>import pandas as pd
  xls = pd.ExcelFile('path_to_xls_file')
  df = pd.read_excel(xls, "sheet_1")
  # first table
  df1 = df.iloc[2:12,0:6]
  </code></pre>
  
  <p>But I didn't get the expected cells from the First_Table.
  Am I doing something wrong with the ranges of the rows and columns?
  Does it have to be specified with the exact row and col indices or is there a more efficient and elegant way to do it?</p>
  
  <p>Thanks in advance!</p>