Advertisement
bard356

MAU

May 6th, 2020
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.63 KB | None | 0 0
  1. import pandas as pd
  2. users_data = pd.read_csv('/datasets/users_data.csv')
  3.  
  4. users_data['session_start_ts'] = pd.to_datetime(users_data['session_start_ts'])
  5. users_data['session_end_ts'] = pd.to_datetime(users_data['session_end_ts'])
  6.  
  7. users_data['session_year']  = users_data['session_start_ts'].dt.year
  8. users_data['session_month'] = users_data['session_start_ts'].dt.month
  9. users_data['session_week']  = users_data['session_start_ts'].dt.week
  10. users_data['session_date'] = users_data['session_start_ts'].dt.date
  11.  
  12. mau_total = users_data.groupby(['session_year','session_month']).agg({'id': 'nunique'}).mean().astype('int64')
  13. print(mau_total)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement