registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now showing results for pandas pivot table for many columns
1import pandas as pd
2import numpy as np
3arrays = [['Monday','Monday','Tursday','Tursday'],
4 ['Morning','Noon','Morning','Evening']]
5tuples = list(zip(*arrays))
6index = pd.MultiIndex.from_tuples(tuples, names=['Weekday', 'Time'])
7df = pd.DataFrame(np.random.randint(5, size=(4,2)), index=index)
8
9In [39]: df
10Out[39]:
11 0 1
12Weekday Time
13Monday Morning 1 3
14 Noon 2 1
15Tursday Morning 3 3
16 Evening 1 2
17
18In [40]: pd.DataFrame(df.to_records())
19Out[40]:
20 Weekday Time 0 1
210 Monday Morning 1 3
221 Monday Noon 2 1
232 Tursday Morning 3 3
243 Tursday Evening 1 2
25
similar questions
pandas df multiindexdrop duplicate index pandaspython remove multiple element from list by indexpandas change order of columns in multiindexmultiple delimiters pandashow to remove last 2 rows in a dataframedataframe multiindexreset index 28drop 3dtrue 29how to slice few rows in pandastrim multiple spaces in pythondrop multiple columns pandaspython pandas remove non numeric characters from multiple columnsdelete multiple dataframes at once in pythondjango multi column indexdrop index in multiindex pandaspandas concat and reset indexpandas remove multi header from dataframedrop a range of rows pandaspandas remove repeated indexpython numpy array delete multiple columnsflattening multi index dataframeexclude index column pandaspython how to copy a 2d array leaving out last columnqueries leading to this page
unstack 28 29pandas unstack multiindexunstack 28 29 in pythondataframe unstack sql resultsunstack column pandaspd after unstackunstack multiindex columns pandaspython unstack exampleunstack 28 29 other waypandas unstack multiindex columnspandas unstack examplematrix unstackunstack 28 29 trong pythondf unstackwhat does pandas unstack dopivot dataframe set indexunstack multilevel index pandaspd unstackunstack pandas unstack 28 29 pandaspandas dataframe unstack multiindexunstack pythonunstacking in pandaspandas unstackdf unstackphyton unstack using columnunstack in pythonunstack in pandaspandas sunstack pandas unstack convert unstack to dataframe in pandaspandas reset index vs unstackvalue counts pandas unstackunstack pandas dataframe pandas stack multiple columnspandas unstack rows to columnsget rid of multiindex pandas after unstackhow extract columns from dataframe with unstack 28 29column names in pandas pivot