Customer_Retention_Plots.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "2e9137a0",
   "metadata": {},
   "source": [
    "import necessery modules"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "af74b0e9",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5ff23fd7",
   "metadata": {},
   "source": [
    "import csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "b83aebc7",
   "metadata": {},
   "outputs": [],
   "source": [
    "DAU = pd.read_csv(r'/Users/bartoszbohaterewicz/Desktop/DATA/DAU.csv')\n",
    "P_Data = pd.read_csv(r'/Users/bartoszbohaterewicz/Desktop/DATA/player_info.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3276f150",
   "metadata": {},
   "source": [
    "transform to DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "e97d1936",
   "metadata": {},
   "outputs": [],
   "source": [
    "DAU = pd.DataFrame(DAU)\n",
    "P_Data = pd.DataFrame(P_Data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "0319a75c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     DATE_DAY  DAY_OF_GAME  PLAYER_ID PLATFORM  GEMS  ENERGY  LEVEL  \\\n",
      "0  2022-01-21           11      32088      ios     3       0     17   \n",
      "1  2022-01-26           23      27587  android     8       8     28   \n",
      "2  2022-01-26           14      33184  android     2       0     31   \n",
      "3  2022-01-26           23      27256      ios     3      18     51   \n",
      "4  2022-01-26           17      31641  android    15      50     41   \n",
      "\n",
      "  COUNTRY_CODE  PAID_IN_DAY  \n",
      "0           DE            0  \n",
      "1           FR            0  \n",
      "2           ES           10  \n",
      "3           VN            0  \n",
      "4           PL            0  \n",
      "   PLAYER_ID             INSTALL_TIME PLATFORM       MEDIA_SOURCE  \\\n",
      "0      34550  2022-01-14 18:56:53.000  android  googleadwords_int   \n",
      "1      34556  2022-01-14 19:06:06.000  android       Facebook Ads   \n",
      "2      34394  2022-01-14 12:20:28.000  android       Facebook Ads   \n",
      "3      34405  2022-01-14 12:45:46.000  android  googleadwords_int   \n",
      "4      34305  2022-01-14 06:15:41.000  android       Facebook Ads   \n",
      "\n",
      "                         CAMPAIGN  TYPE  \n",
      "0  SR_Android_Tier1_20220104_tCPI  Paid  \n",
      "1   SR_Android_TIER1_20220103_AEO  Paid  \n",
      "2   SR_Android_TIER1_20220103_AEO  Paid  \n",
      "3  SR_Android_Tier1_20220104_tCPI  Paid  \n",
      "4   SR_Android_TIER1_20220103_AEO  Paid  \n"
     ]
    }
   ],
   "source": [
    "print(DAU.head())\n",
    "print(P_Data.head())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "820738ee",
   "metadata": {},
   "source": [
    "Change blanks to \"no_data\" in both \"source\" and \"campaign\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "590f99ea",
   "metadata": {},
   "outputs": [],
   "source": [
    "P_Data.loc[P_Data['MEDIA_SOURCE'].str.len() == 0, 'MEDIA_SOURCE'] = np.NaN\n",
    "P_Data['MEDIA_SOURCE'] = P_Data['MEDIA_SOURCE'].fillna('no_data')\n",
    "P_Data.loc[P_Data['CAMPAIGN'].str.len() == 0, 'CAMPAIGN'] = np.NaN\n",
    "P_Data['CAMPAIGN'] = P_Data['CAMPAIGN'].fillna('no_data')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a48541cf",
   "metadata": {},
   "source": [
    "Merge both spreadsheets\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "9a773e15",
   "metadata": {},
   "outputs": [],
   "source": [
    "New_Data = pd.merge(DAU,P_Data, on = 'PLAYER_ID',how = 'left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "29b832de",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CAMPAIGN\n",
      "Organic                           30618\n",
      "SR_Android_TIER1_20220103_AEO      8827\n",
      "SR_Android_Tier1_20220104_tCPI     2874\n",
      "no_data                            2352\n",
      "SR_Android_US_20211209_AEO         2071\n",
      "restricted                         1793\n",
      "SR_Android_DE_20211209_AEO          686\n",
      "(WW) Slash & Roll Brand              10\n",
      "SR_Android_PL_20210924_AAA            1\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(New_Data.value_counts(subset = 'CAMPAIGN'))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "76e47bd1",
   "metadata": {},
   "source": [
    "Create new variables with individual campaigns\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "25a0661e",
   "metadata": {},
   "outputs": [],
   "source": [
    "SR_Android_AE0 = New_Data.loc[New_Data['CAMPAIGN'] == 'SR_Android_TIER1_20220103_AEO']\n",
    "SR_Android_tCPI = New_Data.loc[New_Data['CAMPAIGN'] == 'SR_Android_Tier1_20220104_tCPI']\n",
    "no_data =  New_Data.loc[New_Data['CAMPAIGN'] == 'no_data']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7ab0ab6b",
   "metadata": {},
   "source": [
    "Create retention plots\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "443bee9e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYEAAAEWCAYAAACAOivfAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAySklEQVR4nO3debxcRZ338c/3JoRsBBKyEBIk4LAjIEaURVAGERTZ3EBRcJmMDIzOM6MIz8ywOO6ooz6Iig4KyCIjIogiIhpxASHBEBIBCXsgJJAFSICsv+ePqiadTi/33ty+ffr29/169atPn1N1qk53df9O1VlaEYGZmXWmrlZXwMzMWsdBwMysgzkImJl1MAcBM7MO5iBgZtbBHATMzDqYg0APSZoiKSQN7mX+GyWd3Ix1dypJcyW9sdX1aHdu28Uj6f9K+l4zyyhkEJB0kKQ/SXpW0hJJf5T02rzsFElrJS2X9JykuyUd1Y117iBpnaQLm78FtUXEkRFxyaasQ9J0SUslbV4x/weSVuX3pvS4u2z5PpJmSnohP+/ToJz9JP1C0rL8Odwh6YObUvdmiIg9ImJ6q+vRHW7b1Ul6RNJhFfOGSDpX0gOSVuQ0F0uakpdPl/RSfr+ekfQTSRPzsh9I+kyd8kZJ+pqkx3L+efn12N7Uv1ki4nMR8ZFmllG4ICBpFHAD8P+AMcAk4DxgZVmy2yJiJLAVcCFwlaStGqz6A8BS4ITKH8++oqSp72n+ArwBCODoKkm+FBEjyx5753xDgOuAHwKjgUuA6/L8auXsD/wG+B3wd8DWwKnAkX27RZ3DbbvHfkxq4+8FtgT2BmYCf1+W5vT8fu1Mes/+u9FKc5u/BdgDOAIYBRwALAb267vqt4mIKNQDmAosq7P8FOAPZa+Hk34QX9tgvQ+SfsQWAu+sWBbAR4EHSF+mbwLKywYBXwaeAR4CTsvpB+fl04HPAn8EXiT9YB4A3Ak8m58PKCtrOvCR7qy7xnacncv6KnBDxbIfAJ+pke9w4InSduV5jwFH1Ej/B+CbdeoxmvSD9nR+z24AJlds52eAPwHLgZ+RAsnlwHP5fZlS8Rl8LL8PzwDnA1152StJAWlxXnY5sFVZ3keAw/L0MFKAWwrcC5wBzK9I+wlgdv58fgQMddtuXdsGLgPW5TKW58/ssPx6uzrb/XJ5+fVpwJxufBc+kt+rkXXWfWZ+X58H/gocV/E5/ZEUcJbl7Tsgz38cWAScXPG9/DZwc17f74Dty5Z/Ped7jhTk3lC27Fzgh2WvPwA8Svou/Ccbtv1zgauBS3M5c4Gpjdpl4XoCwN+AtZIukXSkpNG1EkoaBHwQWE16Y2qlewMwGbiK9CZ9oEqyo4DXkvY23g28Jc//h7zs1aQv8Tur5H0/MA3YgvTm/xz4BulH76vAzyVtXSVfd9Zd6QOkH8HLgbdImtCNPJD2emZHbi3Z7Dx/A5KGA/uT9sRq6QK+D2wPvIL0hb2gIs0JpPdmEumH/LacZwzpB/qcivTHkd6HfYFjgA+VqgR8HtgW2A3YjtTgqzkHmALsCLwZOKlKmneT9gB3APYifXn7g9t2FRHxftIOydsj9V6/RAoCd0TE47XylcvDOO8A/tKN5IcBv4yI5XXSPEjqcW9J6q39sDTUlL2O9P3ZGriC9P6/lhQoTwIukDSyLP37gP8CxgKzSN/fkjuBfUjfiyuA/5U0tMo27k7qHb4PmJjrNqki2dG5LlsB17Pxd3Jj/bEH1Is9pt1I0XM+sCZvzISyKLyGFIFXk3583t1gfd8Dfpqn98/5xlfsLR1U9vpq4Mw8/Rvgo2XLDmfjvaVPly1/P6nxlpd/G3BKlb2luuuush0H5bqPza/vA/5PxR7HS/m9KT0uycv+E7iqYn2XA+dWKWdSrseuPfjM9gGWlr2eDvx72euvADeWvX47MKviMzii7PU/AbfUKOtY4C9lrx9h/d7QQ8BbypZ9hI17AieVvf4S8G237Za37Zc/w/z6u5XttUqe6cAL+f16IrfncWXfhVo9gZuBL/Twc5sFHFP2OT1QtuxVedsmlM1bDOxTVperypaNBNZSo5dD6rHtnafPJfcESKMAV5alGw6sYsOewK/Llu8OvNho24rYEyAi7o2IUyJiMrAnaQ/wa2VJbo+IrUhDEteTInZVkoYB7yJH3oi4jbTX8d6KpE+VTb9A+qDIZZfvjVTbKytfvm2VNI+yccTu7rrLnQz8KiKeya+vyPPKfTkitip7lJYvJ419lhtF2rurtJTUPZ9YZRmQeguSviPpUUnPAbcCW+U92JKFZdMvVnldvqcEG78X2+ayxku6StITuawfkvaoqql8T6vtSdb6rJvObbvbFlOn/ZX5WG7nkyLifRHxdF+sW9IHJM3KJ0UsI31W5W2usi0TEfXa98vvRaQeyBLWt+9/k3RvPllgGWkPv1r73rZiPS/kbSlX+VkPVYMzsgoZBMpFxH2kSLpnlWXLSXuM75f06hqrOI70Y3ehpKckPUVqtNW6zdUsIA0/lLyiWjXLpp8kDZGUewVpT6U36wZe/sK/GzikbDv+D7C3pL1rV/9lc4G9JKls3l55/gZy47qN1L2u5d+AXYDXRcQo4OBSVbtRl1oq34sn8/TnSe/xXrmsk+qUs4A0PFJtnYXitl2zHIBfA/tJmlwt8Sb6NWkodUS1hZK2J/VETge2zkF5Dn3UtvMw0RjgyTyc9ynSd3t0LuvZGmVt0Lbzb0K1obgeKVwQkLRrjoyT8+vtgBOB26ulj4jFpC7x2TVWeTJwManLtk9+HAjsI+lV3ajS1cDHJE3OY7hnNkj/C2BnSe+VNFjSe0jdshs2cd3HkrqQu5dtx27A7+nel356zv8xSZtLOj3P/02N9GcAp0j6ZGnMV9Lekq7Ky7cg7e0skzSGjcf3e+OTkkbnz/zjpIO2pbKW57ImAZ+ss46rgbPyeiaRvsiF4LZd10LScRwAIuLXpGGbayW9Jpe3haSPSvpQzbV0z2WkPepr8mfSJWlrpXPy3wqMIAWlpwGUToveKFD30FuVTg8eQjo28OdIxzu2IA0BPg0MlnQ2G/fYS34MvF3SAXk957FpgQkoYBAgDU+8DvizpBWkL8gc0p5nLV8jvcl7lc/MPwJ/D3wtIp4qe8wEfsnGQynVfBe4CbgbuAv4Sb3E+Yt7VK7vYtKP6VFlQzi9XffJwPcj4rHybSEd+HlfWZfvDG14ncAzuV6rSIHkA6Qx1A8Bx+b51bbjT8Ch+fGQpCXARaQfAkjv+TDS2R+3k97PTXUd6eyIWaQDkP+T559HOlj8bJ5f7336NGm8/WHSHt+P2fAUzFZy267t88B/5OGXT+R57yS1tx+RPvs5pIPMv264ZfW3YyXp4PB9pEDzHHAHaQjmzxHxV9IxrNtIwelVpLOBNsUVpB2lJcBrSAd3Ib1HN5JOGniUdEyv6sHwiJgL/DPpwO8CUntaxCa279KpYmYtJSmAnSJiXh+v91TghIg4pC/Xa9Zdkn5AOjnhP/p4vSNJO3Q7RcTDvV1PEXsCZr0maaKkA3MXfxfSXuu1ra6XWV+Q9PZ8UsYI0nUY95DOrOo1BwEbaIYA3yF1lX9DGmKqejsFpVsQLJI0p2zeGEk3K92q4GaVncsv6Syl2wvcL+ktZfNfI+mevOwbFQffzfrSMaQD9E8CO5F6uZs0nOPhIOtYkg4mHXC+NCL2zPO+BCyJiC9IOpN0xsanlC7UuZJ0W4FtSePSO0fEWkl3kA5k304aw/5GRNzYgk0y6zH3BKxjRcStpAN15Y4h3XaC/Hxs2fyrImJlHn+dRzqFcSIwKiJuy3tkl5blMSu8wt/WdezYsTFlypRWV8MGriWkMy1KJkTEAoCIWCBpfJ4/iQ1P5Zyf563O05XzNyJpGukWDIwYMeI1u+66a59sgFmlmTNnPhMR47qTtvBBYMqUKcyYMaPV1bABStITdK9HXG2cP+rM33hmxEWk02yZOnVquF1bs0jq9hXaHg4y29BCrb8n/UTSediQ9vDLr4CdTDo4N58Nr1AuzTdrC8UPAosWNU5j1neuZ/2FVieTzi4qzT8hX229A+nMjDvy0NHzkl6fzwr6QFkes8Ir/HAQa9e2ugY2QJ144okAu5L+M2U+6YrOLwBXS/ow6WZs74J0taakq0n3ll8DnBYRpcZ5KukeQMNIV3/6zCBrG4U/RXTqNtvEjKeeapzQrBckzYyIqf1dro8JWDP1pF0XfzjIPQEzs6YpfhBYt67VNTAzG7CKHwTcE7CB6L77YMWKVtfCzEHArCVWrIDl9f7i1qx/OAiYtcrz1f7Z06x/FT8I+JiADVTuCVgBFD8IuCdgA5WDgBWAg4BZqzgIWAEUPwhEwOrVra6FWd9zELACKH4QAB9As4HJQcAKoD2CwHPPtboGZn3POzdWAA4CZq3inoAVQHsEAe8x2UDkIGAF0B5BwD0BG2gGDXIQsEJojyDgnoANNF1dDgJWCO0RBNwTsIHGPQErCAcBs1bo6nIP1wqhPYKAvyw20Hg4yAqi+EGgq8s9ARt4PBxkBdEeQcA9ARtoHASsIBoGAUkXS1okaU7ZvDGSbpb0QH4eXbbsLEnzJN0v6S1l818j6Z687BuS1K0aDhrknoANPB4OsoLoTk/gB8ARFfPOBG6JiJ2AW/JrJO0OnADskfNcKGlQzvMtYBqwU35UrrM6BwEbiNzDtYJoGAQi4lZgScXsY4BL8vQlwLFl86+KiJUR8TAwD9hP0kRgVETcFhEBXFqWp75Bg/xlsYFn0KD0F5P+0yRrsd4eE5gQEQsA8vP4PH8S8HhZuvl53qQ8XTm/KknTJM2QNGPVmjXuCdjA09WVbpP+4outrol1uL4+MFxtnD/qzK8qIi6KiKkRMXXIsGHuCdjAMyiPkvq4gLVYb4PAwjzEQ35elOfPB7YrSzcZeDLPn1xlfmM+JmADUVf+6jkIWIv1NghcD5ycp08Griubf4KkzSXtQDoAfEceMnpe0uvzWUEfKMtTn48J2EDknoAVxOBGCSRdCbwRGCtpPnAO8AXgakkfBh4D3gUQEXMlXQ38FVgDnBYRpT8JPpV0ptEw4Mb8aKyrC1atgpUrYfPNu79lZkVW6gl4B8darGEQiIgTayz6+xrpPwt8tsr8GcCePaodrN9jeu45GDeux9nNCsk9ASuI4l8xXPqyeI/JBhIfE7CCaJ8g4IPD1o8kPZKvcJ8laUae1+Mr5WtyT8AKovhBwGOn1jpvioh9ImJqft2bK+Wrc0/ACqL4QcA9ASuOHl0pX3dN7glYQTgImFUXwK8kzZQ0Lc/r6ZXyGyi/Ev7pZ57x6c9WCA3PDmo5Hxi21jgwIp6UNB64WdJ9ddJ264r4iLgIuAhg6tSpwbPPuidgLeeegFkVEfFkfl4EXEsa3unplfL1jRzpIGAtV/wg4APD1s8kjZC0RWkaOByYQw+vlG9Y0BZbOAhYyxV/OAjSl8U9Aes/E4Br8/8eDQauiIhfSrqTnl8pX5t7AlYA7REERo1yELB+ExEPAXtXmb+YHl4pX5eDgBVA8YeDIPUEPBxkA83IkW7X1nLtEQTcE7CByD0BK4D2CALuCdhA5CBgBdAeQcA9ARuIfHaQFYCDgFmrlHoCUfOfVs2arj2CgIeDbCAaOdJ/Nm8t1x5BYPRoePZZWLGi1TUx6zsjR6Zn7+BYC7VHEHjTm2DdOrixe/9IadYWSkHAxwWshdojCLzhDemvJa+5ptU1Mes7DgJWAO0RBAYPhmOPhRtugJdeanVtzPrGFlukZwcBa6H2CAIA73hH+rLcfHOra2LWN9wTsAJonyDwpjfBVlt5SMgGDgcBK4D2CQJDhsDRR8N118GqVa2ujdmm89lBVgDtEwQgDQktWwa//W2ra2K26dwTsAJoryBw+OFpSOhzn0unjJq1Mx8YtgJoryAwdCh85Stw663wzW+2ujZmm2bzzdPfpzoIWAu1VxAA+OAH4cgj4VOfgnnzWl0bs96TfCdRa7n2CwISfPe76UDxKaf4vivW3iZMgPvvb3UtrIO1XxAAmDQJvvUt+OMf06mjTz3V6hqZ9c5xx6VrX55+utU1sQ7VnkEA4MQT4Sc/gXvugf32S2cM+Za81m7e+15YuxZ+/ONW18Q6VPsGAUh7Ub//ffrxP/RQ2Htv+Pa34ZlnWl0zs+551atgjz3giitaXRPrUO0dBAD23TeNqX73u+lMi1NPhW22gcMOgy99KXW1Fy1yL8GKSUq9gT/8AR59tNW1sQ7U/kEAYPhw+MhH4K67YObMdObQE0+k58MPTwffhg6F7beHo46C738flixpda3NkhNPTM9XXdXaelhHUhR8D3nq1KkxY8aM3mVesgRmzUrHDRYsgCefTNcYlPa4xo6FiRNhhx3g1a9Oj9e/PgUN6wiSZkbE1P4ud6N2fcAB8MILqb2abaKetOvBza5MS40Zk44VHHro+nkRqbdw003w+OMpODzwQLpNdekq5Fe+EnbfPZ2GOmQIjBiRru4cMiTd1nrQoLSeiHRcYt99W7N9NnCcdBKcdlq6P9YXvwi77dbqGlmHGNhBoBoJpk5Nj3IrVsDs2fCnP6VTTx98ENasSTerW7EiBYtqPvOZ1HsYPjzd0mLsWBg/PvUudtwxBaLNNkvBY+3a9NhtN+gaGCNx1kemTUt/ofr5z6eDxe98J5xwAhxxRBrKNGuSgT0c1JeeeCJdk/DAAxvO33572HnnFCiWLUtnJj3zTON7G40eDUuXVl/2X/+Vgsf3v58CUVdX+jOdFSvgzDPhkEPSvLVr09Wmf/d3Kb31WGGGg0qefjoFgksvhcWLUy90771hr73S53700WmHw6yOnrRrB4FmWLMmDTU9+GDau1u2LB24Lnnzm9PQ0s9/3ndlbrZZeh4yJP1IDB+ebkkwd+6G6f7pn9KZKLNnb7yOk09OvZpBg1KQWbw4HVyvNGlSSrdgQVpPVxe87W2wyy7pzKz3vS/VY7PNUs+rwAoXBEpWr4bp0+FnP0vHCWbPTm1piy3g+ONTb3LChNTrHDsWtt46PY8aVfj33JrPQaDdrFiR7ilfOs4QkfbwzzsvPa9dC8OGpb3C/fdPw05nn72+V7LLLumHISINX73wQlrnihXpgrpyw4b13602urpSD6X04zR8eHrebTfYc8/02HXXlg53FDYIVFq3Lp3UcOmlcO21aceinsMOS+/r8OGpDf3iF+uXXXEF7LQTbLll2lEYOTKlGzSoV9tixeMgYPVFwMqV649RrFmTHtL61xFpb7T0v87f/jY8/HDKP2lS+gH56183XvfIkan3IKVgs3hxejz/fApOixfD3/6W1g0pUOy4Y9qrHTs2DW0dcEB6bLNN09+KtgkClZYvh4UL0zUwixal/+Aud8AB64cQ++LeRG9+c9oJkda3i2pKgR/WH//66lfTzscTT6R2V6r7unWpnZVupHfIISkQjRuX2ldXl3s1vVToICDpCODrwCDgexHxhXrpHQQGoNWrUyCYOxfmzIH77kvHUZ5+OvVuVq5M6caMSb2cPfdMtwZ57WthypQ+HfLoyyDQk7bd7+160aIUgJcuTT/Oy5al4aUVK+CjH22cf5dd0q2vI9Kp1osXN73KfeL449dPz5mT2l1f+O//Tr1yaX1bHDs2tc8CBK7CBgFJg4C/AW8G5gN3AidGRJVdysRBoMOsXJku+rv99hQc7r8f7r57w+GPoUPTl22ffdJjm23SnuNWW8Eb39ij4voqCPS0bQ+Ydr1sWRq2XL16/VX5pefSXv2rXpWOH512WvfXe955cM45m16/PfdcX6fK42PNMGpUOr182LD0esiQ1C633DLNGzo0PY8cma5X+stf0vRpp6UdndIQ3uBNO3GzyEFgf+DciHhLfn0WQER8vlaeAfNlsd6LSP8dcdddMH9+umvsAw+kL9Bjj61PN3Jkj/+vtw+DQI/attt1i82ZA7fcsuFxuHnz4MYb0w/wgQemx+abp+HP8nSlYazSA9b3kO6+O+28lIY7X3pp/ckhL72UdnJKPd1azj47BcFNUOSLxSYBj5e9ng+8rjKRpGnAtPxypaQ5PShjLNDTO8j1Rx7Xq9l5li8fi9TTMrbvYfpaGrbtTWzX0NntoX/rNW8eXHJJa+r16U+nx6aV0+123d9BoNpg2UZdkYi4CLgIQNKMnuyp9TR9f+VxvYq5LX2oYdvelHbdX3lcr4FRr57o78tW5wPblb2eDDzZz3Uwawa3bWtL/R0E7gR2krSDpCHACcD1/VwHs2Zw27a21K/DQRGxRtLpwE2k0+gujohGh+wv6mExPU3fX3lcr+bn6U0ZfaIXbXsgvYeuVzHzdEvhLxYzM7Pm8a0szcw6mIOAmVkni4hCPoAjgPuBecCZ3czzCHAPMAuYUSPNxcAiYE7ZvDHAzcAD+Xl0g/TnAk/kcmYBb60oYzvgt8C9wFzg4/XKqZO+ZjnAUOAO4O6c57xubEutPI22ZxDwF+CGRmXUydOojI0+u0bl1MhTt5wiPGhC26aH7bo3bZsetuv+att10jdsCxSwbddI33Bbet0eW/2FqNHgBwEPAjsCQ/KHu3s3vyhjG6Q5GNiXDRv+l8hfRuBM4IsN0p8LfKJOGROBffP0FqTbCexeq5w66WuWQzovfWSe3gz4M/D6BttSK0+j7flX4IqyRl+zjDp5GpWx0WfXqJwaeeqW0+pHs9p2T9t1b9p2T9t1f7Xt3rbrorbt/m7XRR0O2g+YFxEPRcQq4CrgmL5YcUTcClT+y/wxQOnywEuAYxukb1TGgoi4K08/T9oLmlSrnDrp65UREbE8v9wsP6LBttTKU5OkycDbgO+Vza5ZRp08vVG3nDbVlLbd03ZdJ0+9MnrUrhvkqVdOj9p2b9o1uG2XFDUIVLsEv27DyQL4laSZ+RL97poQEQsgNVpgfDfynC5ptqSLJY2ulUjSFODVpL2ThuVUpK9bjqRBkmaRuvQ3R0TDMmrkqVfO14AzgPK/Smu0HdXy1N0Wqn92jcqp9Xl367Npkf5s271p19CN96+n7bpKnrrl9LRt96JdQ3Hbdr+266IGgW7dXqKKAyNiX+BI4DRJB/dttV72LeCVwD7AAuAr1RJJGglcA/xLRDzXaKVV0tctJyLWRsQ+pKtT95O0Z6MyauSpWo6ko4BFETGz0XrLtqFWnkbvWW8+u2p5uvXZtFDbt+2etusaefq0bfekXef6FLlt92u7LmoQ6NUl+BHxZH5eBFxL6np3x0JJEwHy86IG5SzMjW4d8N1q5UjajNToL4+I0t971SynWvrulJPTLQOmkw44dmtbyvPUKedA4GhJj5CGLQ6V9MMGZVTN02hbanx2dbelWp7uvmct1J9tu0ftOq+/7vvX03ZdK0+z2nY32zUUuG33d7suahDo8SX4kkZI2qI0DRwOdPcujdcDJ+fpk4HrGpQ1sezlcZXlSBLwP8C9EfHVRuXUSl+vHEnjJG2Vp4cBhwH31duWWnlqlRMRZ0XE5IiYQvoMfhMRJ9Uro1aeBttS67Orty1V8zT6bAqgP9t2j9p1Xn+9z6lH7bpenr5s2z1t11Dctt2Sdh0FOGOi2gN4K+lMggeBf+9G+h1JZ1qUThOrmge4ktSdWk3aK/swsDVwC+l0rVuAMQ3SX0Y6hWt2/jAnVpRxEKmLP5uyU7pqlVMnfc1ygL1Ip6nNJjWIs/P8ettSK0/d7clp3sj6syFqllEnT71tqfrZNdiWWnkabkurHzShbddop3U/pxp56n1OPWrX/dW266TvVlugQG27TvqmtWvfNsLMrIMVdTjIzMz6gYOAmVkHcxAwM+tgDgJmZh3MQcDMrIM5CDSBpLWSZkmaK+luSf8qqanvtaTzc3nnN7Mc61xu1wOTTxFtAknLI2Jknh5PuuPgHyPinCaW+RwwLiJWNqsM62xu1wOTewJNFunS72mkmz9J0hRJv5d0V34cACDpMkkv301S0uWSji5fV85/vqQ5ku6R9J48/3pgBPDn0ryyPOMk3ZzL+o6kRyWNzct+qnSTqrkqu1GVpOWSvpiX/VrSfpKmS3qoVCelG3adL+lOpZta/WNz3kErIrfrAaTVV08OxAewvMq8pcAEYDgwNM/bifV/GnEI8NM8vSXwMDC4Yh3vIP0BxaC8rsfIVw5WKzPPvwA4K08fQbp6c2x+XbpKcRjpSsut8+sAjszT1wK/It2ed29gVp4/DfiPPL05MAPYodXvvR9u127XPXsMrhYYrClKd4/cDLhA0j7AWmBngIj4naRv5m728cA1EbGmYh0HAVdGxFrSDah+B7yW+veeOYh0rxEi4peSlpYt+5ik4/L0dqQv72JgFfDLPP8eYGVErJZ0DzAlzz8c2EvSO/PrLXP+hxu+EzaQuF23OQeBfiBpR9IXYxFwDrCQtPfRBbxUlvQy4H2km1N9qNqqelN8jTq9kXSjrf0j4gVJ00l/0wewOvKuEOm+6SsBImKdpFKbEfDPEXFTL+pkA4Db9cDgYwJNJmkc8G3ggtwAtwQWRLol7PtJXeCSHwD/AhARc6us7lbgPXncchzp7wHvaFCFPwDvznU5HCj9GcWWwNL8RdmV9Hd8PXETcKrSbYKRtLPSXQ+tA7hdDxzuCTTHMKV/OdoMWEPaEyrdRvdC4BpJ7yL9AfeKUqaIWCjpXuCnNdZ7LbA/6Q6DAZwREU81qMt5wJX5wNrvSHeNfJ7ULf6opNmkPz2/vYfb+D1SF/ouSQKeZmD8/aPV5nY9APkU0QKRNJw0VrlvRDzbR+vcHFgbEWsk7Q98K9I/MJn1C7frYnNPoCAkHQZcDHy1r74o2SuAq5Uu6lkF/EMfrtusLrfr4nNPwMysg/nAsJlZB3MQMDPrYA4CZmYdzEHAzKyDOQiYmXUwBwEzsw7mIGBm1sEcBMzMOpiDgJlZB3MQMDPrYA4CZmYdzEHAzKyDOQiYmXUwBwEzsw7mINDHJP1A0mdaXY+ikTQ3//+rmRVIxwUBSY9IWlj+v6GSPpL/kLq/6zJd0kc2cR37SfqFpGWSlki6Q9IH+6qOfSUi9oiI6a2uh5ltqOOCQDYY+HirK7Gp8t/q/Yb0H6t/B2wNnAoc2cp6mVn76NQgcD7wCUlbVVso6QBJd0p6Nj8fUGtFkl4t6S5Jz0v6ETC0bNloSTdIelrS0jw9OS/7LPAG4AJJyyVdkOd/XdLjkp6TNFPSGxpsxyUR8cWIeCaSmRHx7kbl5+XTJX1G0p9yHX4maWtJl+fy75Q0pSx9SPqYpIckPSPp/Pz3fkh6paTfSFqcl11e/v7mHthheXqYpEtyne6VdIak+RVpPyFpdv4MfiTp5ffVzPpOpwaBGcB04BOVCySNAX4OfIO0Z/1V4OeStq6SdgjwU+AyYAzwv8A7ypJ0Ad8Htif9J+qLwAUAEfHvwO+B0yNiZEScnvPcCeyT13cF8L/VfgDzn3fvD/y4znbWLL/MCcD7gUnAK4Hbcp4xwL3AORXpjwOmAvsCxwAfKlUJ+DywLbAbsB1wbo16nQNMAXYE3gycVCXNu4EjgB2AvYBT6mynmfVSpwYBgLOBf5Y0rmL+24AHIuKyiFgTEVcC9wFvr7KO1wObAV+LiNUR8WPSjzgAEbE4Iq6JiBci4nngs8Ah9SoVET/M+dZExFeAzYFdqiQdTfr8FtRZV3fK/35EPJj/BPxG4MGI+HVErCEFtVdXpP9iRCyJiMeArwEn5rLmRcTNEbEyIp4mBc9a2/pu4HMRsTQi5pMCbqVvRMSTEbEE+BkpMJpZH+vYIBARc4AbgDMrFm0LPFox71HSnnKlbYEnIiIq0gJpb13SdyQ9Kuk54FZgK0mDatVL0r/lIZJnJS0DtgTGVkm6FFgHTKyzru6Uv7Bs+sUqr0dWrPbxim3dNpc1XtJVkp7IZf2wRr3JecrX83iVNE+VTb9QpR5m1gc6Nghk5wD/wIY/8E+Shk/KvQJ4okr+BcAkSapIW/JvpL3410XEKODgPL+Uvjx4kMf/P0XaUx4dEVsBz5alf1lEvEAaunlH5bIelN8b25VNv4L0fkEaCgpgr1zWSXXKWQBMLnu9XY10ZtZkHR0EImIe8CPgY2WzfwHsLOm9kgZLeg+wO6nXUOk2YA3wsZz2eGC/suVbkPaml+VjDZXj6wtJ4+Ll6dcATwODJZ0NjKqzCWcAp0j6ZOmYhaS9JV3VzfJ745P5gPN2pDOsflRW1vJc1iTgk3XWcTVwVl7PJOD0OmnNrIk6OghknwZevmYgIhYDR5H2oheTfmiPiohnKjNGxCrgeNJBy6XAe4CflCX5GjAMeAa4HfhlxSq+DrwznyXzDeAm0rj830hDLS9RfaikVP6fgEPz4yFJS4CLSIGsO+X3xnXATGAW6QD6/+T555EOFj+b5/+kWubs08B84GHg16SD2yv7oG5m1kPacDjbrDZJAeyUe1B9ud5TgRMiou5BczPre+4JWL+TNFHSgZK6JO1C6nVd2+p6mXWihkFA0sWSFkmaUzZvjKSbJT2Qn0eXLTtL0jxJ90t6S9n810i6Jy/7RsXBVOssQ4DvAM+Trni+DriwpTUy61ANh4MkHUw64HdpROyZ530JWBIRX5B0JulMlk9J2h24knRwdFvSeO/OEbFW0h2kA4m3k8asvxERNzZrw8zMrLGGPYGIuBVYUjH7GOCSPH0JcGzZ/KvyBUMPA/OA/SRNBEZFxG35nPpLy/KYmVmLDO5lvgkRsQAgIhZIGp/nTyLt6ZfMz/NW5+nK+VVJmgZMAxgxYsRrdt11115W06y+mTNnPhMRlVeNm3WM3gaBWqqN80ed+VVFxEWkUx2ZOnVqzJgxo29qZ1ZBUuXV4WYdpbdnBy3MQzzk50V5/nw2vPpzMumK0vlseIVoab6ZmbVQb4PA9cDJefpk0tkdpfknSNpc0g7ATsAdeejoeUmvz2cFfaAsj5mZtUjD4SBJVwJvBMbme76fA3wBuFrSh4HHgHcBRMRcSVcDfyXd/uC0iFibV3Uq8APSFaw35oeZmbVQ4a8Y9jEBayZJMyNiaqvrYdYqvmLYzKyDOQiYmXUwBwEzsw7mIGBm1sEcBMzMOpiDgJlZB3MQMDPrYA4CZmYdzEHAzKyDFT8ILFzY6hqYmQ1YxQ8C69a1ugZmZgOWg4CZWQcrfhBYu7ZxGjMz65XiBwH3BMzMmsZBwMysgxU/CHg4yMysaYofBNwTMDNrGgcBM7MOVvwg4OEgM7OmKX4QcE/AzKxpHATMzDpY8YPA2rUQ0epamJkNSMUPAgCrVrW6BmZmA1J7BIHly1tdAzOzAclBwMysg7VHEFixotU1MDMbkNojCLgnYGbWFA4CZmYdrD2CgIeDzMyaoj2CgHsCZmZNsUlBQNIjku6RNEvSjDxvjKSbJT2Qn0eXpT9L0jxJ90t6S7cLchAwM2uKvugJvCki9omIqfn1mcAtEbETcEt+jaTdgROAPYAjgAslDepWCR4OMjNrimYMBx0DXJKnLwGOLZt/VUSsjIiHgXnAft1ao3sCZmZNsalBIIBfSZopaVqeNyEiFgDk5/F5/iTg8bK88/O8jUiaJmlGaYjJQcDMrDkGb2L+AyPiSUnjgZsl3VcnrarMq3pnuIi4CLgIYOrgweHhIDOz5tiknkBEPJmfFwHXkoZ3FkqaCJCfF+Xk84HtyrJPBp5sXMMu9wTMzJqk10FA0ghJW5SmgcOBOcD1wMk52cnAdXn6euAESZtL2gHYCbijYUGDBjkImJk1yaYMB00ArpVUWs8VEfFLSXcCV0v6MPAY8C6AiJgr6Wrgr8Aa4LSIaPzfkV1dPjvIzKxJeh0EIuIhYO8q8xcDf18jz2eBz/aoIA8HmZk1TfGvGPZwkJlZ0xQ/CHg4yMysaYofBNwTMDNrmuIHAR8TMDNrmvYIAitWQFS9rszMzDZB8YPAoEGwdi2sXNnqmpiZDTjFDwJduYoeEjIz63PtEwR8hpCZWZ8rfhAYlP9ywD0BM7M+V/wg4OEgM7OmaZ8g4OEgM7M+V/wg4OEgM7OmKX4Q8HCQmVnTtE8Q8HCQmVmfK34Q8HCQmVnTFD8IuCdgZtY0xQ8CEgwZ4p6AmVkTFD8IAIwc6SBgZtYE7RMEPBxkZtbn2iMIjBjhnoCZWRO0RxDwcJCZWVO0TxDwcJCZWZ9rjyDg4SAzs6ZojyDg4SAzs6ZonyDg4SAzsz7XHkHAw0FmZk3RHkFgm23guefgootaXRMzswGlPYLAaafBkUfCP/4jnHEGPP88rFnT6lqZmbU9RUSr61DX1KlTY8aMGelH/+MfhwsvXL9ws81g663hqafqr+TYY+HMM2HwYHjiCVi7FiZNgl13TcsHD4Zhw9J9iqyjSJoZEVNbXQ+zVmmfIAAQAddfDw88AC+9lI4TLF4M3/tecwo/77x0PGLw4FT2HXfAiy/Cgw/CPff0TRmTJ6c7pXZ1pdtmd3WlYFQrIB16KOy8c/fX39UF48f3rE7jx8Puu6fpcePW3857AHIQsE7X70FA0hHA14FBwPci4gv10m8QBGp59lm4/XZYvTr1GFavTkNGzz6bAsX48enH9i9/gf/8z5Rn1Kg03dUFq1bBkiVw/vl9so0DziGHpEAgwfTpqSdVzfHHp3RDhsDQoRs+Ro+GCRNgiy3S88SJKcBW2nrrfu2ROQhYp+vXICBpEPA34M3AfOBO4MSI+GutPN0KAs2yZk06NXXduhRQpk1LQ0991QtoFwcfvP6H/49/rJ1ujz1SutWrU0/txRdh5cr0vG5d98sbPhxeeGHDea98ZeqBNXLWWSkITZgAU6bA9tvDLrvU7M04CFinG9zP5e0HzIuIhwAkXQUcA9QMAi01eDBsuWWaHj0afvWr1tanXUWkIPrgg3DQQSlA1DJ8OLz97fCjH204f489uhcEvvzlFITKLV9evddhZv0eBCYBj5e9ng+8rjKRpGnAtPxypaQ5PShjLPBMD+vVH3lcr+7keeGF8gCwPs/113evjNWrNy5j5Mh6ebbvzorNBqr+DgLVBns3Go+KiIuAiwAkzehJd72n6fsrj+tVzG0x63T9fZ3AfGC7steTgSf7uQ5mZpb1dxC4E9hJ0g6ShgAnAN3q55uZWd/r1+GgiFgj6XTgJtIpohdHxNwG2Xp6r4je3FuiP/K4Xs3P4/uKmPVQ4S8WMzOz5mmPeweZmVlTOAiYmXWwwgYBSUdIul/SPElndjPPI5LukTRLUtXLjCVdLGlR+bUHksZIulnSA/l5dIP050p6IpczS9JbK8rYTtJvJd0raa6kj9crp076muVIGirpDkl35zzndWNbauVptD2DJP1F0g2NyqiTp1EZG312jcqpkaduOWa2oUIeE+jN7SVyvkeAqRFR86IkSQcDy4FLI2LPPO9LwJKI+EIOOKMj4lN10p8LLI+IL9coYyIwMSLukrQFMBM4FjilWjl10r+7VjmSBIyIiOWSNgP+AHwcOL7OttTKc0SD7flXYCowKiKOqvd+1cnT6D17hIrPrlE5NfLULcfMNlTUnsDLt5eIiFVA6fYSmywibgWWVMw+BrgkT19C+gGul75RGQsi4q48/TxwL+lq6arl1Elfr4yIiNLfrW2WH9FgW2rlqUnSZOBtQPmtWmuWUSdPb9Qtx8w2XVGDQLXbS9T9UcwC+JWkmUq3nuiuCRGxANIPMtCdey+fLml2Hi7aaDikRNIU4NXAn7tTTkX6uuXkIZdZwCLg5ohoWEaNPPXK+RpwBlB+B7hG21EtT91tofpn16icWp93tz4bMytuEOjW7SWqODAi9gWOBE7LQznN8C3glcA+wALgK9USSRoJXAP8S0Q812ilVdLXLSci1kbEPqQrr/eTtGejMmrkqVqOpKOARRExs9F6y7ahVp5G71lvPrtqebr12ZhZUtQg0KvbS0TEk/l5EXAtaVipOxbmcfnSeP6iBuUszD+m64DvVisnj7lfA1weET9pVE619N0pJ6dbBkwnje13a1vK89Qp50Dg6Dz2fhVwqKQfNiijap5G21Ljs6u7LdXydPc9M7OkqEGgx7eXkDQiH1RF0gjgcKC7dx+9Hjg5T58MXNegrIllL4+rLCcfgP0f4N6I+Gqjcmqlr1eOpHGStsrTw4DDgPvqbUutPLXKiYizImJyREwhfQa/iYiT6pVRK0+Dban12dXblqp5Gn02ZlYhIgr5AN5KOkPoQeDfu5F+R+Du/JhbKw9wJWmYYDWpx/FhYGvgFuCB/DymQfrLgHuA2aQfqokVZRxEGr6aDczKj7fWKqdO+prlAHsBf8nL5gBn5/n1tqVWnrrbk9O8EbihURl18tTblqqfXYNtqZWn4bb44Ycf6x+FPEXUzMz6R1GHg8zMrB84CJiZdTAHATOzDuYgYGbWwRwEzMw6mINAE0ham+9gOVfpjp3/Kqmp77Wk83N55zezHDMbWHyKaBNIWh4RI/P0eOAK4I8RcU4Ty3wOGBcRK5tVhpkNPO4JNFmkWxpMI93UTJKmSPq9pLvy4wAASZdJevlOqZIul3R0+bpy/vMlzVG6j/578vzrgRHAn0vzyvKMU7oX/12SviPpUUlj87Kf5puvzS2/AZuk5ZK+mJf9WtJ+kqZLeqhUp3wjuvMl3Zlv1vaPzXkHzaypWn212kB8kO5nXzlvKTABGA4MzfN2Ambk6UOAn+bpLYGHgcEV63gHcDMwKK/rMfIVsdXKzPMvAM7K00eQrkwem1+XrlgeRrqCeOv8OoAj8/S1wK9It53eG5iV508D/iNPbw7MAHZo9Xvvhx9+9OwxuA/jidVXujPqZsAFkvYB1gI7A0TE7yR9Mw8fHQ9cExFrKtZxEHBlRKwl3Vztd8BrqX9fpYNI99AhIn4paWnZso9JOi5Pb0cKSouBVcAv8/x7gJURsVrSPcCUPP9wYC9J78yvt8z5H274TphZYTgI9ANJO5J+8BcB5wALSXvVXcBLZUkvA95HuvHah6qtqjfF16jTG0k3kNs/Il6QNB0YmhevjojSwaJ1wEqAiFgnqdRmBPxzRNzUizqZWUH4mECTSRoHfBu4IP+wbgksiHSr4/eThnZKfgD8C0BEzK2yuluB9+Tx+HHAwcAdDarwB9LfVCLpcKD0JytbAktzANgVeH0PN+0m4NR8C2wk7Zzv5mlmbcQ9geYYpvTvXZsBa0h7+KVbRF8IXCPpXcBvgRWlTBGxUNK9wE9rrPdaYH/SnTMDOCMinmpQl/OAK/MB49+R7oj6PGm456OSZgP3A7f3cBu/RxoauivfCvtp/PePZm3Hp4gWiKThpDH4fSPi2T5a5+bA2ohYI2l/4FuR/lnMzMw9gaKQdBhwMfDVvgoA2SuAq/PFaquAf+jDdZtZm3NPwMysg/nAsJlZB3MQMDPrYA4CZmYdzEHAzKyDOQiYmXWw/w8YEffEmZQmSAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 3 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "xtick_0 = [*range(0,60,5)]\n",
    "plt.figure(1)\n",
    "plt.subplot(2,2,1)\n",
    "SR_Android_AE0['DAY_OF_GAME'].value_counts().plot(kind='line',color='red')\n",
    "plt.title('SR Android AE0 Campaign')\n",
    "plt.xlabel('Day of game')\n",
    "plt.ylim([0,1600])\n",
    "plt.xlim([0,60])\n",
    "plt.xticks(xtick_0)\n",
    "\n",
    "plt.subplot(2,2,2)\n",
    "SR_Android_tCPI['DAY_OF_GAME'].value_counts().plot(kind='line', ax=plt.gca(),color='red')\n",
    "plt.title('SR Android tCPI Campaign')\n",
    "plt.xlabel('Day of game')\n",
    "plt.ylim([0,1000])\n",
    "plt.xlim([0,60])\n",
    "plt.xticks(xtick_0)\n",
    "\n",
    "plt.subplot(2,2,3)\n",
    "no_data['DAY_OF_GAME'].value_counts().plot(kind='line',ax=plt.gca(),color='red')\n",
    "plt.title('No data Campaign')\n",
    "plt.xlabel('Day of game')\n",
    "plt.ylim([0,1000])\n",
    "plt.xlim([0,60])\n",
    "plt.xticks(xtick_0)\n",
    "\n",
    "plt.subplots_adjust(hspace =0.800)\n",
    "plt.show()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}