Python, sort

[jamescooper]

My following code works nicely but I'd like to be able to sort axis 1 ascending, adding the bold doesn't work; any ideas?

import pandas as pd
filtered_df = df[df['Hotel Name'] == 'Leonardo Hotel']
ct_mean = pd.crosstab(filtered_df['Check-In'], filtered_df['Date Captured'], values=filtered_df['Current price'], aggfunc='min')
.fillna('')
.sort_index(axis=1, ascending=False)

 

[Cubist]

Try sort first then fillna.

 

[jamescooper]

Thanks still getting #Python!

Not sure if this time it is because I have a filtered column?

 

[Cubist]

Check if there are entries for 'Leonardo Hotel'.

 

[jamescooper]

There are, just to be clear; this is what you recommended;

import pandas as pd
filtered_df = df[df['Hotel Name'] == 'Leonardo Hotel']
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]

...as this doesn't work.

Without the text in bold it works but the dates are around the wrong way.

 

[jamescooper]

Really sorry Cubist, changing it around worked!