import pandas as pd import numpy as np
#create a dataframe df = pd.DataFrame({'date': ['2013-04-01','2013-04-01','2013-04-01','2013-04-02', '2013-04-02'], 'user_id': ['0001', '0001', '0002', '0002', '0002'], 'duration': [30, 15, 20, 15, 30]}) df
#here we can count the number of distinct users viewing on a given day df = df.groupby("date").agg({"duration": np.sum, "user_id": pd.Series.nunique}) df