I have multiindex like this:
col1 col2 col3 ...
Chars Date ...
A 2020 January 4.0 1,417.0 1,136.0 ...
2020 February .
2020 March .
2020 April .
2020 May
2020 June
2020 July
2020 Agust
2020 September
2020 October
2020 November
2020 December
B 2020 January 4.0 1,007.0 975.0 ...
2020 February .
2020 March .
2020 April .
2020 May
2020 June
2020 July
2020 Agust
2020 September
2020 October
2020 November
2020 December
.
.
.
I want to order this multiindex's index at levels=0.('Chars'). But I want to change the order of index due to a list. I have tried:
order_list = ['B', 'C', 'Z', 'Y' ... 'E', 'A']
df = df.loc[order_list]
Can anyone help?