Untitled

 avatar
unknown
plain_text
2 years ago
857 B
5
Indexable
# Посмотрим распределение по группам и конверсию в каждой группе. Нужен новый датасет.
event_funnel_by_group = logs_new.pivot_table(index='event_name', 
                                             columns='group',
                                             values='device_id', 
                                             aggfunc='nunique')\
                                .sort_values(by = 247, ascending=False)
event_funnel_by_group['246+247'] = event_funnel_by_group[246] + event_funnel_by_group[247]
event_funnel_by_group['all'] = event_funnel_by_group[246] + event_funnel_by_group[247] + event_funnel_by_group[248]
event_funnel_by_group.drop(['Tutorial'], inplace = True)
event_funnel_by_group = event_funnel_by_group.reset_index()
display(event_funnel_by_group)