Python Pandas pivot_table - Count of values in one column [duplicate]

Question

I am having a DataFrame (28 rows from the Titanic passenger list) which has a column "Sex" consisting of two values, "Male", "Female". I want to get the count of Males/Females

The output should show "Sex" as Row labels(index) and the count (of Male/Female) in the second column

df.pivot_table(index ="Sex", values ="Sex", aggfunc='count')

This returns a "ValueError: Grouper for 'Sex' not 1-dimensional" error.

Please guide

If you need assistance formatting a small sample of your DataFrame as a copyable piece of code for SO see How to make good reproducible pandas examples. — Henry Ecker
– Henry Ecker ♦, Commented Aug 20, 2021 at 2:31
df.pivot_table(index ="Sex",values="PassengerId", aggfunc='count') - This works and gives the result(i.e. when the index and values are different fields. Can it not be done with only the "Sex" column? — user1955215
– user1955215, Commented Aug 20, 2021 at 2:41

Randy · Accepted Answer · 2021-08-20 02:31:49Z

1

It's just df['Sex'].value_counts()

answered Aug 20, 2021 at 2:31

Randy

14.9k3 gold badges40 silver badges44 bronze badges

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

3 Comments

user1955215 Over a year ago

Thanks, This does answer the question and gives the expected result. What would be pivot_table version of the solution?

Trenton McKinney Over a year ago

@user1955215 there isn't one. Look at df.pivot_table(columns="sex", aggfunc='count') and then look at df.pivot_table(index="sex", aggfunc='count'). You'll see that you can't have the same column value for both index and values.

user1955215 Over a year ago

@TrentonMcKinney, Thanks for the clarification regarding "you cant have the same column value".

Collectives™ on Stack Overflow

Python Pandas pivot_table - Count of values in one column [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related