Create columns by unique row values

Asked Oct 27 '21 at 14:16

Active Oct 27 '21 at 14:16

Viewed 23 times

I have the following dataset (a bit more elaborate but the below gives a good indication);

and I'm looking to pivot/stack or something to get the following; (Essentially to make the unique values in 'A' the column headers and then B would be in the index)

  22  23  24
1 52  20  45
2 14  15  12
3 11  8   40
4 9   60  52

Any help much appreciated!

asked Oct 27 '21 at 14:16

spcol

1

with ```pivot_table``` --> ```df.pivot_table(columns='A',index='B',values='C')``` – sophocles Oct 27 '21 at 14:21
1

or crosstab `pd.crosstab(df.B,df.A,df.C,aggfunc='first')` – Umar.H Oct 27 '21 at 14:23
1

or unstack `df.set_index(["A","B"]).unstack("A")`. – Henry Yik Oct 27 '21 at 14:25
These are all really helpful, thank you! – spcol Oct 27 '21 at 14:29

Create columns by unique row values

0 Answers0