Create pivot table in pandas

Asked Mar 26 '21 at 06:10

Active Mar 26 '21 at 06:19

Viewed 34 times

I have my dataframe say df

data = [['00637', 'rew_A'], ['5644', 'rew_A'], ['564', 'rew_A'], 
        ['2218', 'rew_C'], ['990', 'rew_C'], ['17', 'rew_A'], 
        ['5565', 'rew_C'], ['121', 'rew_A'], ['76700', 'rew_B'],
         ['00637', 'rew_C']]
t = pd.DataFrame(data, columns = ['emp_id', 'reward'])
t

    emp_id  reward
0   00637   rew_A
1   5644    rew_A
2   564     rew_A
3   2218    rew_C
4   990     rew_C
5   17      rew_A
6   5565    rew_C
7   121     rew_A
8   76700   rew_B
9   00637   rew_C

My OP should contain 4 columns i.e - emp_id, rew_A, rew_B, and rew_C, a basic pivot table which should look like -

    emp_id  rew_A   rew_B   rew_C
0   00637   1                1
1   5644    1       
2   564     1

Please help me out to create this.

Thanks!!! :)

asked Mar 26 '21 at 06:10

KReEd

1

I think you need `crosstab` – jezrael Mar 26 '21 at 06:13
`need to arrange the columns ` can you explain more? – jezrael Mar 26 '21 at 07:18
@jezrael, Sir thanks for your reply, just need to arrange the columns, `reward rew_A rew_B rew_C emp_id` – KReEd Mar 26 '21 at 07:18
I think format of comments is bad, better is edit question. – jezrael Mar 26 '21 at 07:20
it came like this - `reward` `rew_A` `rew_B` `rew_C` and beneath reward it gives `emp_id` Sir, did you get it now? – KReEd Mar 26 '21 at 07:22

Create pivot table in pandas

0 Answers0