Count no. of specific values in a dataframe pandas

Question

I am a newbie in data analysis stuff. I am trying to analyse a dataset using python.

PassengerId Survived Pclass Sex 0 1 0 3 male 1 2 1 1 female 2 3 1 3 male 3 4 1 1 female 4 5 0 3 male

I tried groupby() but its giving error.

In[88] titanic_data.groupby('Survived') Out[88] <pandas.core.groupby.DataFrameGroupBy object at 0x000000000BFFE588>

Please suggest solution

Can you show your efforts, also the norm is to provide raw data rather than an image of your data. — EdChum, Jul 28 '16 at 07:44
Thanks for suggesting me to paste raw data. I have posted it. — Rahul Saxena, Jul 28 '16 at 07:56
To clarify, it isn't giving an error. It is printing an object reference rather than a human-readable format for the table (because of the grouping). Edit submitted. — IBBoard, Aug 16 '18 at 14:20

score 5 · Accepted Answer · answered Jul 28 '16 at 07:43

5

df['Survived'].value_counts()
df['Sex'].value_counts()

answered Jul 28 '16 at 07:43

shivsn

1 problem per question, incrementing your requirements is poor form, SO is not a forum – EdChum Jul 28 '16 at 07:52
@EdChum thanks for your suggestion – Rahul Saxena Jul 28 '16 at 07:56
This counts total number of male and female but how about number of females in pclass1 and number of males in pclass2 etc? – TokyoToo May 25 '20 at 09:25

1 Answers1