title: Reading in Empty Cells with `read_excel` in Python pandas
body: <p>I am using Python pandas to <code>read_excel</code>. This is the column I am reading in.</p>
  
  <p><a href="https://i.stack.imgur.com/JsFdj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JsFdj.png" alt="Excel Snippet"></a></p>
  
  <p>My problem is that read_excel isn't counting the empty cells as cells. When I use <code>df2=df1.iloc[0:30]</code>, I want it to include those empty cells so those last two data items are not included in my dataframe (this is because these cells are populated daily throughout the month, so those empty cells will exist until the very last day of the month). How do I ensure pandas read_excel includes those empty cells in its dataframe?</p>