title: Selecting specific excel rows for analysis in pandas/ipython?
body: <p>This question is probably quite elementary, but I am totally stuck here so I would appreciate any help: Is there a way to extract data for analysis from an excel file by selecting specific row numbers? For example, if I have an excel file with 30 rows, and I want to add up the values of row 5+10+21+27 ?</p>
  
  <p>I only managed to learn how to select adjacent ranges with the iloc function like this:</p>
  
  <pre><code>import pandas as pd
  
  df = pd.read_excel("example.xlsl")
  
  df.iloc[1:5]
  </code></pre>
  
  <p>If this is not possible in Pandas, I would appreciate advice how to copy selected rows from a spreadsheet into a new spreadsheet via openpyxl, then I could just load the new worksheet into Pandas.</p>