Pandas Pivot table with multi index

Question

Input Dataframe:

I am trying to pivot my df by sorting Time Column in column wise
my output df:

Pivoting df wont give Time in sorted order. Is there any alternate way to do ?

Please don't post images of code (or links to them)

jezrael
– jezrael

2018-06-25 13:24:56 +00:00
Commented Jun 25, 2018 at 13:24 — jezrael
– jezrael, Commented Jun 25, 2018 at 13:24

jezrael · Accepted Answer · 2018-06-26 06:35:54Z

1

You need reindex by unique values of column Loc_Time with sort_values by column Time, because pivot by default sorting:

df1 = df.pivot('Group','Loc_Time','Value')
df1 = df1.reindex(columns=df.sort_values('Time')['Loc_Time'].unique())
print (df1)
Loc_Time  loc1_Week1  loc2_Week1  loc3_Week1  loc1_Week2  loc2_Week2  \
Group                                                                  
prod1             10          12          14          11          13   
prod2             20          22          24          21          23   

Loc_Time  loc3_Week2  
Group                 
prod1             15  
prod2             25

Detail:

print (df.sort_values('Time')['Loc_Time'].unique())

['loc1_Week1' 'loc2_Week1' 'loc3_Week1' 'loc1_Week2' 'loc2_Week2'
 'loc3_Week2']

edited Jun 26, 2018 at 6:35

answered Jun 25, 2018 at 13:34

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nick Over a year ago

thanks, @jezrael but my desired output is lill different from yours. I need Time column to be sorted.

Collectives™ on Stack Overflow

Pandas Pivot table with multi index

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related