Advertisement
AnnaCh1971

Пользовательская сессия из анализ бизнес-показателей

May 10th, 2023
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.69 KB | None | 0 0
  1. import pandas as pd
  2. from matplotlib import pyplot as plt
  3.  
  4. sessions = pd.read_csv('users_sessions_data.csv')
  5. sessions['session_start_ts'] = pd.to_datetime(sessions['session_start_ts'])
  6.  
  7. # определяем год и месяц начала сессии
  8. sessions['session_year'] = sessions['session_start_ts'].dt.year
  9. sessions['session_month'] = sessions['session_start_ts'].dt.month
  10.  
  11. sessions_per_user = sessions.groupby(['session_year', 'session_month']).agg(
  12. {'client_id':['count', 'nunique']})
  13.  
  14. sessions_per_user.columns = ['n_sessions', 'n_users']
  15.  
  16. sessions_per_user['sess_per_user'] = (
  17.     sessions_per_user['n_sessions']/ sessions_per_user['n_users'])
  18.  
  19. print(sessions_per_user)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement