Pandas unstacking using hierarchical indexes
import pandas as pd df = pd.DataFrame([[10, 30, 40], [], [15, 8, 12], [15, 14, 1, 8], [7, 8], [5, 4, 1]], columns=['Apple', 'Orange', 'Banana', 'Pear'], index=['Basket1', 'Basket2', 'Basket3', 'Basket4', 'Basket5', 'Basket6']) print("\n------ DataFrame-----\n") print(df) print("\n------ Unstacking DataFrame -----\n") print(df.unstack(level=-1))
C:\pandas>python example.py ------ DataFrame----- Apple Orange Banana Pear Basket1 10.0 30.0 40.0 NaN Basket2 NaN NaN NaN NaN Basket3 15.0 8.0 12.0 NaN Basket4 15.0 14.0 1.0 8.0 Basket5 7.0 8.0 NaN NaN Basket6 5.0 4.0 1.0 NaN ------ Unstacking DataFrame ----- Apple Basket1 10.0 Basket2 NaN Basket3 15.0 Basket4 15.0 Basket5 7.0 Basket6 5.0 Orange Basket1 30.0 Basket2 NaN Basket3 8.0 Basket4 14.0 Basket5 8.0 Basket6 4.0 Banana Basket1 40.0 Basket2 NaN Basket3 12.0 Basket4 1.0 Basket5 NaN Basket6 1.0 Pear Basket1 NaN Basket2 NaN Basket3 NaN Basket4 8.0 Basket5 NaN Basket6 NaN dtype: float64 C:\pandas>
2018-10-18T10:28:52+05:30
2018-10-18T10:28:52+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution