convert a data frame into pivot table after group by

Question

I have a data frame which I get after doing group by which looks like below:-

data = [[1,'US', 10], [1,'CA', 15], [1,'IN', 14],
        [2,'US', 15], [2,'CA', 9], [2,'IN', 1],
        [3,'US', 16], [3,'CA', 8], [3,'IN', 33]]
 
# Create the pandas DataFrame
df = pd.DataFrame(data, columns = ['fan', 'country','value'])
 
# print data frame.
df

which I want to convert into:-

it helped but not the exact case.. i am quite new to pandas – abhi Jun 23 '21 at 16:53 — abhi, Jun 23 '21 at 16:53

score 2 · Accepted Answer · answered Jun 23 '21 at 16:42

2

You just need pivot:

>>> df.pivot(index="country", columns="fan", values="value").reset_index()
fan country   1   2   3
0        CA  15   9   8
1        IN  14   1  33
2        US  10  15  16

answered Jun 23 '21 at 16:42

not_speshal

22,093
2
15
30

convert a data frame into pivot table after group by

1 Answers1