Pandas count groupby values

Question

Example df:

df = pd.DataFrame({
    'group': ['a', 'a', 'a', 'a', 'a', 'b', 'b', 'b', 'b',],
    'value': ['yes', 'yes', 'yes', 'no', 'no', 'yes', 'no', 'no', 'no']
})

I need to count each value in group and get something like this:

group yes no
a     3   2
b     1   3

I tried df.groupby(['group', 'value'])['value'].count().to_frame() and its look fine but too multiindexed, i need simple table like example above

Fix your code by adding unstack and some formatting: `df.groupby(['group', 'value'])['value'].count().unstack().rename_axis(None,axis=1).reset_index()` — anky, Aug 31 '20 at 16:14

score 0 · Answer 1 · answered Aug 31 '20 at 16:15

0

try:

df.groupby(['group', 'value'])['value'].count().reset_index()

next, you can change the column names

answered Aug 31 '20 at 16:15

aggis

608
4
9

Pandas count groupby values

1 Answers1