pandas.DataFrame.loc won't work for indexing dates

Question

I'm trying to look for a piece of data by date and value, however, I keep getting an error. Here is the code:

eth.loc['2020-08-13', 'Value']

Here is the error:


        352                 except ValueError as err:
        353                     raise KeyError(key) from err
    --> 354             raise KeyError(key)
        355         return super().get_loc(key, method=method, tolerance=tolerance)
        356 
    
    KeyError: '2020-08-13'

Thanks!

please try eth.loc[eth.columnname=='2020-08-13', 'Value']. where columnname is maybe date. Alternatively post the eth sample dataframe — wwnde
– wwnde, Commented Aug 16, 2020 at 1:06
According to the docs, df.loc will raise a Key Error if any items are not found. It seems you don't have '2020-08-13', if you share a snippet of the data we could help you better. — Algebra8
– Algebra8, Commented Aug 16, 2020 at 1:08

Weber Kanga · Accepted Answer · 2020-08-16 02:11:49Z

2

Assumming you've a dataset defined by:

eth = pd.DataFrame([['2020-08-13', 2], ['2020-08-14', 5], ['2020-08-15', 8]], 
                    index=['book1','book2','book3'], 
                    columns=['Date','Value'])

You can get items with value say 2:

eth.loc[eth['Value'] == 2]

You can get items with date say 2020-08-13:

eth.loc[eth['Date'] == '2020-08-13']

answered Aug 16, 2020 at 2:11

Weber Kanga

212 bronze badges

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

Comments

N T · Accepted Answer · 2020-08-16 01:11:05Z

1

Answer turned out to be eth.loc[eth.columnname=='2020-08-13', 'Value'], thanks to @wwnde for the help!

answered Aug 16, 2020 at 1:11

N T

531 silver badge6 bronze badges

Collectives™ on Stack Overflow

pandas.DataFrame.loc won't work for indexing dates

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related