tldr
KggleのGoogle Play Store AppsをApp Type Prediction - Data Every Day #044に沿ってやっていきます。
実行環境はGoogle Colaboratorです。
インポート
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
import sklearn.preprocessing as sp
from sklearn.model_selection import train_test_split
import sklearn.linear_model as slm
import tensorflow as tf
データのダウンロード
Google Driveをマウントします。
from google.colab import drive
drive.mount('/content/drive')
Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount("/content/drive", force_remount=True).
KaggleのAPIクライアントを初期化し、認証します。
認証情報はGoogle Drive内（/content/drive/My Drive/Colab Notebooks/Kaggle）にkaggle.jsonとして置いてあります。
import os
kaggle_path = "/content/drive/My Drive/Colab Notebooks/Kaggle"
os.environ['KAGGLE_CONFIG_DIR'] = kaggle_path
from kaggle.api.kaggle_api_extended import KaggleApi
api = KaggleApi()
api.authenticate()
Kaggle APIを使ってデータをダウンロードします。
dataset_id = 'lava18/google-play-store-apps'
dataset = api.dataset_list_files(dataset_id)
file_name = dataset.files[0].name
file_path = os.path.join(api.get_default_download_dir(), file_name)
file_path
'/content/googleplaystore.csv'
api.dataset_download_file(dataset_id, file_name, force=True, quiet=False)
100%|██████████| 312k/312k [00:00<00:00, 36.2MB/s]
Downloading googleplaystore.csv.zip to /content
True
データの読み込み
data = pd.read_csv(file_path + '.zip')
data
| App | Category | Rating | Reviews | Size | Installs | Type | Price | Content Rating | Genres | Last Updated | Current Ver | Android Ver | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Photo Editor & Candy Camera & Grid & ScrapBook | ART_AND_DESIGN | 4.1 | 159 | 19M | 10,000+ | Free | 0 | Everyone | Art & Design | January 7, 2018 | 1.0.0 | 4.0.3 and up |
| 1 | Coloring book moana | ART_AND_DESIGN | 3.9 | 967 | 14M | 500,000+ | Free | 0 | Everyone | Art & Design;Pretend Play | January 15, 2018 | 2.0.0 | 4.0.3 and up |
| 2 | U Launcher Lite – FREE Live Cool Themes, Hide ... | ART_AND_DESIGN | 4.7 | 87510 | 8.7M | 5,000,000+ | Free | 0 | Everyone | Art & Design | August 1, 2018 | 1.2.4 | 4.0.3 and up |
| 3 | Sketch - Draw & Paint | ART_AND_DESIGN | 4.5 | 215644 | 25M | 50,000,000+ | Free | 0 | Teen | Art & Design | June 8, 2018 | Varies with device | 4.2 and up |
| 4 | Pixel Draw - Number Art Coloring Book | ART_AND_DESIGN | 4.3 | 967 | 2.8M | 100,000+ | Free | 0 | Everyone | Art & Design;Creativity | June 20, 2018 | 1.1 | 4.4 and up |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 10836 | Sya9a Maroc - FR | FAMILY | 4.5 | 38 | 53M | 5,000+ | Free | 0 | Everyone | Education | July 25, 2017 | 1.48 | 4.1 and up |
| 10837 | Fr. Mike Schmitz Audio Teachings | FAMILY | 5.0 | 4 | 3.6M | 100+ | Free | 0 | Everyone | Education | July 6, 2018 | 1.0 | 4.1 and up |
| 10838 | Parkinson Exercices FR | MEDICAL | NaN | 3 | 9.5M | 1,000+ | Free | 0 | Everyone | Medical | January 20, 2017 | 1.0 | 2.2 and up |
| 10839 | The SCP Foundation DB fr nn5n | BOOKS_AND_REFERENCE | 4.5 | 114 | Varies with device | 1,000+ | Free | 0 | Mature 17+ | Books & Reference | January 19, 2015 | Varies with device | Varies with device |
| 10840 | iHoroscope - 2018 Daily Horoscope & Astrology | LIFESTYLE | 4.5 | 398307 | 19M | 10,000,000+ | Free | 0 | Everyone | Lifestyle | July 25, 2018 | Varies with device | Varies with device |
10841 rows × 13 columns
下準備
data.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 10841 entries, 0 to 10840
Data columns (total 13 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 App 10841 non-null object
1 Category 10841 non-null object
2 Rating 9367 non-null float64
3 Reviews 10841 non-null object
4 Size 10841 non-null object
5 Installs 10841 non-null object
6 Type 10840 non-null object
7 Price 10841 non-null object
8 Content Rating 10840 non-null object
9 Genres 10841 non-null object
10 Last Updated 10841 non-null object
11 Current Ver 10833 non-null object
12 Android Ver 10838 non-null object
dtypes: float64(1), object(12)
memory usage: 1.1+ MB
unneeded_columns = ['App', 'Genres', 'Current Ver', 'Android Ver']
data = data.drop(unneeded_columns, axis=1)
data.isna().sum()
Category 0
Rating 1474
Reviews 0
Size 0
Installs 0
Type 1
Price 0
Content Rating 1
Last Updated 0
dtype: int64
def get_uniques(df, columns):
return {column: list(df[column].unique()) for column in columns}
def get_categorical_columns(df):
return [column for column in df.columns if df.dtypes[column] == 'object']
get_uniques(data, get_categorical_columns(data))
{'Category': ['ART_AND_DESIGN',
'AUTO_AND_VEHICLES',
'BEAUTY',
'BOOKS_AND_REFERENCE',
'BUSINESS',
'COMICS',
'COMMUNICATION',
'DATING',
'EDUCATION',
'ENTERTAINMENT',
'EVENTS',
'FINANCE',
'FOOD_AND_DRINK',
'HEALTH_AND_FITNESS',
'HOUSE_AND_HOME',
'LIBRARIES_AND_DEMO',
'LIFESTYLE',
'GAME',
'FAMILY',
'MEDICAL',
'SOCIAL',
'SHOPPING',
'PHOTOGRAPHY',
'SPORTS',
'TRAVEL_AND_LOCAL',
'TOOLS',
'PERSONALIZATION',
'PRODUCTIVITY',
'PARENTING',
'WEATHER',
'VIDEO_PLAYERS',
'NEWS_AND_MAGAZINES',
'MAPS_AND_NAVIGATION',
'1.9'],
'Content Rating': ['Everyone',
'Teen',
'Everyone 10+',
'Mature 17+',
'Adults only 18+',
'Unrated',
nan],
'Installs': ['10,000+',
'500,000+',
'5,000,000+',
'50,000,000+',
'100,000+',
'50,000+',
'1,000,000+',
'10,000,000+',
'5,000+',
'100,000,000+',
'1,000,000,000+',
'1,000+',
'500,000,000+',
'50+',
'100+',
'500+',
'10+',
'1+',
'5+',
'0+',
'0',
'Free'],
'Last Updated': ['January 7, 2018',
'January 15, 2018',
'August 1, 2018',
'June 8, 2018',
'June 20, 2018',
'March 26, 2017',
'April 26, 2018',
'June 14, 2018',
'September 20, 2017',
'July 3, 2018',
'October 27, 2017',
'July 31, 2018',
'April 2, 2018',
'June 26, 2018',
'August 3, 2018',
'June 6, 2018',
'November 7, 2017',
'July 30, 2018',
'April 20, 2018',
'March 20, 2018',
'July 12, 2018',
'March 7, 2018',
'July 7, 2018',
'April 25, 2018',
'October 11, 2017',
'March 21, 2018',
'August 22, 2017',
'May 31, 2018',
'July 19, 2018',
'January 6, 2018',
'April 27, 2018',
'July 11, 2018',
'August 2, 2018',
'July 14, 2018',
'November 29, 2017',
'March 31, 2018',
'July 20, 2018',
'April 15, 2018',
'January 3, 2018',
'November 14, 2017',
'December 17, 2017',
'May 28, 2018',
'May 10, 2018',
'July 26, 2018',
'July 18, 2018',
'July 29, 2018',
'August 26, 2014',
'July 8, 2018',
'July 28, 2018',
'June 12, 2018',
'October 14, 2016',
'May 25, 2018',
'July 16, 2018',
'July 27, 2018',
'July 4, 2018',
'March 27, 2018',
'July 15, 2018',
'July 24, 2018',
'July 23, 2018',
'August 4, 2018',
'May 16, 2018',
'June 2, 2018',
'April 21, 2018',
'November 9, 2017',
'May 15, 2018',
'October 24, 2016',
'February 28, 2018',
'July 25, 2018',
'June 21, 2018',
'June 5, 2018',
'September 12, 2017',
'April 9, 2018',
'March 1, 2018',
'April 5, 2018',
'August 3, 2017',
'May 24, 2018',
'November 21, 2017',
'October 18, 2017',
'May 29, 2018',
'May 14, 2018',
'July 17, 2018',
'July 2, 2018',
'June 7, 2018',
'August 8, 2017',
'December 11, 2017',
'June 1, 2018',
'March 1, 2017',
'January 24, 2018',
'August 7, 2017',
'July 31, 2017',
'July 17, 2015',
'May 18, 2018',
'June 28, 2018',
'January 21, 2018',
'May 27, 2018',
'May 17, 2018',
'July 13, 2018',
'June 25, 2018',
'June 29, 2018',
'November 23, 2017',
'October 16, 2014',
'August 28, 2017',
'August 20, 2016',
'June 16, 2018',
'May 1, 2018',
'June 15, 2018',
'February 15, 2018',
'August 7, 2015',
'May 21, 2018',
'May 4, 2018',
'April 13, 2016',
'July 9, 2018',
'February 8, 2018',
'September 11, 2015',
'July 10, 2018',
'February 26, 2018',
'March 26, 2018',
'January 31, 2018',
'May 30, 2017',
'March 25, 2018',
'April 11, 2017',
'April 18, 2018',
'February 13, 2018',
'March 22, 2018',
'November 16, 2017',
'December 27, 2017',
'March 5, 2018',
'July 6, 2018',
'May 23, 2018',
'December 18, 2017',
'July 5, 2018',
'May 26, 2018',
'July 21, 2018',
'June 19, 2018',
'October 27, 2016',
'June 27, 2018',
'November 4, 2016',
'September 2, 2015',
'April 19, 2018',
'January 23, 2018',
'August 27, 2017',
'April 1, 2016',
'July 10, 2017',
'February 2, 2015',
'March 5, 2017',
'January 5, 2018',
'December 4, 2017',
'June 22, 2018',
'June 7, 2016',
'April 3, 2018',
'July 6, 2014',
'August 9, 2017',
'September 28, 2016',
'October 25, 2017',
'September 1, 2017',
'July 25, 2017',
'January 21, 2017',
'January 27, 2017',
'February 3, 2017',
'February 25, 2016',
'June 13, 2018',
'May 12, 2018',
'January 8, 2017',
'November 6, 2017',
'December 28, 2017',
'January 28, 2017',
'February 1, 2017',
'April 29, 2018',
'March 29, 2018',
'February 16, 2018',
'April 7, 2018',
'June 15, 2017',
'July 22, 2018',
'December 29, 2017',
'May 2, 2018',
'February 25, 2018',
'March 23, 2018',
'February 3, 2018',
'January 19, 2017',
'October 26, 2017',
'October 17, 2017',
'October 23, 2016',
'March 9, 2018',
'November 28, 2017',
'September 28, 2017',
'January 16, 2017',
'August 17, 2017',
'July 4, 2016',
'August 21, 2014',
'August 22, 2015',
'June 28, 2015',
'December 25, 2017',
'May 20, 2018',
'July 11, 2014',
'April 29, 2015',
'December 2, 2013',
'July 23, 2015',
'November 17, 2016',
'June 18, 2018',
'February 15, 2017',
'November 11, 2017',
'June 1, 2016',
'May 4, 2016',
'June 13, 2017',
'September 20, 2016',
'December 20, 2016',
'January 11, 2015',
'October 1, 2017',
'July 29, 2016',
'October 16, 2017',
'December 24, 2017',
'July 24, 2017',
'July 21, 2017',
'January 20, 2018',
'April 28, 2016',
'July 16, 2015',
'September 14, 2016',
'February 14, 2018',
'February 7, 2018',
'June 11, 2018',
'April 12, 2018',
'January 19, 2018',
'December 14, 2017',
'June 30, 2018',
'July 7, 2017',
'September 15, 2015',
'September 22, 2015',
'November 27, 2017',
'June 23, 2018',
'November 8, 2016',
'October 14, 2017',
'April 27, 2017',
'December 15, 2017',
'May 30, 2018',
'May 3, 2018',
'May 8, 2018',
'June 9, 2018',
'June 7, 2017',
'March 13, 2018',
'May 11, 2018',
'May 9, 2018',
'February 22, 2018',
'October 12, 2016',
'March 28, 2018',
'January 25, 2018',
'June 10, 2018',
'June 24, 2018',
'February 17, 2017',
'April 10, 2018',
'June 3, 2018',
'May 22, 2018',
'August 12, 2017',
'January 10, 2017',
'October 16, 2016',
'December 22, 2015',
'February 9, 2017',
'July 28, 2016',
'January 17, 2018',
'June 19, 2012',
'August 5, 2018',
'March 30, 2018',
'February 10, 2018',
'July 17, 2017',
'August 27, 2016',
'August 23, 2017',
'January 29, 2018',
'July 23, 2014',
'July 16, 2017',
'March 11, 2017',
'February 22, 2017',
'February 18, 2018',
'March 2, 2016',
'September 19, 2017',
'August 21, 2017',
'March 13, 2015',
'April 7, 2015',
'March 17, 2015',
'May 30, 2015',
'March 6, 2015',
'March 12, 2015',
'March 11, 2015',
'August 30, 2017',
'April 23, 2018',
'October 15, 2015',
'February 20, 2018',
'January 16, 2018',
'March 6, 2013',
'January 17, 2012',
'June 10, 2017',
'September 27, 2017',
'March 8, 2018',
'January 2, 2017',
'March 14, 2016',
'November 5, 2017',
'February 23, 2018',
'November 7, 2016',
'June 29, 2011',
'September 21, 2015',
'February 12, 2013',
'January 9, 2018',
'July 1, 2018',
'December 20, 2017',
'November 3, 2016',
'June 30, 2016',
'September 24, 2015',
'December 17, 2016',
'February 21, 2018',
'September 27, 2016',
'January 11, 2018',
'May 7, 2018',
'August 2, 2017',
'August 29, 2017',
'June 5, 2017',
'January 26, 2017',
'April 30, 2014',
'June 18, 2017',
'October 12, 2017',
'August 28, 2015',
'July 18, 2017',
'February 27, 2016',
'June 23, 2017',
'March 8, 2017',
'April 17, 2018',
'March 6, 2018',
'April 13, 2018',
'April 11, 2018',
'December 22, 2017',
'February 27, 2018',
'December 21, 2017',
'October 19, 2015',
'November 30, 2017',
'April 12, 2017',
'June 28, 2017',
'March 14, 2017',
'October 15, 2017',
'July 28, 2017',
'March 16, 2018',
'August 6, 2018',
'June 4, 2018',
'November 22, 2016',
'February 1, 2018',
'June 29, 2017',
'July 14, 2017',
'October 6, 2017',
'July 12, 2017',
'August 31, 2017',
'November 22, 2017',
'March 7, 2017',
'October 4, 2017',
'July 22, 2016',
'May 18, 2017',
'February 2, 2018',
'February 18, 2016',
'March 15, 2017',
'March 5, 2016',
'February 2, 2016',
'January 13, 2017',
'July 13, 2017',
'December 1, 2015',
'June 17, 2015',
'March 23, 2017',
'July 3, 2017',
'September 8, 2016',
'September 3, 2015',
'November 14, 2014',
'December 13, 2017',
'August 2, 2016',
'February 9, 2016',
'August 12, 2015',
'August 24, 2015',
'June 16, 2016',
'May 22, 2013',
'August 4, 2017',
'October 28, 2016',
'December 9, 2014',
'December 9, 2017',
'December 30, 2016',
'February 5, 2016',
'April 14, 2016',
'February 11, 2016',
'November 30, 2014',
'April 6, 2018',
'October 3, 2016',
'June 17, 2017',
'September 21, 2017',
'November 15, 2017',
'August 7, 2014',
'December 6, 2017',
'December 3, 2014',
'April 18, 2017',
'January 24, 2016',
'October 22, 2014',
'November 22, 2012',
'August 18, 2015',
'December 16, 2015',
'November 5, 2013',
'May 26, 2015',
'March 14, 2018',
'August 5, 2017',
'August 11, 2017',
'December 8, 2016',
'August 3, 2015',
'October 5, 2017',
'June 11, 2016',
'August 2, 2014',
'September 14, 2017',
'September 6, 2014',
'January 2, 2018',
'July 26, 2013',
'March 2, 2017',
'October 3, 2017',
'May 6, 2015',
'January 14, 2018',
'May 9, 2017',
'October 2, 2017',
'October 10, 2017',
'October 13, 2016',
'October 17, 2016',
'December 8, 2017',
'March 24, 2018',
'October 22, 2013',
'September 6, 2016',
'December 23, 2017',
'April 4, 2018',
'June 1, 2017',
'April 24, 2018',
'September 26, 2017',
'January 18, 2015',
'March 14, 2015',
'May 10, 2015',
'February 25, 2017',
'April 16, 2018',
'September 12, 2016',
'November 20, 2017',
'October 25, 2016',
'January 20, 2015',
'January 30, 2018',
'June 8, 2016',
'February 29, 2016',
'December 5, 2017',
'July 25, 2015',
'December 1, 2017',
'March 5, 2015',
'January 22, 2018',
'February 6, 2018',
'July 29, 2015',
'November 8, 2017',
'November 2, 2016',
'January 25, 2016',
'July 29, 2017',
'August 11, 2015',
'November 10, 2017',
'March 25, 2016',
'May 5, 2018',
'February 10, 2015',
'March 3, 2017',
'February 11, 2015',
'October 19, 2016',
'October 17, 2015',
'April 6, 2017',
'February 11, 2018',
'November 6, 2014',
'March 21, 2017',
'July 18, 2016',
'September 8, 2017',
'January 7, 2016',
'March 16, 2017',
'August 23, 2016',
'December 5, 2016',
'December 6, 2016',
'July 14, 2016',
'March 21, 2016',
'July 5, 2016',
'November 13, 2017',
'July 14, 2015',
'August 10, 2016',
'November 21, 2014',
'January 17, 2016',
'July 27, 2016',
'November 13, 2014',
'March 27, 2017',
'January 3, 2017',
'May 12, 2017',
'April 22, 2014',
'July 11, 2017',
'November 18, 2017',
'August 10, 2015',
'September 17, 2017',
'February 5, 2018',
'April 28, 2017',
'August 7, 2018',
'September 5, 2016',
'May 12, 2016',
'March 18, 2018',
'April 25, 2014',
'December 2, 2017',
'September 25, 2017',
'March 9, 2017',
'December 10, 2017',
'January 22, 2017',
'November 1, 2016',
'August 24, 2016',
'October 20, 2016',
'December 7, 2016',
'May 11, 2016',
'April 4, 2014',
'January 7, 2015',
'March 17, 2018',
'December 24, 2016',
'May 1, 2014',
'November 28, 2016',
'June 24, 2014',
'October 29, 2017',
'May 27, 2016',
'October 9, 2017',
'August 10, 2017',
'April 22, 2016',
'April 14, 2017',
'March 15, 2018',
'August 7, 2016',
'December 11, 2016',
'December 19, 2015',
'October 30, 2017',
'September 30, 2013',
'November 12, 2017',
'October 18, 2016',
'December 25, 2016',
'May 19, 2018',
'April 25, 2016',
'August 8, 2016',
'January 8, 2018',
'November 1, 2017',
'January 9, 2017',
'August 18, 2016',
'December 30, 2017',
'January 7, 2017',
'April 1, 2018',
'March 19, 2018',
'October 31, 2017',
'November 19, 2017',
'December 3, 2015',
'February 13, 2015',
'February 3, 2015',
'June 3, 2016',
'October 30, 2014',
'January 13, 2018',
'March 11, 2016',
'May 25, 2017',
'August 9, 2016',
'February 19, 2018',
'November 2, 2017',
'December 4, 2016',
'August 26, 2016',
'January 5, 2017',
'April 22, 2018',
'June 16, 2017',
'May 13, 2018',
'September 13, 2017',
'September 12, 2014',
'November 24, 2017',
'June 11, 2015',
'April 12, 2016',
'May 19, 2017',
'May 4, 2015',
'August 19, 2017',
'December 22, 2016',
'October 22, 2016',
'August 16, 2015',
'September 2, 2017',
'March 31, 2016',
'June 20, 2017',
'August 26, 2017',
'July 31, 2014',
'May 13, 2017',
'June 24, 2017',
'December 16, 2017',
'April 4, 2016',
'September 26, 2015',
'January 20, 2016',
'June 3, 2017',
'August 31, 2016',
'September 22, 2017',
'May 16, 2014',
'March 2, 2018',
'January 18, 2018',
'November 26, 2015',
'May 3, 2017',
'October 23, 2017',
'October 6, 2016',
'February 21, 2017',
'August 5, 2015',
'December 26, 2017',
'July 24, 2016',
'October 7, 2016',
'December 15, 2016',
'January 28, 2014',
'April 21, 2017',
'March 15, 2016',
'July 19, 2016',
'July 12, 2016',
'December 7, 2017',
'January 25, 2017',
'September 8, 2013',
'September 1, 2015',
'September 26, 2016',
'April 10, 2013',
'October 21, 2017',
'December 7, 2015',
'January 1, 2016',
'September 30, 2017',
'April 7, 2016',
'November 3, 2017',
'February 8, 2017',
'December 14, 2015',
'May 19, 2015',
'November 20, 2015',
'February 4, 2018',
'September 10, 2017',
'January 4, 2016',
'December 19, 2017',
'January 1, 2018',
'September 7, 2017',
'November 16, 2016',
'October 22, 2017',
'April 30, 2018',
'October 20, 2017',
'December 12, 2017',
'March 12, 2018',
'May 14, 2014',
'October 17, 2014',
'July 23, 2016',
'June 17, 2018',
'May 8, 2017',
'January 13, 2014',
'May 1, 2016',
'April 21, 2016',
'January 11, 2017',
'November 17, 2017',
'August 22, 2013',
'April 4, 2017',
'June 6, 2016',
'September 7, 2015',
'April 2, 2016',
'February 12, 2017',
'December 4, 2015',
'March 11, 2018',
'March 20, 2017',
'July 9, 2017',
'January 12, 2018',
'May 17, 2017',
'July 15, 2016',
'February 9, 2018',
'March 28, 2017',
'May 25, 2015',
'July 1, 2015',
'March 6, 2017',
'February 15, 2016',
'December 26, 2014',
'May 31, 2017',
'August 20, 2017',
'December 3, 2011',
'April 25, 2017',
'September 14, 2015',
'May 6, 2018',
'April 14, 2018',
'February 12, 2018',
'March 16, 2015',
'August 4, 2016',
'April 1, 2017',
'May 16, 2017',
'March 4, 2017',
'July 12, 2014',
'March 16, 2016',
'December 3, 2017',
'December 8, 2015',
'May 15, 2017',
'February 21, 2014',
'May 14, 2017',
'September 24, 2017',
'September 16, 2014',
'June 20, 2016',
'April 28, 2018',
'May 29, 2017',
'August 7, 2013',
'February 27, 2017',
'July 8, 2016',
'January 31, 2017',
'September 19, 2012',
'February 12, 2016',
'August 14, 2017',
'November 15, 2014',
'April 3, 2017',
'October 24, 2017',
'April 20, 2016',
'August 25, 2015',
'February 24, 2016',
'August 19, 2014',
'November 8, 2012',
'September 27, 2013',
'September 29, 2016',
'May 14, 2013',
'April 8, 2018',
'June 25, 2017',
'March 3, 2018',
'September 11, 2017',
'February 5, 2014',
'October 7, 2017',
'January 28, 2018',
'February 24, 2018',
'January 23, 2017',
'September 20, 2014',
'June 22, 2017',
'November 19, 2016',
'September 3, 2017',
'January 4, 2017',
'April 11, 2014',
'February 26, 2014',
'December 31, 2017',
'January 25, 2015',
'October 19, 2017',
'March 4, 2018',
'November 13, 2015',
'July 28, 2015',
'August 1, 2017',
'November 5, 2014',
'July 31, 2016',
'June 30, 2017',
'April 8, 2016',
'March 13, 2017',
'July 10, 2014',
'July 10, 2015',
'November 3, 2015',
'June 15, 2016',
'June 21, 2016',
'February 23, 2017',
'February 2, 2017',
'September 15, 2016',
'December 31, 2016',
'October 8, 2012',
'July 9, 2014',
'November 23, 2016',
'July 19, 2017',
'December 11, 2015',
'July 30, 2016',
'January 8, 2015',
'June 2, 2017',
'November 27, 2015',
'June 8, 2017',
'October 28, 2014',
'July 30, 2015',
'December 28, 2015',
'July 28, 2014',
'August 20, 2015',
'December 17, 2013',
'May 7, 2016',
'May 3, 2014',
'September 25, 2013',
'December 21, 2016',
'July 26, 2016',
'September 17, 2015',
'April 25, 2013',
'May 26, 2014',
'August 9, 2014',
'November 20, 2013',
'September 30, 2016',
'March 23, 2016',
'January 19, 2014',
'December 31, 2015',
'January 4, 2018',
'December 13, 2013',
'November 12, 2013',
'June 27, 2017',
'December 31, 2014',
'January 24, 2014',
'January 1, 2015',
'October 9, 2015',
'December 10, 2015',
'June 15, 2015',
'August 1, 2013',
'October 26, 2016',
'December 9, 2016',
'January 25, 2013',
'December 19, 2013',
'June 29, 2016',
'November 28, 2012',
'May 1, 2017',
'May 2, 2017',
'November 20, 2014',
'March 20, 2015',
'March 31, 2017',
'June 9, 2017',
'May 23, 2017',
'May 5, 2017',
'June 26, 2017',
'April 30, 2017',
'October 28, 2017',
'May 12, 2011',
'June 21, 2017',
'October 1, 2013',
'May 11, 2017',
'January 10, 2018',
'April 22, 2017',
'May 26, 2017',
'November 4, 2017',
'June 3, 2015',
'September 25, 2015',
'February 18, 2013',
'March 7, 2016',
'May 4, 2017',
'January 27, 2018',
'June 13, 2016',
'March 24, 2017',
'June 4, 2013',
'August 15, 2016',
'September 29, 2017',
'March 17, 2017',
'September 7, 2016',
'November 11, 2016',
'February 26, 2017',
'April 26, 2015',
'March 1, 2016',
'March 10, 2018',
'May 2, 2015',
'September 11, 2013',
'February 15, 2015',
'March 25, 2017',
'June 24, 2015',
'February 17, 2018',
'October 8, 2016',
'April 5, 2017',
'March 10, 2016',
'April 10, 2015',
'October 21, 2016',
'May 10, 2017',
'February 23, 2016',
'March 11, 2014',
'December 23, 2016',
'June 2, 2016',
'March 8, 2016',
'May 14, 2015',
'August 30, 2015',
'August 12, 2014',
'March 22, 2016',
'November 1, 2013',
'August 14, 2016',
'August 31, 2013',
'July 19, 2015',
'July 30, 2017',
'January 19, 2016',
'November 4, 2015',
'August 15, 2017',
'October 14, 2015',
'June 22, 2016',
'February 23, 2014',
'September 22, 2011',
'January 23, 2016',
'May 24, 2017',
'September 30, 2014',
'December 26, 2016',
'July 18, 2013',
'December 3, 2016',
'July 26, 2015',
'April 2, 2015',
'June 6, 2017',
'November 26, 2017',
'December 2, 2014',
'May 22, 2017',
'January 26, 2018',
'May 14, 2016',
'July 1, 2016',
'September 18, 2017',
'September 5, 2017',
'August 3, 2016',
'April 8, 2017',
'September 22, 2016',
'March 6, 2014',
'September 19, 2013',
'August 4, 2014',
'May 17, 2016',
'July 6, 2017',
'September 15, 2017',
'September 4, 2013',
'June 6, 2015',
'July 15, 2015',
'October 20, 2015',
'February 14, 2017',
'February 8, 2016',
'October 12, 2015',
'October 26, 2015',
'July 4, 2017',
'November 11, 2015',
'October 2, 2014',
'July 8, 2017',
'December 19, 2016',
'November 26, 2012',
'November 25, 2017',
'February 23, 2015',
'August 18, 2017',
'December 1, 2016',
'February 16, 2017',
'August 31, 2015',
'July 6, 2015',
'October 27, 2015',
'June 13, 2014',
'July 21, 2016',
'December 21, 2015',
'August 5, 2016',
'October 5, 2016',
'April 11, 2016',
'April 17, 2014',
'February 18, 2017',
'August 13, 2015',
'March 28, 2016',
'December 14, 2016',
'November 16, 2015',
'July 2, 2017',
'August 13, 2016',
'May 30, 2016',
'September 23, 2015',
'September 29, 2015',
'November 2, 2015',
'April 15, 2016',
'February 18, 2015',
'August 15, 2013',
'October 5, 2015',
'October 8, 2015',
'February 19, 2016',
'April 9, 2012',
'January 19, 2015',
'January 12, 2016',
'May 16, 2016',
'April 29, 2017',
'December 18, 2015',
'October 7, 2015',
'September 13, 2015',
'July 22, 2017',
'December 12, 2016',
'November 10, 2016',
'May 26, 2016',
'January 27, 2016',
'January 16, 2016',
'January 29, 2016',
'November 12, 2014',
'September 4, 2017',
'June 18, 2015',
'March 31, 2015',
'June 9, 2015',
'February 22, 2016',
'October 4, 2015',
'August 28, 2016',
'July 26, 2017',
'April 23, 2017',
'November 9, 2015',
'June 14, 2015',
'May 25, 2016',
'July 5, 2017',
'November 12, 2015',
'June 12, 2017',
'March 19, 2017',
'October 2, 2015',
'July 11, 2015',
'June 14, 2016',
'September 23, 2017',
'March 29, 2017',
'December 15, 2015',
'November 9, 2016',
'September 17, 2016',
'October 30, 2015',
'November 10, 2014',
'October 13, 2015',
'November 19, 2015',
'August 16, 2016',
'November 29, 2016',
'February 6, 2017',
'November 26, 2014',
'October 3, 2015',
'September 22, 2014',
'May 8, 2015',
'August 12, 2016',
'December 2, 2016',
'July 7, 2016',
'March 30, 2015',
'April 20, 2015',
'January 12, 2017',
'March 20, 2014',
'January 6, 2017',
'May 23, 2016',
'August 8, 2015',
'June 10, 2015',
'July 16, 2016',
'March 22, 2015',
'February 3, 2016',
'February 7, 2016',
'April 14, 2015',
'July 18, 2014',
'June 5, 2014',
'July 1, 2013',
'February 20, 2017',
'May 6, 2013',
'April 24, 2016',
...],
'Price': ['0',
'$4.99',
'$3.99',
'$6.99',
'$1.49',
'$2.99',
'$7.99',
'$5.99',
'$3.49',
'$1.99',
'$9.99',
'$7.49',
'$0.99',
'$9.00',
'$5.49',
'$10.00',
'$24.99',
'$11.99',
'$79.99',
'$16.99',
'$14.99',
'$1.00',
'$29.99',
'$12.99',
'$2.49',
'$10.99',
'$1.50',
'$19.99',
'$15.99',
'$33.99',
'$74.99',
'$39.99',
'$3.95',
'$4.49',
'$1.70',
'$8.99',
'$2.00',
'$3.88',
'$25.99',
'$399.99',
'$17.99',
'$400.00',
'$3.02',
'$1.76',
'$4.84',
'$4.77',
'$1.61',
'$2.50',
'$1.59',
'$6.49',
'$1.29',
'$5.00',
'$13.99',
'$299.99',
'$379.99',
'$37.99',
'$18.99',
'$389.99',
'$19.90',
'$8.49',
'$1.75',
'$14.00',
'$4.85',
'$46.99',
'$109.99',
'$154.99',
'$3.08',
'$2.59',
'$4.80',
'$1.96',
'$19.40',
'$3.90',
'$4.59',
'$15.46',
'$3.04',
'$4.29',
'$2.60',
'$3.28',
'$4.60',
'$28.99',
'$2.95',
'$2.90',
'$1.97',
'$200.00',
'$89.99',
'$2.56',
'$30.99',
'$3.61',
'$394.99',
'$1.26',
'Everyone',
'$1.20',
'$1.04'],
'Reviews': ['159',
'967',
'87510',
'215644',
'167',
'178',
'36815',
'13791',
'121',
'13880',
'8788',
'44829',
'4326',
'1518',
'55',
'3632',
'27',
'194216',
'224399',
'450',
'654',
'7699',
'61',
'118',
'192',
'20260',
'203',
'136',
'223',
'1120',
'227',
'5035',
'1015',
'353',
'564',
'8145',
'36639',
'158',
'591',
'117',
'176',
'295221',
'2206',
'26',
'174531',
'1070',
'85',
'845',
'367',
'1598',
'284',
'17057',
'129',
'542',
'10479',
'805',
'1403',
'3971',
'534',
'7774',
'38846',
'2431',
'6090',
'295',
'190',
'40211',
'356',
'52530',
'116986',
'1379',
'271920',
'736',
'7021',
'197',
'737',
'3574',
'994',
'197136',
'142',
'15168',
'2155',
'138',
'5414',
'21777',
'348',
'250',
'13372',
'7880',
'3617',
'4806',
'65786',
'31433',
'5097',
'1754',
'2680',
'1288',
'18900',
'49790',
'1150',
'1739',
'32090',
'2225',
'4369',
'8572',
'964',
'42050',
'104',
'17934',
'601',
'36',
'187',
'182',
'30',
'134',
'74',
'113715',
'3595',
'9315',
'75',
'38',
'26834',
'119',
'2277',
'2280',
'184',
'9',
'77',
'35',
'364',
'18',
'473',
'66',
'3871',
'257',
'62',
'2914724',
'1857',
'4478',
'577550',
'814080',
'246315',
'454060',
'155446',
'418',
'22486',
'203130',
'1435',
'116507',
'1433233',
'90468',
'860',
'363934',
'87873',
'17506',
'1862',
'2084',
'47303',
'19080',
'161',
'85842',
'7831',
'91615',
'4620',
'21336',
'26875',
'1778',
'2709',
'64513',
'8342',
'527',
'1322',
'1680',
'2739',
'1065',
'233757',
'2',
'51269',
'30105',
'156',
'114',
'341157',
'16129',
'674730',
'1254730',
'85185',
'32584',
'217730',
'70991',
'1002861',
'16589',
'148945',
'4458',
'62272',
'8941',
'46353',
'1279184',
'88073',
'67000',
'159872',
'30847',
'188841',
'11622',
'95912',
'4034',
'45964',
'14955',
'6903',
'31614',
'23055',
'19023',
'207372',
'1225',
'380837',
'10600',
'74359',
'822',
'80805',
'2287',
'4162',
'14760',
'23243',
'8978',
'42492',
'286897',
'103755',
'46505',
'11442',
'10295',
'296',
'29313',
'51507',
'1802',
'1383',
'23175',
'5868',
'2111',
'5448',
'4159',
'20815',
'78662',
'7149',
'3079',
'5800',
'6989',
'16422',
'108741',
'624',
'1661',
'97702',
'308',
'5211',
'1058',
'78172',
'80804',
'1002859',
'51510',
'413',
'1013635',
'24005',
'57106',
'2249',
'516',
'834',
'1010',
'238970',
'302',
'438',
'73',
'39',
'144',
'2181',
'93965',
'1446',
'12088',
'314',
'25671',
'15194',
'22551',
'29839',
'279',
'564387',
'1330',
'1677',
'757',
'115',
'125',
'9952',
'18814',
'21',
'15',
'51981',
'3596',
'1006',
'5968',
'4895',
'56642847',
'69119316',
'125257',
'9642995',
'1429035',
'4604324',
'3419249',
'11334799',
'158679',
'3075028',
'4187998',
'659395',
'4785892',
'66602',
'30209',
'36901',
'5149854',
'192948',
'99559',
'437674',
'13698',
'2473509',
'20769',
'36880',
'171031',
'63543',
'45487',
'615381',
'2451083',
'33053',
'5387333',
'3648120',
'136662',
'42370',
'781810',
'3128250',
'2083237',
'541389',
'46702',
'2939',
'13761',
'258556',
'40751',
'17712922',
'25021',
'27187',
'56646578',
'4785988',
'122498',
'11334973',
'3419433',
'132014',
'83239',
'594728',
'5387446',
'10484169',
'3128509',
'2451093',
'2876500',
'28238',
'335646',
'350154',
'349384',
'346982',
'244863',
'10790289',
'330761',
'37320',
'12842860',
'2546527',
'36893',
'15880',
'346980',
'9643041',
'3075118',
'2264916',
'2473693',
'42925',
'5150471',
'2511130',
'3648480',
'17714850',
'13100',
'27156',
'55098',
'1133501',
'12578',
'10965',
'18247',
'190613',
'125232',
'72065',
'27540',
'104990',
'177703',
'17529',
'177263',
'237468',
'32254',
'483565',
'552441',
'60308',
'457283',
'93825',
'32283',
'15287',
'205739',
'14873',
'7820209',
'9498',
'4604483',
'4188142',
'88427',
'305218',
'183374',
'20901',
'122595',
'124346',
'837842',
'255',
'41420',
'44706',
'23707',
'3419513',
'11335255',
'29208',
'191032',
'1545',
'57',
'0',
'4',
'516801',
'285726',
'76646',
'2556',
'7779',
'61637',
'12632',
'313724',
'48845',
'305708',
'31320',
'172460',
'4195',
'11633',
'10212',
'37053',
'667',
'13202',
'28671',
'1157',
'212626',
'222888',
'2067',
'1643',
'105',
'3414',
'42194',
'11806',
'1999',
'22544',
'97684',
'2519',
'1146',
'13046',
'17268',
'8722',
'953',
'2593',
'5377',
'852',
'212',
'1972',
'35206',
'5164',
'1939',
'277',
'80',
'825',
'40035',
'1093',
'135418',
'1601',
'2212',
'57081',
'241',
'63986',
'7888',
'535',
'5084',
'2430',
'837',
'738',
'4631',
'4953',
'1439',
'1645',
'13204',
'853',
'337',
'13049',
'51698',
'923',
'1546',
'149',
'198',
'135420',
'22545',
'8723',
'23170',
'13890',
'57083',
'537',
'13440',
'143',
'1059',
'894',
'6191',
'15081',
'218',
'35205',
'243950',
'236',
'5152',
'1576',
'6701',
'40039',
'742',
'2506',
'182986',
'8661',
'8',
'59',
'28',
'185',
'6',
'110',
'3',
'5',
'84',
'20',
'776',
'1',
'14',
'24',
'23',
'11',
'101',
'120',
'4954',
'954',
'2560',
'42197',
'5168',
'12633',
'41605',
'2433',
'791',
'5323',
'478',
'69',
'53',
'97699',
'6289924',
'181893',
'2544',
'85375',
'314299',
'9770',
'32346',
'4075',
'10611',
'9321',
'56065',
'14286',
'133136',
'2469',
'36212',
'390',
'1090',
'266948',
'342918',
'748',
'172640',
'1619',
'3168',
'29855',
'6736',
'7005',
'889',
'5741',
'27572',
'10852',
'9888',
'1929',
'1516',
'215301',
'423',
'254519',
'1107903',
'211856',
'99020',
'90481',
'32381',
'248912',
'248555',
'272145',
'56897',
'8599',
'41185',
'29980',
'304',
'358',
'11904',
'22251',
'22384',
'73404',
'12733',
'25183',
'52743',
'61749',
'55704',
'19277',
'13612',
'37862',
'18372',
'656',
'240',
'275',
'3692',
'2363',
'1769',
'430',
'756',
'3963',
'316',
'642',
'6290507',
'32380',
'172505',
'69493',
'1107884',
'7973',
'266935',
'5695',
'142632',
'55256',
'172508',
'54798',
'4815',
'75112',
'33646',
'314300',
'206527',
'9348',
'3816',
'47847',
'16195',
'206',
'28392',
'3241',
'835',
'2525',
'828',
'200058',
'1239',
'702',
'108613',
'69498',
'148550',
'3847',
'84309',
'1107948',
'14206',
'206532',
'14700',
'42828',
'40209',
'1405',
'148549',
'84311',
'256079',
'2078',
'16103',
'31085',
'3528',
'5456208',
'11656',
'28948',
'296771',
'470089',
'10939',
'98509',
'5241',
'22508',
'10291',
'7165362',
'4885646',
'141980',
'6979',
'46618',
'103078',
'17682',
'37000',
'175528',
'1828284',
'34923',
'684116',
'46916',
'407698',
'702975',
'32458',
'235496',
'11661',
'653008',
'23063',
'87384',
'411683',
'8918',
'501498',
'2133296',
'29690',
'130549',
'613059',
'1633682',
'2646',
'21867',
'32732',
'243747',
'2639',
'1511',
'44550',
'501497',
'7813',
'1033',
'2442',
'15254',
'155234',
'310066',
'12216',
'388089',
'92058',
'88185',
'493',
'33387',
'123279',
'27424',
'60841',
'29706',
'288150',
'14807',
'319692',
'61201',
'22998',
'12398',
'35928',
'64448',
'22378',
'5456599',
'296829',
'310095',
'319691',
'16372',
'58028',
'736864',
'1968',
'35279',
'35931',
'17247',
'87723',
'18523',
'182103',
'197774',
'8674',
'5456708',
'58082',
'407719',
'115033',
'22997',
'801',
'8968',
'303',
'732',
'1856',
'50725',
'1575',
'6238',
'9941',
'23666',
'67554',
'38769',
'160164',
'3771',
'256664',
'787177',
'3782',
'40113',
'7074',
'2153',
'26089',
'20611',
'811',
'15558',
'573',
'37',
'8232',
'3089',
'3874',
'464',
'731',
'8800',
'99',
'456',
'3200',
'5839',
'663',
'16',
'13',
'46',
'1953',
'12',
'4298',
'49',
'100',
'399',
'7',
'124424',
'39041',
'52306',
'36718',
'42644',
'278082',
'6076',
'112656',
'335738',
'31906',
'20672',
'957973',
'130582',
'31218',
'167168',
'34428',
'15247',
'48445',
'35518',
'12185',
'36746',
'21996',
'138371',
'12073',
'111632',
'250706',
'706301',
'64959',
'659741',
'510392',
'7215',
'25508',
'60449',
'381788',
'10697',
'347838',
'31804',
'3856',
'199684',
'44545',
'1336246',
'57493',
'283',
'12304',
'8188',
'11919',
'45957',
'126431',
'21570',
'134564',
'16961',
'111254',
'7731',
'5928',
'15703',
'6148',
'861',
'8662',
'23130',
'69973',
'1311',
'26587',
'2417',
'706302',
'1054',
'25166',
'129304',
'19870',
'161440',
'7514',
'46106',
'15141',
'714',
'42410',
'260547',
'4344',
'22808',
'42809',
'16808',
'157505',
'24647',
'1922',
'3334',
'10658',
'78361',
'2594',
'13868',
'135952',
'11066',
'45962',
'34861',
'37580',
'281485',
'685',
'126447',
'3780',
'15192',
'5950',
'15993',
'5905',
'659760',
'14627',
'1098',
'2898',
'70782',
'11264',
'100997',
'347874',
'3290',
'341090',
'87951',
'250719',
'510401',
'24729',
'78306',
'43313',
'1374549',
'208463',
'6998',
'145323',
'95',
'64784',
'32997',
'82',
'2707',
'129737',
'611136',
'6118',
'2473',
'109784',
'3320',
'68103',
'8412',
'10741',
'3803',
'155944',
'10159',
'28008',
'43614',
'455377',
'1398',
'1032935',
'32405',
'151080',
'22513',
'90042',
'58316',
'8509',
'19314',
'21314',
'30224',
'454',
'14952',
'1250',
'1726',
'14065',
'556',
'4925',
'6507',
'11707',
'1077',
'46539',
'9066',
'1962',
'22071',
'196',
'278',
'61881',
'2129',
'1268',
'91359',
'22015',
'131569',
'31986',
'22875',
'17071',
'90242',
'483960',
'511228',
...],
'Size': ['19M',
'14M',
'8.7M',
'25M',
'2.8M',
'5.6M',
'29M',
'33M',
'3.1M',
'28M',
'12M',
'20M',
'21M',
'37M',
'2.7M',
'5.5M',
'17M',
'39M',
'31M',
'4.2M',
'7.0M',
'23M',
'6.0M',
'6.1M',
'4.6M',
'9.2M',
'5.2M',
'11M',
'24M',
'Varies with device',
'9.4M',
'15M',
'10M',
'1.2M',
'26M',
'8.0M',
'7.9M',
'56M',
'57M',
'35M',
'54M',
'201k',
'3.6M',
'5.7M',
'8.6M',
'2.4M',
'27M',
'2.5M',
'16M',
'3.4M',
'8.9M',
'3.9M',
'2.9M',
'38M',
'32M',
'5.4M',
'18M',
'1.1M',
'2.2M',
'4.5M',
'9.8M',
'52M',
'9.0M',
'6.7M',
'30M',
'2.6M',
'7.1M',
'3.7M',
'22M',
'7.4M',
'6.4M',
'3.2M',
'8.2M',
'9.9M',
'4.9M',
'9.5M',
'5.0M',
'5.9M',
'13M',
'73M',
'6.8M',
'3.5M',
'4.0M',
'2.3M',
'7.2M',
'2.1M',
'42M',
'7.3M',
'9.1M',
'55M',
'23k',
'6.5M',
'1.5M',
'7.5M',
'51M',
'41M',
'48M',
'8.5M',
'46M',
'8.3M',
'4.3M',
'4.7M',
'3.3M',
'40M',
'7.8M',
'8.8M',
'6.6M',
'5.1M',
'61M',
'66M',
'79k',
'8.4M',
'118k',
'44M',
'695k',
'1.6M',
'6.2M',
'18k',
'53M',
'1.4M',
'3.0M',
'5.8M',
'3.8M',
'9.6M',
'45M',
'63M',
'49M',
'77M',
'4.4M',
'4.8M',
'70M',
'6.9M',
'9.3M',
'10.0M',
'8.1M',
'36M',
'84M',
'97M',
'2.0M',
'1.9M',
'1.8M',
'5.3M',
'47M',
'556k',
'526k',
'76M',
'7.6M',
'59M',
'9.7M',
'78M',
'72M',
'43M',
'7.7M',
'6.3M',
'334k',
'34M',
'93M',
'65M',
'79M',
'100M',
'58M',
'50M',
'68M',
'64M',
'67M',
'60M',
'94M',
'232k',
'99M',
'624k',
'95M',
'8.5k',
'41k',
'292k',
'11k',
'80M',
'1.7M',
'74M',
'62M',
'69M',
'75M',
'98M',
'85M',
'82M',
'96M',
'87M',
'71M',
'86M',
'91M',
'81M',
'92M',
'83M',
'88M',
'704k',
'862k',
'899k',
'378k',
'266k',
'375k',
'1.3M',
'975k',
'980k',
'4.1M',
'89M',
'696k',
'544k',
'525k',
'920k',
'779k',
'853k',
'720k',
'713k',
'772k',
'318k',
'58k',
'241k',
'196k',
'857k',
'51k',
'953k',
'865k',
'251k',
'930k',
'540k',
'313k',
'746k',
'203k',
'26k',
'314k',
'239k',
'371k',
'220k',
'730k',
'756k',
'91k',
'293k',
'17k',
'74k',
'14k',
'317k',
'78k',
'924k',
'902k',
'818k',
'81k',
'939k',
'169k',
'45k',
'475k',
'965k',
'90M',
'545k',
'61k',
'283k',
'655k',
'714k',
'93k',
'872k',
'121k',
'322k',
'1.0M',
'976k',
'172k',
'238k',
'549k',
'206k',
'954k',
'444k',
'717k',
'210k',
'609k',
'308k',
'705k',
'306k',
'904k',
'473k',
'175k',
'350k',
'383k',
'454k',
'421k',
'70k',
'812k',
'442k',
'842k',
'417k',
'412k',
'459k',
'478k',
'335k',
'782k',
'721k',
'430k',
'429k',
'192k',
'200k',
'460k',
'728k',
'496k',
'816k',
'414k',
'506k',
'887k',
'613k',
'243k',
'569k',
'778k',
'683k',
'592k',
'319k',
'186k',
'840k',
'647k',
'191k',
'373k',
'437k',
'598k',
'716k',
'585k',
'982k',
'222k',
'219k',
'55k',
'948k',
'323k',
'691k',
'511k',
'951k',
'963k',
'25k',
'554k',
'351k',
'27k',
'82k',
'208k',
'913k',
'514k',
'551k',
'29k',
'103k',
'898k',
'743k',
'116k',
'153k',
'209k',
'353k',
'499k',
'173k',
'597k',
'809k',
'122k',
'411k',
'400k',
'801k',
'787k',
'237k',
'50k',
'643k',
'986k',
'97k',
'516k',
'837k',
'780k',
'961k',
'269k',
'20k',
'498k',
'600k',
'749k',
'642k',
'881k',
'72k',
'656k',
'601k',
'221k',
'228k',
'108k',
'940k',
'176k',
'33k',
'663k',
'34k',
'942k',
'259k',
'164k',
'458k',
'245k',
'629k',
'28k',
'288k',
'775k',
'785k',
'636k',
'916k',
'994k',
'309k',
'485k',
'914k',
'903k',
'608k',
'500k',
'54k',
'562k',
'847k',
'957k',
'688k',
'811k',
'270k',
'48k',
'329k',
'523k',
'921k',
'874k',
'981k',
'784k',
'280k',
'24k',
'518k',
'754k',
'892k',
'154k',
'860k',
'364k',
'387k',
'626k',
'161k',
'879k',
'39k',
'970k',
'170k',
'141k',
'160k',
'144k',
'143k',
'190k',
'376k',
'193k',
'246k',
'73k',
'658k',
'992k',
'253k',
'420k',
'404k',
'1,000+',
'470k',
'226k',
'240k',
'89k',
'234k',
'257k',
'861k',
'467k',
'157k',
'44k',
'676k',
'67k',
'552k',
'885k',
'1020k',
'582k',
'619k'],
'Type': ['Free', 'Paid', nan, '0']}
data[data['Category'] == '1.9']
| Category | Rating | Reviews | Size | Installs | Type | Price | Content Rating | Last Updated | |
|---|---|---|---|---|---|---|---|---|---|
| 10472 | 1.9 | 19.0 | 3.0M | 1,000+ | Free | 0 | Everyone | NaN | 1.0.19 |
data = data.drop(10472, axis=0).reset_index(drop=True)
get_uniques(data, get_categorical_columns(data))
{'Category': ['ART_AND_DESIGN',
'AUTO_AND_VEHICLES',
'BEAUTY',
'BOOKS_AND_REFERENCE',
'BUSINESS',
'COMICS',
'COMMUNICATION',
'DATING',
'EDUCATION',
'ENTERTAINMENT',
'EVENTS',
'FINANCE',
'FOOD_AND_DRINK',
'HEALTH_AND_FITNESS',
'HOUSE_AND_HOME',
'LIBRARIES_AND_DEMO',
'LIFESTYLE',
'GAME',
'FAMILY',
'MEDICAL',
'SOCIAL',
'SHOPPING',
'PHOTOGRAPHY',
'SPORTS',
'TRAVEL_AND_LOCAL',
'TOOLS',
'PERSONALIZATION',
'PRODUCTIVITY',
'PARENTING',
'WEATHER',
'VIDEO_PLAYERS',
'NEWS_AND_MAGAZINES',
'MAPS_AND_NAVIGATION'],
'Content Rating': ['Everyone',
'Teen',
'Everyone 10+',
'Mature 17+',
'Adults only 18+',
'Unrated'],
'Installs': ['10,000+',
'500,000+',
'5,000,000+',
'50,000,000+',
'100,000+',
'50,000+',
'1,000,000+',
'10,000,000+',
'5,000+',
'100,000,000+',
'1,000,000,000+',
'1,000+',
'500,000,000+',
'50+',
'100+',
'500+',
'10+',
'1+',
'5+',
'0+',
'0'],
'Last Updated': ['January 7, 2018',
'January 15, 2018',
'August 1, 2018',
'June 8, 2018',
'June 20, 2018',
'March 26, 2017',
'April 26, 2018',
'June 14, 2018',
'September 20, 2017',
'July 3, 2018',
'October 27, 2017',
'July 31, 2018',
'April 2, 2018',
'June 26, 2018',
'August 3, 2018',
'June 6, 2018',
'November 7, 2017',
'July 30, 2018',
'April 20, 2018',
'March 20, 2018',
'July 12, 2018',
'March 7, 2018',
'July 7, 2018',
'April 25, 2018',
'October 11, 2017',
'March 21, 2018',
'August 22, 2017',
'May 31, 2018',
'July 19, 2018',
'January 6, 2018',
'April 27, 2018',
'July 11, 2018',
'August 2, 2018',
'July 14, 2018',
'November 29, 2017',
'March 31, 2018',
'July 20, 2018',
'April 15, 2018',
'January 3, 2018',
'November 14, 2017',
'December 17, 2017',
'May 28, 2018',
'May 10, 2018',
'July 26, 2018',
'July 18, 2018',
'July 29, 2018',
'August 26, 2014',
'July 8, 2018',
'July 28, 2018',
'June 12, 2018',
'October 14, 2016',
'May 25, 2018',
'July 16, 2018',
'July 27, 2018',
'July 4, 2018',
'March 27, 2018',
'July 15, 2018',
'July 24, 2018',
'July 23, 2018',
'August 4, 2018',
'May 16, 2018',
'June 2, 2018',
'April 21, 2018',
'November 9, 2017',
'May 15, 2018',
'October 24, 2016',
'February 28, 2018',
'July 25, 2018',
'June 21, 2018',
'June 5, 2018',
'September 12, 2017',
'April 9, 2018',
'March 1, 2018',
'April 5, 2018',
'August 3, 2017',
'May 24, 2018',
'November 21, 2017',
'October 18, 2017',
'May 29, 2018',
'May 14, 2018',
'July 17, 2018',
'July 2, 2018',
'June 7, 2018',
'August 8, 2017',
'December 11, 2017',
'June 1, 2018',
'March 1, 2017',
'January 24, 2018',
'August 7, 2017',
'July 31, 2017',
'July 17, 2015',
'May 18, 2018',
'June 28, 2018',
'January 21, 2018',
'May 27, 2018',
'May 17, 2018',
'July 13, 2018',
'June 25, 2018',
'June 29, 2018',
'November 23, 2017',
'October 16, 2014',
'August 28, 2017',
'August 20, 2016',
'June 16, 2018',
'May 1, 2018',
'June 15, 2018',
'February 15, 2018',
'August 7, 2015',
'May 21, 2018',
'May 4, 2018',
'April 13, 2016',
'July 9, 2018',
'February 8, 2018',
'September 11, 2015',
'July 10, 2018',
'February 26, 2018',
'March 26, 2018',
'January 31, 2018',
'May 30, 2017',
'March 25, 2018',
'April 11, 2017',
'April 18, 2018',
'February 13, 2018',
'March 22, 2018',
'November 16, 2017',
'December 27, 2017',
'March 5, 2018',
'July 6, 2018',
'May 23, 2018',
'December 18, 2017',
'July 5, 2018',
'May 26, 2018',
'July 21, 2018',
'June 19, 2018',
'October 27, 2016',
'June 27, 2018',
'November 4, 2016',
'September 2, 2015',
'April 19, 2018',
'January 23, 2018',
'August 27, 2017',
'April 1, 2016',
'July 10, 2017',
'February 2, 2015',
'March 5, 2017',
'January 5, 2018',
'December 4, 2017',
'June 22, 2018',
'June 7, 2016',
'April 3, 2018',
'July 6, 2014',
'August 9, 2017',
'September 28, 2016',
'October 25, 2017',
'September 1, 2017',
'July 25, 2017',
'January 21, 2017',
'January 27, 2017',
'February 3, 2017',
'February 25, 2016',
'June 13, 2018',
'May 12, 2018',
'January 8, 2017',
'November 6, 2017',
'December 28, 2017',
'January 28, 2017',
'February 1, 2017',
'April 29, 2018',
'March 29, 2018',
'February 16, 2018',
'April 7, 2018',
'June 15, 2017',
'July 22, 2018',
'December 29, 2017',
'May 2, 2018',
'February 25, 2018',
'March 23, 2018',
'February 3, 2018',
'January 19, 2017',
'October 26, 2017',
'October 17, 2017',
'October 23, 2016',
'March 9, 2018',
'November 28, 2017',
'September 28, 2017',
'January 16, 2017',
'August 17, 2017',
'July 4, 2016',
'August 21, 2014',
'August 22, 2015',
'June 28, 2015',
'December 25, 2017',
'May 20, 2018',
'July 11, 2014',
'April 29, 2015',
'December 2, 2013',
'July 23, 2015',
'November 17, 2016',
'June 18, 2018',
'February 15, 2017',
'November 11, 2017',
'June 1, 2016',
'May 4, 2016',
'June 13, 2017',
'September 20, 2016',
'December 20, 2016',
'January 11, 2015',
'October 1, 2017',
'July 29, 2016',
'October 16, 2017',
'December 24, 2017',
'July 24, 2017',
'July 21, 2017',
'January 20, 2018',
'April 28, 2016',
'July 16, 2015',
'September 14, 2016',
'February 14, 2018',
'February 7, 2018',
'June 11, 2018',
'April 12, 2018',
'January 19, 2018',
'December 14, 2017',
'June 30, 2018',
'July 7, 2017',
'September 15, 2015',
'September 22, 2015',
'November 27, 2017',
'June 23, 2018',
'November 8, 2016',
'October 14, 2017',
'April 27, 2017',
'December 15, 2017',
'May 30, 2018',
'May 3, 2018',
'May 8, 2018',
'June 9, 2018',
'June 7, 2017',
'March 13, 2018',
'May 11, 2018',
'May 9, 2018',
'February 22, 2018',
'October 12, 2016',
'March 28, 2018',
'January 25, 2018',
'June 10, 2018',
'June 24, 2018',
'February 17, 2017',
'April 10, 2018',
'June 3, 2018',
'May 22, 2018',
'August 12, 2017',
'January 10, 2017',
'October 16, 2016',
'December 22, 2015',
'February 9, 2017',
'July 28, 2016',
'January 17, 2018',
'June 19, 2012',
'August 5, 2018',
'March 30, 2018',
'February 10, 2018',
'July 17, 2017',
'August 27, 2016',
'August 23, 2017',
'January 29, 2018',
'July 23, 2014',
'July 16, 2017',
'March 11, 2017',
'February 22, 2017',
'February 18, 2018',
'March 2, 2016',
'September 19, 2017',
'August 21, 2017',
'March 13, 2015',
'April 7, 2015',
'March 17, 2015',
'May 30, 2015',
'March 6, 2015',
'March 12, 2015',
'March 11, 2015',
'August 30, 2017',
'April 23, 2018',
'October 15, 2015',
'February 20, 2018',
'January 16, 2018',
'March 6, 2013',
'January 17, 2012',
'June 10, 2017',
'September 27, 2017',
'March 8, 2018',
'January 2, 2017',
'March 14, 2016',
'November 5, 2017',
'February 23, 2018',
'November 7, 2016',
'June 29, 2011',
'September 21, 2015',
'February 12, 2013',
'January 9, 2018',
'July 1, 2018',
'December 20, 2017',
'November 3, 2016',
'June 30, 2016',
'September 24, 2015',
'December 17, 2016',
'February 21, 2018',
'September 27, 2016',
'January 11, 2018',
'May 7, 2018',
'August 2, 2017',
'August 29, 2017',
'June 5, 2017',
'January 26, 2017',
'April 30, 2014',
'June 18, 2017',
'October 12, 2017',
'August 28, 2015',
'July 18, 2017',
'February 27, 2016',
'June 23, 2017',
'March 8, 2017',
'April 17, 2018',
'March 6, 2018',
'April 13, 2018',
'April 11, 2018',
'December 22, 2017',
'February 27, 2018',
'December 21, 2017',
'October 19, 2015',
'November 30, 2017',
'April 12, 2017',
'June 28, 2017',
'March 14, 2017',
'October 15, 2017',
'July 28, 2017',
'March 16, 2018',
'August 6, 2018',
'June 4, 2018',
'November 22, 2016',
'February 1, 2018',
'June 29, 2017',
'July 14, 2017',
'October 6, 2017',
'July 12, 2017',
'August 31, 2017',
'November 22, 2017',
'March 7, 2017',
'October 4, 2017',
'July 22, 2016',
'May 18, 2017',
'February 2, 2018',
'February 18, 2016',
'March 15, 2017',
'March 5, 2016',
'February 2, 2016',
'January 13, 2017',
'July 13, 2017',
'December 1, 2015',
'June 17, 2015',
'March 23, 2017',
'July 3, 2017',
'September 8, 2016',
'September 3, 2015',
'November 14, 2014',
'December 13, 2017',
'August 2, 2016',
'February 9, 2016',
'August 12, 2015',
'August 24, 2015',
'June 16, 2016',
'May 22, 2013',
'August 4, 2017',
'October 28, 2016',
'December 9, 2014',
'December 9, 2017',
'December 30, 2016',
'February 5, 2016',
'April 14, 2016',
'February 11, 2016',
'November 30, 2014',
'April 6, 2018',
'October 3, 2016',
'June 17, 2017',
'September 21, 2017',
'November 15, 2017',
'August 7, 2014',
'December 6, 2017',
'December 3, 2014',
'April 18, 2017',
'January 24, 2016',
'October 22, 2014',
'November 22, 2012',
'August 18, 2015',
'December 16, 2015',
'November 5, 2013',
'May 26, 2015',
'March 14, 2018',
'August 5, 2017',
'August 11, 2017',
'December 8, 2016',
'August 3, 2015',
'October 5, 2017',
'June 11, 2016',
'August 2, 2014',
'September 14, 2017',
'September 6, 2014',
'January 2, 2018',
'July 26, 2013',
'March 2, 2017',
'October 3, 2017',
'May 6, 2015',
'January 14, 2018',
'May 9, 2017',
'October 2, 2017',
'October 10, 2017',
'October 13, 2016',
'October 17, 2016',
'December 8, 2017',
'March 24, 2018',
'October 22, 2013',
'September 6, 2016',
'December 23, 2017',
'April 4, 2018',
'June 1, 2017',
'April 24, 2018',
'September 26, 2017',
'January 18, 2015',
'March 14, 2015',
'May 10, 2015',
'February 25, 2017',
'April 16, 2018',
'September 12, 2016',
'November 20, 2017',
'October 25, 2016',
'January 20, 2015',
'January 30, 2018',
'June 8, 2016',
'February 29, 2016',
'December 5, 2017',
'July 25, 2015',
'December 1, 2017',
'March 5, 2015',
'January 22, 2018',
'February 6, 2018',
'July 29, 2015',
'November 8, 2017',
'November 2, 2016',
'January 25, 2016',
'July 29, 2017',
'August 11, 2015',
'November 10, 2017',
'March 25, 2016',
'May 5, 2018',
'February 10, 2015',
'March 3, 2017',
'February 11, 2015',
'October 19, 2016',
'October 17, 2015',
'April 6, 2017',
'February 11, 2018',
'November 6, 2014',
'March 21, 2017',
'July 18, 2016',
'September 8, 2017',
'January 7, 2016',
'March 16, 2017',
'August 23, 2016',
'December 5, 2016',
'December 6, 2016',
'July 14, 2016',
'March 21, 2016',
'July 5, 2016',
'November 13, 2017',
'July 14, 2015',
'August 10, 2016',
'November 21, 2014',
'January 17, 2016',
'July 27, 2016',
'November 13, 2014',
'March 27, 2017',
'January 3, 2017',
'May 12, 2017',
'April 22, 2014',
'July 11, 2017',
'November 18, 2017',
'August 10, 2015',
'September 17, 2017',
'February 5, 2018',
'April 28, 2017',
'August 7, 2018',
'September 5, 2016',
'May 12, 2016',
'March 18, 2018',
'April 25, 2014',
'December 2, 2017',
'September 25, 2017',
'March 9, 2017',
'December 10, 2017',
'January 22, 2017',
'November 1, 2016',
'August 24, 2016',
'October 20, 2016',
'December 7, 2016',
'May 11, 2016',
'April 4, 2014',
'January 7, 2015',
'March 17, 2018',
'December 24, 2016',
'May 1, 2014',
'November 28, 2016',
'June 24, 2014',
'October 29, 2017',
'May 27, 2016',
'October 9, 2017',
'August 10, 2017',
'April 22, 2016',
'April 14, 2017',
'March 15, 2018',
'August 7, 2016',
'December 11, 2016',
'December 19, 2015',
'October 30, 2017',
'September 30, 2013',
'November 12, 2017',
'October 18, 2016',
'December 25, 2016',
'May 19, 2018',
'April 25, 2016',
'August 8, 2016',
'January 8, 2018',
'November 1, 2017',
'January 9, 2017',
'August 18, 2016',
'December 30, 2017',
'January 7, 2017',
'April 1, 2018',
'March 19, 2018',
'October 31, 2017',
'November 19, 2017',
'December 3, 2015',
'February 13, 2015',
'February 3, 2015',
'June 3, 2016',
'October 30, 2014',
'January 13, 2018',
'March 11, 2016',
'May 25, 2017',
'August 9, 2016',
'February 19, 2018',
'November 2, 2017',
'December 4, 2016',
'August 26, 2016',
'January 5, 2017',
'April 22, 2018',
'June 16, 2017',
'May 13, 2018',
'September 13, 2017',
'September 12, 2014',
'November 24, 2017',
'June 11, 2015',
'April 12, 2016',
'May 19, 2017',
'May 4, 2015',
'August 19, 2017',
'December 22, 2016',
'October 22, 2016',
'August 16, 2015',
'September 2, 2017',
'March 31, 2016',
'June 20, 2017',
'August 26, 2017',
'July 31, 2014',
'May 13, 2017',
'June 24, 2017',
'December 16, 2017',
'April 4, 2016',
'September 26, 2015',
'January 20, 2016',
'June 3, 2017',
'August 31, 2016',
'September 22, 2017',
'May 16, 2014',
'March 2, 2018',
'January 18, 2018',
'November 26, 2015',
'May 3, 2017',
'October 23, 2017',
'October 6, 2016',
'February 21, 2017',
'August 5, 2015',
'December 26, 2017',
'July 24, 2016',
'October 7, 2016',
'December 15, 2016',
'January 28, 2014',
'April 21, 2017',
'March 15, 2016',
'July 19, 2016',
'July 12, 2016',
'December 7, 2017',
'January 25, 2017',
'September 8, 2013',
'September 1, 2015',
'September 26, 2016',
'April 10, 2013',
'October 21, 2017',
'December 7, 2015',
'January 1, 2016',
'September 30, 2017',
'April 7, 2016',
'November 3, 2017',
'February 8, 2017',
'December 14, 2015',
'May 19, 2015',
'November 20, 2015',
'February 4, 2018',
'September 10, 2017',
'January 4, 2016',
'December 19, 2017',
'January 1, 2018',
'September 7, 2017',
'November 16, 2016',
'October 22, 2017',
'April 30, 2018',
'October 20, 2017',
'December 12, 2017',
'March 12, 2018',
'May 14, 2014',
'October 17, 2014',
'July 23, 2016',
'June 17, 2018',
'May 8, 2017',
'January 13, 2014',
'May 1, 2016',
'April 21, 2016',
'January 11, 2017',
'November 17, 2017',
'August 22, 2013',
'April 4, 2017',
'June 6, 2016',
'September 7, 2015',
'April 2, 2016',
'February 12, 2017',
'December 4, 2015',
'March 11, 2018',
'March 20, 2017',
'July 9, 2017',
'January 12, 2018',
'May 17, 2017',
'July 15, 2016',
'February 9, 2018',
'March 28, 2017',
'May 25, 2015',
'July 1, 2015',
'March 6, 2017',
'February 15, 2016',
'December 26, 2014',
'May 31, 2017',
'August 20, 2017',
'December 3, 2011',
'April 25, 2017',
'September 14, 2015',
'May 6, 2018',
'April 14, 2018',
'February 12, 2018',
'March 16, 2015',
'August 4, 2016',
'April 1, 2017',
'May 16, 2017',
'March 4, 2017',
'July 12, 2014',
'March 16, 2016',
'December 3, 2017',
'December 8, 2015',
'May 15, 2017',
'February 21, 2014',
'May 14, 2017',
'September 24, 2017',
'September 16, 2014',
'June 20, 2016',
'April 28, 2018',
'May 29, 2017',
'August 7, 2013',
'February 27, 2017',
'July 8, 2016',
'January 31, 2017',
'September 19, 2012',
'February 12, 2016',
'August 14, 2017',
'November 15, 2014',
'April 3, 2017',
'October 24, 2017',
'April 20, 2016',
'August 25, 2015',
'February 24, 2016',
'August 19, 2014',
'November 8, 2012',
'September 27, 2013',
'September 29, 2016',
'May 14, 2013',
'April 8, 2018',
'June 25, 2017',
'March 3, 2018',
'September 11, 2017',
'February 5, 2014',
'October 7, 2017',
'January 28, 2018',
'February 24, 2018',
'January 23, 2017',
'September 20, 2014',
'June 22, 2017',
'November 19, 2016',
'September 3, 2017',
'January 4, 2017',
'April 11, 2014',
'February 26, 2014',
'December 31, 2017',
'January 25, 2015',
'October 19, 2017',
'March 4, 2018',
'November 13, 2015',
'July 28, 2015',
'August 1, 2017',
'November 5, 2014',
'July 31, 2016',
'June 30, 2017',
'April 8, 2016',
'March 13, 2017',
'July 10, 2014',
'July 10, 2015',
'November 3, 2015',
'June 15, 2016',
'June 21, 2016',
'February 23, 2017',
'February 2, 2017',
'September 15, 2016',
'December 31, 2016',
'October 8, 2012',
'July 9, 2014',
'November 23, 2016',
'July 19, 2017',
'December 11, 2015',
'July 30, 2016',
'January 8, 2015',
'June 2, 2017',
'November 27, 2015',
'June 8, 2017',
'October 28, 2014',
'July 30, 2015',
'December 28, 2015',
'July 28, 2014',
'August 20, 2015',
'December 17, 2013',
'May 7, 2016',
'May 3, 2014',
'September 25, 2013',
'December 21, 2016',
'July 26, 2016',
'September 17, 2015',
'April 25, 2013',
'May 26, 2014',
'August 9, 2014',
'November 20, 2013',
'September 30, 2016',
'March 23, 2016',
'January 19, 2014',
'December 31, 2015',
'January 4, 2018',
'December 13, 2013',
'November 12, 2013',
'June 27, 2017',
'December 31, 2014',
'January 24, 2014',
'January 1, 2015',
'October 9, 2015',
'December 10, 2015',
'June 15, 2015',
'August 1, 2013',
'October 26, 2016',
'December 9, 2016',
'January 25, 2013',
'December 19, 2013',
'June 29, 2016',
'November 28, 2012',
'May 1, 2017',
'May 2, 2017',
'November 20, 2014',
'March 20, 2015',
'March 31, 2017',
'June 9, 2017',
'May 23, 2017',
'May 5, 2017',
'June 26, 2017',
'April 30, 2017',
'October 28, 2017',
'May 12, 2011',
'June 21, 2017',
'October 1, 2013',
'May 11, 2017',
'January 10, 2018',
'April 22, 2017',
'May 26, 2017',
'November 4, 2017',
'June 3, 2015',
'September 25, 2015',
'February 18, 2013',
'March 7, 2016',
'May 4, 2017',
'January 27, 2018',
'June 13, 2016',
'March 24, 2017',
'June 4, 2013',
'August 15, 2016',
'September 29, 2017',
'March 17, 2017',
'September 7, 2016',
'November 11, 2016',
'February 26, 2017',
'April 26, 2015',
'March 1, 2016',
'March 10, 2018',
'May 2, 2015',
'September 11, 2013',
'February 15, 2015',
'March 25, 2017',
'June 24, 2015',
'February 17, 2018',
'October 8, 2016',
'April 5, 2017',
'March 10, 2016',
'April 10, 2015',
'October 21, 2016',
'May 10, 2017',
'February 23, 2016',
'March 11, 2014',
'December 23, 2016',
'June 2, 2016',
'March 8, 2016',
'May 14, 2015',
'August 30, 2015',
'August 12, 2014',
'March 22, 2016',
'November 1, 2013',
'August 14, 2016',
'August 31, 2013',
'July 19, 2015',
'July 30, 2017',
'January 19, 2016',
'November 4, 2015',
'August 15, 2017',
'October 14, 2015',
'June 22, 2016',
'February 23, 2014',
'September 22, 2011',
'January 23, 2016',
'May 24, 2017',
'September 30, 2014',
'December 26, 2016',
'July 18, 2013',
'December 3, 2016',
'July 26, 2015',
'April 2, 2015',
'June 6, 2017',
'November 26, 2017',
'December 2, 2014',
'May 22, 2017',
'January 26, 2018',
'May 14, 2016',
'July 1, 2016',
'September 18, 2017',
'September 5, 2017',
'August 3, 2016',
'April 8, 2017',
'September 22, 2016',
'March 6, 2014',
'September 19, 2013',
'August 4, 2014',
'May 17, 2016',
'July 6, 2017',
'September 15, 2017',
'September 4, 2013',
'June 6, 2015',
'July 15, 2015',
'October 20, 2015',
'February 14, 2017',
'February 8, 2016',
'October 12, 2015',
'October 26, 2015',
'July 4, 2017',
'November 11, 2015',
'October 2, 2014',
'July 8, 2017',
'December 19, 2016',
'November 26, 2012',
'November 25, 2017',
'February 23, 2015',
'August 18, 2017',
'December 1, 2016',
'February 16, 2017',
'August 31, 2015',
'July 6, 2015',
'October 27, 2015',
'June 13, 2014',
'July 21, 2016',
'December 21, 2015',
'August 5, 2016',
'October 5, 2016',
'April 11, 2016',
'April 17, 2014',
'February 18, 2017',
'August 13, 2015',
'March 28, 2016',
'December 14, 2016',
'November 16, 2015',
'July 2, 2017',
'August 13, 2016',
'May 30, 2016',
'September 23, 2015',
'September 29, 2015',
'November 2, 2015',
'April 15, 2016',
'February 18, 2015',
'August 15, 2013',
'October 5, 2015',
'October 8, 2015',
'February 19, 2016',
'April 9, 2012',
'January 19, 2015',
'January 12, 2016',
'May 16, 2016',
'April 29, 2017',
'December 18, 2015',
'October 7, 2015',
'September 13, 2015',
'July 22, 2017',
'December 12, 2016',
'November 10, 2016',
'May 26, 2016',
'January 27, 2016',
'January 16, 2016',
'January 29, 2016',
'November 12, 2014',
'September 4, 2017',
'June 18, 2015',
'March 31, 2015',
'June 9, 2015',
'February 22, 2016',
'October 4, 2015',
'August 28, 2016',
'July 26, 2017',
'April 23, 2017',
'November 9, 2015',
'June 14, 2015',
'May 25, 2016',
'July 5, 2017',
'November 12, 2015',
'June 12, 2017',
'March 19, 2017',
'October 2, 2015',
'July 11, 2015',
'June 14, 2016',
'September 23, 2017',
'March 29, 2017',
'December 15, 2015',
'November 9, 2016',
'September 17, 2016',
'October 30, 2015',
'November 10, 2014',
'October 13, 2015',
'November 19, 2015',
'August 16, 2016',
'November 29, 2016',
'February 6, 2017',
'November 26, 2014',
'October 3, 2015',
'September 22, 2014',
'May 8, 2015',
'August 12, 2016',
'December 2, 2016',
'July 7, 2016',
'March 30, 2015',
'April 20, 2015',
'January 12, 2017',
'March 20, 2014',
'January 6, 2017',
'May 23, 2016',
'August 8, 2015',
'June 10, 2015',
'July 16, 2016',
'March 22, 2015',
'February 3, 2016',
'February 7, 2016',
'April 14, 2015',
'July 18, 2014',
'June 5, 2014',
'July 1, 2013',
'February 20, 2017',
'May 6, 2013',
'April 24, 2016',
...],
'Price': ['0',
'$4.99',
'$3.99',
'$6.99',
'$1.49',
'$2.99',
'$7.99',
'$5.99',
'$3.49',
'$1.99',
'$9.99',
'$7.49',
'$0.99',
'$9.00',
'$5.49',
'$10.00',
'$24.99',
'$11.99',
'$79.99',
'$16.99',
'$14.99',
'$1.00',
'$29.99',
'$12.99',
'$2.49',
'$10.99',
'$1.50',
'$19.99',
'$15.99',
'$33.99',
'$74.99',
'$39.99',
'$3.95',
'$4.49',
'$1.70',
'$8.99',
'$2.00',
'$3.88',
'$25.99',
'$399.99',
'$17.99',
'$400.00',
'$3.02',
'$1.76',
'$4.84',
'$4.77',
'$1.61',
'$2.50',
'$1.59',
'$6.49',
'$1.29',
'$5.00',
'$13.99',
'$299.99',
'$379.99',
'$37.99',
'$18.99',
'$389.99',
'$19.90',
'$8.49',
'$1.75',
'$14.00',
'$4.85',
'$46.99',
'$109.99',
'$154.99',
'$3.08',
'$2.59',
'$4.80',
'$1.96',
'$19.40',
'$3.90',
'$4.59',
'$15.46',
'$3.04',
'$4.29',
'$2.60',
'$3.28',
'$4.60',
'$28.99',
'$2.95',
'$2.90',
'$1.97',
'$200.00',
'$89.99',
'$2.56',
'$30.99',
'$3.61',
'$394.99',
'$1.26',
'$1.20',
'$1.04'],
'Reviews': ['159',
'967',
'87510',
'215644',
'167',
'178',
'36815',
'13791',
'121',
'13880',
'8788',
'44829',
'4326',
'1518',
'55',
'3632',
'27',
'194216',
'224399',
'450',
'654',
'7699',
'61',
'118',
'192',
'20260',
'203',
'136',
'223',
'1120',
'227',
'5035',
'1015',
'353',
'564',
'8145',
'36639',
'158',
'591',
'117',
'176',
'295221',
'2206',
'26',
'174531',
'1070',
'85',
'845',
'367',
'1598',
'284',
'17057',
'129',
'542',
'10479',
'805',
'1403',
'3971',
'534',
'7774',
'38846',
'2431',
'6090',
'295',
'190',
'40211',
'356',
'52530',
'116986',
'1379',
'271920',
'736',
'7021',
'197',
'737',
'3574',
'994',
'197136',
'142',
'15168',
'2155',
'138',
'5414',
'21777',
'348',
'250',
'13372',
'7880',
'3617',
'4806',
'65786',
'31433',
'5097',
'1754',
'2680',
'1288',
'18900',
'49790',
'1150',
'1739',
'32090',
'2225',
'4369',
'8572',
'964',
'42050',
'104',
'17934',
'601',
'36',
'187',
'182',
'30',
'134',
'74',
'113715',
'3595',
'9315',
'75',
'38',
'26834',
'119',
'2277',
'2280',
'184',
'9',
'77',
'35',
'364',
'18',
'473',
'66',
'3871',
'257',
'62',
'2914724',
'1857',
'4478',
'577550',
'814080',
'246315',
'454060',
'155446',
'418',
'22486',
'203130',
'1435',
'116507',
'1433233',
'90468',
'860',
'363934',
'87873',
'17506',
'1862',
'2084',
'47303',
'19080',
'161',
'85842',
'7831',
'91615',
'4620',
'21336',
'26875',
'1778',
'2709',
'64513',
'8342',
'527',
'1322',
'1680',
'2739',
'1065',
'233757',
'2',
'51269',
'30105',
'156',
'114',
'341157',
'16129',
'674730',
'1254730',
'85185',
'32584',
'217730',
'70991',
'1002861',
'16589',
'148945',
'4458',
'62272',
'8941',
'46353',
'1279184',
'88073',
'67000',
'159872',
'30847',
'188841',
'11622',
'95912',
'4034',
'45964',
'14955',
'6903',
'31614',
'23055',
'19023',
'207372',
'1225',
'380837',
'10600',
'74359',
'822',
'80805',
'2287',
'4162',
'14760',
'23243',
'8978',
'42492',
'286897',
'103755',
'46505',
'11442',
'10295',
'296',
'29313',
'51507',
'1802',
'1383',
'23175',
'5868',
'2111',
'5448',
'4159',
'20815',
'78662',
'7149',
'3079',
'5800',
'6989',
'16422',
'108741',
'624',
'1661',
'97702',
'308',
'5211',
'1058',
'78172',
'80804',
'1002859',
'51510',
'413',
'1013635',
'24005',
'57106',
'2249',
'516',
'834',
'1010',
'238970',
'302',
'438',
'73',
'39',
'144',
'2181',
'93965',
'1446',
'12088',
'314',
'25671',
'15194',
'22551',
'29839',
'279',
'564387',
'1330',
'1677',
'757',
'115',
'125',
'9952',
'18814',
'21',
'15',
'51981',
'3596',
'1006',
'5968',
'4895',
'56642847',
'69119316',
'125257',
'9642995',
'1429035',
'4604324',
'3419249',
'11334799',
'158679',
'3075028',
'4187998',
'659395',
'4785892',
'66602',
'30209',
'36901',
'5149854',
'192948',
'99559',
'437674',
'13698',
'2473509',
'20769',
'36880',
'171031',
'63543',
'45487',
'615381',
'2451083',
'33053',
'5387333',
'3648120',
'136662',
'42370',
'781810',
'3128250',
'2083237',
'541389',
'46702',
'2939',
'13761',
'258556',
'40751',
'17712922',
'25021',
'27187',
'56646578',
'4785988',
'122498',
'11334973',
'3419433',
'132014',
'83239',
'594728',
'5387446',
'10484169',
'3128509',
'2451093',
'2876500',
'28238',
'335646',
'350154',
'349384',
'346982',
'244863',
'10790289',
'330761',
'37320',
'12842860',
'2546527',
'36893',
'15880',
'346980',
'9643041',
'3075118',
'2264916',
'2473693',
'42925',
'5150471',
'2511130',
'3648480',
'17714850',
'13100',
'27156',
'55098',
'1133501',
'12578',
'10965',
'18247',
'190613',
'125232',
'72065',
'27540',
'104990',
'177703',
'17529',
'177263',
'237468',
'32254',
'483565',
'552441',
'60308',
'457283',
'93825',
'32283',
'15287',
'205739',
'14873',
'7820209',
'9498',
'4604483',
'4188142',
'88427',
'305218',
'183374',
'20901',
'122595',
'124346',
'837842',
'255',
'41420',
'44706',
'23707',
'3419513',
'11335255',
'29208',
'191032',
'1545',
'57',
'0',
'4',
'516801',
'285726',
'76646',
'2556',
'7779',
'61637',
'12632',
'313724',
'48845',
'305708',
'31320',
'172460',
'4195',
'11633',
'10212',
'37053',
'667',
'13202',
'28671',
'1157',
'212626',
'222888',
'2067',
'1643',
'105',
'3414',
'42194',
'11806',
'1999',
'22544',
'97684',
'2519',
'1146',
'13046',
'17268',
'8722',
'953',
'2593',
'5377',
'852',
'212',
'1972',
'35206',
'5164',
'1939',
'277',
'80',
'825',
'40035',
'1093',
'135418',
'1601',
'2212',
'57081',
'241',
'63986',
'7888',
'535',
'5084',
'2430',
'837',
'738',
'4631',
'4953',
'1439',
'1645',
'13204',
'853',
'337',
'13049',
'51698',
'923',
'1546',
'149',
'198',
'135420',
'22545',
'8723',
'23170',
'13890',
'57083',
'537',
'13440',
'143',
'1059',
'894',
'6191',
'15081',
'218',
'35205',
'243950',
'236',
'5152',
'1576',
'6701',
'40039',
'742',
'2506',
'182986',
'8661',
'8',
'59',
'28',
'185',
'6',
'110',
'3',
'5',
'84',
'20',
'776',
'1',
'14',
'24',
'23',
'11',
'101',
'120',
'4954',
'954',
'2560',
'42197',
'5168',
'12633',
'41605',
'2433',
'791',
'5323',
'478',
'69',
'53',
'97699',
'6289924',
'181893',
'2544',
'85375',
'314299',
'9770',
'32346',
'4075',
'10611',
'9321',
'56065',
'14286',
'133136',
'2469',
'36212',
'390',
'1090',
'266948',
'342918',
'748',
'172640',
'1619',
'3168',
'29855',
'6736',
'7005',
'889',
'5741',
'27572',
'10852',
'9888',
'1929',
'1516',
'215301',
'423',
'254519',
'1107903',
'211856',
'99020',
'90481',
'32381',
'248912',
'248555',
'272145',
'56897',
'8599',
'41185',
'29980',
'304',
'358',
'11904',
'22251',
'22384',
'73404',
'12733',
'25183',
'52743',
'61749',
'55704',
'19277',
'13612',
'37862',
'18372',
'656',
'240',
'275',
'3692',
'2363',
'1769',
'430',
'756',
'3963',
'316',
'642',
'6290507',
'32380',
'172505',
'69493',
'1107884',
'7973',
'266935',
'5695',
'142632',
'55256',
'172508',
'54798',
'4815',
'75112',
'33646',
'314300',
'206527',
'9348',
'3816',
'47847',
'16195',
'206',
'28392',
'3241',
'835',
'2525',
'828',
'200058',
'1239',
'702',
'108613',
'69498',
'148550',
'3847',
'84309',
'1107948',
'14206',
'206532',
'14700',
'42828',
'40209',
'1405',
'148549',
'84311',
'256079',
'2078',
'16103',
'31085',
'3528',
'5456208',
'11656',
'28948',
'296771',
'470089',
'10939',
'98509',
'5241',
'22508',
'10291',
'7165362',
'4885646',
'141980',
'6979',
'46618',
'103078',
'17682',
'37000',
'175528',
'1828284',
'34923',
'684116',
'46916',
'407698',
'702975',
'32458',
'235496',
'11661',
'653008',
'23063',
'87384',
'411683',
'8918',
'501498',
'2133296',
'29690',
'130549',
'613059',
'1633682',
'2646',
'21867',
'32732',
'243747',
'2639',
'1511',
'44550',
'501497',
'7813',
'1033',
'2442',
'15254',
'155234',
'310066',
'12216',
'388089',
'92058',
'88185',
'493',
'33387',
'123279',
'27424',
'60841',
'29706',
'288150',
'14807',
'319692',
'61201',
'22998',
'12398',
'35928',
'64448',
'22378',
'5456599',
'296829',
'310095',
'319691',
'16372',
'58028',
'736864',
'1968',
'35279',
'35931',
'17247',
'87723',
'18523',
'182103',
'197774',
'8674',
'5456708',
'58082',
'407719',
'115033',
'22997',
'801',
'8968',
'303',
'732',
'1856',
'50725',
'1575',
'6238',
'9941',
'23666',
'67554',
'38769',
'160164',
'3771',
'256664',
'787177',
'3782',
'40113',
'7074',
'2153',
'26089',
'20611',
'811',
'15558',
'573',
'37',
'8232',
'3089',
'3874',
'464',
'731',
'8800',
'99',
'456',
'3200',
'5839',
'663',
'16',
'13',
'46',
'1953',
'12',
'4298',
'49',
'100',
'399',
'7',
'124424',
'39041',
'52306',
'36718',
'42644',
'278082',
'6076',
'112656',
'335738',
'31906',
'20672',
'957973',
'130582',
'31218',
'167168',
'34428',
'15247',
'48445',
'35518',
'12185',
'36746',
'21996',
'138371',
'12073',
'111632',
'250706',
'706301',
'64959',
'659741',
'510392',
'7215',
'25508',
'60449',
'381788',
'10697',
'347838',
'31804',
'3856',
'199684',
'44545',
'1336246',
'57493',
'283',
'12304',
'8188',
'11919',
'45957',
'126431',
'21570',
'134564',
'16961',
'111254',
'7731',
'5928',
'15703',
'6148',
'861',
'8662',
'23130',
'69973',
'1311',
'26587',
'2417',
'706302',
'1054',
'25166',
'129304',
'19870',
'161440',
'7514',
'46106',
'15141',
'714',
'42410',
'260547',
'4344',
'22808',
'42809',
'16808',
'157505',
'24647',
'1922',
'3334',
'10658',
'78361',
'2594',
'13868',
'135952',
'11066',
'45962',
'34861',
'37580',
'281485',
'685',
'126447',
'3780',
'15192',
'5950',
'15993',
'5905',
'659760',
'14627',
'1098',
'2898',
'70782',
'11264',
'100997',
'347874',
'3290',
'341090',
'87951',
'250719',
'510401',
'24729',
'78306',
'43313',
'1374549',
'208463',
'6998',
'145323',
'95',
'64784',
'32997',
'82',
'2707',
'129737',
'611136',
'6118',
'2473',
'109784',
'3320',
'68103',
'8412',
'10741',
'3803',
'155944',
'10159',
'28008',
'43614',
'455377',
'1398',
'1032935',
'32405',
'151080',
'22513',
'90042',
'58316',
'8509',
'19314',
'21314',
'30224',
'454',
'14952',
'1250',
'1726',
'14065',
'556',
'4925',
'6507',
'11707',
'1077',
'46539',
'9066',
'1962',
'22071',
'196',
'278',
'61881',
'2129',
'1268',
'91359',
'22015',
'131569',
'31986',
'22875',
'17071',
'90242',
'483960',
'511228',
...],
'Size': ['19M',
'14M',
'8.7M',
'25M',
'2.8M',
'5.6M',
'29M',
'33M',
'3.1M',
'28M',
'12M',
'20M',
'21M',
'37M',
'2.7M',
'5.5M',
'17M',
'39M',
'31M',
'4.2M',
'7.0M',
'23M',
'6.0M',
'6.1M',
'4.6M',
'9.2M',
'5.2M',
'11M',
'24M',
'Varies with device',
'9.4M',
'15M',
'10M',
'1.2M',
'26M',
'8.0M',
'7.9M',
'56M',
'57M',
'35M',
'54M',
'201k',
'3.6M',
'5.7M',
'8.6M',
'2.4M',
'27M',
'2.5M',
'16M',
'3.4M',
'8.9M',
'3.9M',
'2.9M',
'38M',
'32M',
'5.4M',
'18M',
'1.1M',
'2.2M',
'4.5M',
'9.8M',
'52M',
'9.0M',
'6.7M',
'30M',
'2.6M',
'7.1M',
'3.7M',
'22M',
'7.4M',
'6.4M',
'3.2M',
'8.2M',
'9.9M',
'4.9M',
'9.5M',
'5.0M',
'5.9M',
'13M',
'73M',
'6.8M',
'3.5M',
'4.0M',
'2.3M',
'7.2M',
'2.1M',
'42M',
'7.3M',
'9.1M',
'55M',
'23k',
'6.5M',
'1.5M',
'7.5M',
'51M',
'41M',
'48M',
'8.5M',
'46M',
'8.3M',
'4.3M',
'4.7M',
'3.3M',
'40M',
'7.8M',
'8.8M',
'6.6M',
'5.1M',
'61M',
'66M',
'79k',
'8.4M',
'118k',
'44M',
'695k',
'1.6M',
'6.2M',
'18k',
'53M',
'1.4M',
'3.0M',
'5.8M',
'3.8M',
'9.6M',
'45M',
'63M',
'49M',
'77M',
'4.4M',
'4.8M',
'70M',
'6.9M',
'9.3M',
'10.0M',
'8.1M',
'36M',
'84M',
'97M',
'2.0M',
'1.9M',
'1.8M',
'5.3M',
'47M',
'556k',
'526k',
'76M',
'7.6M',
'59M',
'9.7M',
'78M',
'72M',
'43M',
'7.7M',
'6.3M',
'334k',
'34M',
'93M',
'65M',
'79M',
'100M',
'58M',
'50M',
'68M',
'64M',
'67M',
'60M',
'94M',
'232k',
'99M',
'624k',
'95M',
'8.5k',
'41k',
'292k',
'11k',
'80M',
'1.7M',
'74M',
'62M',
'69M',
'75M',
'98M',
'85M',
'82M',
'96M',
'87M',
'71M',
'86M',
'91M',
'81M',
'92M',
'83M',
'88M',
'704k',
'862k',
'899k',
'378k',
'266k',
'375k',
'1.3M',
'975k',
'980k',
'4.1M',
'89M',
'696k',
'544k',
'525k',
'920k',
'779k',
'853k',
'720k',
'713k',
'772k',
'318k',
'58k',
'241k',
'196k',
'857k',
'51k',
'953k',
'865k',
'251k',
'930k',
'540k',
'313k',
'746k',
'203k',
'26k',
'314k',
'239k',
'371k',
'220k',
'730k',
'756k',
'91k',
'293k',
'17k',
'74k',
'14k',
'317k',
'78k',
'924k',
'902k',
'818k',
'81k',
'939k',
'169k',
'45k',
'475k',
'965k',
'90M',
'545k',
'61k',
'283k',
'655k',
'714k',
'93k',
'872k',
'121k',
'322k',
'1.0M',
'976k',
'172k',
'238k',
'549k',
'206k',
'954k',
'444k',
'717k',
'210k',
'609k',
'308k',
'705k',
'306k',
'904k',
'473k',
'175k',
'350k',
'383k',
'454k',
'421k',
'70k',
'812k',
'442k',
'842k',
'417k',
'412k',
'459k',
'478k',
'335k',
'782k',
'721k',
'430k',
'429k',
'192k',
'200k',
'460k',
'728k',
'496k',
'816k',
'414k',
'506k',
'887k',
'613k',
'243k',
'569k',
'778k',
'683k',
'592k',
'319k',
'186k',
'840k',
'647k',
'191k',
'373k',
'437k',
'598k',
'716k',
'585k',
'982k',
'222k',
'219k',
'55k',
'948k',
'323k',
'691k',
'511k',
'951k',
'963k',
'25k',
'554k',
'351k',
'27k',
'82k',
'208k',
'913k',
'514k',
'551k',
'29k',
'103k',
'898k',
'743k',
'116k',
'153k',
'209k',
'353k',
'499k',
'173k',
'597k',
'809k',
'122k',
'411k',
'400k',
'801k',
'787k',
'237k',
'50k',
'643k',
'986k',
'97k',
'516k',
'837k',
'780k',
'961k',
'269k',
'20k',
'498k',
'600k',
'749k',
'642k',
'881k',
'72k',
'656k',
'601k',
'221k',
'228k',
'108k',
'940k',
'176k',
'33k',
'663k',
'34k',
'942k',
'259k',
'164k',
'458k',
'245k',
'629k',
'28k',
'288k',
'775k',
'785k',
'636k',
'916k',
'994k',
'309k',
'485k',
'914k',
'903k',
'608k',
'500k',
'54k',
'562k',
'847k',
'957k',
'688k',
'811k',
'270k',
'48k',
'329k',
'523k',
'921k',
'874k',
'981k',
'784k',
'280k',
'24k',
'518k',
'754k',
'892k',
'154k',
'860k',
'364k',
'387k',
'626k',
'161k',
'879k',
'39k',
'970k',
'170k',
'141k',
'160k',
'144k',
'143k',
'190k',
'376k',
'193k',
'246k',
'73k',
'658k',
'992k',
'253k',
'420k',
'404k',
'470k',
'226k',
'240k',
'89k',
'234k',
'257k',
'861k',
'467k',
'157k',
'44k',
'676k',
'67k',
'552k',
'885k',
'1020k',
'582k',
'619k'],
'Type': ['Free', 'Paid', nan]}
data['Reviews'] = data['Reviews'].astype(np.float)
(data['Size'] == 'Varies with device').sum()
1695
data['Size'] = data['Size'].apply(lambda x: np.NaN if x == 'Varies with device' else x)
data['Size'] = data['Size'].apply(lambda x: np.float(x.replace('M', '')) * 1e6 if type(x) != float and 'M' in x else x)
data['Size'] = data['Size'].apply(lambda x: np.float(x.replace('k', '')) * 1e3 if type(x) != float and 'k' in x else x)
data['Size'].astype(np.float)
0 19000000.0
1 14000000.0
2 8700000.0
3 25000000.0
4 2800000.0
...
10835 53000000.0
10836 3600000.0
10837 9500000.0
10838 NaN
10839 19000000.0
Name: Size, Length: 10840, dtype: float64
data['Price'] = data['Price'].apply(lambda x: np.float(x.replace('$', '')))
get_uniques(data, get_categorical_columns(data))
{'Category': ['ART_AND_DESIGN',
'AUTO_AND_VEHICLES',
'BEAUTY',
'BOOKS_AND_REFERENCE',
'BUSINESS',
'COMICS',
'COMMUNICATION',
'DATING',
'EDUCATION',
'ENTERTAINMENT',
'EVENTS',
'FINANCE',
'FOOD_AND_DRINK',
'HEALTH_AND_FITNESS',
'HOUSE_AND_HOME',
'LIBRARIES_AND_DEMO',
'LIFESTYLE',
'GAME',
'FAMILY',
'MEDICAL',
'SOCIAL',
'SHOPPING',
'PHOTOGRAPHY',
'SPORTS',
'TRAVEL_AND_LOCAL',
'TOOLS',
'PERSONALIZATION',
'PRODUCTIVITY',
'PARENTING',
'WEATHER',
'VIDEO_PLAYERS',
'NEWS_AND_MAGAZINES',
'MAPS_AND_NAVIGATION'],
'Content Rating': ['Everyone',
'Teen',
'Everyone 10+',
'Mature 17+',
'Adults only 18+',
'Unrated'],
'Installs': ['10,000+',
'500,000+',
'5,000,000+',
'50,000,000+',
'100,000+',
'50,000+',
'1,000,000+',
'10,000,000+',
'5,000+',
'100,000,000+',
'1,000,000,000+',
'1,000+',
'500,000,000+',
'50+',
'100+',
'500+',
'10+',
'1+',
'5+',
'0+',
'0'],
'Last Updated': ['January 7, 2018',
'January 15, 2018',
'August 1, 2018',
'June 8, 2018',
'June 20, 2018',
'March 26, 2017',
'April 26, 2018',
'June 14, 2018',
'September 20, 2017',
'July 3, 2018',
'October 27, 2017',
'July 31, 2018',
'April 2, 2018',
'June 26, 2018',
'August 3, 2018',
'June 6, 2018',
'November 7, 2017',
'July 30, 2018',
'April 20, 2018',
'March 20, 2018',
'July 12, 2018',
'March 7, 2018',
'July 7, 2018',
'April 25, 2018',
'October 11, 2017',
'March 21, 2018',
'August 22, 2017',
'May 31, 2018',
'July 19, 2018',
'January 6, 2018',
'April 27, 2018',
'July 11, 2018',
'August 2, 2018',
'July 14, 2018',
'November 29, 2017',
'March 31, 2018',
'July 20, 2018',
'April 15, 2018',
'January 3, 2018',
'November 14, 2017',
'December 17, 2017',
'May 28, 2018',
'May 10, 2018',
'July 26, 2018',
'July 18, 2018',
'July 29, 2018',
'August 26, 2014',
'July 8, 2018',
'July 28, 2018',
'June 12, 2018',
'October 14, 2016',
'May 25, 2018',
'July 16, 2018',
'July 27, 2018',
'July 4, 2018',
'March 27, 2018',
'July 15, 2018',
'July 24, 2018',
'July 23, 2018',
'August 4, 2018',
'May 16, 2018',
'June 2, 2018',
'April 21, 2018',
'November 9, 2017',
'May 15, 2018',
'October 24, 2016',
'February 28, 2018',
'July 25, 2018',
'June 21, 2018',
'June 5, 2018',
'September 12, 2017',
'April 9, 2018',
'March 1, 2018',
'April 5, 2018',
'August 3, 2017',
'May 24, 2018',
'November 21, 2017',
'October 18, 2017',
'May 29, 2018',
'May 14, 2018',
'July 17, 2018',
'July 2, 2018',
'June 7, 2018',
'August 8, 2017',
'December 11, 2017',
'June 1, 2018',
'March 1, 2017',
'January 24, 2018',
'August 7, 2017',
'July 31, 2017',
'July 17, 2015',
'May 18, 2018',
'June 28, 2018',
'January 21, 2018',
'May 27, 2018',
'May 17, 2018',
'July 13, 2018',
'June 25, 2018',
'June 29, 2018',
'November 23, 2017',
'October 16, 2014',
'August 28, 2017',
'August 20, 2016',
'June 16, 2018',
'May 1, 2018',
'June 15, 2018',
'February 15, 2018',
'August 7, 2015',
'May 21, 2018',
'May 4, 2018',
'April 13, 2016',
'July 9, 2018',
'February 8, 2018',
'September 11, 2015',
'July 10, 2018',
'February 26, 2018',
'March 26, 2018',
'January 31, 2018',
'May 30, 2017',
'March 25, 2018',
'April 11, 2017',
'April 18, 2018',
'February 13, 2018',
'March 22, 2018',
'November 16, 2017',
'December 27, 2017',
'March 5, 2018',
'July 6, 2018',
'May 23, 2018',
'December 18, 2017',
'July 5, 2018',
'May 26, 2018',
'July 21, 2018',
'June 19, 2018',
'October 27, 2016',
'June 27, 2018',
'November 4, 2016',
'September 2, 2015',
'April 19, 2018',
'January 23, 2018',
'August 27, 2017',
'April 1, 2016',
'July 10, 2017',
'February 2, 2015',
'March 5, 2017',
'January 5, 2018',
'December 4, 2017',
'June 22, 2018',
'June 7, 2016',
'April 3, 2018',
'July 6, 2014',
'August 9, 2017',
'September 28, 2016',
'October 25, 2017',
'September 1, 2017',
'July 25, 2017',
'January 21, 2017',
'January 27, 2017',
'February 3, 2017',
'February 25, 2016',
'June 13, 2018',
'May 12, 2018',
'January 8, 2017',
'November 6, 2017',
'December 28, 2017',
'January 28, 2017',
'February 1, 2017',
'April 29, 2018',
'March 29, 2018',
'February 16, 2018',
'April 7, 2018',
'June 15, 2017',
'July 22, 2018',
'December 29, 2017',
'May 2, 2018',
'February 25, 2018',
'March 23, 2018',
'February 3, 2018',
'January 19, 2017',
'October 26, 2017',
'October 17, 2017',
'October 23, 2016',
'March 9, 2018',
'November 28, 2017',
'September 28, 2017',
'January 16, 2017',
'August 17, 2017',
'July 4, 2016',
'August 21, 2014',
'August 22, 2015',
'June 28, 2015',
'December 25, 2017',
'May 20, 2018',
'July 11, 2014',
'April 29, 2015',
'December 2, 2013',
'July 23, 2015',
'November 17, 2016',
'June 18, 2018',
'February 15, 2017',
'November 11, 2017',
'June 1, 2016',
'May 4, 2016',
'June 13, 2017',
'September 20, 2016',
'December 20, 2016',
'January 11, 2015',
'October 1, 2017',
'July 29, 2016',
'October 16, 2017',
'December 24, 2017',
'July 24, 2017',
'July 21, 2017',
'January 20, 2018',
'April 28, 2016',
'July 16, 2015',
'September 14, 2016',
'February 14, 2018',
'February 7, 2018',
'June 11, 2018',
'April 12, 2018',
'January 19, 2018',
'December 14, 2017',
'June 30, 2018',
'July 7, 2017',
'September 15, 2015',
'September 22, 2015',
'November 27, 2017',
'June 23, 2018',
'November 8, 2016',
'October 14, 2017',
'April 27, 2017',
'December 15, 2017',
'May 30, 2018',
'May 3, 2018',
'May 8, 2018',
'June 9, 2018',
'June 7, 2017',
'March 13, 2018',
'May 11, 2018',
'May 9, 2018',
'February 22, 2018',
'October 12, 2016',
'March 28, 2018',
'January 25, 2018',
'June 10, 2018',
'June 24, 2018',
'February 17, 2017',
'April 10, 2018',
'June 3, 2018',
'May 22, 2018',
'August 12, 2017',
'January 10, 2017',
'October 16, 2016',
'December 22, 2015',
'February 9, 2017',
'July 28, 2016',
'January 17, 2018',
'June 19, 2012',
'August 5, 2018',
'March 30, 2018',
'February 10, 2018',
'July 17, 2017',
'August 27, 2016',
'August 23, 2017',
'January 29, 2018',
'July 23, 2014',
'July 16, 2017',
'March 11, 2017',
'February 22, 2017',
'February 18, 2018',
'March 2, 2016',
'September 19, 2017',
'August 21, 2017',
'March 13, 2015',
'April 7, 2015',
'March 17, 2015',
'May 30, 2015',
'March 6, 2015',
'March 12, 2015',
'March 11, 2015',
'August 30, 2017',
'April 23, 2018',
'October 15, 2015',
'February 20, 2018',
'January 16, 2018',
'March 6, 2013',
'January 17, 2012',
'June 10, 2017',
'September 27, 2017',
'March 8, 2018',
'January 2, 2017',
'March 14, 2016',
'November 5, 2017',
'February 23, 2018',
'November 7, 2016',
'June 29, 2011',
'September 21, 2015',
'February 12, 2013',
'January 9, 2018',
'July 1, 2018',
'December 20, 2017',
'November 3, 2016',
'June 30, 2016',
'September 24, 2015',
'December 17, 2016',
'February 21, 2018',
'September 27, 2016',
'January 11, 2018',
'May 7, 2018',
'August 2, 2017',
'August 29, 2017',
'June 5, 2017',
'January 26, 2017',
'April 30, 2014',
'June 18, 2017',
'October 12, 2017',
'August 28, 2015',
'July 18, 2017',
'February 27, 2016',
'June 23, 2017',
'March 8, 2017',
'April 17, 2018',
'March 6, 2018',
'April 13, 2018',
'April 11, 2018',
'December 22, 2017',
'February 27, 2018',
'December 21, 2017',
'October 19, 2015',
'November 30, 2017',
'April 12, 2017',
'June 28, 2017',
'March 14, 2017',
'October 15, 2017',
'July 28, 2017',
'March 16, 2018',
'August 6, 2018',
'June 4, 2018',
'November 22, 2016',
'February 1, 2018',
'June 29, 2017',
'July 14, 2017',
'October 6, 2017',
'July 12, 2017',
'August 31, 2017',
'November 22, 2017',
'March 7, 2017',
'October 4, 2017',
'July 22, 2016',
'May 18, 2017',
'February 2, 2018',
'February 18, 2016',
'March 15, 2017',
'March 5, 2016',
'February 2, 2016',
'January 13, 2017',
'July 13, 2017',
'December 1, 2015',
'June 17, 2015',
'March 23, 2017',
'July 3, 2017',
'September 8, 2016',
'September 3, 2015',
'November 14, 2014',
'December 13, 2017',
'August 2, 2016',
'February 9, 2016',
'August 12, 2015',
'August 24, 2015',
'June 16, 2016',
'May 22, 2013',
'August 4, 2017',
'October 28, 2016',
'December 9, 2014',
'December 9, 2017',
'December 30, 2016',
'February 5, 2016',
'April 14, 2016',
'February 11, 2016',
'November 30, 2014',
'April 6, 2018',
'October 3, 2016',
'June 17, 2017',
'September 21, 2017',
'November 15, 2017',
'August 7, 2014',
'December 6, 2017',
'December 3, 2014',
'April 18, 2017',
'January 24, 2016',
'October 22, 2014',
'November 22, 2012',
'August 18, 2015',
'December 16, 2015',
'November 5, 2013',
'May 26, 2015',
'March 14, 2018',
'August 5, 2017',
'August 11, 2017',
'December 8, 2016',
'August 3, 2015',
'October 5, 2017',
'June 11, 2016',
'August 2, 2014',
'September 14, 2017',
'September 6, 2014',
'January 2, 2018',
'July 26, 2013',
'March 2, 2017',
'October 3, 2017',
'May 6, 2015',
'January 14, 2018',
'May 9, 2017',
'October 2, 2017',
'October 10, 2017',
'October 13, 2016',
'October 17, 2016',
'December 8, 2017',
'March 24, 2018',
'October 22, 2013',
'September 6, 2016',
'December 23, 2017',
'April 4, 2018',
'June 1, 2017',
'April 24, 2018',
'September 26, 2017',
'January 18, 2015',
'March 14, 2015',
'May 10, 2015',
'February 25, 2017',
'April 16, 2018',
'September 12, 2016',
'November 20, 2017',
'October 25, 2016',
'January 20, 2015',
'January 30, 2018',
'June 8, 2016',
'February 29, 2016',
'December 5, 2017',
'July 25, 2015',
'December 1, 2017',
'March 5, 2015',
'January 22, 2018',
'February 6, 2018',
'July 29, 2015',
'November 8, 2017',
'November 2, 2016',
'January 25, 2016',
'July 29, 2017',
'August 11, 2015',
'November 10, 2017',
'March 25, 2016',
'May 5, 2018',
'February 10, 2015',
'March 3, 2017',
'February 11, 2015',
'October 19, 2016',
'October 17, 2015',
'April 6, 2017',
'February 11, 2018',
'November 6, 2014',
'March 21, 2017',
'July 18, 2016',
'September 8, 2017',
'January 7, 2016',
'March 16, 2017',
'August 23, 2016',
'December 5, 2016',
'December 6, 2016',
'July 14, 2016',
'March 21, 2016',
'July 5, 2016',
'November 13, 2017',
'July 14, 2015',
'August 10, 2016',
'November 21, 2014',
'January 17, 2016',
'July 27, 2016',
'November 13, 2014',
'March 27, 2017',
'January 3, 2017',
'May 12, 2017',
'April 22, 2014',
'July 11, 2017',
'November 18, 2017',
'August 10, 2015',
'September 17, 2017',
'February 5, 2018',
'April 28, 2017',
'August 7, 2018',
'September 5, 2016',
'May 12, 2016',
'March 18, 2018',
'April 25, 2014',
'December 2, 2017',
'September 25, 2017',
'March 9, 2017',
'December 10, 2017',
'January 22, 2017',
'November 1, 2016',
'August 24, 2016',
'October 20, 2016',
'December 7, 2016',
'May 11, 2016',
'April 4, 2014',
'January 7, 2015',
'March 17, 2018',
'December 24, 2016',
'May 1, 2014',
'November 28, 2016',
'June 24, 2014',
'October 29, 2017',
'May 27, 2016',
'October 9, 2017',
'August 10, 2017',
'April 22, 2016',
'April 14, 2017',
'March 15, 2018',
'August 7, 2016',
'December 11, 2016',
'December 19, 2015',
'October 30, 2017',
'September 30, 2013',
'November 12, 2017',
'October 18, 2016',
'December 25, 2016',
'May 19, 2018',
'April 25, 2016',
'August 8, 2016',
'January 8, 2018',
'November 1, 2017',
'January 9, 2017',
'August 18, 2016',
'December 30, 2017',
'January 7, 2017',
'April 1, 2018',
'March 19, 2018',
'October 31, 2017',
'November 19, 2017',
'December 3, 2015',
'February 13, 2015',
'February 3, 2015',
'June 3, 2016',
'October 30, 2014',
'January 13, 2018',
'March 11, 2016',
'May 25, 2017',
'August 9, 2016',
'February 19, 2018',
'November 2, 2017',
'December 4, 2016',
'August 26, 2016',
'January 5, 2017',
'April 22, 2018',
'June 16, 2017',
'May 13, 2018',
'September 13, 2017',
'September 12, 2014',
'November 24, 2017',
'June 11, 2015',
'April 12, 2016',
'May 19, 2017',
'May 4, 2015',
'August 19, 2017',
'December 22, 2016',
'October 22, 2016',
'August 16, 2015',
'September 2, 2017',
'March 31, 2016',
'June 20, 2017',
'August 26, 2017',
'July 31, 2014',
'May 13, 2017',
'June 24, 2017',
'December 16, 2017',
'April 4, 2016',
'September 26, 2015',
'January 20, 2016',
'June 3, 2017',
'August 31, 2016',
'September 22, 2017',
'May 16, 2014',
'March 2, 2018',
'January 18, 2018',
'November 26, 2015',
'May 3, 2017',
'October 23, 2017',
'October 6, 2016',
'February 21, 2017',
'August 5, 2015',
'December 26, 2017',
'July 24, 2016',
'October 7, 2016',
'December 15, 2016',
'January 28, 2014',
'April 21, 2017',
'March 15, 2016',
'July 19, 2016',
'July 12, 2016',
'December 7, 2017',
'January 25, 2017',
'September 8, 2013',
'September 1, 2015',
'September 26, 2016',
'April 10, 2013',
'October 21, 2017',
'December 7, 2015',
'January 1, 2016',
'September 30, 2017',
'April 7, 2016',
'November 3, 2017',
'February 8, 2017',
'December 14, 2015',
'May 19, 2015',
'November 20, 2015',
'February 4, 2018',
'September 10, 2017',
'January 4, 2016',
'December 19, 2017',
'January 1, 2018',
'September 7, 2017',
'November 16, 2016',
'October 22, 2017',
'April 30, 2018',
'October 20, 2017',
'December 12, 2017',
'March 12, 2018',
'May 14, 2014',
'October 17, 2014',
'July 23, 2016',
'June 17, 2018',
'May 8, 2017',
'January 13, 2014',
'May 1, 2016',
'April 21, 2016',
'January 11, 2017',
'November 17, 2017',
'August 22, 2013',
'April 4, 2017',
'June 6, 2016',
'September 7, 2015',
'April 2, 2016',
'February 12, 2017',
'December 4, 2015',
'March 11, 2018',
'March 20, 2017',
'July 9, 2017',
'January 12, 2018',
'May 17, 2017',
'July 15, 2016',
'February 9, 2018',
'March 28, 2017',
'May 25, 2015',
'July 1, 2015',
'March 6, 2017',
'February 15, 2016',
'December 26, 2014',
'May 31, 2017',
'August 20, 2017',
'December 3, 2011',
'April 25, 2017',
'September 14, 2015',
'May 6, 2018',
'April 14, 2018',
'February 12, 2018',
'March 16, 2015',
'August 4, 2016',
'April 1, 2017',
'May 16, 2017',
'March 4, 2017',
'July 12, 2014',
'March 16, 2016',
'December 3, 2017',
'December 8, 2015',
'May 15, 2017',
'February 21, 2014',
'May 14, 2017',
'September 24, 2017',
'September 16, 2014',
'June 20, 2016',
'April 28, 2018',
'May 29, 2017',
'August 7, 2013',
'February 27, 2017',
'July 8, 2016',
'January 31, 2017',
'September 19, 2012',
'February 12, 2016',
'August 14, 2017',
'November 15, 2014',
'April 3, 2017',
'October 24, 2017',
'April 20, 2016',
'August 25, 2015',
'February 24, 2016',
'August 19, 2014',
'November 8, 2012',
'September 27, 2013',
'September 29, 2016',
'May 14, 2013',
'April 8, 2018',
'June 25, 2017',
'March 3, 2018',
'September 11, 2017',
'February 5, 2014',
'October 7, 2017',
'January 28, 2018',
'February 24, 2018',
'January 23, 2017',
'September 20, 2014',
'June 22, 2017',
'November 19, 2016',
'September 3, 2017',
'January 4, 2017',
'April 11, 2014',
'February 26, 2014',
'December 31, 2017',
'January 25, 2015',
'October 19, 2017',
'March 4, 2018',
'November 13, 2015',
'July 28, 2015',
'August 1, 2017',
'November 5, 2014',
'July 31, 2016',
'June 30, 2017',
'April 8, 2016',
'March 13, 2017',
'July 10, 2014',
'July 10, 2015',
'November 3, 2015',
'June 15, 2016',
'June 21, 2016',
'February 23, 2017',
'February 2, 2017',
'September 15, 2016',
'December 31, 2016',
'October 8, 2012',
'July 9, 2014',
'November 23, 2016',
'July 19, 2017',
'December 11, 2015',
'July 30, 2016',
'January 8, 2015',
'June 2, 2017',
'November 27, 2015',
'June 8, 2017',
'October 28, 2014',
'July 30, 2015',
'December 28, 2015',
'July 28, 2014',
'August 20, 2015',
'December 17, 2013',
'May 7, 2016',
'May 3, 2014',
'September 25, 2013',
'December 21, 2016',
'July 26, 2016',
'September 17, 2015',
'April 25, 2013',
'May 26, 2014',
'August 9, 2014',
'November 20, 2013',
'September 30, 2016',
'March 23, 2016',
'January 19, 2014',
'December 31, 2015',
'January 4, 2018',
'December 13, 2013',
'November 12, 2013',
'June 27, 2017',
'December 31, 2014',
'January 24, 2014',
'January 1, 2015',
'October 9, 2015',
'December 10, 2015',
'June 15, 2015',
'August 1, 2013',
'October 26, 2016',
'December 9, 2016',
'January 25, 2013',
'December 19, 2013',
'June 29, 2016',
'November 28, 2012',
'May 1, 2017',
'May 2, 2017',
'November 20, 2014',
'March 20, 2015',
'March 31, 2017',
'June 9, 2017',
'May 23, 2017',
'May 5, 2017',
'June 26, 2017',
'April 30, 2017',
'October 28, 2017',
'May 12, 2011',
'June 21, 2017',
'October 1, 2013',
'May 11, 2017',
'January 10, 2018',
'April 22, 2017',
'May 26, 2017',
'November 4, 2017',
'June 3, 2015',
'September 25, 2015',
'February 18, 2013',
'March 7, 2016',
'May 4, 2017',
'January 27, 2018',
'June 13, 2016',
'March 24, 2017',
'June 4, 2013',
'August 15, 2016',
'September 29, 2017',
'March 17, 2017',
'September 7, 2016',
'November 11, 2016',
'February 26, 2017',
'April 26, 2015',
'March 1, 2016',
'March 10, 2018',
'May 2, 2015',
'September 11, 2013',
'February 15, 2015',
'March 25, 2017',
'June 24, 2015',
'February 17, 2018',
'October 8, 2016',
'April 5, 2017',
'March 10, 2016',
'April 10, 2015',
'October 21, 2016',
'May 10, 2017',
'February 23, 2016',
'March 11, 2014',
'December 23, 2016',
'June 2, 2016',
'March 8, 2016',
'May 14, 2015',
'August 30, 2015',
'August 12, 2014',
'March 22, 2016',
'November 1, 2013',
'August 14, 2016',
'August 31, 2013',
'July 19, 2015',
'July 30, 2017',
'January 19, 2016',
'November 4, 2015',
'August 15, 2017',
'October 14, 2015',
'June 22, 2016',
'February 23, 2014',
'September 22, 2011',
'January 23, 2016',
'May 24, 2017',
'September 30, 2014',
'December 26, 2016',
'July 18, 2013',
'December 3, 2016',
'July 26, 2015',
'April 2, 2015',
'June 6, 2017',
'November 26, 2017',
'December 2, 2014',
'May 22, 2017',
'January 26, 2018',
'May 14, 2016',
'July 1, 2016',
'September 18, 2017',
'September 5, 2017',
'August 3, 2016',
'April 8, 2017',
'September 22, 2016',
'March 6, 2014',
'September 19, 2013',
'August 4, 2014',
'May 17, 2016',
'July 6, 2017',
'September 15, 2017',
'September 4, 2013',
'June 6, 2015',
'July 15, 2015',
'October 20, 2015',
'February 14, 2017',
'February 8, 2016',
'October 12, 2015',
'October 26, 2015',
'July 4, 2017',
'November 11, 2015',
'October 2, 2014',
'July 8, 2017',
'December 19, 2016',
'November 26, 2012',
'November 25, 2017',
'February 23, 2015',
'August 18, 2017',
'December 1, 2016',
'February 16, 2017',
'August 31, 2015',
'July 6, 2015',
'October 27, 2015',
'June 13, 2014',
'July 21, 2016',
'December 21, 2015',
'August 5, 2016',
'October 5, 2016',
'April 11, 2016',
'April 17, 2014',
'February 18, 2017',
'August 13, 2015',
'March 28, 2016',
'December 14, 2016',
'November 16, 2015',
'July 2, 2017',
'August 13, 2016',
'May 30, 2016',
'September 23, 2015',
'September 29, 2015',
'November 2, 2015',
'April 15, 2016',
'February 18, 2015',
'August 15, 2013',
'October 5, 2015',
'October 8, 2015',
'February 19, 2016',
'April 9, 2012',
'January 19, 2015',
'January 12, 2016',
'May 16, 2016',
'April 29, 2017',
'December 18, 2015',
'October 7, 2015',
'September 13, 2015',
'July 22, 2017',
'December 12, 2016',
'November 10, 2016',
'May 26, 2016',
'January 27, 2016',
'January 16, 2016',
'January 29, 2016',
'November 12, 2014',
'September 4, 2017',
'June 18, 2015',
'March 31, 2015',
'June 9, 2015',
'February 22, 2016',
'October 4, 2015',
'August 28, 2016',
'July 26, 2017',
'April 23, 2017',
'November 9, 2015',
'June 14, 2015',
'May 25, 2016',
'July 5, 2017',
'November 12, 2015',
'June 12, 2017',
'March 19, 2017',
'October 2, 2015',
'July 11, 2015',
'June 14, 2016',
'September 23, 2017',
'March 29, 2017',
'December 15, 2015',
'November 9, 2016',
'September 17, 2016',
'October 30, 2015',
'November 10, 2014',
'October 13, 2015',
'November 19, 2015',
'August 16, 2016',
'November 29, 2016',
'February 6, 2017',
'November 26, 2014',
'October 3, 2015',
'September 22, 2014',
'May 8, 2015',
'August 12, 2016',
'December 2, 2016',
'July 7, 2016',
'March 30, 2015',
'April 20, 2015',
'January 12, 2017',
'March 20, 2014',
'January 6, 2017',
'May 23, 2016',
'August 8, 2015',
'June 10, 2015',
'July 16, 2016',
'March 22, 2015',
'February 3, 2016',
'February 7, 2016',
'April 14, 2015',
'July 18, 2014',
'June 5, 2014',
'July 1, 2013',
'February 20, 2017',
'May 6, 2013',
'April 24, 2016',
...],
'Type': ['Free', 'Paid', nan]}
data[data['Type'].isna()]
| Category | Rating | Reviews | Size | Installs | Type | Price | Content Rating | Last Updated | |
|---|---|---|---|---|---|---|---|---|---|
| 9148 | FAMILY | NaN | 0.0 | NaN | 0 | NaN | 0.0 | Everyone 10+ | June 28, 2018 |
data = data.drop(9148, axis=0).reset_index(drop=True)
data.isna().sum()
Category 0
Rating 1473
Reviews 0
Size 1694
Installs 0
Type 0
Price 0
Content Rating 0
Last Updated 0
dtype: int64
data['Rating'] = data['Rating'].fillna(data['Rating'].mean())
data['Size'] = data['Size'].fillna(data['Size'].mean())
data.isna().sum()
Category 0
Rating 0
Reviews 0
Size 0
Installs 0
Type 0
Price 0
Content Rating 0
Last Updated 0
dtype: int64
エンコード
get_uniques(data, get_categorical_columns(data))
{'Category': ['ART_AND_DESIGN',
'AUTO_AND_VEHICLES',
'BEAUTY',
'BOOKS_AND_REFERENCE',
'BUSINESS',
'COMICS',
'COMMUNICATION',
'DATING',
'EDUCATION',
'ENTERTAINMENT',
'EVENTS',
'FINANCE',
'FOOD_AND_DRINK',
'HEALTH_AND_FITNESS',
'HOUSE_AND_HOME',
'LIBRARIES_AND_DEMO',
'LIFESTYLE',
'GAME',
'FAMILY',
'MEDICAL',
'SOCIAL',
'SHOPPING',
'PHOTOGRAPHY',
'SPORTS',
'TRAVEL_AND_LOCAL',
'TOOLS',
'PERSONALIZATION',
'PRODUCTIVITY',
'PARENTING',
'WEATHER',
'VIDEO_PLAYERS',
'NEWS_AND_MAGAZINES',
'MAPS_AND_NAVIGATION'],
'Content Rating': ['Everyone',
'Teen',
'Everyone 10+',
'Mature 17+',
'Adults only 18+',
'Unrated'],
'Installs': ['10,000+',
'500,000+',
'5,000,000+',
'50,000,000+',
'100,000+',
'50,000+',
'1,000,000+',
'10,000,000+',
'5,000+',
'100,000,000+',
'1,000,000,000+',
'1,000+',
'500,000,000+',
'50+',
'100+',
'500+',
'10+',
'1+',
'5+',
'0+'],
'Last Updated': ['January 7, 2018',
'January 15, 2018',
'August 1, 2018',
'June 8, 2018',
'June 20, 2018',
'March 26, 2017',
'April 26, 2018',
'June 14, 2018',
'September 20, 2017',
'July 3, 2018',
'October 27, 2017',
'July 31, 2018',
'April 2, 2018',
'June 26, 2018',
'August 3, 2018',
'June 6, 2018',
'November 7, 2017',
'July 30, 2018',
'April 20, 2018',
'March 20, 2018',
'July 12, 2018',
'March 7, 2018',
'July 7, 2018',
'April 25, 2018',
'October 11, 2017',
'March 21, 2018',
'August 22, 2017',
'May 31, 2018',
'July 19, 2018',
'January 6, 2018',
'April 27, 2018',
'July 11, 2018',
'August 2, 2018',
'July 14, 2018',
'November 29, 2017',
'March 31, 2018',
'July 20, 2018',
'April 15, 2018',
'January 3, 2018',
'November 14, 2017',
'December 17, 2017',
'May 28, 2018',
'May 10, 2018',
'July 26, 2018',
'July 18, 2018',
'July 29, 2018',
'August 26, 2014',
'July 8, 2018',
'July 28, 2018',
'June 12, 2018',
'October 14, 2016',
'May 25, 2018',
'July 16, 2018',
'July 27, 2018',
'July 4, 2018',
'March 27, 2018',
'July 15, 2018',
'July 24, 2018',
'July 23, 2018',
'August 4, 2018',
'May 16, 2018',
'June 2, 2018',
'April 21, 2018',
'November 9, 2017',
'May 15, 2018',
'October 24, 2016',
'February 28, 2018',
'July 25, 2018',
'June 21, 2018',
'June 5, 2018',
'September 12, 2017',
'April 9, 2018',
'March 1, 2018',
'April 5, 2018',
'August 3, 2017',
'May 24, 2018',
'November 21, 2017',
'October 18, 2017',
'May 29, 2018',
'May 14, 2018',
'July 17, 2018',
'July 2, 2018',
'June 7, 2018',
'August 8, 2017',
'December 11, 2017',
'June 1, 2018',
'March 1, 2017',
'January 24, 2018',
'August 7, 2017',
'July 31, 2017',
'July 17, 2015',
'May 18, 2018',
'June 28, 2018',
'January 21, 2018',
'May 27, 2018',
'May 17, 2018',
'July 13, 2018',
'June 25, 2018',
'June 29, 2018',
'November 23, 2017',
'October 16, 2014',
'August 28, 2017',
'August 20, 2016',
'June 16, 2018',
'May 1, 2018',
'June 15, 2018',
'February 15, 2018',
'August 7, 2015',
'May 21, 2018',
'May 4, 2018',
'April 13, 2016',
'July 9, 2018',
'February 8, 2018',
'September 11, 2015',
'July 10, 2018',
'February 26, 2018',
'March 26, 2018',
'January 31, 2018',
'May 30, 2017',
'March 25, 2018',
'April 11, 2017',
'April 18, 2018',
'February 13, 2018',
'March 22, 2018',
'November 16, 2017',
'December 27, 2017',
'March 5, 2018',
'July 6, 2018',
'May 23, 2018',
'December 18, 2017',
'July 5, 2018',
'May 26, 2018',
'July 21, 2018',
'June 19, 2018',
'October 27, 2016',
'June 27, 2018',
'November 4, 2016',
'September 2, 2015',
'April 19, 2018',
'January 23, 2018',
'August 27, 2017',
'April 1, 2016',
'July 10, 2017',
'February 2, 2015',
'March 5, 2017',
'January 5, 2018',
'December 4, 2017',
'June 22, 2018',
'June 7, 2016',
'April 3, 2018',
'July 6, 2014',
'August 9, 2017',
'September 28, 2016',
'October 25, 2017',
'September 1, 2017',
'July 25, 2017',
'January 21, 2017',
'January 27, 2017',
'February 3, 2017',
'February 25, 2016',
'June 13, 2018',
'May 12, 2018',
'January 8, 2017',
'November 6, 2017',
'December 28, 2017',
'January 28, 2017',
'February 1, 2017',
'April 29, 2018',
'March 29, 2018',
'February 16, 2018',
'April 7, 2018',
'June 15, 2017',
'July 22, 2018',
'December 29, 2017',
'May 2, 2018',
'February 25, 2018',
'March 23, 2018',
'February 3, 2018',
'January 19, 2017',
'October 26, 2017',
'October 17, 2017',
'October 23, 2016',
'March 9, 2018',
'November 28, 2017',
'September 28, 2017',
'January 16, 2017',
'August 17, 2017',
'July 4, 2016',
'August 21, 2014',
'August 22, 2015',
'June 28, 2015',
'December 25, 2017',
'May 20, 2018',
'July 11, 2014',
'April 29, 2015',
'December 2, 2013',
'July 23, 2015',
'November 17, 2016',
'June 18, 2018',
'February 15, 2017',
'November 11, 2017',
'June 1, 2016',
'May 4, 2016',
'June 13, 2017',
'September 20, 2016',
'December 20, 2016',
'January 11, 2015',
'October 1, 2017',
'July 29, 2016',
'October 16, 2017',
'December 24, 2017',
'July 24, 2017',
'July 21, 2017',
'January 20, 2018',
'April 28, 2016',
'July 16, 2015',
'September 14, 2016',
'February 14, 2018',
'February 7, 2018',
'June 11, 2018',
'April 12, 2018',
'January 19, 2018',
'December 14, 2017',
'June 30, 2018',
'July 7, 2017',
'September 15, 2015',
'September 22, 2015',
'November 27, 2017',
'June 23, 2018',
'November 8, 2016',
'October 14, 2017',
'April 27, 2017',
'December 15, 2017',
'May 30, 2018',
'May 3, 2018',
'May 8, 2018',
'June 9, 2018',
'June 7, 2017',
'March 13, 2018',
'May 11, 2018',
'May 9, 2018',
'February 22, 2018',
'October 12, 2016',
'March 28, 2018',
'January 25, 2018',
'June 10, 2018',
'June 24, 2018',
'February 17, 2017',
'April 10, 2018',
'June 3, 2018',
'May 22, 2018',
'August 12, 2017',
'January 10, 2017',
'October 16, 2016',
'December 22, 2015',
'February 9, 2017',
'July 28, 2016',
'January 17, 2018',
'June 19, 2012',
'August 5, 2018',
'March 30, 2018',
'February 10, 2018',
'July 17, 2017',
'August 27, 2016',
'August 23, 2017',
'January 29, 2018',
'July 23, 2014',
'July 16, 2017',
'March 11, 2017',
'February 22, 2017',
'February 18, 2018',
'March 2, 2016',
'September 19, 2017',
'August 21, 2017',
'March 13, 2015',
'April 7, 2015',
'March 17, 2015',
'May 30, 2015',
'March 6, 2015',
'March 12, 2015',
'March 11, 2015',
'August 30, 2017',
'April 23, 2018',
'October 15, 2015',
'February 20, 2018',
'January 16, 2018',
'March 6, 2013',
'January 17, 2012',
'June 10, 2017',
'September 27, 2017',
'March 8, 2018',
'January 2, 2017',
'March 14, 2016',
'November 5, 2017',
'February 23, 2018',
'November 7, 2016',
'June 29, 2011',
'September 21, 2015',
'February 12, 2013',
'January 9, 2018',
'July 1, 2018',
'December 20, 2017',
'November 3, 2016',
'June 30, 2016',
'September 24, 2015',
'December 17, 2016',
'February 21, 2018',
'September 27, 2016',
'January 11, 2018',
'May 7, 2018',
'August 2, 2017',
'August 29, 2017',
'June 5, 2017',
'January 26, 2017',
'April 30, 2014',
'June 18, 2017',
'October 12, 2017',
'August 28, 2015',
'July 18, 2017',
'February 27, 2016',
'June 23, 2017',
'March 8, 2017',
'April 17, 2018',
'March 6, 2018',
'April 13, 2018',
'April 11, 2018',
'December 22, 2017',
'February 27, 2018',
'December 21, 2017',
'October 19, 2015',
'November 30, 2017',
'April 12, 2017',
'June 28, 2017',
'March 14, 2017',
'October 15, 2017',
'July 28, 2017',
'March 16, 2018',
'August 6, 2018',
'June 4, 2018',
'November 22, 2016',
'February 1, 2018',
'June 29, 2017',
'July 14, 2017',
'October 6, 2017',
'July 12, 2017',
'August 31, 2017',
'November 22, 2017',
'March 7, 2017',
'October 4, 2017',
'July 22, 2016',
'May 18, 2017',
'February 2, 2018',
'February 18, 2016',
'March 15, 2017',
'March 5, 2016',
'February 2, 2016',
'January 13, 2017',
'July 13, 2017',
'December 1, 2015',
'June 17, 2015',
'March 23, 2017',
'July 3, 2017',
'September 8, 2016',
'September 3, 2015',
'November 14, 2014',
'December 13, 2017',
'August 2, 2016',
'February 9, 2016',
'August 12, 2015',
'August 24, 2015',
'June 16, 2016',
'May 22, 2013',
'August 4, 2017',
'October 28, 2016',
'December 9, 2014',
'December 9, 2017',
'December 30, 2016',
'February 5, 2016',
'April 14, 2016',
'February 11, 2016',
'November 30, 2014',
'April 6, 2018',
'October 3, 2016',
'June 17, 2017',
'September 21, 2017',
'November 15, 2017',
'August 7, 2014',
'December 6, 2017',
'December 3, 2014',
'April 18, 2017',
'January 24, 2016',
'October 22, 2014',
'November 22, 2012',
'August 18, 2015',
'December 16, 2015',
'November 5, 2013',
'May 26, 2015',
'March 14, 2018',
'August 5, 2017',
'August 11, 2017',
'December 8, 2016',
'August 3, 2015',
'October 5, 2017',
'June 11, 2016',
'August 2, 2014',
'September 14, 2017',
'September 6, 2014',
'January 2, 2018',
'July 26, 2013',
'March 2, 2017',
'October 3, 2017',
'May 6, 2015',
'January 14, 2018',
'May 9, 2017',
'October 2, 2017',
'October 10, 2017',
'October 13, 2016',
'October 17, 2016',
'December 8, 2017',
'March 24, 2018',
'October 22, 2013',
'September 6, 2016',
'December 23, 2017',
'April 4, 2018',
'June 1, 2017',
'April 24, 2018',
'September 26, 2017',
'January 18, 2015',
'March 14, 2015',
'May 10, 2015',
'February 25, 2017',
'April 16, 2018',
'September 12, 2016',
'November 20, 2017',
'October 25, 2016',
'January 20, 2015',
'January 30, 2018',
'June 8, 2016',
'February 29, 2016',
'December 5, 2017',
'July 25, 2015',
'December 1, 2017',
'March 5, 2015',
'January 22, 2018',
'February 6, 2018',
'July 29, 2015',
'November 8, 2017',
'November 2, 2016',
'January 25, 2016',
'July 29, 2017',
'August 11, 2015',
'November 10, 2017',
'March 25, 2016',
'May 5, 2018',
'February 10, 2015',
'March 3, 2017',
'February 11, 2015',
'October 19, 2016',
'October 17, 2015',
'April 6, 2017',
'February 11, 2018',
'November 6, 2014',
'March 21, 2017',
'July 18, 2016',
'September 8, 2017',
'January 7, 2016',
'March 16, 2017',
'August 23, 2016',
'December 5, 2016',
'December 6, 2016',
'July 14, 2016',
'March 21, 2016',
'July 5, 2016',
'November 13, 2017',
'July 14, 2015',
'August 10, 2016',
'November 21, 2014',
'January 17, 2016',
'July 27, 2016',
'November 13, 2014',
'March 27, 2017',
'January 3, 2017',
'May 12, 2017',
'April 22, 2014',
'July 11, 2017',
'November 18, 2017',
'August 10, 2015',
'September 17, 2017',
'February 5, 2018',
'April 28, 2017',
'August 7, 2018',
'September 5, 2016',
'May 12, 2016',
'March 18, 2018',
'April 25, 2014',
'December 2, 2017',
'September 25, 2017',
'March 9, 2017',
'December 10, 2017',
'January 22, 2017',
'November 1, 2016',
'August 24, 2016',
'October 20, 2016',
'December 7, 2016',
'May 11, 2016',
'April 4, 2014',
'January 7, 2015',
'March 17, 2018',
'December 24, 2016',
'May 1, 2014',
'November 28, 2016',
'June 24, 2014',
'October 29, 2017',
'May 27, 2016',
'October 9, 2017',
'August 10, 2017',
'April 22, 2016',
'April 14, 2017',
'March 15, 2018',
'August 7, 2016',
'December 11, 2016',
'December 19, 2015',
'October 30, 2017',
'September 30, 2013',
'November 12, 2017',
'October 18, 2016',
'December 25, 2016',
'May 19, 2018',
'April 25, 2016',
'August 8, 2016',
'January 8, 2018',
'November 1, 2017',
'January 9, 2017',
'August 18, 2016',
'December 30, 2017',
'January 7, 2017',
'April 1, 2018',
'March 19, 2018',
'October 31, 2017',
'November 19, 2017',
'December 3, 2015',
'February 13, 2015',
'February 3, 2015',
'June 3, 2016',
'October 30, 2014',
'January 13, 2018',
'March 11, 2016',
'May 25, 2017',
'August 9, 2016',
'February 19, 2018',
'November 2, 2017',
'December 4, 2016',
'August 26, 2016',
'January 5, 2017',
'April 22, 2018',
'June 16, 2017',
'May 13, 2018',
'September 13, 2017',
'September 12, 2014',
'November 24, 2017',
'June 11, 2015',
'April 12, 2016',
'May 19, 2017',
'May 4, 2015',
'August 19, 2017',
'December 22, 2016',
'October 22, 2016',
'August 16, 2015',
'September 2, 2017',
'March 31, 2016',
'June 20, 2017',
'August 26, 2017',
'July 31, 2014',
'May 13, 2017',
'June 24, 2017',
'December 16, 2017',
'April 4, 2016',
'September 26, 2015',
'January 20, 2016',
'June 3, 2017',
'August 31, 2016',
'September 22, 2017',
'May 16, 2014',
'March 2, 2018',
'January 18, 2018',
'November 26, 2015',
'May 3, 2017',
'October 23, 2017',
'October 6, 2016',
'February 21, 2017',
'August 5, 2015',
'December 26, 2017',
'July 24, 2016',
'October 7, 2016',
'December 15, 2016',
'January 28, 2014',
'April 21, 2017',
'March 15, 2016',
'July 19, 2016',
'July 12, 2016',
'December 7, 2017',
'January 25, 2017',
'September 8, 2013',
'September 1, 2015',
'September 26, 2016',
'April 10, 2013',
'October 21, 2017',
'December 7, 2015',
'January 1, 2016',
'September 30, 2017',
'April 7, 2016',
'November 3, 2017',
'February 8, 2017',
'December 14, 2015',
'May 19, 2015',
'November 20, 2015',
'February 4, 2018',
'September 10, 2017',
'January 4, 2016',
'December 19, 2017',
'January 1, 2018',
'September 7, 2017',
'November 16, 2016',
'October 22, 2017',
'April 30, 2018',
'October 20, 2017',
'December 12, 2017',
'March 12, 2018',
'May 14, 2014',
'October 17, 2014',
'July 23, 2016',
'June 17, 2018',
'May 8, 2017',
'January 13, 2014',
'May 1, 2016',
'April 21, 2016',
'January 11, 2017',
'November 17, 2017',
'August 22, 2013',
'April 4, 2017',
'June 6, 2016',
'September 7, 2015',
'April 2, 2016',
'February 12, 2017',
'December 4, 2015',
'March 11, 2018',
'March 20, 2017',
'July 9, 2017',
'January 12, 2018',
'May 17, 2017',
'July 15, 2016',
'February 9, 2018',
'March 28, 2017',
'May 25, 2015',
'July 1, 2015',
'March 6, 2017',
'February 15, 2016',
'December 26, 2014',
'May 31, 2017',
'August 20, 2017',
'December 3, 2011',
'April 25, 2017',
'September 14, 2015',
'May 6, 2018',
'April 14, 2018',
'February 12, 2018',
'March 16, 2015',
'August 4, 2016',
'April 1, 2017',
'May 16, 2017',
'March 4, 2017',
'July 12, 2014',
'March 16, 2016',
'December 3, 2017',
'December 8, 2015',
'May 15, 2017',
'February 21, 2014',
'May 14, 2017',
'September 24, 2017',
'September 16, 2014',
'June 20, 2016',
'April 28, 2018',
'May 29, 2017',
'August 7, 2013',
'February 27, 2017',
'July 8, 2016',
'January 31, 2017',
'September 19, 2012',
'February 12, 2016',
'August 14, 2017',
'November 15, 2014',
'April 3, 2017',
'October 24, 2017',
'April 20, 2016',
'August 25, 2015',
'February 24, 2016',
'August 19, 2014',
'November 8, 2012',
'September 27, 2013',
'September 29, 2016',
'May 14, 2013',
'April 8, 2018',
'June 25, 2017',
'March 3, 2018',
'September 11, 2017',
'February 5, 2014',
'October 7, 2017',
'January 28, 2018',
'February 24, 2018',
'January 23, 2017',
'September 20, 2014',
'June 22, 2017',
'November 19, 2016',
'September 3, 2017',
'January 4, 2017',
'April 11, 2014',
'February 26, 2014',
'December 31, 2017',
'January 25, 2015',
'October 19, 2017',
'March 4, 2018',
'November 13, 2015',
'July 28, 2015',
'August 1, 2017',
'November 5, 2014',
'July 31, 2016',
'June 30, 2017',
'April 8, 2016',
'March 13, 2017',
'July 10, 2014',
'July 10, 2015',
'November 3, 2015',
'June 15, 2016',
'June 21, 2016',
'February 23, 2017',
'February 2, 2017',
'September 15, 2016',
'December 31, 2016',
'October 8, 2012',
'July 9, 2014',
'November 23, 2016',
'July 19, 2017',
'December 11, 2015',
'July 30, 2016',
'January 8, 2015',
'June 2, 2017',
'November 27, 2015',
'June 8, 2017',
'October 28, 2014',
'July 30, 2015',
'December 28, 2015',
'July 28, 2014',
'August 20, 2015',
'December 17, 2013',
'May 7, 2016',
'May 3, 2014',
'September 25, 2013',
'December 21, 2016',
'July 26, 2016',
'September 17, 2015',
'April 25, 2013',
'May 26, 2014',
'August 9, 2014',
'November 20, 2013',
'September 30, 2016',
'March 23, 2016',
'January 19, 2014',
'December 31, 2015',
'January 4, 2018',
'December 13, 2013',
'November 12, 2013',
'June 27, 2017',
'December 31, 2014',
'January 24, 2014',
'January 1, 2015',
'October 9, 2015',
'December 10, 2015',
'June 15, 2015',
'August 1, 2013',
'October 26, 2016',
'December 9, 2016',
'January 25, 2013',
'December 19, 2013',
'June 29, 2016',
'November 28, 2012',
'May 1, 2017',
'May 2, 2017',
'November 20, 2014',
'March 20, 2015',
'March 31, 2017',
'June 9, 2017',
'May 23, 2017',
'May 5, 2017',
'June 26, 2017',
'April 30, 2017',
'October 28, 2017',
'May 12, 2011',
'June 21, 2017',
'October 1, 2013',
'May 11, 2017',
'January 10, 2018',
'April 22, 2017',
'May 26, 2017',
'November 4, 2017',
'June 3, 2015',
'September 25, 2015',
'February 18, 2013',
'March 7, 2016',
'May 4, 2017',
'January 27, 2018',
'June 13, 2016',
'March 24, 2017',
'June 4, 2013',
'August 15, 2016',
'September 29, 2017',
'March 17, 2017',
'September 7, 2016',
'November 11, 2016',
'February 26, 2017',
'April 26, 2015',
'March 1, 2016',
'March 10, 2018',
'May 2, 2015',
'September 11, 2013',
'February 15, 2015',
'March 25, 2017',
'June 24, 2015',
'February 17, 2018',
'October 8, 2016',
'April 5, 2017',
'March 10, 2016',
'April 10, 2015',
'October 21, 2016',
'May 10, 2017',
'February 23, 2016',
'March 11, 2014',
'December 23, 2016',
'June 2, 2016',
'March 8, 2016',
'May 14, 2015',
'August 30, 2015',
'August 12, 2014',
'March 22, 2016',
'November 1, 2013',
'August 14, 2016',
'August 31, 2013',
'July 19, 2015',
'July 30, 2017',
'January 19, 2016',
'November 4, 2015',
'August 15, 2017',
'October 14, 2015',
'June 22, 2016',
'February 23, 2014',
'September 22, 2011',
'January 23, 2016',
'May 24, 2017',
'September 30, 2014',
'December 26, 2016',
'July 18, 2013',
'December 3, 2016',
'July 26, 2015',
'April 2, 2015',
'June 6, 2017',
'November 26, 2017',
'December 2, 2014',
'May 22, 2017',
'January 26, 2018',
'May 14, 2016',
'July 1, 2016',
'September 18, 2017',
'September 5, 2017',
'August 3, 2016',
'April 8, 2017',
'September 22, 2016',
'March 6, 2014',
'September 19, 2013',
'August 4, 2014',
'May 17, 2016',
'July 6, 2017',
'September 15, 2017',
'September 4, 2013',
'June 6, 2015',
'July 15, 2015',
'October 20, 2015',
'February 14, 2017',
'February 8, 2016',
'October 12, 2015',
'October 26, 2015',
'July 4, 2017',
'November 11, 2015',
'October 2, 2014',
'July 8, 2017',
'December 19, 2016',
'November 26, 2012',
'November 25, 2017',
'February 23, 2015',
'August 18, 2017',
'December 1, 2016',
'February 16, 2017',
'August 31, 2015',
'July 6, 2015',
'October 27, 2015',
'June 13, 2014',
'July 21, 2016',
'December 21, 2015',
'August 5, 2016',
'October 5, 2016',
'April 11, 2016',
'April 17, 2014',
'February 18, 2017',
'August 13, 2015',
'March 28, 2016',
'December 14, 2016',
'November 16, 2015',
'July 2, 2017',
'August 13, 2016',
'May 30, 2016',
'September 23, 2015',
'September 29, 2015',
'November 2, 2015',
'April 15, 2016',
'February 18, 2015',
'August 15, 2013',
'October 5, 2015',
'October 8, 2015',
'February 19, 2016',
'April 9, 2012',
'January 19, 2015',
'January 12, 2016',
'May 16, 2016',
'April 29, 2017',
'December 18, 2015',
'October 7, 2015',
'September 13, 2015',
'July 22, 2017',
'December 12, 2016',
'November 10, 2016',
'May 26, 2016',
'January 27, 2016',
'January 16, 2016',
'January 29, 2016',
'November 12, 2014',
'September 4, 2017',
'June 18, 2015',
'March 31, 2015',
'June 9, 2015',
'February 22, 2016',
'October 4, 2015',
'August 28, 2016',
'July 26, 2017',
'April 23, 2017',
'November 9, 2015',
'June 14, 2015',
'May 25, 2016',
'July 5, 2017',
'November 12, 2015',
'June 12, 2017',
'March 19, 2017',
'October 2, 2015',
'July 11, 2015',
'June 14, 2016',
'September 23, 2017',
'March 29, 2017',
'December 15, 2015',
'November 9, 2016',
'September 17, 2016',
'October 30, 2015',
'November 10, 2014',
'October 13, 2015',
'November 19, 2015',
'August 16, 2016',
'November 29, 2016',
'February 6, 2017',
'November 26, 2014',
'October 3, 2015',
'September 22, 2014',
'May 8, 2015',
'August 12, 2016',
'December 2, 2016',
'July 7, 2016',
'March 30, 2015',
'April 20, 2015',
'January 12, 2017',
'March 20, 2014',
'January 6, 2017',
'May 23, 2016',
'August 8, 2015',
'June 10, 2015',
'July 16, 2016',
'March 22, 2015',
'February 3, 2016',
'February 7, 2016',
'April 14, 2015',
'July 18, 2014',
'June 5, 2014',
'July 1, 2013',
'February 20, 2017',
'May 6, 2013',
'April 24, 2016',
...],
'Type': ['Free', 'Paid']}
import re
data['Month'] = data['Last Updated'].apply(lambda x: re.search('^[^\s]+', x).group(0))
data['Year'] = data['Last Updated'].apply(lambda x: re.search('[^\s]+$', x).group(0))
data = data.drop('Last Updated', axis=1)
label_encoder = sp.LabelEncoder()
data['Category'] = label_encoder.fit_transform(data['Category'])
category_mapping = {index: label for index, label in enumerate(label_encoder.classes_)}
category_mapping
{0: 'ART_AND_DESIGN',
1: 'AUTO_AND_VEHICLES',
2: 'BEAUTY',
3: 'BOOKS_AND_REFERENCE',
4: 'BUSINESS',
5: 'COMICS',
6: 'COMMUNICATION',
7: 'DATING',
8: 'EDUCATION',
9: 'ENTERTAINMENT',
10: 'EVENTS',
11: 'FAMILY',
12: 'FINANCE',
13: 'FOOD_AND_DRINK',
14: 'GAME',
15: 'HEALTH_AND_FITNESS',
16: 'HOUSE_AND_HOME',
17: 'LIBRARIES_AND_DEMO',
18: 'LIFESTYLE',
19: 'MAPS_AND_NAVIGATION',
20: 'MEDICAL',
21: 'NEWS_AND_MAGAZINES',
22: 'PARENTING',
23: 'PERSONALIZATION',
24: 'PHOTOGRAPHY',
25: 'PRODUCTIVITY',
26: 'SHOPPING',
27: 'SOCIAL',
28: 'SPORTS',
29: 'TOOLS',
30: 'TRAVEL_AND_LOCAL',
31: 'VIDEO_PLAYERS',
32: 'WEATHER'}
def binary_encoding(df, column, positive_value):
df = df.copy()
df[column] = df[column].apply(lambda x: 1 if x == positive_value else 0)
return df
def ordinal_encoding(df, column, ordering):
df = df.copy()
df[column] = data[column].apply(lambda x: ordering.index(x))
return df
get_uniques(data, get_categorical_columns(data))
{'Content Rating': ['Everyone',
'Teen',
'Everyone 10+',
'Mature 17+',
'Adults only 18+',
'Unrated'],
'Installs': ['10,000+',
'500,000+',
'5,000,000+',
'50,000,000+',
'100,000+',
'50,000+',
'1,000,000+',
'10,000,000+',
'5,000+',
'100,000,000+',
'1,000,000,000+',
'1,000+',
'500,000,000+',
'50+',
'100+',
'500+',
'10+',
'1+',
'5+',
'0+'],
'Month': ['January',
'August',
'June',
'March',
'April',
'September',
'July',
'October',
'November',
'May',
'December',
'February'],
'Type': ['Free', 'Paid'],
'Year': ['2018',
'2017',
'2014',
'2016',
'2015',
'2013',
'2012',
'2011',
'2010']}
installs_ordering = [
'0+',
'1+',
'5+',
'10+',
'50+',
'100+',
'500+',
'1,000+',
'5,000+',
'10,000+',
'50,000+',
'100,000+',
'500,000+',
'1,000,000+',
'5,000,000+',
'10,000,000+',
'50,000,000+',
'100,000,000+',
'500,000,000+',
'1,000,000,000+',
]
rating_ordering = [
'Everyone',
'Everyone 10+',
'Teen',
'Mature 17+',
'Adults only 18+',
'Unrated'
]
month_ordering = [
'January',
'February',
'March',
'April',
'May',
'June',
'July',
'August',
'September',
'October',
'November',
'December',
]
data = binary_encoding(data, 'Type', 'Paid')
data = ordinal_encoding(data, 'Installs', installs_ordering)
data = ordinal_encoding(data, 'Content Rating', rating_ordering)
data = ordinal_encoding(data, 'Month', month_ordering)
分割とスケーリング
y = data['Category']
X = data.drop('Category', axis=1)
scaler = sp.StandardScaler()
X = pd.DataFrame(scaler.fit_transform(X), columns=X.columns)
X_train, X_test, y_train, y_test = train_test_split(X, y, train_size=0.7)
トレーニング
X.shape
(10839, 9)
model = tf.keras.Sequential([
tf.keras.layers.Dense(64, activation='relu', input_shape=(9,)),
tf.keras.layers.Dense(64, activation='relu'),
tf.keras.layers.Dense(33, activation='softmax'),
])
model.summary()
model.compile(
optimizer='adam',
loss='sparse_categorical_crossentropy',
metrics=['accuracy'],
)
batch_size = 64
epochs = 100
history = model.fit(
X_train,
y_train,
validation_split=0.2,
batch_size=batch_size,
epochs=epochs,
callbacks=[tf.keras.callbacks.ReduceLROnPlateau()],
verbose=0,
)
Model: "sequential_2"
_________________________________________________________________
Layer (type) Output Shape Param #
=================================================================
dense_6 (Dense) (None, 64) 640
_________________________________________________________________
dense_7 (Dense) (None, 64) 4160
_________________________________________________________________
dense_8 (Dense) (None, 33) 2145
=================================================================
Total params: 6,945
Trainable params: 6,945
Non-trainable params: 0
_________________________________________________________________
結果
plt.figure(figsize=(14, 10))
epochs_range = range(1, epochs+1)
train_loss = history.history['loss']
val_loss = history.history['val_loss']
plt.plot(epochs_range, train_loss, label='Training Loss')
plt.plot(epochs_range, val_loss, label='Validation Loss')
plt.title('Training and Validation Loss')
plt.xlabel('Epoch')
plt.ylabel('Loss')
plt.legend()
plt.show()
model.evaluate(X_test, y_test)
102/102 [==============================] - 0s 2ms/step - loss: 2.6756 - accuracy: 0.2555
[2.6756021976470947, 0.2555350661277771]