title: Filter all rows based on one specific index value, python and pandas
body: <p>I am trying to output a filtered list based on the input of the index.
  In my case, I want to make the Location the index, and only show all the results whose location is 'Switzerland'. I am using jupyter-notebook</p>
  <p>I have an xlsx file called Book1 containing [here.][1]
  , I type this in.</p>
  <pre><code>import pandas as pd
  from pandas import Series, DataFrame
  from scipy import stats
  
  substats=pd.read_excel('Book1.xlsx', index_col=1) #index_col=1 makes Location the index
  
  </code></pre>
  <p>I am stuck, but I am expecting [the output to be like this][2]</p>
  <p>Notice that the second image index is not 4, 6, but instead 1, 2.</p>
  <p>Can you help me with this?
  [1]: <a href="https://i.stack.imgur.com/NIbKx.png" rel="nofollow noreferrer">https://i.stack.imgur.com/NIbKx.png</a>
  [2]: <a href="https://i.stack.imgur.com/whSEP.png" rel="nofollow noreferrer">https://i.stack.imgur.com/whSEP.png</a></p>