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
#4
The error is clear and the problem lay in df Dataframe.
When do index=df["Date"] means that the Dataframe most have column named Date.
To show a example.
import pandas as pd

data = {
    "Name": ["Tom", "nick", "krish", "jack"],
    "Date": [20, 21, 19, 18],
}

df = pd.DataFrame(data)
>>> df
    Name  Date
0    Tom    20
1   nick    21
2  krish    19
3   jack    18

>>> df['Date']
0    20
1    21
2    19
3    18
Name: Date, dtype: int64

>>> df.columns
Index(['Name', 'Date'], dtype='object')
If eg put a space in Date string it will fail with your error.
>>> df['Date']
Traceback (most recent call last):
.....  
KeyError: 'Date'

# Date most be the exact name and a column in df
>>> df.columns
Index(['Name', 'Date '], dtype='object')
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
RE: Index error - columns vs non-column - by snippsat - Aug-09-2021, 04:46 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Converting column of values into muliple columns of counts highland44 0 367 Feb-01-2024, 12:48 AM
Last Post: highland44
  pyscript index error while calling input from html form pyscript_dude 2 1,117 May-21-2023, 08:17 AM
Last Post: snippsat
  Index error help MRsquared 1 876 May-15-2023, 03:28 PM
Last Post: buran
  I'm getting a String index out of range error debian77 7 2,540 Jun-26-2022, 09:50 AM
Last Post: deanhystad
  df column aggregate and group by multiple columns SriRajesh 0 1,129 May-06-2022, 02:26 PM
Last Post: SriRajesh
  Removing the index column from df bnadir55 7 3,424 Apr-05-2022, 02:49 PM
Last Post: snippsat
  Transform 3 Columns into Single Column DaveG 8 2,047 Apr-04-2022, 08:42 AM
Last Post: Pedroski55
  Split single column to multiple columns SriRajesh 1 1,410 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,497 Oct-23-2021, 04:35 AM
Last Post: JaneTan
  How to remove a column or two columns in a correlation heatmap? lulu43366 3 5,491 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