Tag: data analysis programming

01 – User Session Count User behavior data table userid action_type action_time U1059 login 2023-12-01 18:00:10 U1092 login 2023-12-01 18:00:17 U1069 login 2023-12-01 18:00:22 … … … A session is considered over if a user does not take any action within 10 minutes, or if they do not log in within 5 minutes after logging out. Calculate the number of sessions for each user. Copy Code：https://c.scudata.com/article/1729475229196#toc_h3_1 02 – Count the players who score 3 times in a row within 1 minute Score table of a ball game team player play_time score A A3 2023-12-31 09:00:09 2 B B1 2023-12-31 09:00:24