{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Data Visualisation Coursework Template\n", "\n", "- These headings are only a recommended structure.\n", "- The wordcount code only works in Jupyter Notebook! You can still use JupyterLab to produce your report if you wish but you will need to use Jupyter Notebook to check the number of words.\n", "- Please delete this text!" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Title: Pricing and Performance: A Study of Mobile Games on the Google Play Store\n", "\n", "by PEI-HENG MA\n", "\n", "The mobile gaming industry is a rapidly growing and highly profitable market, with billions of users around the world downloading and playing games on their smartphones and tablets. However, while many mobile games are available for free, others require users to pay in order to download and play. This raises questions about the impact of pricing on mobile game success, and whether paid games perform better or worse than free games in terms of ratings, installs, and average rating. In this research paper, I will examine the relationship between pricing and performance for mobile games on the Google Play Store, using data from the top 100 games of each category.\n", "\n", "According to a study by Hamari et al.(2020), the freemium business model is peculiar in a way that increasing perceived value of the freemium service (i.e. enjoyment) may both add to and retract from future profitability via increased retention on one hand, reduced monetization on the other. The study found that the more enjoyable the players perceive the service to be, the more they are willing to use it, however, the less they are willing to purchase premium content. Social value was found to be positively associated with purchasing game content. Quality of the freemium service was not associated with purchase intentions. The economical value of the freemium service had a positive association with the intention to continue using the freemium service, but it had no direct association with intentions to purchase premium content. The economical value only had an indirect association with purchases through the increased willingness to continue using the freemium service.\n", "\n", "Using the dataset from Kaggle, this data analysis provides a wealth of information about the performance and popularity of mobile games, including data on total ratings, installs, average rating, growth over time, and pricing. This dataset offers an opportunity to investigate important questions about the mobile gaming industry, such as the impact of pricing on mobile game success. By analyzing this data, we can gain a deeper understanding of the factors that influence the popularity and performance of mobile games, and inform strategies for pricing and monetizing mobile games." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import matplotlib as mpl\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "\n", "# For unit testing answers.\n", "from unittest.mock import patch" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | rank | \n", "title | \n", "total ratings | \n", "installs | \n", "average rating | \n", "growth (30 days) | \n", "growth (60 days) | \n", "price | \n", "category | \n", "5 star ratings | \n", "4 star ratings | \n", "3 star ratings | \n", "2 star ratings | \n", "1 star ratings | \n", "paid | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "Garena Free Fire- World Series | \n", "86273129 | \n", "500.0 M | \n", "4 | \n", "2.1 | \n", "6.9 | \n", "0.0 | \n", "GAME ACTION | \n", "63546766 | \n", "4949507 | \n", "3158756 | \n", "2122183 | \n", "12495915 | \n", "False | \n", "
1 | \n", "2 | \n", "PUBG MOBILE - Traverse | \n", "37276732 | \n", "500.0 M | \n", "4 | \n", "1.8 | \n", "3.6 | \n", "0.0 | \n", "GAME ACTION | \n", "28339753 | \n", "2164478 | \n", "1253185 | \n", "809821 | \n", "4709492 | \n", "False | \n", "
2 | \n", "3 | \n", "Mobile Legends: Bang Bang | \n", "26663595 | \n", "100.0 M | \n", "4 | \n", "1.5 | \n", "3.2 | \n", "0.0 | \n", "GAME ACTION | \n", "18777988 | \n", "1812094 | \n", "1050600 | \n", "713912 | \n", "4308998 | \n", "False | \n", "
3 | \n", "4 | \n", "Brawl Stars | \n", "17971552 | \n", "100.0 M | \n", "4 | \n", "1.4 | \n", "4.4 | \n", "0.0 | \n", "GAME ACTION | \n", "13018610 | \n", "1552950 | \n", "774012 | \n", "406184 | \n", "2219794 | \n", "False | \n", "
4 | \n", "5 | \n", "Sniper 3D: Fun Free Online FPS Shooting Game | \n", "14464235 | \n", "500.0 M | \n", "4 | \n", "0.8 | \n", "1.5 | \n", "0.0 | \n", "GAME ACTION | \n", "9827328 | \n", "2124154 | \n", "1047741 | \n", "380670 | \n", "1084340 | \n", "False | \n", "