Sort dataframe columns by day of the week

Asked Mar 06 '20 at 07:22

Active Mar 06 '20 at 07:22

Viewed 35 times

I created a pivot table with days of the week as columns, and I want to order the columns by day of week: Sunday, Monday, etc.

piv = reports.pivot_table(index='DayOfWeek',columns='Category',aggfunc='size',fill_value=0)

How do I go about this?

asked Mar 06 '20 at 07:22

bco

Change `df['Day of Week'] = df['Day of Week'].astype('category', categories=cats, ordered=True)` to `df.columns = df.columns.astype('category', categories=cats, ordered=True)` and then `df = df.sort_index(axis=1)` – jezrael Mar 06 '20 at 07:24
@jezrael i get the error astype() got an unexpected keyword argument 'categories' – bco Mar 06 '20 at 07:34
Is possible use `df.columns = pd.CategoricalIndex(df.columns, categories=cats, ordered=True)` ? – jezrael Mar 06 '20 at 07:34
@jezrael no error, but the columns still aren't sorted :( – bco Mar 06 '20 at 07:40
do you add `df = df.sort_index(axis=1)` ? – jezrael Mar 06 '20 at 07:41
1

@jezrael worked! thank you so so much – bco Mar 06 '20 at 07:42

0 Answers0