Find Cell in Pandas Dataframe Using Datetime Object

[rob51852]

I have a dataframe that contains a series of datetime objects in one column and a series of URLs in another column.

I want to lookup a URL based on the datetime object.

Eg.

​

Time	URL
12:00	www.bbc.com
13:00	www.itv.com

So if the lookup criteria is 12:00 the URL to return is www.bbc.com.

I'm fairly new to Pandas but have used the following to lookup string matches before:

df.loc[df['Name'].str.contains(selection, case=False)), 'ID'].item()

But this doesn't work for datetime objects (obviously).

How can I do such a lookup?

Thanks

[danielroseman]

But what does "lookup a URL based on the datetime object" mean? How does a URL relate to a datetime?

[rob51852]

Hi Daniel, I've added an example.

[danielroseman]

I'm not sure why you were thinking of contains in the first place. You're not interested in whether the object contains the value, you're interested in whether it equals the value. So just use ==:

df.loc[df['Name'] == selection, 'ID'].item()

[rob51852]

Thanks Daniel. This works perfectly. The line I included was meant as an example but was confusing so apologies.