title: When trying to count the rows in a sheet colum inside excell by PyCharm(pandas), the column cant be found?
body: <p>I can print specific Excel sheets on PyCharm (pandas) with no problem. But when trying to count rows inside column (Sample):</p>
  <pre class="lang-py prettyprint-override"><code>import pandas as pd
  
  x = pd.read_excel(r&quot;C:\Users\nan\PycharmProjects\giraffe\GENERA.xlsx&quot;, sheet_name=[&quot;Sample Info&quot;], engine=&quot;openpyxl&quot;)
  
  split_values = x[&quot;Sample&quot;].unique()
  
  print(split_values)
  </code></pre>
  <p>I get:</p>
  <pre><code>  warn(msg)
  Traceback (most recent call last):
    File &quot;C:/Users/nan/PycharmProjects/giraffe/genera1.py&quot;, line 8, in &lt;module&gt;
      split_values = x[&quot;Sample&quot;].unique()
  KeyError: 'Sample'
  </code></pre>
  <p>What am I doing wrong?</p>