Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- users_data = pd.read_csv('/datasets/users_data.csv')
- users_data['session_start_ts'] = pd.to_datetime(users_data['session_start_ts'])
- users_data['session_end_ts'] = pd.to_datetime(users_data['session_end_ts'])
- users_data['session_year'] = users_data['session_start_ts'].dt.year
- users_data['session_month'] = users_data['session_start_ts'].dt.month
- users_data['session_week'] = users_data['session_start_ts'].dt.week
- users_data['session_date'] = users_data['session_start_ts'].dt.date
- mau_total = users_data.groupby(['session_year','session_month']).agg({'id': 'nunique'}).mean().astype('int64')
- print(mau_total)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement