Advertisement
praktikum

Untitled

Dec 26th, 2019
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. import pandas as pd
  2. events = pd.read_csv('/datasets/coffee_home.csv')
  3. events['coffee_time'] = pd.to_datetime(events['coffee_time'])
  4. events['first_coffee_datetime'] = pd.to_datetime(events['first_coffee_datetime'])
  5.  
  6. events['time_to_event'] = events['coffee_time'] - events['first_coffee_datetime']
  7. filtered_events = events[events['time_to_event'] < '30 days']
  8.  
  9. count_events_by_users = filtered_events.groupby(['user_id']).agg({'coffee_time':'count'}).reset_index()
  10. count_events_by_users['is_target_behavior'] = count_events_by_users['coffee_time'] > 4
  11. print(count_events_by_users.head(10))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement