How to query from multiindex dataframe containing data and time as index

Question

Check this image of dataframe

I've posted the picture of dataframe I am working with, I want to pull out data from specific times of a certain date

I've tried

Both do not work.

It seems like you have date, and time indices as string. – ThePyGuy Sep 07 '21 at 05:26 — ThePyGuy, Sep 07 '21 at 05:26

score 1 · Answer 1 · answered Sep 07 '21 at 05:27

1

Just try:

stockdf.loc[("2015-01-01", "09:17:00")]

If they're dates:

stockdf.loc[(pd.to_datetime("2015-01-01").date(), pd.to_datetime("09:17:00").time())]

answered Sep 07 '21 at 05:27

U13-Forward

Dupe, second answer. – jezrael Sep 07 '21 at 05:32
My indexes are already in date and time format, i tried the first one with date it works. But with date and time together like you said it doesnt. Key error -' 09:17:00' – Rajat Yadav Sep 07 '21 at 05:32
@jezrael Ok... . – U13-Forward Sep 07 '21 at 05:37
second one doesn't work too – Rajat Yadav Sep 07 '21 at 05:51

1 Answers1