python find specific value in dataframe

Question

I am trying to get a specific value in a dataframe that is composed of two columns, Date and Close. what I need is a close value of a specific date.

As a first step, I tried to find a specific date in the date column using the code below, but I keeps failing.

df[df['Date'].isin([specific_date])]

I can't come up with any better idea than this. Please help me.

score 0 · Accepted Answer · answered Feb 27 '21 at 09:46

0

df.loc[ df['Date'] == specific_date ]

answered Feb 27 '21 at 09:46

alexzander

Thanks, but I tried it before, and when I print the result, it says empty dataframe. I don't know what the problem is. – NAM Feb 27 '21 at 09:56
can you give me the dataframe to find a solution for you? – alexzander Feb 27 '21 at 09:58
Thanks it solved. The problem is the date was not in the dataframe. I thought every date is in df. – NAM Feb 27 '21 at 10:01
my pleasure to help. – alexzander Feb 27 '21 at 10:03

1 Answers1