The sample data in my dataframe is as follows.

enter image description here

What I want to do is create a new dataframe from this one that contains 2 columns, I want to have all 12 community areas (as below) and the count of times "OFFENSE INVOLVING CHILDREN" from the primary type column shows up for each of these communities.

enter image description here

I've used group by and count functions and haven't been able to achieve this.

I figured out how to use the group by function but have not been able to also count the number of times that value shows up for each of the communities.

CodePudding user response：

IIUC, value_counts gives you the count of the

df.loc[df['Primary Type'].eq('OFFENSE INVOLVING CHILDREN')]['Community Area'].value_counts()

PS: if you had shared the minimal reproducible example, it would have allowed me to share the results too