Filtering Pandas Dataframe on Time (not Date)

Question

I have the dataframe below and want to filter by time. The time column comes up as an object when I use dtypes.

To get the time to use as the filter criteria I use split:

start_time = "25 September 2022, 13:00:00"
split_time = start_time.split(", ")[1]

I have tried converting split_time and the df column to datime but get an error on the df column conversion:

TypeError: <class 'datetime.time'> is not convertible to datetime

I have also tried a simple string search but this doesn't return any results.

I have been able to filter by date using:

split_date = start_time.split(", ")[0]
event_date = datetime.strptime(split_date, "%d %B %Y") 
events_df['start_date'] = pd.to_datetime(events_df['start_date']) 
filtered_df = events_df.loc[(events_df['start_date'] == event_date)]

But can't seem to do the equivalent for time. Can anyone see the problem?

Thanks

	fixture_id	name	start_date	time
145	9394134	Plymouth Argyle v Ipswich Town	2022-09-25 00:00:00	12:30:00
146	9694948	Grays Athletic v Merstham FC	2022-09-25 00:00:00	13:00:00
147	9694959	FC Romania v Faversham Town	2022-09-25 00:00:00	15:00:00

jezrael · Accepted Answer · 2022-09-23 11:23:25Z

5

Comapre times generated by Series.dt.time with Timestamp.time:

start_time = "25 September 2022, 13:00:00"
dt = pd.to_datetime(start_time, format="%d %B %Y, %H:%M:%S")

events_df['start_date'] = pd.to_datetime(events_df['start_date'])
#if necessary
events_df['time'] = pd.to_datetime(events_df['time']).dt.time

filtered_df = events_df.loc[(events_df['time'] == dt.time())]
print (filtered_df)
        fixture_id                          name start_date      time
1  146     9694948  Grays Athletic v Merstham FC 2022-09-25  13:00:00

answered Sep 23, 2022 at 11:23

jezrael

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

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

Collectives™ on Stack Overflow

Filtering Pandas Dataframe on Time (not Date)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related