title: Pandas- ValueError: Usecols do not match columns, columns expected but not found
body: <p>I am trying to copy some of the columns from the imported <code>csv</code> file to <code>selected.csv</code> but it gives me this error :</p>
  <pre><code>'ValueError: Usecols do not match columns, columns expected but not found: ['Status']'; 
  </code></pre>
  <p>It doesn't matter which column name I use it still won't work.
  I tried printing the headers and it shows them normally, I even tried copying the column names from there so if there is maybe a whitespace I missed or something, but it still gives me the same error. I searched for the answer already but none of the ones I found were right for me.</p>
  <pre class="lang-py prettyprint-override"><code>import pandas as pd
  import numpy as numpy
  import csv as csv
  
  path_to_import ='C:/Users/Amila/hello/Auftraege_ALSO_R00.csv'
  
  import_file = pd.read_csv(path_to_import, sep=';',engine='python',encoding='utf-8-sig')
  
  headers = pd.read_csv(path_to_import, index_col=0, nrows=0).columns.tolist()
  
  columns = ['Status']
  
  path_to_selected = 'C:/Users/Amila/hello/selected.csv'
  
  pd.read_csv(path_to_import,usecols=columns).to_csv('selected.csv', index=False)
  </code></pre>
  <p>These are the printed column names:</p>
  <pre><code>['Auftragsdatum;&quot;Auftrags-Nr.&quot;;&quot;Ihre Referenz&quot;;&quot;Auftragswert&quot;;&quot;Auftragsstatus&quot;;&quot;Lieferadresse&quot;;&quot;Pos.&quot;;&quot;Menge&quot;;&quot;Art.Nr.&quot;;&quot;Herst.Nr.&quot;;&quot;Produktname&quot;;&quot;Ihre Referenz (Position)&quot;;&quot;Netto / Stk.&quot;;&quot;Rechn.-Nr.&quot;;&quot;Liefers.-Nr.&quot;;&quot;Serien-Nr.&quot;;&quot;Status&quot;;&quot;Hersteller&quot;']
  </code></pre>