Making a matrix from from unique values from two columns

Asked Dec 15 '18 at 12:54

Active Dec 15 '18 at 12:54

Viewed 22 times

I have dataset in this form:

data = {'col1':['a','a','b','c'],
        'col2':['d','e','f','g'],
        'col3':[1,2,3,4]}
pd.DataFrame(data)

   col1 col2 col3
0   a   d   1
1   a   e   2
2   b   f   3
3   c   g   4

But i want data to be of following form:

    d   e   f   g
a   1   1   0   0
b   0   0   1   0
c   0   0   0   1

Any help?

asked Dec 15 '18 at 12:54

Ankish Bansal

1,827
3
15
25

Any Try from your end? – A l w a y s S u n n y Dec 15 '18 at 12:55
4

`pd.crosstab(df.col1, df.col2)` – cs95 Dec 15 '18 at 13:01
Thanks, what if i want to add same number as (2,3,4) instead of 1 at their places – Ankish Bansal Dec 15 '18 at 13:15
`pd.crosstab(df.col1, df.col2, df.col3)` – cs95 Dec 15 '18 at 14:07

Making a matrix from from unique values from two columns

0 Answers0