Count values in one column based on the categories of other column

Question

I'm working on the following dataset:

and I want to count each value in the LearnCode column for each Age category, I've tried doing it using Groupby method but didn't manage to get it correctly, can anyone help on how to do it?

Yes exactly what I was looking for! Thank you – Abde Jan 08 '22 at 01:01 — Abde, Jan 08 '22 at 01:01

score 1 · Accepted Answer · answered Jan 08 '22 at 00:47

1

You can do this using a groupby on two columns

results = df.groupby(by=['Age', 'LearnCode']).count()

This outputs a count for each ['Age', 'LearnCode'] pair

answered Jan 08 '22 at 00:47

NickHilton

662
6
13

thank you, it works but how can i get the count of each (LearnCode) Category now? – Abde Jan 08 '22 at 00:55

Count values in one column based on the categories of other column

1 Answers1