jamescooper
Well-known Member
- Joined
- Sep 8, 2014
- Messages
- 886
Hello, trying to filter today's date, which is in the format dd/mm/yyyy
import pandas as pd
from datetime import date
today_format = datetime.datetime.strptime(today, "%d/%m/%y")
filtered_df = df[df['Date Captured'] == today_format]
ct_mean = pd.crosstab(filtered_df['Check-In'], filtered_df['Date Captured'], values=filtered_df['Current price'], aggfunc='min').sort_index(axis=1, ascending=False).fillna('')
Any idea how to get this to work?
Many thanks.
import pandas as pd
from datetime import date
today_format = datetime.datetime.strptime(today, "%d/%m/%y")
filtered_df = df[df['Date Captured'] == today_format]
ct_mean = pd.crosstab(filtered_df['Check-In'], filtered_df['Date Captured'], values=filtered_df['Current price'], aggfunc='min').sort_index(axis=1, ascending=False).fillna('')
Any idea how to get this to work?
Many thanks.