How to Extract Data by Date and Time within a time frame - Python Pandas CSV

Question

I am trying to extract all rows by date and time in a certain time frame (For example between 05/24/2021 12:50 and 07/24/2021 21:00. The data that I am using is shown below:

The code that I have now is:

import pandas as pd

df = pd.read_csv(r"C:\Users\OneDrive\Desktop\entries-88339.csv") #to read a CSV
print(df) #print original data
df.head()

df_rename = df.rename(columns = {'DATE': 'ENTRY DATE'}) #ENTRY DATE = DATE column
print(df_rename)


df_date = df_rename[(df_rename['ENTRY DATE'] <= '05-26-21') & (df_rename['ENTRY DATE'] > '05-03-21')] #date timeframe
print(df_date)

path = '/Users/Desktop' #for exporting to new csv
new_file = 'New_file.csv'
df_date.to_csv(new_file, index = False) #index = False is no index to csv

I am getting an error on df_date = df_rename[(df_rename['ENTRY DATE'] <= '05-26-21') & (df_rename['ENTRY DATE'] > '05-03-21')] #date timeframe print(df_date) — Dana7371
– Dana7371, Commented Jul 14, 2021 at 18:52

Utsav · Accepted Answer · 2021-07-14 00:33:15Z

1

Toy Example

Input Df

    EntryDate           Values
0   2021-05-21 16:31:00 1
1   2021-05-24 12:51:00 2
2   2021-06-21 16:31:00 3
3   2021-07-24 12:51:00 4
4   2021-07-24 22:31:00 5

Code

df.EntryDate = pd.to_datetime(df.EntryDate, format='%m/%d/%Y %H:%M')

start_date = '05-24-2021 12:50'
end_date = '07-24-2021 21:00'
mask = (df['EntryDate'] > start_date) & (df['EntryDate'] <= end_date)
df.loc[mask]

Output

    EntryDate           Values
1   2021-05-24 12:51:00 2
2   2021-06-21 16:31:00 3
3   2021-07-24 12:51:00 4

answered Jul 14, 2021 at 0:33

Utsav

6,1032 gold badges36 silver badges58 bronze badges

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

2 Comments

Dana7371 Over a year ago

Where did you get the EntryDate from in df.EntryDate?

Dana7371 Over a year ago

df.EntryDate ?

Collectives™ on Stack Overflow

How to Extract Data by Date and Time within a time frame - Python Pandas CSV

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related