How to use Stacking using non-hierarchical indexes in Pandas?
Stacking using non-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------ Stacking DataFrame -----\n") print(df.stack(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 ------ Stacking DataFrame ----- Basket1 Apple 10.0 Orange 30.0 Banana 40.0 Basket3 Apple 15.0 Orange 8.0 Banana 12.0 Basket4 Apple 15.0 Orange 14.0 Banana 1.0 Pear 8.0 Basket5 Apple 7.0 Orange 8.0 Basket6 Apple 5.0 Orange 4.0 Banana 1.0 dtype: float64 C:\pandas>
2018-10-17T09:28:50+05:30
2018-10-17T09:28:50+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution