A Collection of Data Science Take-Home Challenges


Query 3



Goal


We define as power users those users who bought at least 10 products. Write a query that returns for each user on which day they became a power user. That is, for each user, on which day they bought the 10th item.

The table below represents transactions. That is, each row means that the corresponding user has bought something on that date.


Data


You can download the data set by clicking here.

head (data,1)

Column Name Value Description
user_id 675 this is id of the user
date 2014-12-31 16:16:12 user 675 bought something on Dec 31, 2014 at 4:16:12 PM




Click here for mock phone interviews to practice similar questions, DS takehome challenges, and more