title: Python Pandas - KeyError: "None of [Index([...] are in the [columns])
body: <p>Trying to red a simple csv file and then trying to visualize one of the variables on the index of the data-frame (it's a date). But it just keeps throwing back the key error. Read through all the posts with similar problems, but none seems to work in my case. Any help is much appreciated.</p>
  <pre><code>df1 = pd.read_csv('df1',index_col=0)
  df1.head()
  
      A   B   C   D
  2000-01-01  1.339091    -0.163643   -0.646443   1.041233
  2000-01-02  -0.774984   0.137034    -0.882716   -2.253382
  2000-01-03  -0.921037   -0.482943   -0.417100   0.478638
  2000-01-04  -1.738808   -0.072973   0.056517    0.015085
  2000-01-05  -0.905980   1.778576    0.381918    0.291436
  </code></pre>
  <p>After this I am simply trying to draw any one variable as a line chart wrt to index</p>
  <pre><code>df1.plot.line(x=df1.index, y='A', figsize=(12,3), lw=1)
  </code></pre>
  <p>Error:</p>
  <pre><code>---------------------------------------------------------------------------
  KeyError                                  Traceback (most recent call last)
  &lt;ipython-input-23-531889937593&gt; in &lt;module&gt;
  ----&gt; 1 df1.plot.line(x=df1.index,y='A',figsize=(12,3),lw=1)
  
  ~\Anaconda3\lib\site-packages\pandas\plotting\_core.py in line(self, x, y, **kwargs)
     1021         as coordinates.
     1022         &quot;&quot;&quot;
  -&gt; 1023         return self(kind=&quot;line&quot;, x=x, y=y, **kwargs)
     1024 
     1025     @Appender(
  
  ~\Anaconda3\lib\site-packages\pandas\plotting\_core.py in __call__(self, *args, **kwargs)
      918                 if is_integer(x) and not data.columns.holds_integer():
      919                     x = data_cols[x]
  --&gt; 920                 elif not isinstance(data[x], ABCSeries):
      921                     raise ValueError(&quot;x must be a label or position&quot;)
      922                 data = data.set_index(x)
  
  ~\Anaconda3\lib\site-packages\pandas\core\frame.py in __getitem__(self, key)
     3028             if is_iterator(key):
     3029                 key = list(key)
  -&gt; 3030             indexer = self.loc._get_listlike_indexer(key, axis=1, raise_missing=True)[1]
     3031 
     3032         # take() does not accept boolean indexers
  
  ~\Anaconda3\lib\site-packages\pandas\core\indexing.py in _get_listlike_indexer(self, key, axis, raise_missing)
     1264             keyarr, indexer, new_indexer = ax._reindex_non_unique(keyarr)
     1265 
  -&gt; 1266         self._validate_read_indexer(keyarr, indexer, axis, raise_missing=raise_missing)
     1267         return keyarr, indexer
     1268 
  
  ~\Anaconda3\lib\site-packages\pandas\core\indexing.py in _validate_read_indexer(self, key, indexer, axis, raise_missing)
     1306             if missing == len(indexer):
     1307                 axis_name = self.obj._get_axis_name(axis)
  -&gt; 1308                 raise KeyError(f&quot;None of [{key}] are in the [{axis_name}]&quot;)
     1309 
     1310             ax = self.obj._get_axis(axis)
  
  KeyError: &quot;None of [Index(['2000-01-01', '2000-01-02', '2000-01-03', '2000-01-04', '2000-01-05',\n       '2000-01-06', '2000-01-07', '2000-01-08', '2000-01-09', '2000-01-10',\n       ...\n       '2002-09-17', '2002-09-18', '2002-09-19', '2002-09-20', '2002-09-21',\n       '2002-09-22', '2002-09-23', '2002-09-24', '2002-09-25', '2002-09-26'],\n      dtype='object', length=1000)] are in the [columns]&quot;
  </code></pre>
  <p>Though this does not impact my work directly, but I will certainly like to know why this is happening. Thanks in advance!!</p>