Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- logs = pd.read_csv('/datasets/logs.csv')
- logs['email'] = logs['email'].fillna(value='')
- logs.loc[logs['source'] == 'None', 'source'] = 'email'
- logs_grouped = logs.groupby('source').agg({'purchase': ['count', 'sum']})
- logs_grouped['conversion'] = logs_grouped['purchase']['sum'] / logs_grouped['purchase']['count']
- print(logs_grouped)
Add Comment
Please, Sign In to add comment
