Get value_counts based on multiple column in python

Question

I am trying to find count of values in column C based on columns A and B. I was trying groupby with no success. How can I achieve this?

df = DataFrame({'A' : ['foo', 'foo', 'foo', 'foo',
                        'bar', 'bar', 'bar', 'bar'],
                'B' : ['1', '1', '1', '2',
                       '1', '1', '2', '2'],
               'C' : [2, 2, 3, 3, 2, 1, 2, 1]})

Result

A, B, C, Count
foo, 1, 2, 2
foo, 1, 3, 1
foo, 2, 3, 1
bar, 1, 1, 1
bar, 1, 2, 1
bar, 2, 1, 1
bar, 2, 2, 1

Not sure exactly what you mean, what does your desired output look like? — Liam Foley
– Liam Foley, Commented Feb 2, 2015 at 23:21

Liam Foley · Accepted Answer · 2015-02-02 23:33:53Z

1

Is this what you're looking for?

In [44]: table = pd.pivot_table(df, values='C', index='A',columns='B', aggfunc=len)
In [45]: df
Out[45]: 
     A  B  C
0  foo  1  2
1  foo  1  3
2  foo  1  3
3  foo  2  3
4  bar  1  2
5  bar  1  3
6  bar  2  2
7  bar  2  2

In [46]: table
Out[46]: 
B    1  2
A        
bar  2  2
foo  3  1

answered Feb 2, 2015 at 23:33

Liam Foley

7,8822 gold badges28 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get value_counts based on multiple column in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related