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

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](https://stackoverflow.com/questions/22391433/count-the-frequency-that-a-value-occurs-in-a-dataframe-column) — Manpreet Singh, Sep 14 '21 at 14:22

score 2 · Accepted Answer · answered Sep 14 '21 at 14:28

2

This should work,

df['genus'].value_counts()

or

df.genus.value_counts()

answered Sep 14 '21 at 14:28

Deera Wijesundara

580
4
15

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

1 Answers1