How to sum # of rows of a column containing a categorical variable in Python [duplicate]

Question

Let's say my data frame has a column 'genus', and it contains 5 rows each that contain 'seed', 'flame', 'turtle', and 'shellfish'.

How can you get Python to add up each category and print out a total count for each category? I want to be able to apply a function that will automatically do this for each unique category in the column 'genus' without having to go and parse out each unique category.

I would want to see something like: seed: 5 flame: 5 turtle: 5 Shellfish: 5

(yes, this is a Pokemon dataset 😂)

Does this answer your question? Count the frequency that a value occurs in a dataframe column — Manpreet Singh
– Manpreet Singh, Commented Sep 14, 2021 at 14:22

Deera Wijesundara · Accepted Answer · 2021-09-14 14:28:46Z

2

This should work,

df['genus'].value_counts()

or

df.genus.value_counts()

answered Sep 14, 2021 at 14:28

Deera Wijesundara

7925 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to sum # of rows of a column containing a categorical variable in Python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related