/Python/How to unstack multiindex pandas

How to unstack multiindex pandas

import pandas as pd
import numpy as np
arrays = [['Monday','Monday','Tursday','Tursday'],
                        ['Morning','Noon','Morning','Evening']]
tuples = list(zip(*arrays))
index = pd.MultiIndex.from_tuples(tuples, names=['Weekday', 'Time'])
df = pd.DataFrame(np.random.randint(5, size=(4,2)), index=index)

In [39]: df
Out[39]: 
                 0  1
Weekday Time         
Monday  Morning  1  3
        Noon     2  1
Tursday Morning  3  3
        Evening  1  2

In [40]: pd.DataFrame(df.to_records())
Out[40]: 
   Weekday     Time  0  1
0   Monday  Morning  1  3
1   Monday     Noon  2  1
2  Tursday  Morning  3  3
3  Tursday  Evening  1  2

-1

Source: stackoverflow.com

Similar codes

0 vote218 views1 answer
How to swirtch the placement of the levels in pandas
Python
0 vote232 views1 answer
Pte or Pvt
Python
0 vote208 views1 answer
How to group multiple test in pytest
Python
10 votes241 views2 answers
Rotation turtle python
Python
0 vote181 views1 answer
How to use constructor of base class in derived class in python
Python
0 vote210 views1 answer
How to make bot commands case insensitive in discord.py
Python
310 votes356 views10 answers
Font awesome cdn
Python
2 votes223 views2 answers
Formula of factorial
Python
9 votes217 views2 answers
Update my anaconda
Python
4 votes222 views2 answers
Python print time difference
Python