LoginSignup
1

More than 3 years have passed since last update.

Data Every Day: Googleプレイストアアプリ

Posted at

tldr

KggleのGoogle Play Store AppsApp 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()

png

model.evaluate(X_test, y_test)
102/102 [==============================] - 0s 2ms/step - loss: 2.6756 - accuracy: 0.2555





[2.6756021976470947, 0.2555350661277771]

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1