Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- events = pd.read_csv('/datasets/coffee_home.csv')
- events['coffee_time'] = pd.to_datetime(events['coffee_time'])
- events['first_coffee_datetime'] = pd.to_datetime(events['first_coffee_datetime'])
- events['time_to_event'] = events['coffee_time'] - events['first_coffee_datetime']
- filtered_events = events[events['time_to_event'] < '30 days']
- count_events_by_users = filtered_events.groupby(['user_id']).agg({'coffee_time':'count'}).reset_index()
- count_events_by_users['is_target_behavior'] = count_events_by_users['coffee_time'] > 4
- print(count_events_by_users.head(10))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement