# Посмотрим распределение по группам и конверсию в каждой группе. Нужен новый датасет.
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)