convert rows from dataframe to columns, matching row on a shared column value

Asked Sep 17 '20 at 08:18

Active Sep 17 '20 at 08:18

Viewed 12 times

Suppose I have a dataframe like this (extracted from key/value SQL table):

id     | key | value
------------------------
abc123 | foo | "horse"
abc123 | bar | 42
def456 | foo | "zebra"
def456 | foo | 101

I'd like to convert to a dataframe that pivots on the id column, using the values of key as new column names:

id     | foo     | bar
------------------------
abc123 | "horse | 42
def456 | "zebra" | 101

Is pivot what I'm looking for? Always had a hard time with my pivot intuition...

Any suggestions on how to do this idiomatic pandas way? Thanks.

asked Sep 17 '20 at 08:18

ghukill

1

yop, need `pivot` – jezrael Sep 17 '20 at 08:20
1

Thanks @jezrael, was literally just answering my own question with a `df.pivot` that did precisely that. – ghukill Sep 17 '20 at 08:22

0 Answers0