What % of users are still playing the game daily?
I am going to share a question that I was asked in a data science interview. I failed the interview as I couldn't answer the question and still now I don't have any idea how to solve it.
Below a data table is given. It's about number of users of a mobile game.
Users Assigned = Newly added users on a day.
Active users = Total users active on a day.
The question is- What % of users are still playing the game daily? Options are
- Almost 5%
- Almost 10% to 15%. And I was ask to show the step by step processes.
It was my first-ever interview in life, so I was nervous and couldn't solve within given time. I hope someone will answer me here and will explain it clearly.
On day 0 you have 4051 users, all of which are active.
On day 1 you have 4095 added users meaning 4051+4095, of which 5522 are active.
Given that registration seems to indicate activity, we have to exclude those that registered today, meaning
Day 1 active users = (5522-4095) / (4051+4095) = 0.1751780015 => 18%
Continue this until day 6 when you have 6820 active with a total playerbase of 4051+4095+3868+3921+4010+4070+4001
Day 6 = (6820-4001) / (4051+4095+3868+3921+4010+4070+4001) = 0.1006210737 =>10%
- how to imitate Pandas' index-based querying in Polars?
- How can I shift a column in a dataframe x times into an array, apply a function, and create a new column?
- Note: you may need to restart the kernel to use updated packages. jupyter
- Is there a way to cumulatively and distinctively expand list in polars
- What is the recommended way for retrieving row numbers (index) for polars?
- Count and groupby a specfic value
- Shape Mismatch XGBoost Regressor
- Pytorch transform.ToTensor() changes image
- TaskRun failed to finish due to an error for Coretex BioInformatics workflow
- Getting ValueError: All arrays must be of the same length
- Why is it that calling standard sum on a numpy array produces a different result than numpy.sum?
- R: monte carlo binomial gambling simulation
- How can I replace null values in polars with a prefix with ascending numbers?
- How to access a part of an element from a list?
- Understanding sklearn's KNNImputer
- sklearn StandardScaler, doesn't allow direct transform, we need to fit_transform
- Sklearn Pipelines + GridsearchCV + XGBoost + Learning Curve
- Pandas: Get Business Month-End Dates Correctly Even for Dates Already on Month-End
- Getting Error 524 while running jupyter lab in google cloud platform
- How can I download a kaggle dataset on my Colab notebook?
- What uml diagrams can be used for a data science project
- How to optimise hyperparameterss for RandomForestClassifier in Python for large datasets?
- Pandas : TypeError: float() argument must be a string or a number
- Training Linear Models with MAE using sklearn in Python
- Calculate T-Student [Test] for different standard Statistical tables in python
- How to plot multiple pandas columns
- Using networkx to create node labels from an array
- Xarray combine datasets with different dimensions?
- SQL - Expand column of arrays into column of elements
- SVC classifier taking too much time for training