Category

Applied Finance

Category

Below is a dataset with single bets made by gambling customers. Our task is to aggregate them into sessions, group sessions into length groups and calculate the average margin by session length group. For example: Session LengthAvg Margin (GGR divided by Turnover)< 15minX15 – 30 minY30 – 45 minZ…..… Description of the dataset: Player_id – unique player identifierGame_End_Timestamp – indicator when bet was placed (aggregated to full minute)Turnover – amount customer staked in that minuteGGR – gross gaming revenue (turnover – wins), casino revenue in that minute Plan of Action This dataset consists of log entries that contain a player_id, timestamp, and betting information. Our first step would be to group all of the actions that a user takes within a given session. A session can be defined as any continuous entry of logs from a specific user, where the gap between the previous timestamp isn’t more than x minutes.…