使用ライブラリのインポート

In [2]:
import numpy as np
import matplotlib.pyplot as plt
import pandas as pd
import scipy.stats as ss
import statsmodels.api as sm
import seaborn as sns

  ## データの読み込み(from googleplaystore.csv)

In [3]:
data_store = pd.read_csv("googleplaystore.csv", header=0)
data_customer = pd.read_csv("googleplaystore_user_reviews.csv")
#Data version 5 from kaggle

欠損値検査

In [4]:
def lack_table(df): 
    import pandas
    '''
    This function is caliculation of lack values from raw data.
    
    Library: pandas, numpy
    
    params
    ---------
    df : DataFrame
            raw data set.
    
    Returns
    --------
    lack_table_ren_columns: pandas.DataFrame
                            Return results lack of raw data.
    '''
    null_val = df.isnull().sum()
    percent = 100 * df.isnull().sum()/len(df)
    lack_table = pandas.concat([null_val, percent], axis=1)
    lack_table_ren_columns = lack_table.rename(
    columns = {0 : '欠損数', 1 : '%'})
    return lack_table_ren_columns
In [5]:
lack_table(data_store)
Out[5]:
欠損数 %
App 0 0.000000
Category 0 0.000000
Rating 1474 13.596532
Reviews 0 0.000000
Size 0 0.000000
Installs 0 0.000000
Type 1 0.009224
Price 0 0.000000
Content Rating 1 0.009224
Genres 0 0.000000
Last Updated 0 0.000000
Current Ver 8 0.073794
Android Ver 3 0.027673
In [6]:
lack_table(data_customer)
Out[6]:
欠損数 %
App 0 0.000000
Translated_Review 26868 41.788631
Sentiment 26863 41.780854
Sentiment_Polarity 26863 41.780854
Sentiment_Subjectivity 26863 41.780854

欠損値処理

Data store
In [7]:
data_store["Rating"] = data_store["Rating"].fillna(data_store["Rating"].median())
data_store["Type"] = data_store["Type"].fillna("Free")
data_store["Content Rating"] = data_store["Content Rating"].fillna("Everyone")
data_store["Current Ver"] = data_store["Current Ver"].fillna("unknown")
data_store["Android Ver"].loc[4453] = "Only custom farm ware 8.1or 9.0 "
data_store["Android Ver"].loc[4490] = "4.0.3 and up"
data_store["Android Ver"].loc[10472] = "4.0 and up"
data_store["Rating"].loc[10472] = 4.7
data_store["Category"].loc[10472] = "TOOLS"
data_store["Reviews"].loc[10472] = "19"
data_store["Size"].loc[10472] = "3.0M"
data_store["Installs"].loc[10472] = "1,000+"
data_store["Type"].loc[10472] = "Free"
data_store["Price"].loc[10472] = 0
data_store["Content Rating"].loc[10472] = "Everyone"
data_store["Genres"].loc[10472] = "Everyone"
data_store["Last Updated"].loc[10472] = "February 11, 2018"
data_store["Current Ver"].loc[10472] = "1.0.19"
/Users/kozuzu931/.pyenv/versions/anaconda3-4.3.1/lib/python3.6/site-packages/pandas/core/indexing.py:189: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
  self._setitem_with_indexer(indexer, value)

Data customer

In [8]:
data_customer["Translated_Review"] = data_customer["Translated_Review"].fillna("No comments")
data_customer["Sentiment"] = data_customer["Sentiment"].fillna("No comments")
data_customer["Sentiment_Polarity"] = data_customer["Sentiment_Polarity"].fillna("No comments")
data_customer["Sentiment_Subjectivity"] = data_customer["Sentiment_Subjectivity"].fillna("No comments")

欠損値処理確認

In [9]:
lack_table(data_store)
Out[9]:
欠損数 %
App 0 0.0
Category 0 0.0
Rating 0 0.0
Reviews 0 0.0
Size 0 0.0
Installs 0 0.0
Type 0 0.0
Price 0 0.0
Content Rating 0 0.0
Genres 0 0.0
Last Updated 0 0.0
Current Ver 0 0.0
Android Ver 0 0.0
In [10]:
lack_table(data_customer)
Out[10]:
欠損数 %
App 0 0.0
Translated_Review 0 0.0
Sentiment 0 0.0
Sentiment_Polarity 0 0.0
Sentiment_Subjectivity 0 0.0

スタージェスの公式関数

In [11]:
def sturges(line_length):
    '''
    This function is caliculation of suitable bin value with formula of Sturges.
    
    parames
    ----------
    line_length: int
    
    Returns
    ---------
    suitable_bins: int
    '''
    suitable_bins = int((1 + np.log2(line_length)))
    return suitable_bins

Store data analysis

In [12]:
data_store
Out[12]:
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
5 Paper flowers instructions ART_AND_DESIGN 4.4 167 5.6M 50,000+ Free 0 Everyone Art & Design March 26, 2017 1.0 2.3 and up
6 Smoke Effect Photo Maker - Smoke Editor ART_AND_DESIGN 3.8 178 19M 50,000+ Free 0 Everyone Art & Design April 26, 2018 1.1 4.0.3 and up
7 Infinite Painter ART_AND_DESIGN 4.1 36815 29M 1,000,000+ Free 0 Everyone Art & Design June 14, 2018 6.1.61.1 4.2 and up
8 Garden Coloring Book ART_AND_DESIGN 4.4 13791 33M 1,000,000+ Free 0 Everyone Art & Design September 20, 2017 2.9.2 3.0 and up
9 Kids Paint Free - Drawing Fun ART_AND_DESIGN 4.7 121 3.1M 10,000+ Free 0 Everyone Art & Design;Creativity July 3, 2018 2.8 4.0.3 and up
10 Text on Photo - Fonteee ART_AND_DESIGN 4.4 13880 28M 1,000,000+ Free 0 Everyone Art & Design October 27, 2017 1.0.4 4.1 and up
11 Name Art Photo Editor - Focus n Filters ART_AND_DESIGN 4.4 8788 12M 1,000,000+ Free 0 Everyone Art & Design July 31, 2018 1.0.15 4.0 and up
12 Tattoo Name On My Photo Editor ART_AND_DESIGN 4.2 44829 20M 10,000,000+ Free 0 Teen Art & Design April 2, 2018 3.8 4.1 and up
13 Mandala Coloring Book ART_AND_DESIGN 4.6 4326 21M 100,000+ Free 0 Everyone Art & Design June 26, 2018 1.0.4 4.4 and up
14 3D Color Pixel by Number - Sandbox Art Coloring ART_AND_DESIGN 4.4 1518 37M 100,000+ Free 0 Everyone Art & Design August 3, 2018 1.2.3 2.3 and up
15 Learn To Draw Kawaii Characters ART_AND_DESIGN 3.2 55 2.7M 5,000+ Free 0 Everyone Art & Design June 6, 2018 unknown 4.2 and up
16 Photo Designer - Write your name with shapes ART_AND_DESIGN 4.7 3632 5.5M 500,000+ Free 0 Everyone Art & Design July 31, 2018 3.1 4.1 and up
17 350 Diy Room Decor Ideas ART_AND_DESIGN 4.5 27 17M 10,000+ Free 0 Everyone Art & Design November 7, 2017 1.0 2.3 and up
18 FlipaClip - Cartoon animation ART_AND_DESIGN 4.3 194216 39M 5,000,000+ Free 0 Everyone Art & Design August 3, 2018 2.2.5 4.0.3 and up
19 ibis Paint X ART_AND_DESIGN 4.6 224399 31M 10,000,000+ Free 0 Everyone Art & Design July 30, 2018 5.5.4 4.1 and up
20 Logo Maker - Small Business ART_AND_DESIGN 4.0 450 14M 100,000+ Free 0 Everyone Art & Design April 20, 2018 4.0 4.1 and up
21 Boys Photo Editor - Six Pack & Men's Suit ART_AND_DESIGN 4.1 654 12M 100,000+ Free 0 Everyone Art & Design March 20, 2018 1.1 4.0.3 and up
22 Superheroes Wallpapers | 4K Backgrounds ART_AND_DESIGN 4.7 7699 4.2M 500,000+ Free 0 Everyone 10+ Art & Design July 12, 2018 2.2.6.2 4.0.3 and up
23 Mcqueen Coloring pages ART_AND_DESIGN 4.3 61 7.0M 100,000+ Free 0 Everyone Art & Design;Action & Adventure March 7, 2018 1.0.0 4.1 and up
24 HD Mickey Minnie Wallpapers ART_AND_DESIGN 4.7 118 23M 50,000+ Free 0 Everyone Art & Design July 7, 2018 1.1.3 4.1 and up
25 Harley Quinn wallpapers HD ART_AND_DESIGN 4.8 192 6.0M 10,000+ Free 0 Everyone Art & Design April 25, 2018 1.5 3.0 and up
26 Colorfit - Drawing & Coloring ART_AND_DESIGN 4.7 20260 25M 500,000+ Free 0 Everyone Art & Design;Creativity October 11, 2017 1.0.8 4.0.3 and up
27 Animated Photo Editor ART_AND_DESIGN 4.1 203 6.1M 100,000+ Free 0 Everyone Art & Design March 21, 2018 1.03 4.0.3 and up
28 Pencil Sketch Drawing ART_AND_DESIGN 3.9 136 4.6M 10,000+ Free 0 Everyone Art & Design July 12, 2018 6.0 2.3 and up
29 Easy Realistic Drawing Tutorial ART_AND_DESIGN 4.1 223 4.2M 100,000+ Free 0 Everyone Art & Design August 22, 2017 1.0 2.3 and up
... ... ... ... ... ... ... ... ... ... ... ... ... ...
10811 FR Plus 1.6 AUTO_AND_VEHICLES 4.3 4 3.9M 100+ Free 0 Everyone Auto & Vehicles July 24, 2018 1.3.6 4.4W and up
10812 Fr Agnel Pune FAMILY 4.1 80 13M 1,000+ Free 0 Everyone Education June 13, 2018 2.0.20 4.0.3 and up
10813 DICT.fr Mobile BUSINESS 4.3 20 2.7M 10,000+ Free 0 Everyone Business July 17, 2018 2.1.10 4.1 and up
10814 FR: My Secret Pets! FAMILY 4.0 785 31M 50,000+ Free 0 Teen Entertainment June 3, 2015 1.3.1 3.0 and up
10815 Golden Dictionary (FR-AR) BOOKS_AND_REFERENCE 4.2 5775 4.9M 500,000+ Free 0 Everyone Books & Reference July 19, 2018 7.0.4.6 4.2 and up
10816 FieldBi FR Offline BUSINESS 4.3 2 6.8M 100+ Free 0 Everyone Business August 6, 2018 2.1.8 4.1 and up
10817 HTC Sense Input - FR TOOLS 4.0 885 8.0M 100,000+ Free 0 Everyone Tools October 30, 2015 1.0.612928 5.0 and up
10818 Gold Quote - Gold.fr FINANCE 4.3 96 1.5M 10,000+ Free 0 Everyone Finance May 19, 2016 2.3 2.2 and up
10819 Fanfic-FR BOOKS_AND_REFERENCE 3.3 52 3.6M 5,000+ Free 0 Teen Books & Reference August 5, 2017 0.3.4 4.1 and up
10820 Fr. Daoud Lamei FAMILY 5.0 22 8.6M 1,000+ Free 0 Teen Education June 27, 2018 3.8.0 4.1 and up
10821 Poop FR FAMILY 4.3 6 2.5M 50+ Free 0 Everyone Entertainment May 29, 2018 1.0 4.0.3 and up
10822 PLMGSS FR PRODUCTIVITY 4.3 0 3.1M 10+ Free 0 Everyone Productivity December 1, 2017 1 4.4 and up
10823 List iptv FR VIDEO_PLAYERS 4.3 1 2.9M 100+ Free 0 Everyone Video Players & Editors April 22, 2018 1.0 4.0.3 and up
10824 Cardio-FR MEDICAL 4.3 67 82M 10,000+ Free 0 Everyone Medical July 31, 2018 2.2.2 4.4 and up
10825 Naruto & Boruto FR SOCIAL 4.3 7 7.7M 100+ Free 0 Teen Social February 2, 2018 1.0 4.0 and up
10826 Frim: get new friends on local chat rooms SOCIAL 4.0 88486 Varies with device 5,000,000+ Free 0 Mature 17+ Social March 23, 2018 Varies with device Varies with device
10827 Fr Agnel Ambarnath FAMILY 4.2 117 13M 5,000+ Free 0 Everyone Education June 13, 2018 2.0.20 4.0.3 and up
10828 Manga-FR - Anime Vostfr COMICS 3.4 291 13M 10,000+ Free 0 Everyone Comics May 15, 2017 2.0.1 4.0 and up
10829 Bulgarian French Dictionary Fr BOOKS_AND_REFERENCE 4.6 603 7.4M 10,000+ Free 0 Everyone Books & Reference June 19, 2016 2.96 4.1 and up
10830 News Minecraft.fr NEWS_AND_MAGAZINES 3.8 881 2.3M 100,000+ Free 0 Everyone News & Magazines January 20, 2014 1.5 1.6 and up
10831 payermonstationnement.fr MAPS_AND_NAVIGATION 4.3 38 9.8M 5,000+ Free 0 Everyone Maps & Navigation June 13, 2018 2.0.148.0 4.0 and up
10832 FR Tides WEATHER 3.8 1195 582k 100,000+ Free 0 Everyone Weather February 16, 2014 6.0 2.1 and up
10833 Chemin (fr) BOOKS_AND_REFERENCE 4.8 44 619k 1,000+ Free 0 Everyone Books & Reference March 23, 2014 0.8 2.2 and up
10834 FR Calculator FAMILY 4.0 7 2.6M 500+ Free 0 Everyone Education June 18, 2017 1.0.0 4.1 and up
10835 FR Forms BUSINESS 4.3 0 9.6M 10+ Free 0 Everyone Business September 29, 2016 1.1.5 4.0 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 4.3 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

In [13]:
app_names_list = data_store["App"].unique()
print("google play storeアプリタイトル数: {} apps".format(len(app_names_list)))
google play storeアプリタイトル数: 9660 apps

カテゴリー

In [14]:
category_names_list = data_store["Category"].unique()
print("google play storeカテゴリー数: {}".format(category_names_list))
google play storeカテゴリー数: ['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']
In [15]:
category_data = data_store.groupby("Category").count()
category_values = np.sort(category_data["App"].values)
sorted_category_name = category_data.App.sort_values().index.values
category_name_position = np.arange(0, len(sorted_category_name))
width = 0.5
In [16]:
category_values
Out[16]:
array([  53,   60,   60,   64,   65,   82,   85,   85,   88,  127,  137,
        149,  156,  175,  231,  234,  258,  260,  283,  295,  335,  341,
        366,  382,  384,  387,  392,  424,  460,  463,  844, 1144, 1972])
In [17]:
plt.barh(category_name_position + width, category_values, width, tick_label=sorted_category_name)
plt.xticks(fontsize=8)
plt.yticks(fontsize=7)
plt.xlabel("Frequency", fontsize=10)
plt.ylabel("Categorys", fontsize=10)
plt.title("Category groups Histgram", fontsize=10)
plt.show()
In [18]:
Category_sets = pd.DataFrame(category_values[::-1], index=sorted_category_name[::-1])
Category_sets
Out[18]:
0
FAMILY 1972
GAME 1144
TOOLS 844
MEDICAL 463
BUSINESS 460
PRODUCTIVITY 424
PERSONALIZATION 392
COMMUNICATION 387
SPORTS 384
LIFESTYLE 382
FINANCE 366
HEALTH_AND_FITNESS 341
PHOTOGRAPHY 335
SOCIAL 295
NEWS_AND_MAGAZINES 283
SHOPPING 260
TRAVEL_AND_LOCAL 258
DATING 234
BOOKS_AND_REFERENCE 231
VIDEO_PLAYERS 175
EDUCATION 156
ENTERTAINMENT 149
MAPS_AND_NAVIGATION 137
FOOD_AND_DRINK 127
HOUSE_AND_HOME 88
LIBRARIES_AND_DEMO 85
AUTO_AND_VEHICLES 85
WEATHER 82
ART_AND_DESIGN 65
EVENTS 64
COMICS 60
PARENTING 60
BEAUTY 53

レーティング(評価)

In [19]:
Rating_stastitics = pd.DataFrame(pd.Series(data_store["Rating"].ravel()).describe()).transpose()
Rating_stastitics
Out[19]:
count mean std min 25% 50% 75% max
0 10841.0 4.206522 0.480343 1.0 4.1 4.3 4.5 5.0
In [20]:
Rating_score_hist = plt.hist(data_store["Rating"])
plt.vlines(x=[data_store["Rating"].mean()], ymin=0.0, ymax=5600.0, colors="m", linestyle=":", label="mean")
plt.vlines(x=[data_store["Rating"].median()], ymin=0.0, ymax=5600.0, colors="c", linestyle="-", label="median")
for x, y in zip(Rating_score_hist[1], Rating_score_hist[0]):
    plt.text(x, y, y, ha="left", va="bottom", fontsize=8)
plt.xlabel("Rating score", fontsize=10)
plt.ylabel("Frequency", fontsize=10)
plt.xticks(fontsize=8)
plt.yticks(fontsize=8)
plt.title("Rating score Histgram", fontsize=10)
plt.legend(fontsize=10)
plt.show()

レビュー数

In [21]:
pd.DataFrame(data_store.sort_values("Reviews", ascending=False))
Out[21]:
App Category Rating Reviews Size Installs Type Price Content Rating Genres Last Updated Current Ver Android Ver
2989 GollerCepte Live Score SPORTS 4.2 9992 31M 1,000,000+ Free 0 Everyone Sports May 23, 2018 6.5 4.1 and up
4970 Ad Block REMOVER - NEED ROOT TOOLS 3.3 999 91k 100,000+ Free 0 Everyone Tools December 17, 2013 3.2 2.2 and up
2705 SnipSnap Coupon App SHOPPING 4.2 9975 18M 1,000,000+ Free 0 Everyone Shopping January 22, 2018 1.4 4.3 and up
2723 SnipSnap Coupon App SHOPPING 4.2 9975 18M 1,000,000+ Free 0 Everyone Shopping January 22, 2018 1.4 4.3 and up
3049 US Open Tennis Championships 2018 SPORTS 4.0 9971 33M 1,000,000+ Free 0 Everyone Sports June 5, 2018 7.1 5.0 and up
3229 DreamTrips TRAVEL_AND_LOCAL 4.7 9971 22M 500,000+ Free 0 Teen Travel & Local August 6, 2018 1.28.1 5.0 and up
3079 US Open Tennis Championships 2018 SPORTS 4.0 9971 33M 1,000,000+ Free 0 Everyone Sports June 5, 2018 7.1 5.0 and up
7002 Adult Color by Number Book - Paint Mandala Pages FAMILY 4.3 997 Varies with device 100,000+ Free 0 Everyone Entertainment June 27, 2018 2.4 4.1 and up
6724 BSPlayer ARMv7 VFP CPU support VIDEO_PLAYERS 4.3 9966 5.5M 1,000,000+ Free 0 Everyone Video Players & Editors March 31, 2017 1.23 2.1 and up
7982 Easy Resume Builder, Resume help, Curriculum v... TOOLS 4.3 996 10M 50,000+ Free 0 Everyone Tools September 28, 2017 2.3 4.0.3 and up
353 MegaFon Dashboard COMMUNICATION 3.7 99559 Varies with device 10,000,000+ Free 0 Everyone Communication July 30, 2018 Varies with device Varies with device
5326 Al jazeera TV FAMILY 4.6 9952 3.7M 100,000+ Free 0 Teen Entertainment July 5, 2016 1.0.0 4.0.3 and up
326 Buff Thun - Daily Free Webtoon / Comics / Web ... COMICS 4.5 9952 38M 500,000+ Free 0 Everyone 10+ Comics July 31, 2018 4.3.0 4.1 and up
3874 Rope Hero Return of a Legend GAME 4.3 9951 96M 1,000,000+ Free 0 Mature 17+ Arcade August 26, 2016 1.0 2.3 and up
10383 Family Guy The Quest for Stuff GAME 4.0 995002 Varies with device 10,000,000+ Free 0 Mature 17+ Adventure July 25, 2018 1.73.0 4.1 and up
7351 tutti.ch - Free Classifieds SHOPPING 4.4 9950 15M 500,000+ Free 0 Everyone Shopping July 18, 2018 3.7.1 4.1 and up
2349 Teach Me Anatomy MEDICAL 4.7 9945 97M 500,000+ Free 0 Everyone Medical July 5, 2018 5.11 4.1 and up
996 Funny Pics ENTERTAINMENT 3.9 9941 Varies with device 1,000,000+ Free 0 Teen Entertainment July 7, 2017 Varies with device Varies with device
78 Best Car Wallpapers AUTO_AND_VEHICLES 4.5 994 2.9M 100,000+ Free 0 Everyone Auto & Vehicles March 27, 2018 1.6 4.1 and up
9112 Files To SD Card Pro TOOLS 4.2 994 2.8M 100,000+ Free 0 Everyone Tools May 18, 2018 6.0.0 5.0 and up
4183 HSPA+ Tweaker (3G booster) TOOLS 4.3 99290 3.9M 5,000,000+ Free 0 Everyone Tools December 5, 2017 3.1 Release b2 2.3 and up
6996 Art Pixel Coloring. Color by Number. FAMILY 4.5 992 49M 100,000+ Free 0 Teen Entertainment August 2, 2018 1.2.0.200 4.2 and up
4957 Adblock Fast PRODUCTIVITY 4.1 9914 3.2M 1,000,000+ Free 0 Everyone Productivity May 17, 2017 1.4.0 5.0 and up
1982 Zombie Catchers GAME 4.7 990796 75M 10,000,000+ Free 0 Everyone Action May 24, 2018 1.0.27 4.1 and up
1898 Zombie Catchers GAME 4.7 990723 75M 10,000,000+ Free 0 Everyone Action May 24, 2018 1.0.27 4.1 and up
1924 Zombie Catchers GAME 4.7 990663 75M 10,000,000+ Free 0 Everyone Action May 24, 2018 1.0.27 4.1 and up
1727 Zombie Catchers GAME 4.7 990586 75M 10,000,000+ Free 0 Everyone Action May 24, 2018 1.0.27 4.1 and up
1693 Zombie Catchers GAME 4.7 990491 75M 10,000,000+ Free 0 Everyone Action May 24, 2018 1.0.27 4.1 and up
741 Udemy - Online Courses EDUCATION 4.5 99020 18M 1,000,000+ Free 0 Everyone Education August 2, 2018 5.0.4 5.0 and up
757 Udemy - Online Courses EDUCATION 4.5 99020 18M 1,000,000+ Free 0 Everyone Education August 2, 2018 5.0.4 5.0 and up
... ... ... ... ... ... ... ... ... ... ... ... ... ...
8017 CW Ringtone (Morse Code generator) COMMUNICATION 4.3 0 269k 10+ Paid $2.49 Everyone Communication March 16, 2018 1.0.2 2.2 and up
9662 EO LAC LIFESTYLE 4.3 0 18M 10+ Free 0 Everyone Lifestyle January 17, 2017 1.1 4.1 and up
10344 FE Connect Fhoton TOOLS 4.3 0 1.8M 100+ Free 0 Everyone Tools November 28, 2017 1.1 4.0.3 and up
8822 Simple x3DS Emulator - BETA GAME 4.3 0 Varies with device 50,000+ Free 0 Everyone Arcade June 13, 2018 Varies with device Varies with device
9660 23rd QM BDE EO BUSINESS 4.3 0 6.3M 10+ Free 0 Everyone Business September 27, 2017 1.0.0 4.1 and up
10347 Santa Fe Espresso & News FOOD_AND_DRINK 4.3 0 15M 10+ Free 0 Everyone Food & Drink October 12, 2017 1.2.2 4.4 and up
10348 Santa Fe Sentry HOUSE_AND_HOME 4.3 0 5.3M 100+ Free 0 Everyone House & Home August 7, 2017 1.6.0 4.1 and up
5056 AF Legendary 2017 BUSINESS 4.3 0 11M 50+ Free 0 Teen Business September 30, 2017 v2.7.11.6 4.1 and up
9025 KeePass DX TOOLS 4.3 0 Varies with device 5,000+ Free 0 Everyone Tools August 2, 2018 Varies with device Varies with device
5023 Dashboard AE AUTO_AND_VEHICLES 4.3 0 13M 10+ Free 0 Everyone Auto & Vehicles May 16, 2018 1255162018 6.0 and up
5835 25 Mins Ako ay may lobo Etc Pinoy Kid Song Off... FAMILY 4.3 0 42M 10+ Free 0 Mature 17+ Entertainment July 29, 2018 3.0 2.3 and up
5834 Ay Yıldız - Xperia Live Theme PERSONALIZATION 4.3 0 2.9M 10+ Paid $0.99 Everyone Personalization December 26, 2017 1.0.0 4.4 and up
7182 US 115th CD TRAVEL_AND_LOCAL 4.3 0 5.7M 5+ Free 0 Everyone Travel & Local November 3, 2017 106 4.0.3 and up
8389 DG Hair LIFESTYLE 4.3 0 3.0M 10+ Free 0 Everyone Lifestyle August 30, 2017 1.0.0 4.0 and up
4489 P Icon Pack FAMILY 4.3 0 21M 10+ Paid $0.99 Everyone Entertainment July 16, 2018 1.0.6 4.0.3 and up
7184 STADE.CD NEWS_AND_MAGAZINES 4.3 0 1.7M 5+ Free 0 Everyone News & Magazines June 9, 2018 1.0 4.0.3 and up
5029 AE Manager TOOLS 4.3 0 4.0M 100+ Free 0 Everyone Tools June 15, 2015 1.0.0 4.0.3 and up
6502 BN PERKS™ LIFESTYLE 4.3 0 15M 100+ Free 0 Everyone Lifestyle June 2, 2018 2.13 4.0.3 and up
7190 CD Supply BUSINESS 4.3 0 14M 5+ Free 0 Mature 17+ Business May 28, 2018 2.3.2 5.0 and up
5486 AP Series Solution Pro FAMILY 4.3 0 7.4M 0+ Paid $1.99 Everyone Education July 30, 2017 1.3 4.0 and up
9030 KeePass DX Pro TOOLS 4.3 0 Varies with device 100+ Paid $5.99 Everyone Tools August 2, 2018 Varies with device Varies with device
7199 CE SmartApp.com BUSINESS 4.3 0 42M 100+ Free 0 Everyone Business March 16, 2018 102.0.875 4.2 and up
7202 ABAI CE Scanner FAMILY 4.3 0 4.3M 1,000+ Free 0 Everyone Education January 23, 2018 1.3 4.1 and up
9231 Ec Solutions Mobile BUSINESS 4.3 0 4.0M 10+ Free 0 Everyone Business November 20, 2016 1.02 4.1 and up
7214 NetApp CE BUSINESS 4.3 0 21M 100+ Free 0 Everyone Business February 27, 2018 v6.6.0 5.0 and up
7217 CE-STRONG FAMILY 4.3 0 16M 100+ Free 0 Everyone Education June 17, 2016 1.0.4 4.0 and up
6492 Anime Mod for BM BOOKS_AND_REFERENCE 4.3 0 8.0M 100+ Free 0 Everyone Books & Reference July 28, 2017 1.0 4.0 and up
7221 CE-SETRAM l’Appli LIBRARIES_AND_DEMO 4.3 0 2.6M 100+ Free 0 Everyone Libraries & Demo December 5, 2017 1.1.8 4.0.3 and up
5480 Glanceable Ap Watch Face PERSONALIZATION 4.3 0 11M 5+ Paid $0.99 Everyone Personalization August 14, 2016 1.0.103 4.4 and up
4177 G-NetReport Pro TOOLS 4.3 0 1.6M 10+ Paid $25.99 Everyone Tools June 14, 2018 5.0 4.0 and up

10841 rows × 13 columns

In [22]:
Reviews_line = data_store.loc[:, "Reviews"]
Reviews_line = pd.Series([int(i) for i in Reviews_line])
In [23]:
Reviews_stastitics = pd.DataFrame(pd.Series(Reviews_line.ravel()).describe()).transpose()
Reviews_stastitics
Out[23]:
count mean std min 25% 50% 75% max
0 10841.0 444111.928051 2.927629e+06 0.0 38.0 2094.0 54768.0 78158306.0
In [24]:
Review_hist = plt.hist(Reviews_line, bins=sturges(len(Reviews_line)), align="mid", log=True)
for x, y in zip(Review_hist[1], Review_hist[0]):
    plt.text(x, y, y, ha="left", va="bottom", fontsize=8)
Reviews_xtick_label = ["{:.3g}".format(i) for i in np.round(Review_hist[1], -6)]
plt.xticks(Review_hist[1], Reviews_xtick_label, fontsize=6)
plt.xlabel("Number of Review", fontsize=10)
plt.ylabel("Frequency [log10]", fontsize=10)
plt.title("Reviews Histgram", fontsize=10)
plt.show()
In [25]:
pd.DataFrame(np.round(Review_hist[1], -6)).transpose()
Out[25]:
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14
0 0.0 6000000.0 11000000.0 17000000.0 22000000.0 28000000.0 33000000.0 39000000.0 45000000.0 50000000.0 56000000.0 61000000.0 67000000.0 73000000.0 78000000.0
In [26]:
Review_boxplot = plt.boxplot(Reviews_line)

サイズ[MB]

In [27]:
size_line_m = data_store[data_store["Size"].str.endswith('M')].Size
size_line_k = data_store[data_store["Size"].str.endswith('k')].Size
size_line_m = [i.strip('M') for i in size_line_m]
size_line_k = [j.strip('k') for j in size_line_k]
In [28]:
size_line = []
size_line.extend([float(i)*1024 for i in size_line_m])
size_line.extend([float(j) for j in size_line_k])
size_line = pd.Series(size_line)
In [29]:
pd.DataFrame(pd.Series((size_line/1024).ravel()).describe()).transpose()
Out[29]:
count mean std min 25% 50% 75% max
0 9146.0 21.514141 22.588679 0.008301 4.9 13.0 30.0 100.0
In [30]:
Size_hist = plt.hist(size_line, bins=sturges(len(size_line)))
for x, y in zip(Size_hist[1], Size_hist[0]):
    plt.text(x, y, y, ha="left", va="bottom", fontsize=8)
plt.xticks(Size_hist[1], ["{:.1f}MB".format(i) for i in Size_hist[1]/1024], fontsize=5)
plt.yticks(fontsize=8)
plt.xlabel("App size [MB]", fontsize=10)
plt.ylabel("Frequency", fontsize=10)
plt.title("App size Histgram", fontsize=10)
Out[30]:
Text(0.5,1,'App size Histgram')
In [31]:
pd.DataFrame(["{:.2f}MB".format(i) for i in Size_hist[1]/1024]).transpose()
Out[31]:
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14
0 0.01MB 7.15MB 14.29MB 21.44MB 28.58MB 35.72MB 42.86MB 50.00MB 57.15MB 64.29MB 71.43MB 78.57MB 85.72MB 92.86MB 100.00MB
In [32]:
plt.boxplot(size_line)
plt.title("Size boxplot", fontsize=10)
plt.show()

Install数

In [33]:
Install_volume = data_store.groupby("Installs").count()
pd.DataFrame(Install_volume.App)
#.sort_index(level=["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+"])
Out[33]:
App
Installs
0 1
0+ 14
1+ 67
1,000+ 908
1,000,000+ 1579
1,000,000,000+ 58
10+ 386
10,000+ 1054
10,000,000+ 1252
100+ 719
100,000+ 1169
100,000,000+ 409
5+ 82
5,000+ 477
5,000,000+ 752
50+ 205
50,000+ 479
50,000,000+ 289
500+ 330
500,000+ 539
500,000,000+ 72
In [34]:
sorted_Install_volume = ["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+"]
Install_values = [Install_volume["App"][i] for i in sorted_Install_volume]
Install_volume_position = np.arange(0, len(sorted_Install_volume))
In [35]:
plt.barh(Install_volume_position, Install_values, width, tick_label=sorted_Install_volume)
plt.xticks(fontsize=8)
plt.yticks(fontsize=8)
plt.xlabel("Frequency", fontsize=10)
plt.ylabel("Number of Installs", fontsize=10)
plt.title("Number of Installs Histgram", fontsize=10)
plt.show()

アプリTypeと価格帯

アプリType

In [36]:
Type_free = data_store[data_store["Type"] == "Free"].Type.count()
In [37]:
Type_paid = data_store[data_store["Type"] != "Free"].Type.count()
In [38]:
plt.pie([Type_free,Type_paid], labels=["Free", "Paid"], explode=[0, 0.3], autopct="%1.1f%%", textprops={"fontsize":8})
plt.legend(fontsize=8)
plt.title("Price Type rate", fontsize=10)
plt.show()

アプリ価格帯

In [39]:
Price = data_store[data_store["Type"] != "Free"].Price.str.replace("$", "").astype(float)
In [40]:
pd.DataFrame(pd.Series(Price.ravel()).describe()).transpose()
Out[40]:
count mean std min 25% 50% 75% max
0 800.0 13.920837 57.195358 0.99 1.49 2.99 4.99 400.0
In [41]:
Price_hist = plt.hist(Price, bins=sturges(len(Price)))
for x, y in zip(Price_hist[1], Price_hist[0]):
    plt.text(x, y, y, ha="left", va="bottom", fontsize=8)
plt.xticks(fontsize=8)
plt.yticks(fontsize=8)
plt.xlabel("Price [$]", fontsize=10)
plt.ylabel("Frequency",fontsize=10)
plt.title("Paid App Price", fontsize=10)
plt.show()
In [42]:
a = ["${:.0f}".format(round(i)) for i in Price_hist[1]]
a.insert(0,"$0")
a
Out[42]:
['$0',
 '$1',
 '$41',
 '$81',
 '$121',
 '$161',
 '$200',
 '$240',
 '$280',
 '$320',
 '$360',
 '$400']
In [43]:
plt.boxplot(Price)
plt.show()

コンテンツレーティング(年齢制限)

In [44]:
Content_Rating = data_store["Content Rating"].unique()
Content_Rating_frequence = pd.DataFrame(data_store.groupby("Content Rating").count().App)
Content_values = Content_Rating_frequence.values.reshape(-1)
Content_position = range(0, len(Content_Rating))
In [45]:
plt.bar(Content_position, Content_values)
for x, y in zip(Content_position, Content_values):
    plt.text(x, y, y, ha="center", va="bottom", fontsize=8)
plt.xticks(np.arange(0, 6), Content_Rating, fontsize=8)
plt.yticks(fontsize=8)
plt.xlabel("Content index", fontsize=10)
plt.ylabel("Frequency", fontsize=10)
plt.title("Contents Rating Histgram", fontsize=10)
plt.show()

人気アプリ傾向

install数10,000+~

In [46]:
Famoust_install = np.asarray([sorted_Install_volume])[:, 9:].reshape(-1)
Famoust_App = data_store[data_store["Installs"].isin(Famoust_install)]
Famoust_App
Out[46]:
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
5 Paper flowers instructions ART_AND_DESIGN 4.4 167 5.6M 50,000+ Free 0 Everyone Art & Design March 26, 2017 1.0 2.3 and up
6 Smoke Effect Photo Maker - Smoke Editor ART_AND_DESIGN 3.8 178 19M 50,000+ Free 0 Everyone Art & Design April 26, 2018 1.1 4.0.3 and up
7 Infinite Painter ART_AND_DESIGN 4.1 36815 29M 1,000,000+ Free 0 Everyone Art & Design June 14, 2018 6.1.61.1 4.2 and up
8 Garden Coloring Book ART_AND_DESIGN 4.4 13791 33M 1,000,000+ Free 0 Everyone Art & Design September 20, 2017 2.9.2 3.0 and up
9 Kids Paint Free - Drawing Fun ART_AND_DESIGN 4.7 121 3.1M 10,000+ Free 0 Everyone Art & Design;Creativity July 3, 2018 2.8 4.0.3 and up
10 Text on Photo - Fonteee ART_AND_DESIGN 4.4 13880 28M 1,000,000+ Free 0 Everyone Art & Design October 27, 2017 1.0.4 4.1 and up
11 Name Art Photo Editor - Focus n Filters ART_AND_DESIGN 4.4 8788 12M 1,000,000+ Free 0 Everyone Art & Design July 31, 2018 1.0.15 4.0 and up
12 Tattoo Name On My Photo Editor ART_AND_DESIGN 4.2 44829 20M 10,000,000+ Free 0 Teen Art & Design April 2, 2018 3.8 4.1 and up
13 Mandala Coloring Book ART_AND_DESIGN 4.6 4326 21M 100,000+ Free 0 Everyone Art & Design June 26, 2018 1.0.4 4.4 and up
14 3D Color Pixel by Number - Sandbox Art Coloring ART_AND_DESIGN 4.4 1518 37M 100,000+ Free 0 Everyone Art & Design August 3, 2018 1.2.3 2.3 and up
16 Photo Designer - Write your name with shapes ART_AND_DESIGN 4.7 3632 5.5M 500,000+ Free 0 Everyone Art & Design July 31, 2018 3.1 4.1 and up
17 350 Diy Room Decor Ideas ART_AND_DESIGN 4.5 27 17M 10,000+ Free 0 Everyone Art & Design November 7, 2017 1.0 2.3 and up
18 FlipaClip - Cartoon animation ART_AND_DESIGN 4.3 194216 39M 5,000,000+ Free 0 Everyone Art & Design August 3, 2018 2.2.5 4.0.3 and up
19 ibis Paint X ART_AND_DESIGN 4.6 224399 31M 10,000,000+ Free 0 Everyone Art & Design July 30, 2018 5.5.4 4.1 and up
20 Logo Maker - Small Business ART_AND_DESIGN 4.0 450 14M 100,000+ Free 0 Everyone Art & Design April 20, 2018 4.0 4.1 and up
21 Boys Photo Editor - Six Pack & Men's Suit ART_AND_DESIGN 4.1 654 12M 100,000+ Free 0 Everyone Art & Design March 20, 2018 1.1 4.0.3 and up
22 Superheroes Wallpapers | 4K Backgrounds ART_AND_DESIGN 4.7 7699 4.2M 500,000+ Free 0 Everyone 10+ Art & Design July 12, 2018 2.2.6.2 4.0.3 and up
23 Mcqueen Coloring pages ART_AND_DESIGN 4.3 61 7.0M 100,000+ Free 0 Everyone Art & Design;Action & Adventure March 7, 2018 1.0.0 4.1 and up
24 HD Mickey Minnie Wallpapers ART_AND_DESIGN 4.7 118 23M 50,000+ Free 0 Everyone Art & Design July 7, 2018 1.1.3 4.1 and up
25 Harley Quinn wallpapers HD ART_AND_DESIGN 4.8 192 6.0M 10,000+ Free 0 Everyone Art & Design April 25, 2018 1.5 3.0 and up
26 Colorfit - Drawing & Coloring ART_AND_DESIGN 4.7 20260 25M 500,000+ Free 0 Everyone Art & Design;Creativity October 11, 2017 1.0.8 4.0.3 and up
27 Animated Photo Editor ART_AND_DESIGN 4.1 203 6.1M 100,000+ Free 0 Everyone Art & Design March 21, 2018 1.03 4.0.3 and up
28 Pencil Sketch Drawing ART_AND_DESIGN 3.9 136 4.6M 10,000+ Free 0 Everyone Art & Design July 12, 2018 6.0 2.3 and up
29 Easy Realistic Drawing Tutorial ART_AND_DESIGN 4.1 223 4.2M 100,000+ Free 0 Everyone Art & Design August 22, 2017 1.0 2.3 and up
30 Pink Silver Bow Keyboard Theme ART_AND_DESIGN 4.2 1120 9.2M 100,000+ Free 0 Everyone Art & Design July 12, 2018 6.7.12.2018 4.0.3 and up
... ... ... ... ... ... ... ... ... ... ... ... ... ...
10784 Big Hunter GAME 4.3 245455 84M 10,000,000+ Free 0 Everyone 10+ Action May 31, 2018 2.8.6 4.0 and up
10785 sugar, sugar FAMILY 4.2 1405 9.5M 10,000+ Paid $1.20 Everyone Puzzle June 5, 2018 2.7 2.3 and up
10786 ChopAssistant TOOLS 4.2 455 2.8M 50,000+ Free 0 Everyone Tools February 28, 2017 1.6 6.0 and up
10787 Modern Counter Global Strike 3D GAME 4.1 297 48M 50,000+ Free 0 Teen Action March 28, 2018 1.2 4.1 and up
10789 Modern Counter Global Strike 3D V2 GAME 4.0 368 48M 50,000+ Free 0 Everyone 10+ Action March 28, 2018 1.7 4.1 and up
10790 HipChat - beta version COMMUNICATION 4.1 1035 20M 50,000+ Free 0 Everyone Communication August 7, 2018 3.20.001 4.1 and up
10791 Winter Wonderland GAME 4.0 1287 38M 50,000+ Free 0 Everyone Word December 18, 2013 1.0 2.2 and up
10792 Soccer Clubs Logo Quiz GAME 4.2 21661 16M 1,000,000+ Free 0 Everyone Trivia May 24, 2018 1.3.81 4.0 and up
10793 Sid Story GAME 4.4 28510 78M 500,000+ Free 0 Teen Card August 1, 2018 2.6.6 4.0.3 and up
10795 Reindeer VPN - Proxy VPN TOOLS 4.2 7339 4.0M 100,000+ Free 0 Everyone Tools May 10, 2018 1.74 4.1 and up
10796 Inf VPN - Global Proxy & Unlimited Free WIFI VPN TOOLS 4.7 61445 7.8M 1,000,000+ Free 0 Everyone Tools July 26, 2018 1.9.734 4.1 and up
10797 Fuel Rewards® program LIFESTYLE 4.6 32433 46M 1,000,000+ Free 0 Everyone Lifestyle June 26, 2018 2.9.1 5.0 and up
10799 Fr Daoud Lamei SOCIAL 4.7 2036 6.8M 100,000+ Free 0 Everyone Social May 20, 2018 1.72 4.0.3 and up
10802 FR: My Famous Lover FAMILY 4.0 185 28M 10,000+ Free 0 Teen Entertainment August 6, 2015 1.3.0 3.0 and up
10803 Fatal Raid - No.1 Mobile FPS GAME 4.3 56496 81M 1,000,000+ Free 0 Teen Action August 7, 2018 1.5.447 4.0 and up
10804 Poker Pro.Fr GAME 4.2 5442 17M 100,000+ Free 0 Teen Card May 22, 2018 4.1.3 2.3 and up
10808 lesparticuliers.fr LIFESTYLE 4.3 96 1.0M 50,000+ Free 0 Everyone Lifestyle November 25, 2014 1.5 2.3 and up
10809 Castle Clash: RPG War and Strategy FR FAMILY 4.7 376223 24M 1,000,000+ Free 0 Everyone Strategy July 18, 2018 1.4.2 4.1 and up
10813 DICT.fr Mobile BUSINESS 4.3 20 2.7M 10,000+ Free 0 Everyone Business July 17, 2018 2.1.10 4.1 and up
10814 FR: My Secret Pets! FAMILY 4.0 785 31M 50,000+ Free 0 Teen Entertainment June 3, 2015 1.3.1 3.0 and up
10815 Golden Dictionary (FR-AR) BOOKS_AND_REFERENCE 4.2 5775 4.9M 500,000+ Free 0 Everyone Books & Reference July 19, 2018 7.0.4.6 4.2 and up
10817 HTC Sense Input - FR TOOLS 4.0 885 8.0M 100,000+ Free 0 Everyone Tools October 30, 2015 1.0.612928 5.0 and up
10818 Gold Quote - Gold.fr FINANCE 4.3 96 1.5M 10,000+ Free 0 Everyone Finance May 19, 2016 2.3 2.2 and up
10824 Cardio-FR MEDICAL 4.3 67 82M 10,000+ Free 0 Everyone Medical July 31, 2018 2.2.2 4.4 and up
10826 Frim: get new friends on local chat rooms SOCIAL 4.0 88486 Varies with device 5,000,000+ Free 0 Mature 17+ Social March 23, 2018 Varies with device Varies with device
10828 Manga-FR - Anime Vostfr COMICS 3.4 291 13M 10,000+ Free 0 Everyone Comics May 15, 2017 2.0.1 4.0 and up
10829 Bulgarian French Dictionary Fr BOOKS_AND_REFERENCE 4.6 603 7.4M 10,000+ Free 0 Everyone Books & Reference June 19, 2016 2.96 4.1 and up
10830 News Minecraft.fr NEWS_AND_MAGAZINES 3.8 881 2.3M 100,000+ Free 0 Everyone News & Magazines January 20, 2014 1.5 1.6 and up
10832 FR Tides WEATHER 3.8 1195 582k 100,000+ Free 0 Everyone Weather February 16, 2014 6.0 2.1 and up
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

7594 rows × 13 columns

人気カテゴリ

In [47]:
Famoust_category = Famoust_App.groupby("Category").App.count().sort_values()
Famoust_category
Out[47]:
Category
EVENTS                   27
BEAUTY                   42
COMICS                   52
ART_AND_DESIGN           55
PARENTING                55
AUTO_AND_VEHICLES        57
LIBRARIES_AND_DEMO       60
WEATHER                  72
HOUSE_AND_HOME           77
MAPS_AND_NAVIGATION      98
FOOD_AND_DRINK          106
BOOKS_AND_REFERENCE     134
VIDEO_PLAYERS           134
ENTERTAINMENT           148
DATING                  153
EDUCATION               154
NEWS_AND_MAGAZINES      186
TRAVEL_AND_LOCAL        190
MEDICAL                 192
BUSINESS                204
SOCIAL                  211
SHOPPING                217
LIFESTYLE               220
PERSONALIZATION         232
FINANCE                 253
HEALTH_AND_FITNESS      255
COMMUNICATION           256
PRODUCTIVITY            278
PHOTOGRAPHY             279
SPORTS                  279
TOOLS                   562
GAME                   1009
FAMILY                 1347
Name: App, dtype: int64
In [48]:
Famoust_category_barh = plt.barh(np.arange(0,len(Famoust_category.index.values)) + 0.5, Famoust_category.values, tick_label=Famoust_category.index)
plt.yticks(fontsize=6)
plt.show()
In [ ]: