Python filter with crosstab

[jamescooper]

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.

 

[Cubist]

Try:

import pandas as pd
from datetime import datetime

today_format = datetime.strptime(datetime.today().strftime('%d/%m/%Y'), "%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('')

 

[jamescooper]

Thanks that works and this time sort by the values

values=filtered_df['Current price']

 

[Cubist]

sort by the values

values=filtered_df['Current price']

Sort how?

 

[jamescooper]

Highest to lowest please.

 

[Cubist]

By row or by column?

 

[jamescooper]

Column thanks.

 

[Cubist]

I don't think what you're asking make sense.