Key error for set_index of a pandas dataframe by list object

Question

I want to set the index of a pandas dataframe by a list which includes dates in a common format YYYY:MM:DD hh:mm:ss

index=df.index.tolist()

df2=df1.set_index(index)

the outcome

KeyError: '2011-06-21 00:00:00'

I tried to

df2=df1.set_index(str(index))

because of the backspace between date and time but the result was a KeyError for every single date in my index list.

jezrael · Accepted Answer · 2018-11-20 13:00:31Z

1

Add [] for nested list, else it looking for columns names:

df2 = df.set_index([index])

answered Nov 20, 2018 at 13:00

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1