Python Forum
Index error - columns vs non-column
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Index error - columns vs non-column
#1
Dear users,

I am getting an IndexError, and not sure why? The code (below) works perfectly when I run it using data.cvs. On that type of file, the index is a column (named Date).

But, if I run the code directly from an input library (e.i., df = yf.download(tickers=ticker, start=start, end=end), I receive the trackback message's below. In this example, the date is not considered a column. So, I think the error comes from that; however, I don't know how to fix it.

I hope I am being clear. It is my first post, and I am a beginner.

Thank you

This is my Code:
df_close_adj = pd.DataFrame(data=df[["Close", "Adj_Close"]].to_numpy(), index=df["Date"], columns=[["Close", "Adj_Close"]])
The Traceback I get is this:

Error:
--------------------------------------------------------------------------- KeyError Traceback (most recent call last) /usr/local/lib/python3.7/dist-packages/pandas/core/indexes/base.py in get_loc(self, key, method, tolerance) 2897 try: -> 2898 return self._engine.get_loc(casted_key) 2899 except KeyError as err: pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc() pandas/_libs/index.pyx in pandas._libs.index.IndexEngine.get_loc() pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item() pandas/_libs/hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item() KeyError: 'Date' The above exception was the direct cause of the following exception: KeyError Traceback (most recent call last) 2 frames /usr/local/lib/python3.7/dist-packages/pandas/core/indexes/base.py in get_loc(self, key, method, tolerance) 2898 return self._engine.get_loc(casted_key) 2899 except KeyError as err: -> 2900 raise KeyError(key) from err 2901 2902 if tolerance is not None: KeyError: 'Date'
Reply


Messages In This Thread
Index error - columns vs non-column - by Vinny - Aug-03-2021, 08:56 PM
RE: Index error - columns vs non-column - by Vinny - Aug-09-2021, 03:57 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Converting column of values into muliple columns of counts highland44 0 383 Feb-01-2024, 12:48 AM
Last Post: highland44
  pyscript index error while calling input from html form pyscript_dude 2 1,143 May-21-2023, 08:17 AM
Last Post: snippsat
  Index error help MRsquared 1 890 May-15-2023, 03:28 PM
Last Post: buran
  I'm getting a String index out of range error debian77 7 2,590 Jun-26-2022, 09:50 AM
Last Post: deanhystad
  df column aggregate and group by multiple columns SriRajesh 0 1,146 May-06-2022, 02:26 PM
Last Post: SriRajesh
  Removing the index column from df bnadir55 7 3,484 Apr-05-2022, 02:49 PM
Last Post: snippsat
  Transform 3 Columns into Single Column DaveG 8 2,110 Apr-04-2022, 08:42 AM
Last Post: Pedroski55
  Split single column to multiple columns SriRajesh 1 1,426 Jan-07-2022, 06:43 PM
Last Post: jefsummers
  pandas pivot table: How to find count for each group in Index and Column JaneTan 0 3,511 Oct-23-2021, 04:35 AM
Last Post: JaneTan
  How to remove a column or two columns in a correlation heatmap? lulu43366 3 5,538 Sep-30-2021, 03:47 PM
Last Post: lulu43366

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020