Getting count groupby right on pandas

Question

I have this dataframe:

I want to groupby code and count how many of each code there is in the dataframe, so it get to look like this:

   code  count     
0  0000      2 
1  0123      2
2  4567      1

I was using: group=df.groupby('code').agg('count') However I wasn't getting it right.

Can someone help?

`df.groupby('code').size()` – user3483203 May 26 '18 at 01:32 — user3483203, May 26 '18 at 01:32
Or, `df.code.value_counts()` – user3483203 May 26 '18 at 01:39 — user3483203, May 26 '18 at 01:39

score 0 · Answer 1 · answered Jun 20 '18 at 08:48

Had a similar problem and I'm forming @user3483203's comments into an answer so the question can be marked as answered.

Using:

df.groupby('code').size()

# OR

df.code.value_counts()

This groups all rows with matching codes and outputs the total for each code.

1 Answers1