Count number of occurrence in a column Python

Question

I want to count the number of occurrences for each input in the column Echantillon. For example:

Echantillon   Classe
1001            0
956             1
9658            2
1001            0
8566            2
956             1

How can this be done using Python?

SO is not a code writing service. As a general rule, I would think that a questioner puts in at least twice as much time into solving the problem themselves as it takes to describe the problem here, and show their working. — Andrew
– Andrew, Commented Sep 5, 2016 at 15:10

bikuser · Accepted Answer · 2016-09-05 15:44:04Z

0

If I understand properly then you want total numbers by classes. If it so then you can do it by:

In [9]: df
Out[9]: 
   Echantillon  Classe
0         1001       0
1          956       1
2         9658       2
3         1001       0
4         8566       2
5          956       1

then you can use groupby function:

In [10]: df.groupby(df['Classe']).sum()
Out[10]: 
        Echantillon
Classe             
0              2002
1              1912
2             18224

answered Sep 5, 2016 at 15:44

bikuser

2,1234 gold badges37 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Count number of occurrence in a column Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related