Convert dataframe column to dataframe header

Asked Jan 08 '20 at 22:52

Active Jan 08 '20 at 22:52

Viewed 22 times

I have a data frame (df) like this:

sem|course|count
sem1|A|1
sem1|B|2
sem1|C|1
sem2|A|2
sem2|B|2
sem2|C|2
sem3|C|2
sem4|A|2

From the above data frame,I want output as a dataframe like this:

  sem1|sem2|sem3|sem4
A  1|2|0|2
B  2|2|0|0
C  1|2|2|0

I have tried the following code:

df.groupby(["sem","course"]).apply(list)

I haven't got the expected output.Could anyone help?

asked Jan 08 '20 at 22:52

Sri Test

df.pivot(index='course', columns='sem', values='count').fillna(0) – thushv89 Jan 08 '20 at 22:57
When I do df.columns,I want sem1,sem2,sem3,sem4 as column names which I couldn't achieve with this – Sri Test Jan 09 '20 at 10:02
This should work fine. What did you get? – thushv89 Jan 09 '20 at 12:03
@thushv89 It displays the following output `Index(['sem1', 'sem2', 'sem3', 'sem4'], dtype='object', name='semester')` I actually need this for the columns and index as subjects. – Sri Test Jan 09 '20 at 12:35
@thushv89 I refer to courses by subjects in the above comment – Sri Test Jan 09 '20 at 12:48

0 Answers0