3-July-19.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Problem Set"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "App Store Dataset\n",
    "List of all unique Prime_Genres(categories) in the dataset\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>id</th>\n",
       "      <th>track_name</th>\n",
       "      <th>size_bytes</th>\n",
       "      <th>currency</th>\n",
       "      <th>price</th>\n",
       "      <th>rating_count_tot</th>\n",
       "      <th>rating_count_ver</th>\n",
       "      <th>user_rating</th>\n",
       "      <th>user_rating_ver</th>\n",
       "      <th>ver</th>\n",
       "      <th>cont_rating</th>\n",
       "      <th>prime_genre</th>\n",
       "      <th>sup_devices.num</th>\n",
       "      <th>ipadSc_urls.num</th>\n",
       "      <th>lang.num</th>\n",
       "      <th>vpp_lic</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>281656475</td>\n",
       "      <td>PAC-MAN Premium</td>\n",
       "      <td>100788224</td>\n",
       "      <td>USD</td>\n",
       "      <td>3.99</td>\n",
       "      <td>21292</td>\n",
       "      <td>26</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6.3.5</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>281796108</td>\n",
       "      <td>Evernote - stay organized</td>\n",
       "      <td>158578688</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>161065</td>\n",
       "      <td>26</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>8.2.2</td>\n",
       "      <td>4+</td>\n",
       "      <td>Productivity</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>281940292</td>\n",
       "      <td>WeatherBug - Local Weather, Radar, Maps, Alerts</td>\n",
       "      <td>100524032</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>188583</td>\n",
       "      <td>2822</td>\n",
       "      <td>3.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.0.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Weather</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>282614216</td>\n",
       "      <td>eBay: Best App to Buy, Sell, Save! Online Shop...</td>\n",
       "      <td>128512000</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>262241</td>\n",
       "      <td>649</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.10.0</td>\n",
       "      <td>12+</td>\n",
       "      <td>Shopping</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>282935706</td>\n",
       "      <td>Bible</td>\n",
       "      <td>92774400</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>985920</td>\n",
       "      <td>5320</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.5.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Reference</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>283619399</td>\n",
       "      <td>Shanghai Mahjong</td>\n",
       "      <td>10485713</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.99</td>\n",
       "      <td>8253</td>\n",
       "      <td>5516</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>47</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>283646709</td>\n",
       "      <td>PayPal - Send and request money safely</td>\n",
       "      <td>227795968</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>119487</td>\n",
       "      <td>879</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6.12.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Finance</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>284035177</td>\n",
       "      <td>Pandora - Music &amp; Radio</td>\n",
       "      <td>130242560</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1126879</td>\n",
       "      <td>3594</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>8.4.1</td>\n",
       "      <td>12+</td>\n",
       "      <td>Music</td>\n",
       "      <td>37</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>284666222</td>\n",
       "      <td>PCalc - The Best Calculator</td>\n",
       "      <td>49250304</td>\n",
       "      <td>USD</td>\n",
       "      <td>9.99</td>\n",
       "      <td>1117</td>\n",
       "      <td>4</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.6.6</td>\n",
       "      <td>4+</td>\n",
       "      <td>Utilities</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>284736660</td>\n",
       "      <td>Ms. PAC-MAN</td>\n",
       "      <td>70023168</td>\n",
       "      <td>USD</td>\n",
       "      <td>3.99</td>\n",
       "      <td>7885</td>\n",
       "      <td>40</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0.4</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>284791396</td>\n",
       "      <td>Solitaire by MobilityWare</td>\n",
       "      <td>49618944</td>\n",
       "      <td>USD</td>\n",
       "      <td>4.99</td>\n",
       "      <td>76720</td>\n",
       "      <td>4017</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.10.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>284815117</td>\n",
       "      <td>SCRABBLE Premium</td>\n",
       "      <td>227547136</td>\n",
       "      <td>USD</td>\n",
       "      <td>7.99</td>\n",
       "      <td>105776</td>\n",
       "      <td>166</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.5</td>\n",
       "      <td>5.19.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>284815942</td>\n",
       "      <td>Google – Search made just for mobile</td>\n",
       "      <td>179979264</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>479440</td>\n",
       "      <td>203</td>\n",
       "      <td>3.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>17+</td>\n",
       "      <td>Utilities</td>\n",
       "      <td>37</td>\n",
       "      <td>4</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>284847138</td>\n",
       "      <td>Bank of America - Mobile Banking</td>\n",
       "      <td>160925696</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>119773</td>\n",
       "      <td>2336</td>\n",
       "      <td>3.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>7.3.8</td>\n",
       "      <td>4+</td>\n",
       "      <td>Finance</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>284862767</td>\n",
       "      <td>FreeCell</td>\n",
       "      <td>55153664</td>\n",
       "      <td>USD</td>\n",
       "      <td>4.99</td>\n",
       "      <td>6340</td>\n",
       "      <td>668</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.0.3</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>284876795</td>\n",
       "      <td>TripAdvisor Hotels Flights Restaurants</td>\n",
       "      <td>207907840</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>56194</td>\n",
       "      <td>87</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>21.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Travel</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>284882215</td>\n",
       "      <td>Facebook</td>\n",
       "      <td>389879808</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2974676</td>\n",
       "      <td>212</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>95.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Social Networking</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>284910350</td>\n",
       "      <td>Yelp - Nearby Restaurants, Shopping &amp; Services</td>\n",
       "      <td>167407616</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>223885</td>\n",
       "      <td>3726</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>11.15.0</td>\n",
       "      <td>12+</td>\n",
       "      <td>Travel</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>20</td>\n",
       "      <td>284993459</td>\n",
       "      <td>Shazam - Discover music, artists, videos &amp; lyrics</td>\n",
       "      <td>147093504</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>402925</td>\n",
       "      <td>136</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>11.0.3</td>\n",
       "      <td>12+</td>\n",
       "      <td>Music</td>\n",
       "      <td>37</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>21</td>\n",
       "      <td>285005463</td>\n",
       "      <td>Crash Bandicoot Nitro Kart 3D</td>\n",
       "      <td>10735026</td>\n",
       "      <td>USD</td>\n",
       "      <td>2.99</td>\n",
       "      <td>31456</td>\n",
       "      <td>4178</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>1.0.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>22</td>\n",
       "      <td>285946052</td>\n",
       "      <td>iQuran</td>\n",
       "      <td>70707916</td>\n",
       "      <td>USD</td>\n",
       "      <td>1.99</td>\n",
       "      <td>2929</td>\n",
       "      <td>966</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>3.3</td>\n",
       "      <td>4+</td>\n",
       "      <td>Reference</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>23</td>\n",
       "      <td>285994151</td>\n",
       "      <td>:) Sudoku +</td>\n",
       "      <td>6169600</td>\n",
       "      <td>USD</td>\n",
       "      <td>2.99</td>\n",
       "      <td>11447</td>\n",
       "      <td>781</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.2.6</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>40</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>24</td>\n",
       "      <td>286058814</td>\n",
       "      <td>Yahoo Sports - Teams, Scores, News &amp; Highlights</td>\n",
       "      <td>130583552</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>137951</td>\n",
       "      <td>131</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6.9</td>\n",
       "      <td>4+</td>\n",
       "      <td>Sports</td>\n",
       "      <td>37</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>25</td>\n",
       "      <td>286070473</td>\n",
       "      <td>Mileage Log | Fahrtenbuch</td>\n",
       "      <td>71203840</td>\n",
       "      <td>USD</td>\n",
       "      <td>5.99</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0.5</td>\n",
       "      <td>4+</td>\n",
       "      <td>Business</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>27</td>\n",
       "      <td>286799607</td>\n",
       "      <td>Cleartune - Chromatic Tuner</td>\n",
       "      <td>11423008</td>\n",
       "      <td>USD</td>\n",
       "      <td>3.99</td>\n",
       "      <td>3241</td>\n",
       "      <td>297</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.1.3</td>\n",
       "      <td>4+</td>\n",
       "      <td>Music</td>\n",
       "      <td>43</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>28</td>\n",
       "      <td>286906691</td>\n",
       "      <td>Lifesum – Inspiring healthy lifestyle app</td>\n",
       "      <td>188017664</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5795</td>\n",
       "      <td>12</td>\n",
       "      <td>3.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.4.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Health &amp; Fitness</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>29</td>\n",
       "      <td>286911400</td>\n",
       "      <td>Hangman.</td>\n",
       "      <td>4765696</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>42316</td>\n",
       "      <td>248</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.0.6</td>\n",
       "      <td>9+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>31</td>\n",
       "      <td>288113403</td>\n",
       "      <td>iTranslate - Language Translator &amp; Dictionary</td>\n",
       "      <td>287933440</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>123215</td>\n",
       "      <td>25</td>\n",
       "      <td>3.5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.5.4</td>\n",
       "      <td>4+</td>\n",
       "      <td>Productivity</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>32</td>\n",
       "      <td>288120394</td>\n",
       "      <td>TouchOSC</td>\n",
       "      <td>4263936</td>\n",
       "      <td>USD</td>\n",
       "      <td>4.99</td>\n",
       "      <td>782</td>\n",
       "      <td>7</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>1.9.8</td>\n",
       "      <td>4+</td>\n",
       "      <td>Music</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>33</td>\n",
       "      <td>288419283</td>\n",
       "      <td>RadarScope</td>\n",
       "      <td>172772352</td>\n",
       "      <td>USD</td>\n",
       "      <td>9.99</td>\n",
       "      <td>3449</td>\n",
       "      <td>23</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>3.4.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Weather</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7167</th>\n",
       "      <td>10995</td>\n",
       "      <td>1182265441</td>\n",
       "      <td>脱出ゲーム　わたしをみつけて　-おじいさんとわたしの物語-</td>\n",
       "      <td>177498112</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7168</th>\n",
       "      <td>10998</td>\n",
       "      <td>1182331762</td>\n",
       "      <td>Escape from the frigid Igloo.</td>\n",
       "      <td>89188352</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7169</th>\n",
       "      <td>11002</td>\n",
       "      <td>1182568288</td>\n",
       "      <td>Talking Santa - Video santa claus calls you</td>\n",
       "      <td>32685056</td>\n",
       "      <td>USD</td>\n",
       "      <td>2.99</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>1.0.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Entertainment</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7170</th>\n",
       "      <td>11010</td>\n",
       "      <td>1183234072</td>\n",
       "      <td>CTFxCmoji</td>\n",
       "      <td>26077184</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>39</td>\n",
       "      <td>4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>9+</td>\n",
       "      <td>Social Networking</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7171</th>\n",
       "      <td>11013</td>\n",
       "      <td>1183260922</td>\n",
       "      <td>Room Escape Game - Santa's Room</td>\n",
       "      <td>143346688</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7172</th>\n",
       "      <td>11016</td>\n",
       "      <td>1183548754</td>\n",
       "      <td>Rescue the Enchanter</td>\n",
       "      <td>242505728</td>\n",
       "      <td>USD</td>\n",
       "      <td>3.99</td>\n",
       "      <td>55</td>\n",
       "      <td>29</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1.4</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>40</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7173</th>\n",
       "      <td>11019</td>\n",
       "      <td>1183709176</td>\n",
       "      <td>My Diary - 你的名字非官方</td>\n",
       "      <td>18164736</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Utilities</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7174</th>\n",
       "      <td>11022</td>\n",
       "      <td>1183856228</td>\n",
       "      <td>VR Thrills: Roller Coaster 360 (Google Cardboard)</td>\n",
       "      <td>169535488</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>1.3.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7175</th>\n",
       "      <td>11024</td>\n",
       "      <td>1183986102</td>\n",
       "      <td>Santa Kids Hair Salon - Christmas Makeover Games</td>\n",
       "      <td>64244736</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41</td>\n",
       "      <td>19</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7176</th>\n",
       "      <td>11027</td>\n",
       "      <td>1184711626</td>\n",
       "      <td>Human Juggling Cup</td>\n",
       "      <td>184324096</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7177</th>\n",
       "      <td>11031</td>\n",
       "      <td>1184800011</td>\n",
       "      <td>Again - room escape game</td>\n",
       "      <td>33946624</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7178</th>\n",
       "      <td>11033</td>\n",
       "      <td>1185209084</td>\n",
       "      <td>Saloons Unleashed</td>\n",
       "      <td>327731200</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7179</th>\n",
       "      <td>11035</td>\n",
       "      <td>1185328193</td>\n",
       "      <td>Fam — Group video calling for iMessage</td>\n",
       "      <td>113382400</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>279</td>\n",
       "      <td>5</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.6.41</td>\n",
       "      <td>4+</td>\n",
       "      <td>Social Networking</td>\n",
       "      <td>37</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7180</th>\n",
       "      <td>11036</td>\n",
       "      <td>1185365336</td>\n",
       "      <td>Laurie Hernandez the Human Emoji</td>\n",
       "      <td>94008320</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26</td>\n",
       "      <td>3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0.5</td>\n",
       "      <td>9+</td>\n",
       "      <td>Utilities</td>\n",
       "      <td>37</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7181</th>\n",
       "      <td>11038</td>\n",
       "      <td>1185428381</td>\n",
       "      <td>剑倚手游</td>\n",
       "      <td>178160640</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9+</td>\n",
       "      <td>Games</td>\n",
       "      <td>40</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7182</th>\n",
       "      <td>11040</td>\n",
       "      <td>1185538497</td>\n",
       "      <td>camera for filter</td>\n",
       "      <td>9362432</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0.3</td>\n",
       "      <td>4+</td>\n",
       "      <td>Photo &amp; Video</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7183</th>\n",
       "      <td>11041</td>\n",
       "      <td>1185580782</td>\n",
       "      <td>Survivalcraft 2</td>\n",
       "      <td>57349120</td>\n",
       "      <td>USD</td>\n",
       "      <td>3.99</td>\n",
       "      <td>292</td>\n",
       "      <td>292</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0.20.1</td>\n",
       "      <td>9+</td>\n",
       "      <td>Games</td>\n",
       "      <td>40</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7184</th>\n",
       "      <td>11042</td>\n",
       "      <td>1185731859</td>\n",
       "      <td>剑客情缘-高爆率高掉落天天疯玩</td>\n",
       "      <td>171944960</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9+</td>\n",
       "      <td>Games</td>\n",
       "      <td>40</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7185</th>\n",
       "      <td>11043</td>\n",
       "      <td>1185777521</td>\n",
       "      <td>问仙奇遇-新玩法新套装嗨到爆</td>\n",
       "      <td>208026624</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7186</th>\n",
       "      <td>11050</td>\n",
       "      <td>1186108496</td>\n",
       "      <td>脱出ゲーム - 書道教室 -  \"漢字\"の謎に満ちた部屋からの 脱出</td>\n",
       "      <td>85580800</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0.1</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7187</th>\n",
       "      <td>11051</td>\n",
       "      <td>1186126548</td>\n",
       "      <td>Escape Game: illumination</td>\n",
       "      <td>52342784</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7188</th>\n",
       "      <td>11060</td>\n",
       "      <td>1186384912</td>\n",
       "      <td>Demolition Derby Virtual Reality (VR) Racing</td>\n",
       "      <td>168774656</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0.0</td>\n",
       "      <td>12+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7189</th>\n",
       "      <td>11074</td>\n",
       "      <td>1187128255</td>\n",
       "      <td>飞刀传奇-动作武侠热血江湖即时PK传奇（登录爆金装）</td>\n",
       "      <td>537462784</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1.0</td>\n",
       "      <td>9+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7190</th>\n",
       "      <td>11077</td>\n",
       "      <td>1187279979</td>\n",
       "      <td>Add-Ons Studio for Minecraft</td>\n",
       "      <td>22999040</td>\n",
       "      <td>USD</td>\n",
       "      <td>2.99</td>\n",
       "      <td>97</td>\n",
       "      <td>97</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7191</th>\n",
       "      <td>11079</td>\n",
       "      <td>1187282363</td>\n",
       "      <td>Plead the Fifth - The Game</td>\n",
       "      <td>27853824</td>\n",
       "      <td>USD</td>\n",
       "      <td>2.99</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.1.1</td>\n",
       "      <td>17+</td>\n",
       "      <td>Games</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7192</th>\n",
       "      <td>11081</td>\n",
       "      <td>1187617475</td>\n",
       "      <td>Kubik</td>\n",
       "      <td>126644224</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>142</td>\n",
       "      <td>75</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1.3</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7193</th>\n",
       "      <td>11082</td>\n",
       "      <td>1187682390</td>\n",
       "      <td>VR Roller-Coaster</td>\n",
       "      <td>120760320</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7194</th>\n",
       "      <td>11087</td>\n",
       "      <td>1187779532</td>\n",
       "      <td>Bret Michaels Emojis + Lyric Keyboard</td>\n",
       "      <td>111322112</td>\n",
       "      <td>USD</td>\n",
       "      <td>1.99</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0.2</td>\n",
       "      <td>9+</td>\n",
       "      <td>Utilities</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7195</th>\n",
       "      <td>11089</td>\n",
       "      <td>1187838770</td>\n",
       "      <td>VR Roller Coaster World - Virtual Reality</td>\n",
       "      <td>97235968</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>85</td>\n",
       "      <td>32</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1.0.15</td>\n",
       "      <td>12+</td>\n",
       "      <td>Games</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7196</th>\n",
       "      <td>11097</td>\n",
       "      <td>1188375727</td>\n",
       "      <td>Escape the Sweet Shop Series</td>\n",
       "      <td>90898432</td>\n",
       "      <td>USD</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4+</td>\n",
       "      <td>Games</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7197 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0          id  \\\n",
       "0              1   281656475   \n",
       "1              2   281796108   \n",
       "2              3   281940292   \n",
       "3              4   282614216   \n",
       "4              5   282935706   \n",
       "5              6   283619399   \n",
       "6              7   283646709   \n",
       "7              8   284035177   \n",
       "8              9   284666222   \n",
       "9             10   284736660   \n",
       "10            11   284791396   \n",
       "11            12   284815117   \n",
       "12            13   284815942   \n",
       "13            14   284847138   \n",
       "14            15   284862767   \n",
       "15            16   284876795   \n",
       "16            17   284882215   \n",
       "17            18   284910350   \n",
       "18            20   284993459   \n",
       "19            21   285005463   \n",
       "20            22   285946052   \n",
       "21            23   285994151   \n",
       "22            24   286058814   \n",
       "23            25   286070473   \n",
       "24            27   286799607   \n",
       "25            28   286906691   \n",
       "26            29   286911400   \n",
       "27            31   288113403   \n",
       "28            32   288120394   \n",
       "29            33   288419283   \n",
       "...          ...         ...   \n",
       "7167       10995  1182265441   \n",
       "7168       10998  1182331762   \n",
       "7169       11002  1182568288   \n",
       "7170       11010  1183234072   \n",
       "7171       11013  1183260922   \n",
       "7172       11016  1183548754   \n",
       "7173       11019  1183709176   \n",
       "7174       11022  1183856228   \n",
       "7175       11024  1183986102   \n",
       "7176       11027  1184711626   \n",
       "7177       11031  1184800011   \n",
       "7178       11033  1185209084   \n",
       "7179       11035  1185328193   \n",
       "7180       11036  1185365336   \n",
       "7181       11038  1185428381   \n",
       "7182       11040  1185538497   \n",
       "7183       11041  1185580782   \n",
       "7184       11042  1185731859   \n",
       "7185       11043  1185777521   \n",
       "7186       11050  1186108496   \n",
       "7187       11051  1186126548   \n",
       "7188       11060  1186384912   \n",
       "7189       11074  1187128255   \n",
       "7190       11077  1187279979   \n",
       "7191       11079  1187282363   \n",
       "7192       11081  1187617475   \n",
       "7193       11082  1187682390   \n",
       "7194       11087  1187779532   \n",
       "7195       11089  1187838770   \n",
       "7196       11097  1188375727   \n",
       "\n",
       "                                             track_name  size_bytes currency  \\\n",
       "0                                       PAC-MAN Premium   100788224      USD   \n",
       "1                             Evernote - stay organized   158578688      USD   \n",
       "2       WeatherBug - Local Weather, Radar, Maps, Alerts   100524032      USD   \n",
       "3     eBay: Best App to Buy, Sell, Save! Online Shop...   128512000      USD   \n",
       "4                                                 Bible    92774400      USD   \n",
       "5                                      Shanghai Mahjong    10485713      USD   \n",
       "6                PayPal - Send and request money safely   227795968      USD   \n",
       "7                               Pandora - Music & Radio   130242560      USD   \n",
       "8                           PCalc - The Best Calculator    49250304      USD   \n",
       "9                                           Ms. PAC-MAN    70023168      USD   \n",
       "10                            Solitaire by MobilityWare    49618944      USD   \n",
       "11                                     SCRABBLE Premium   227547136      USD   \n",
       "12                 Google – Search made just for mobile   179979264      USD   \n",
       "13                     Bank of America - Mobile Banking   160925696      USD   \n",
       "14                                             FreeCell    55153664      USD   \n",
       "15               TripAdvisor Hotels Flights Restaurants   207907840      USD   \n",
       "16                                             Facebook   389879808      USD   \n",
       "17       Yelp - Nearby Restaurants, Shopping & Services   167407616      USD   \n",
       "18    Shazam - Discover music, artists, videos & lyrics   147093504      USD   \n",
       "19                        Crash Bandicoot Nitro Kart 3D    10735026      USD   \n",
       "20                                               iQuran    70707916      USD   \n",
       "21                                          :) Sudoku +     6169600      USD   \n",
       "22      Yahoo Sports - Teams, Scores, News & Highlights   130583552      USD   \n",
       "23                            Mileage Log | Fahrtenbuch    71203840      USD   \n",
       "24                          Cleartune - Chromatic Tuner    11423008      USD   \n",
       "25            Lifesum – Inspiring healthy lifestyle app   188017664      USD   \n",
       "26                                             Hangman.     4765696      USD   \n",
       "27        iTranslate - Language Translator & Dictionary   287933440      USD   \n",
       "28                                             TouchOSC     4263936      USD   \n",
       "29                                           RadarScope   172772352      USD   \n",
       "...                                                 ...         ...      ...   \n",
       "7167                      脱出ゲーム　わたしをみつけて　-おじいさんとわたしの物語-   177498112      USD   \n",
       "7168                      Escape from the frigid Igloo.    89188352      USD   \n",
       "7169        Talking Santa - Video santa claus calls you    32685056      USD   \n",
       "7170                                          CTFxCmoji    26077184      USD   \n",
       "7171                    Room Escape Game - Santa's Room   143346688      USD   \n",
       "7172                               Rescue the Enchanter   242505728      USD   \n",
       "7173                                 My Diary - 你的名字非官方    18164736      USD   \n",
       "7174  VR Thrills: Roller Coaster 360 (Google Cardboard)   169535488      USD   \n",
       "7175   Santa Kids Hair Salon - Christmas Makeover Games    64244736      USD   \n",
       "7176                                 Human Juggling Cup   184324096      USD   \n",
       "7177                           Again - room escape game    33946624      USD   \n",
       "7178                                  Saloons Unleashed   327731200      USD   \n",
       "7179             Fam — Group video calling for iMessage   113382400      USD   \n",
       "7180                   Laurie Hernandez the Human Emoji    94008320      USD   \n",
       "7181                                               剑倚手游   178160640      USD   \n",
       "7182                                  camera for filter     9362432      USD   \n",
       "7183                                    Survivalcraft 2    57349120      USD   \n",
       "7184                                    剑客情缘-高爆率高掉落天天疯玩   171944960      USD   \n",
       "7185                                     问仙奇遇-新玩法新套装嗨到爆   208026624      USD   \n",
       "7186                 脱出ゲーム - 書道教室 -  \"漢字\"の謎に満ちた部屋からの 脱出    85580800      USD   \n",
       "7187                          Escape Game: illumination    52342784      USD   \n",
       "7188       Demolition Derby Virtual Reality (VR) Racing   168774656      USD   \n",
       "7189                         飞刀传奇-动作武侠热血江湖即时PK传奇（登录爆金装）   537462784      USD   \n",
       "7190                       Add-Ons Studio for Minecraft    22999040      USD   \n",
       "7191                         Plead the Fifth - The Game    27853824      USD   \n",
       "7192                                              Kubik   126644224      USD   \n",
       "7193                                  VR Roller-Coaster   120760320      USD   \n",
       "7194              Bret Michaels Emojis + Lyric Keyboard   111322112      USD   \n",
       "7195          VR Roller Coaster World - Virtual Reality    97235968      USD   \n",
       "7196                       Escape the Sweet Shop Series    90898432      USD   \n",
       "\n",
       "      price  rating_count_tot  rating_count_ver  user_rating  user_rating_ver  \\\n",
       "0      3.99             21292                26          4.0              4.5   \n",
       "1      0.00            161065                26          4.0              3.5   \n",
       "2      0.00            188583              2822          3.5              4.5   \n",
       "3      0.00            262241               649          4.0              4.5   \n",
       "4      0.00            985920              5320          4.5              5.0   \n",
       "5      0.99              8253              5516          4.0              4.0   \n",
       "6      0.00            119487               879          4.0              4.5   \n",
       "7      0.00           1126879              3594          4.0              4.5   \n",
       "8      9.99              1117                 4          4.5              5.0   \n",
       "9      3.99              7885                40          4.0              4.0   \n",
       "10     4.99             76720              4017          4.5              4.5   \n",
       "11     7.99            105776               166          3.5              2.5   \n",
       "12     0.00            479440               203          3.5              4.0   \n",
       "13     0.00            119773              2336          3.5              4.5   \n",
       "14     4.99              6340               668          4.5              4.5   \n",
       "15     0.00             56194                87          4.0              3.5   \n",
       "16     0.00           2974676               212          3.5              3.5   \n",
       "17     0.00            223885              3726          4.0              4.5   \n",
       "18     0.00            402925               136          4.0              4.5   \n",
       "19     2.99             31456              4178          4.0              3.5   \n",
       "20     1.99              2929               966          4.5              4.5   \n",
       "21     2.99             11447               781          5.0              5.0   \n",
       "22     0.00            137951               131          4.0              4.5   \n",
       "23     5.99                 8                 0          4.5              0.0   \n",
       "24     3.99              3241               297          4.0              4.0   \n",
       "25     0.00              5795                12          3.5              4.0   \n",
       "26     0.00             42316               248          3.0              3.5   \n",
       "27     0.00            123215                25          3.5              5.0   \n",
       "28     4.99               782                 7          4.0              3.5   \n",
       "29     9.99              3449                23          4.0              4.5   \n",
       "...     ...               ...               ...          ...              ...   \n",
       "7167   0.00                 1                 1          1.0              1.0   \n",
       "7168   0.00                 3                 3          4.0              4.0   \n",
       "7169   2.99                 9                 3          3.0              3.5   \n",
       "7170   0.00                39                 4          5.0              5.0   \n",
       "7171   0.00                10                10          5.0              5.0   \n",
       "7172   3.99                55                29          4.5              4.5   \n",
       "7173   0.99                 0                 0          0.0              0.0   \n",
       "7174   0.00                14                 4          4.0              3.5   \n",
       "7175   0.00                41                19          4.5              4.5   \n",
       "7176   0.00                 0                 0          0.0              0.0   \n",
       "7177   0.00                11                 8          4.0              4.0   \n",
       "7178   0.99                 0                 0          0.0              0.0   \n",
       "7179   0.00               279                 5          3.5              3.0   \n",
       "7180   0.00                26                 3          5.0              5.0   \n",
       "7181   0.99                 0                 0          0.0              0.0   \n",
       "7182   0.00                 0                 0          0.0              0.0   \n",
       "7183   3.99               292               292          4.0              4.0   \n",
       "7184   0.00                 0                 0          0.0              0.0   \n",
       "7185   0.99                 0                 0          0.0              0.0   \n",
       "7186   0.00                 1                 1          2.0              2.0   \n",
       "7187   0.00                23                23          4.5              4.5   \n",
       "7188   0.00                18                18          4.0              4.0   \n",
       "7189   0.99                 0                 0          0.0              0.0   \n",
       "7190   2.99                97                97          3.0              3.0   \n",
       "7191   2.99                11                 0          4.0              0.0   \n",
       "7192   0.00               142                75          4.5              4.5   \n",
       "7193   0.00                30                30          4.5              4.5   \n",
       "7194   1.99                15                 0          4.5              0.0   \n",
       "7195   0.00                85                32          4.5              4.5   \n",
       "7196   0.00                 3                 3          5.0              5.0   \n",
       "\n",
       "           ver cont_rating        prime_genre  sup_devices.num  \\\n",
       "0        6.3.5          4+              Games               38   \n",
       "1        8.2.2          4+       Productivity               37   \n",
       "2        5.0.0          4+            Weather               37   \n",
       "3       5.10.0         12+           Shopping               37   \n",
       "4        7.5.1          4+          Reference               37   \n",
       "5          1.8          4+              Games               47   \n",
       "6       6.12.0          4+            Finance               37   \n",
       "7        8.4.1         12+              Music               37   \n",
       "8        3.6.6          4+          Utilities               37   \n",
       "9        4.0.4          4+              Games               38   \n",
       "10      4.10.1          4+              Games               38   \n",
       "11      5.19.0          4+              Games               37   \n",
       "12        27.0         17+          Utilities               37   \n",
       "13       7.3.8          4+            Finance               37   \n",
       "14       4.0.3          4+              Games               38   \n",
       "15        21.1          4+             Travel               37   \n",
       "16        95.0          4+  Social Networking               37   \n",
       "17     11.15.0         12+             Travel               37   \n",
       "18      11.0.3         12+              Music               37   \n",
       "19       1.0.0          4+              Games               47   \n",
       "20         3.3          4+          Reference               43   \n",
       "21       5.2.6          4+              Games               40   \n",
       "22         6.9          4+             Sports               37   \n",
       "23       9.0.5          4+           Business               37   \n",
       "24       2.1.3          4+              Music               43   \n",
       "25       8.4.1          4+   Health & Fitness               37   \n",
       "26       2.0.6          9+              Games               38   \n",
       "27      10.5.4          4+       Productivity               37   \n",
       "28       1.9.8          4+              Music               43   \n",
       "29       3.4.1          4+            Weather               37   \n",
       "...        ...         ...                ...              ...   \n",
       "7167     1.0.1          4+              Games               38   \n",
       "7168     1.0.1          4+              Games               38   \n",
       "7169     1.0.1          4+      Entertainment               37   \n",
       "7170       1.3          9+  Social Networking               37   \n",
       "7171       1.0          4+              Games               40   \n",
       "7172       1.4          4+              Games               40   \n",
       "7173       1.1          4+          Utilities               37   \n",
       "7174     1.3.0          4+              Games               37   \n",
       "7175       1.3          4+              Games               37   \n",
       "7176     1.0.1          4+              Games               40   \n",
       "7177     1.1.0          4+              Games               37   \n",
       "7178       1.1          4+              Games               37   \n",
       "7179    0.6.41          4+  Social Networking               37   \n",
       "7180     1.0.5          9+          Utilities               37   \n",
       "7181       1.0          9+              Games               40   \n",
       "7182     1.0.3          4+      Photo & Video               37   \n",
       "7183  2.0.20.1          9+              Games               40   \n",
       "7184       1.0          9+              Games               40   \n",
       "7185       1.0          9+              Games               38   \n",
       "7186     1.0.1          4+              Games               38   \n",
       "7187       1.0          4+              Games               37   \n",
       "7188     1.0.0         12+              Games               38   \n",
       "7189     2.1.0          9+              Games               38   \n",
       "7190       1.0          4+              Games               37   \n",
       "7191     1.1.1         17+              Games               37   \n",
       "7192       1.3          4+              Games               38   \n",
       "7193       0.9          4+              Games               38   \n",
       "7194     1.0.2          9+          Utilities               37   \n",
       "7195    1.0.15         12+              Games               38   \n",
       "7196       1.0          4+              Games               40   \n",
       "\n",
       "      ipadSc_urls.num  lang.num  vpp_lic  \n",
       "0                   5        10        1  \n",
       "1                   5        23        1  \n",
       "2                   5         3        1  \n",
       "3                   5         9        1  \n",
       "4                   5        45        1  \n",
       "5                   5         1        1  \n",
       "6                   0        19        1  \n",
       "7                   4         1        1  \n",
       "8                   5         1        1  \n",
       "9                   0        10        1  \n",
       "10                  4        11        1  \n",
       "11                  0         6        1  \n",
       "12                  4        33        1  \n",
       "13                  0         2        1  \n",
       "14                  5         2        1  \n",
       "15                  1        26        1  \n",
       "16                  1        29        1  \n",
       "17                  5        18        1  \n",
       "18                  3        16        1  \n",
       "19                  0         1        1  \n",
       "20                  0         2        1  \n",
       "21                  5         1        1  \n",
       "22                  2         6        1  \n",
       "23                  5         3        1  \n",
       "24                  2        10        1  \n",
       "25                  5        11        1  \n",
       "26                  0         1        1  \n",
       "27                  5        23        1  \n",
       "28                  1         1        1  \n",
       "29                  5         1        1  \n",
       "...               ...       ...      ...  \n",
       "7167                4         1        1  \n",
       "7168                5         1        1  \n",
       "7169                0        31        1  \n",
       "7170                1         1        1  \n",
       "7171                0         1        1  \n",
       "7172                5         1        1  \n",
       "7173                0         1        1  \n",
       "7174                5         1        1  \n",
       "7175                5        25        1  \n",
       "7176                4         1        1  \n",
       "7177                5         1        1  \n",
       "7178                5         1        1  \n",
       "7179                4         1        1  \n",
       "7180                4         1        1  \n",
       "7181                5         0        1  \n",
       "7182                0         1        1  \n",
       "7183                5         1        1  \n",
       "7184                5         0        1  \n",
       "7185                5         1        1  \n",
       "7186                5         1        1  \n",
       "7187                5         2        1  \n",
       "7188                4         1        1  \n",
       "7189                5         1        1  \n",
       "7190                5         3        1  \n",
       "7191                0         1        1  \n",
       "7192                5         1        1  \n",
       "7193                0         1        1  \n",
       "7194                1         1        1  \n",
       "7195                0         2        1  \n",
       "7196                0         2        1  \n",
       "\n",
       "[7197 rows x 17 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df=pd.read_csv(\"data files/AppleStore.csv\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Games',\n",
       " 'Productivity',\n",
       " 'Weather',\n",
       " 'Shopping',\n",
       " 'Reference',\n",
       " 'Games',\n",
       " 'Finance',\n",
       " 'Music',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Utilities',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Travel',\n",
       " 'Social Networking',\n",
       " 'Travel',\n",
       " 'Music',\n",
       " 'Games',\n",
       " 'Reference',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Business',\n",
       " 'Music',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Productivity',\n",
       " 'Music',\n",
       " 'Weather',\n",
       " 'Social Networking',\n",
       " 'Health & Fitness',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'Music',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Weather',\n",
       " 'Games',\n",
       " 'Photo & Video',\n",
       " 'Music',\n",
       " 'Navigation',\n",
       " 'Music',\n",
       " 'Navigation',\n",
       " 'Travel',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Games',\n",
       " 'Weather',\n",
       " 'Business',\n",
       " 'Education',\n",
       " 'Weather',\n",
       " 'Lifestyle',\n",
       " 'Lifestyle',\n",
       " 'Food & Drink',\n",
       " 'Entertainment',\n",
       " 'Education',\n",
       " 'Health & Fitness',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Utilities',\n",
       " 'Music',\n",
       " 'Music',\n",
       " 'Finance',\n",
       " 'Reference',\n",
       " 'Food & Drink',\n",
       " 'News',\n",
       " 'Navigation',\n",
       " 'Weather',\n",
       " 'Finance',\n",
       " 'News',\n",
       " 'Utilities',\n",
       " 'Education',\n",
       " 'Utilities',\n",
       " 'Entertainment',\n",
       " 'Health & Fitness',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Book',\n",
       " 'Games',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Games',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Social Networking',\n",
       " 'Photo & Video',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Finance',\n",
       " 'Weather',\n",
       " 'Health & Fitness',\n",
       " 'Health & Fitness',\n",
       " 'News',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Health & Fitness',\n",
       " 'Photo & Video',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Utilities',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Reference',\n",
       " 'News',\n",
       " 'Sports',\n",
       " 'Utilities',\n",
       " 'Entertainment',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Business',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Productivity',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Finance',\n",
       " 'Music',\n",
       " 'Productivity',\n",
       " 'Games',\n",
       " 'Productivity',\n",
       " 'Travel',\n",
       " 'Finance',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Social Networking',\n",
       " 'Weather',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'News',\n",
       " 'Sports',\n",
       " 'Travel',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Sports',\n",
       " 'Music',\n",
       " 'News',\n",
       " 'Social Networking',\n",
       " 'Shopping',\n",
       " 'Navigation',\n",
       " 'Games',\n",
       " 'Finance',\n",
       " 'Finance',\n",
       " 'Health & Fitness',\n",
       " 'Photo & Video',\n",
       " 'Food & Drink',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Weather',\n",
       " 'Games',\n",
       " 'Navigation',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Music',\n",
       " 'Food & Drink',\n",
       " 'Sports',\n",
       " 'News',\n",
       " 'Weather',\n",
       " 'Games',\n",
       " 'Productivity',\n",
       " 'Health & Fitness',\n",
       " 'Utilities',\n",
       " 'Medical',\n",
       " 'Photo & Video',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Weather',\n",
       " 'Entertainment',\n",
       " 'Sports',\n",
       " 'Productivity',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Navigation',\n",
       " 'Finance',\n",
       " 'Navigation',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'Photo & Video',\n",
       " 'Food & Drink',\n",
       " 'Games',\n",
       " 'Food & Drink',\n",
       " 'Sports',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'News',\n",
       " 'Shopping',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Lifestyle',\n",
       " 'News',\n",
       " 'Lifestyle',\n",
       " 'Business',\n",
       " 'News',\n",
       " 'Travel',\n",
       " 'News',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Reference',\n",
       " 'Games',\n",
       " 'Business',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Lifestyle',\n",
       " 'Sports',\n",
       " 'Entertainment',\n",
       " 'Health & Fitness',\n",
       " 'Shopping',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Social Networking',\n",
       " 'Navigation',\n",
       " 'Health & Fitness',\n",
       " 'Productivity',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'News',\n",
       " 'Music',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Business',\n",
       " 'Shopping',\n",
       " 'Entertainment',\n",
       " 'Photo & Video',\n",
       " 'Entertainment',\n",
       " 'Food & Drink',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Shopping',\n",
       " 'Health & Fitness',\n",
       " 'Travel',\n",
       " 'Productivity',\n",
       " 'News',\n",
       " 'Photo & Video',\n",
       " 'Music',\n",
       " 'Business',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Travel',\n",
       " 'Lifestyle',\n",
       " 'Travel',\n",
       " 'Games',\n",
       " 'Navigation',\n",
       " 'Games',\n",
       " 'Travel',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Travel',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'Business',\n",
       " 'Entertainment',\n",
       " 'Photo & Video',\n",
       " 'News',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Book',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Lifestyle',\n",
       " 'Entertainment',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Productivity',\n",
       " 'Utilities',\n",
       " 'Health & Fitness',\n",
       " 'Health & Fitness',\n",
       " 'News',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Education',\n",
       " 'Entertainment',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Travel',\n",
       " 'Education',\n",
       " 'Education',\n",
       " 'Shopping',\n",
       " 'Social Networking',\n",
       " 'Photo & Video',\n",
       " 'Travel',\n",
       " 'Entertainment',\n",
       " 'Photo & Video',\n",
       " 'Music',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Sports',\n",
       " 'Games',\n",
       " 'Productivity',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Productivity',\n",
       " 'Navigation',\n",
       " 'Photo & Video',\n",
       " 'Weather',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Music',\n",
       " 'Utilities',\n",
       " 'Productivity',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Weather',\n",
       " 'Entertainment',\n",
       " 'Productivity',\n",
       " 'Business',\n",
       " 'Reference',\n",
       " 'Utilities',\n",
       " 'Reference',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Productivity',\n",
       " 'Reference',\n",
       " 'Photo & Video',\n",
       " 'Entertainment',\n",
       " 'Navigation',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Health & Fitness',\n",
       " 'Book',\n",
       " 'Travel',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'News',\n",
       " 'Travel',\n",
       " 'Utilities',\n",
       " 'Travel',\n",
       " 'Productivity',\n",
       " 'Book',\n",
       " 'Weather',\n",
       " 'Entertainment',\n",
       " 'Business',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Finance',\n",
       " 'Productivity',\n",
       " 'Utilities',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Social Networking',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Finance',\n",
       " 'Education',\n",
       " 'Weather',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'News',\n",
       " 'Productivity',\n",
       " 'Productivity',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Education',\n",
       " 'Weather',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Sports',\n",
       " 'Entertainment',\n",
       " 'Education',\n",
       " 'Navigation',\n",
       " 'Photo & Video',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Navigation',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Travel',\n",
       " 'Book',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Utilities',\n",
       " 'Music',\n",
       " 'Lifestyle',\n",
       " 'Shopping',\n",
       " 'Productivity',\n",
       " 'Education',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Lifestyle',\n",
       " 'Sports',\n",
       " 'Business',\n",
       " 'Health & Fitness',\n",
       " 'Utilities',\n",
       " 'Shopping',\n",
       " 'Business',\n",
       " 'Shopping',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Entertainment',\n",
       " 'Music',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Photo & Video',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Lifestyle',\n",
       " 'Reference',\n",
       " 'Lifestyle',\n",
       " 'Business',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'News',\n",
       " 'Lifestyle',\n",
       " 'Utilities',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Reference',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Travel',\n",
       " 'Utilities',\n",
       " 'Productivity',\n",
       " 'Medical',\n",
       " 'Utilities',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Utilities',\n",
       " 'Entertainment',\n",
       " 'Social Networking',\n",
       " 'Sports',\n",
       " 'Education',\n",
       " 'Photo & Video',\n",
       " 'Productivity',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Navigation',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Medical',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Productivity',\n",
       " 'Book',\n",
       " 'Games',\n",
       " 'Food & Drink',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Business',\n",
       " 'Social Networking',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Productivity',\n",
       " 'Shopping',\n",
       " 'Reference',\n",
       " 'Entertainment',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'Travel',\n",
       " 'Weather',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'News',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Utilities',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'Finance',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Weather',\n",
       " 'Games',\n",
       " 'Lifestyle',\n",
       " 'News',\n",
       " 'Reference',\n",
       " 'Finance',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Games',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Travel',\n",
       " 'Productivity',\n",
       " 'News',\n",
       " 'Travel',\n",
       " 'Business',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Reference',\n",
       " 'Entertainment',\n",
       " 'Weather',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Education',\n",
       " 'Music',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Photo & Video',\n",
       " 'Travel',\n",
       " 'Food & Drink',\n",
       " 'Finance',\n",
       " 'Utilities',\n",
       " 'Finance',\n",
       " 'Travel',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'News',\n",
       " 'Food & Drink',\n",
       " 'Photo & Video',\n",
       " 'Finance',\n",
       " 'Health & Fitness',\n",
       " 'Entertainment',\n",
       " 'Health & Fitness',\n",
       " 'Photo & Video',\n",
       " 'Navigation',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Health & Fitness',\n",
       " 'Weather',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'Productivity',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Reference',\n",
       " 'Reference',\n",
       " 'Education',\n",
       " 'Photo & Video',\n",
       " 'Sports',\n",
       " 'Sports',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Sports',\n",
       " 'News',\n",
       " 'Games',\n",
       " 'Navigation',\n",
       " 'Weather',\n",
       " 'Productivity',\n",
       " 'Food & Drink',\n",
       " 'Education',\n",
       " 'Lifestyle',\n",
       " 'Photo & Video',\n",
       " 'Finance',\n",
       " 'Shopping',\n",
       " 'Entertainment',\n",
       " 'Social Networking',\n",
       " 'Music',\n",
       " 'Reference',\n",
       " 'News',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Utilities',\n",
       " 'Lifestyle',\n",
       " 'Lifestyle',\n",
       " 'Photo & Video',\n",
       " 'Utilities',\n",
       " 'Photo & Video',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Health & Fitness',\n",
       " 'Shopping',\n",
       " 'Productivity',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Weather',\n",
       " 'Sports',\n",
       " 'Music',\n",
       " 'Lifestyle',\n",
       " 'Utilities',\n",
       " 'Education',\n",
       " 'Food & Drink',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Music',\n",
       " 'Entertainment',\n",
       " 'News',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Productivity',\n",
       " 'Photo & Video',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Reference',\n",
       " 'Productivity',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'News',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'News',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Utilities',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Travel',\n",
       " 'Travel',\n",
       " 'Social Networking',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Sports',\n",
       " 'Social Networking',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Productivity',\n",
       " 'Productivity',\n",
       " 'Book',\n",
       " 'Games',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Utilities',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Navigation',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Reference',\n",
       " 'Sports',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Reference',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Social Networking',\n",
       " 'Photo & Video',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Weather',\n",
       " 'Shopping',\n",
       " 'Education',\n",
       " 'Travel',\n",
       " 'Utilities',\n",
       " 'Education',\n",
       " 'Education',\n",
       " 'Productivity',\n",
       " 'Education',\n",
       " 'Travel',\n",
       " 'Education',\n",
       " 'Photo & Video',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Food & Drink',\n",
       " 'Games',\n",
       " 'Photo & Video',\n",
       " 'Shopping',\n",
       " 'News',\n",
       " 'Entertainment',\n",
       " 'Photo & Video',\n",
       " 'Business',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Productivity',\n",
       " 'Shopping',\n",
       " 'Business',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Utilities',\n",
       " 'Food & Drink',\n",
       " 'Photo & Video',\n",
       " 'Entertainment',\n",
       " 'Utilities',\n",
       " 'Photo & Video',\n",
       " 'Education',\n",
       " 'Social Networking',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Entertainment',\n",
       " 'Reference',\n",
       " 'Education',\n",
       " 'Photo & Video',\n",
       " 'Productivity',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'Social Networking',\n",
       " 'Travel',\n",
       " 'Utilities',\n",
       " 'Weather',\n",
       " 'Book',\n",
       " 'Business',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Entertainment',\n",
       " 'Finance',\n",
       " 'Social Networking',\n",
       " 'Entertainment',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Finance',\n",
       " 'Productivity',\n",
       " 'Medical',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Navigation',\n",
       " 'Games',\n",
       " 'Photo & Video',\n",
       " 'Travel',\n",
       " 'Business',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Productivity',\n",
       " 'Games',\n",
       " 'Photo & Video',\n",
       " 'Utilities',\n",
       " 'Social Networking',\n",
       " 'Health & Fitness',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Travel',\n",
       " 'Reference',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Entertainment',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'News',\n",
       " 'Entertainment',\n",
       " 'Shopping',\n",
       " 'Navigation',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Travel',\n",
       " 'Health & Fitness',\n",
       " 'Utilities',\n",
       " 'Reference',\n",
       " 'Health & Fitness',\n",
       " 'Entertainment',\n",
       " 'Travel',\n",
       " 'Social Networking',\n",
       " 'Food & Drink',\n",
       " 'Utilities',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Social Networking',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Business',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Photo & Video',\n",
       " 'Reference',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Weather',\n",
       " 'Social Networking',\n",
       " 'Entertainment',\n",
       " 'Education',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Games',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Music',\n",
       " 'Games',\n",
       " 'Productivity',\n",
       " 'Navigation',\n",
       " 'Utilities',\n",
       " 'Education',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " 'Health & Fitness',\n",
       " 'Entertainment',\n",
       " 'Entertainment',\n",
       " 'Travel',\n",
       " 'Education',\n",
       " 'Photo & Video',\n",
       " 'Navigation',\n",
       " 'Lifestyle',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'News',\n",
       " 'Education',\n",
       " 'Photo & Video',\n",
       " 'Sports',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Food & Drink',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Lifestyle',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Music',\n",
       " 'Weather',\n",
       " 'Business',\n",
       " 'News',\n",
       " 'Health & Fitness',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'News',\n",
       " 'Shopping',\n",
       " 'Finance',\n",
       " 'Productivity',\n",
       " 'Business',\n",
       " 'Travel',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Games',\n",
       " 'Education',\n",
       " 'Education',\n",
       " 'Games',\n",
       " 'Finance',\n",
       " 'Games',\n",
       " 'Shopping',\n",
       " 'Photo & Video',\n",
       " 'Games',\n",
       " ...]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#List of all unique Prime_Genres(categories) in the dataset\n",
    "list(df[\"prime_genre\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Category with highest number of apps\n",
    "df."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}