How to count group by condition in pandas?

user_19371934 0
Viewed 26

My input dataframe name 'df'

enter image description here

I want to create a new dataframe name 'df1' group by 'date' in df, which include 2 fields: 'date' and 'sponsorRate' with calculation formula as below

date = df.date sponsorRate = count(sponsored) on check column / count total on check column

My desired output

enter image description here

Tks for all helps

pandas python-3.x
1 Answers

Compare check and aggregate mean:

df1 = df['check'].eq('sponsored').groupby('date').mean().reset_index()

Or:

df1 = df['check'].eq('sponsored').groupby(level=0).mean().reset_index()
user_29010020
Related