i have the below code that compares a date column with a given date and i am expecting to get an output when condition is met,i.e date in date column comes after given date. Any help in this would be appreciated.Thanks
import pandas as pd
df1=pd.read_excel('test_date.xlsx',engine='openpyxl')
start_date = pd.Timestamp(2024, 5, 1)
filtered_date = df1.loc[df1['date'] > start_date]
filtered_date.to_csv("filtered.csv",index=False)
input file:
output expected:
1