Data Analysis Programming from SQL to SPL: Sequential Events
The following is part of the data from the simplified user behavior table actions, which records the occurrence time of 9 types of events for each user: Download test data 1.Find users whohave sequentially triggered events e2, e3, e7 Sequential events do not require continuity. First, group the events by user. Then, sort each user’s events by time. Next, loop through each user’s e2 event to search for an e3 event after it. If an e3 is found, search for an e7 event after e3. If an e7 is found, the user is deemed to satisfy the criteria. Let’s look
...