The purpose of this project is to identify the types of New Free Apps that will most likely generate highest demand of customer usage based on current App usage data available from AppleStore and Googleplay. The analysis will be limited only to Free Apps and Apps in English. The output of recommendations will be presented to App Product Design Department to facilitate their decision making.
Regarding any data analysis project, typically the first order of business is to ensure data correctness (identify and remove errors), filter out duplications and limit the analysis to only Apps in English.
Google Play data has a number of duplicate entries because the data was collected multiple times at different dates. The duplicates were updated with an increase of reviews. The output below shows that there were 1181 duplicate apps.
Analyzing the data to include the duplicates will distort the results. I will choose each unique app with the largest number of reviews since that will reflect the most up to date data for each unique app.
App data on both Google Play and the App Store is being analyzed in order to find App profiles that are successful on both markets. We will determine the frequency of App types within the column headings as follows: (i) "prime_genres" from AppleStore data file (ii) "genres" from GoolePlayStore file (iii) "categories" from GooglePlayStore file
Looking at the "breakout" of categories/genres by percent of Apps across both AppleStore and GooglePlayStore, it looks like non-business/family/entertainment are the most common, with gaming being a form of "entertainment".
Within the GooglePlayStore data file, I would say that analyzing "Genres" is not worthwhile because there are just too many types of Google Genres (qty. 114). Qty. 24 "Genres" account for 80% of all the Apps, but the 24 cover a broad range of "genre types". Within GoolePlayStore "Categories", there are qty. 33 types. Unfortunately, this data doesn't follow the "Pareto Principle", which facilitates prioritizing. Data which follows the "Pareto Principle" generally shows 20% of the "categories/genres/whatever" covering 80% of the total "population" (all Apps in this case). It turns out that it takes 50% of the categories to cover 80% of all the Apps. The top two Categories are: "Family" and "Game" which covers about 29% of all the Apps.
Within the Applestore data file, it does follow the Pareto Principle. There are qty. 23 prime_genres. The top 5 prime_genres (5/23 = 22%) accounts for 78% of all the Apps. The top two are: "Games" and "Entertainment" which covers about 66% of all the Apps.
So, the most common genres/categories across the two data files are: Games/Family/Entertainment.
Regarding the AppleStore data, there is only one "genre-app" that is both in the top 5 (5th) by percentage of total Apps and the top 5 (3rd) by total user ratings and that is: "Social Networking". At this point of the analysis, that is our best recommendation to pursue App type.
Concerning the GooglePlayStore data, "Productivity" did show up both in the top 6 (6th) by percentage of total Apps and the top 6 (5th) in total installations, however that doesn't "jive" with AppleStore data. I would believe "Productivity" relates more to business that "pleasure" and "fun" (Games and Entertainment). "Game" is both in the top 6 (2nd) by percentage of total Apps and the top 6 (6th) in total installations.
One caution about total installations. High number of installations doesn't necessarily mean high volume of exposure to ads within the respective App if a user installs the App and then uninstalls it in the same day because they were not impressed with it. App rating might help to determine whether users were likely to be long time users of specific Apps or App types.
In conclusion, I recommend pursuing development of Game/Family/Entertainment type of new Apps. I believe new App development somewhere in that group would yield low risk investment of time and dollars.
opened_file = open('AppleStore.csv')
from csv import reader
read_file = reader(opened_file)
Apple_data = list(read_file)
Apple_header = Apple_data[0]
Apple_data = Apple_data[1:]
opened_file = open('googleplaystore.csv')
from csv import reader
read_file = reader(opened_file)
Google_data = list(read_file)
Google_header = Google_data[0]
Google_data = Google_data[1:]
print(len(Google_data))
del Google_data[10472]
print(len(Google_data))
def explore_data(Apple_data, start, end, rows_and_columns=False):
Apple_slice = Apple_data[start:end]
for row in Apple_slice:
print(row)
print('\n') # adds a new (empty) line after each row
if rows_and_columns:
print('Number of rows:', len(Apple_data))
print('Number of columns:', len(Apple_data[0]))
print(Apple_header)
print('\n')
print(explore_data(Apple_data, 0, 3, True))
def explore_data(Google_data, start, end, rows_and_columns=False):
Google_slice = Google_data[start:end]
for row in Google_slice:
print(row)
print('\n') # adds a new (empty) line after each row
if rows_and_columns:
print('Number of rows:', len(Google_data))
print('Number of columns:', len(Google_data[0]))
print(Google_header)
print('\n')
print(explore_data(Google_data, 0, 3, True))
duplicate_apps = []
unique_apps = []
for app in Google_data:
name = app[0]
if name in unique_apps:
duplicate_apps.append(name)
else:
unique_apps.append(name)
print('Number of duplicate apps:', len(duplicate_apps))
print('\n')
print('Examples of duplicate apps:', duplicate_apps[:10])
print('\n')
Reviews_max = {}
for row in Google_data:
name = row[0]
n_reviews = float(row[3])
if (name in Reviews_max) and (Reviews_max[name] < n_reviews):
Reviews_max[name] = n_reviews
elif name not in Reviews_max:
Reviews_max[name] = n_reviews
print(len(Reviews_max))
print(len(Google_data))
print('\n')
print(n_reviews)
Google_clean = []
Already_added = []
for row in Google_data:
name = row[0]
n_reviews = float(row[3])
if (Reviews_max[name] == n_reviews) and (name not in Already_added):
Google_clean.append(row)
Already_added.append(name)
print(len(Google_clean))
Google_Eng = []
Google_Non_Eng = []
for row in Google_clean:
name = row[0]
non_eng = 0
for character in name:
if ord(character) > 127:
non_eng = non_eng + 1
if non_eng > 3:
Google_Non_Eng.append(row)
else:
Google_Eng.append(row)
print(len(Google_Eng))
print(len(Google_Non_Eng))
Apple_Eng = []
Apple_Non_Eng = []
for row2 in Apple_data:
name2 = row2[1]
non_eng2 = 0
for character2 in name2:
if ord(character2) > 127:
non_eng2 = non_eng2 + 1
if non_eng2 > 3:
Apple_Non_Eng.append(row2)
else:
Apple_Eng.append(row2)
print(len(Apple_Eng))
print(len(Apple_Non_Eng))
print('\n')
Google_Free = []
Google_Not_Free = []
for row in Google_Eng:
price = row[7]
if price == '0':
Google_Free.append(row)
else:
Google_Not_Free.append(row)
print('Free Google Apps')
print(len(Google_Free))
print('\n')
print('Non Free Google Apps')
print(len(Google_Not_Free))
print('\n')
Apple_Free = []
Apple_Not_Free = []
for row in Apple_Eng:
price = float(row[4])
if price == 0:
Apple_Free.append(row)
else:
Apple_Not_Free.append(row)
print('Free Apple Apps')
print(len(Apple_Free))
print('\n')
print('Non Free Apple Apps')
print(len(Apple_Not_Free))
def freq_table(dataset, index):
table = {}
total = 0
for row in dataset:
total += 1
value = row[index]
if value in table:
table[value] += 1
else:
table[value] = 1
table_percentages = {}
for key in table:
percentage = (table[key] / total) * 100
table_percentages[key] = percentage
return table_percentages
a_genres_table = freq_table(Apple_Free, 11)
print(a_genres_table)
print(len(a_genres_table))
print('\n')
g_genres_table = freq_table(Google_Free, 9)
print(g_genres_table)
print(len(g_genres_table))
print('\n')
g_categories_table = freq_table(Google_Free, 1)
print(g_categories_table)
print(len(g_categories_table))
print('\n')
def display_table(dataset, index):
table = freq_table(dataset, index)
table_display = []
for key in table:
key_val_as_tuple = (table[key], key)
table_display.append(key_val_as_tuple)
table_sorted = sorted(table_display, reverse = True)
for entry in table_sorted:
print(entry[1], ':', entry[0])
return table_sorted
a_sorted_genres_table = display_table(Apple_Free, 11)
print('\n')
g_sorted_genres_table = display_table(Google_Free, 9)
print('\n')
g_sorted_categories_table = display_table(Google_Free, 1)
print('\n')
print('\n')
genre_Apple = freq_table(Apple_Free, 11)
for genre in genre_Apple:
total = 0
len_genre = 0
for app in Apple_Free:
genre_app = app[11]
if genre_app == genre:
rating_sum = float(app[5])
total += rating_sum
len_genre += 1
avg_user_rating = total / len_genre
print(genre, ':', avg_user_rating)
print('\n')
print('\n')
categories_Google = freq_table(Google_Free, 1)
for category in categories_Google:
total = 0
len_category = 0
for app in Google_Free:
category_app = app[1]
if category_app == category:
n_installs = app[5]
n_installs = n_installs.replace('+', '')
n_installs = n_installs.replace(',', '')
total += float(n_installs)
len_category = len_category + 1
avg_n_installs = total / len_category
print(category, ':', avg_n_installs)
10841 10840 ['id', 'track_name', 'size_bytes', 'currency', 'price', 'rating_count_tot', 'rating_count_ver', 'user_rating', 'user_rating_ver', 'ver', 'cont_rating', 'prime_genre', 'sup_devices.num', 'ipadSc_urls.num', 'lang.num', 'vpp_lic'] ['284882215', 'Facebook', '389879808', 'USD', '0.0', '2974676', '212', '3.5', '3.5', '95.0', '4+', 'Social Networking', '37', '1', '29', '1'] ['389801252', 'Instagram', '113954816', 'USD', '0.0', '2161558', '1289', '4.5', '4.0', '10.23', '12+', 'Photo & Video', '37', '0', '29', '1'] ['529479190', 'Clash of Clans', '116476928', 'USD', '0.0', '2130805', '579', '4.5', '4.5', '9.24.12', '9+', 'Games', '38', '5', '18', '1'] Number of rows: 7197 Number of columns: 16 None ['App', 'Category', 'Rating', 'Reviews', 'Size', 'Installs', 'Type', 'Price', 'Content Rating', 'Genres', 'Last Updated', 'Current Ver', 'Android Ver'] ['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'] ['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'] ['U Launcher Lite – FREE Live Cool Themes, Hide Apps', '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'] Number of rows: 10840 Number of columns: 13 None Number of duplicate apps: 1181 Examples of duplicate apps: ['Quick PDF Scanner + OCR FREE', 'Box', 'Google My Business', 'ZOOM Cloud Meetings', 'join.me - Simple Meetings', 'Box', 'Zenefits', 'Google Ads', 'Google My Business', 'Slack'] 9659 10840 398307.0 9659 9614 45 6183 1014 Free Google Apps 8864 Non Free Google Apps 750 Free Apple Apps 3222 Non Free Apple Apps 2961 {'Social Networking': 3.2898820608317814, 'Photo & Video': 4.9658597144630665, 'Games': 58.16263190564867, 'Music': 2.0484171322160147, 'Reference': 0.5586592178770949, 'Health & Fitness': 2.0173805090006205, 'Weather': 0.8690254500310366, 'Utilities': 2.5139664804469275, 'Travel': 1.2414649286157666, 'Shopping': 2.60707635009311, 'News': 1.3345747982619491, 'Navigation': 0.186219739292365, 'Lifestyle': 1.5828677839851024, 'Entertainment': 7.883302296710118, 'Food & Drink': 0.8069522036002483, 'Sports': 2.1415270018621975, 'Book': 0.4345127250155183, 'Finance': 1.1173184357541899, 'Education': 3.662321539416512, 'Productivity': 1.7380509000620732, 'Business': 0.5276225946617008, 'Catalogs': 0.12414649286157665, 'Medical': 0.186219739292365} 23 {'Art & Design': 0.5979241877256317, 'Art & Design;Creativity': 0.06768953068592057, 'Auto & Vehicles': 0.9250902527075812, 'Beauty': 0.5979241877256317, 'Books & Reference': 2.1435018050541514, 'Business': 4.591606498194946, 'Comics': 0.6092057761732852, 'Comics;Creativity': 0.01128158844765343, 'Communication': 3.2378158844765346, 'Dating': 1.861462093862816, 'Education': 5.347472924187725, 'Education;Creativity': 0.04512635379061372, 'Education;Education': 0.33844765342960287, 'Education;Pretend Play': 0.056407942238267145, 'Education;Brain Games': 0.033844765342960284, 'Entertainment': 6.069494584837545, 'Entertainment;Brain Games': 0.078971119133574, 'Entertainment;Creativity': 0.033844765342960284, 'Entertainment;Music & Video': 0.16922382671480143, 'Events': 0.7107400722021661, 'Finance': 3.7003610108303246, 'Food & Drink': 1.2409747292418771, 'Health & Fitness': 3.0798736462093865, 'House & Home': 0.8235559566787004, 'Libraries & Demo': 0.9363718411552346, 'Lifestyle': 3.892148014440433, 'Lifestyle;Pretend Play': 0.01128158844765343, 'Card': 0.45126353790613716, 'Arcade': 1.8501805054151623, 'Puzzle': 1.128158844765343, 'Racing': 0.9927797833935018, 'Sports': 3.463447653429603, 'Casual': 1.7599277978339352, 'Simulation': 2.0419675090252705, 'Adventure': 0.6768953068592057, 'Trivia': 0.41741877256317694, 'Action': 3.1024368231046933, 'Word': 0.2594765342960289, 'Role Playing': 0.9363718411552346, 'Strategy': 0.9138086642599278, 'Board': 0.3835740072202166, 'Music': 0.2030685920577617, 'Action;Action & Adventure': 0.10153429602888085, 'Casual;Brain Games': 0.13537906137184114, 'Educational;Creativity': 0.033844765342960284, 'Puzzle;Brain Games': 0.16922382671480143, 'Educational;Education': 0.39485559566787, 'Casual;Pretend Play': 0.236913357400722, 'Educational;Brain Games': 0.06768953068592057, 'Art & Design;Pretend Play': 0.01128158844765343, 'Educational;Pretend Play': 0.09025270758122744, 'Entertainment;Education': 0.01128158844765343, 'Casual;Education': 0.02256317689530686, 'Casual;Creativity': 0.06768953068592057, 'Casual;Action & Adventure': 0.13537906137184114, 'Music;Music & Video': 0.02256317689530686, 'Arcade;Pretend Play': 0.01128158844765343, 'Adventure;Action & Adventure': 0.033844765342960284, 'Role Playing;Action & Adventure': 0.033844765342960284, 'Simulation;Pretend Play': 0.02256317689530686, 'Puzzle;Creativity': 0.02256317689530686, 'Simulation;Action & Adventure': 0.078971119133574, 'Racing;Action & Adventure': 0.16922382671480143, 'Sports;Action & Adventure': 0.02256317689530686, 'Educational;Action & Adventure': 0.033844765342960284, 'Arcade;Action & Adventure': 0.12409747292418773, 'Entertainment;Action & Adventure': 0.033844765342960284, 'Art & Design;Action & Adventure': 0.01128158844765343, 'Puzzle;Action & Adventure': 0.033844765342960284, 'Education;Action & Adventure': 0.033844765342960284, 'Strategy;Action & Adventure': 0.01128158844765343, 'Music & Audio;Music & Video': 0.01128158844765343, 'Health & Fitness;Education': 0.01128158844765343, 'Board;Action & Adventure': 0.02256317689530686, 'Board;Brain Games': 0.078971119133574, 'Casual;Music & Video': 0.01128158844765343, 'Education;Music & Video': 0.033844765342960284, 'Role Playing;Pretend Play': 0.04512635379061372, 'Entertainment;Pretend Play': 0.02256317689530686, 'Medical': 3.531137184115524, 'Social': 2.6624548736462095, 'Shopping': 2.2450361010830324, 'Photography': 2.944494584837545, 'Travel & Local': 2.3240072202166067, 'Travel & Local;Action & Adventure': 0.01128158844765343, 'Tools': 8.449909747292418, 'Tools;Education': 0.01128158844765343, 'Personalization': 3.3167870036101084, 'Productivity': 3.892148014440433, 'Parenting': 0.4963898916967509, 'Parenting;Music & Video': 0.06768953068592057, 'Parenting;Education': 0.078971119133574, 'Parenting;Brain Games': 0.01128158844765343, 'Weather': 0.8009927797833934, 'Video Players & Editors': 1.7712093862815883, 'Video Players & Editors;Music & Video': 0.02256317689530686, 'Video Players & Editors;Creativity': 0.01128158844765343, 'News & Magazines': 2.7978339350180503, 'Maps & Navigation': 1.3989169675090252, 'Health & Fitness;Action & Adventure': 0.01128158844765343, 'Educational': 0.3722924187725632, 'Casino': 0.42870036101083037, 'Trivia;Education': 0.01128158844765343, 'Lifestyle;Education': 0.01128158844765343, 'Card;Action & Adventure': 0.01128158844765343, 'Books & Reference;Education': 0.01128158844765343, 'Simulation;Education': 0.01128158844765343, 'Puzzle;Education': 0.01128158844765343, 'Adventure;Education': 0.01128158844765343, 'Role Playing;Brain Games': 0.01128158844765343, 'Strategy;Education': 0.01128158844765343, 'Racing;Pretend Play': 0.01128158844765343, 'Communication;Creativity': 0.01128158844765343, 'Strategy;Creativity': 0.01128158844765343} 114 {'ART_AND_DESIGN': 0.6430505415162455, 'AUTO_AND_VEHICLES': 0.9250902527075812, 'BEAUTY': 0.5979241877256317, 'BOOKS_AND_REFERENCE': 2.1435018050541514, 'BUSINESS': 4.591606498194946, 'COMICS': 0.6204873646209386, 'COMMUNICATION': 3.2378158844765346, 'DATING': 1.861462093862816, 'EDUCATION': 1.1620036101083033, 'ENTERTAINMENT': 0.9589350180505415, 'EVENTS': 0.7107400722021661, 'FINANCE': 3.7003610108303246, 'FOOD_AND_DRINK': 1.2409747292418771, 'HEALTH_AND_FITNESS': 3.0798736462093865, 'HOUSE_AND_HOME': 0.8235559566787004, 'LIBRARIES_AND_DEMO': 0.9363718411552346, 'LIFESTYLE': 3.9034296028880866, 'GAME': 9.724729241877256, 'FAMILY': 18.907942238267147, 'MEDICAL': 3.531137184115524, 'SOCIAL': 2.6624548736462095, 'SHOPPING': 2.2450361010830324, 'PHOTOGRAPHY': 2.944494584837545, 'SPORTS': 3.395758122743682, 'TRAVEL_AND_LOCAL': 2.33528880866426, 'TOOLS': 8.461191335740072, 'PERSONALIZATION': 3.3167870036101084, 'PRODUCTIVITY': 3.892148014440433, 'PARENTING': 0.6543321299638989, 'WEATHER': 0.8009927797833934, 'VIDEO_PLAYERS': 1.7937725631768955, 'NEWS_AND_MAGAZINES': 2.7978339350180503, 'MAPS_AND_NAVIGATION': 1.3989169675090252} 33 Games : 58.16263190564867 Entertainment : 7.883302296710118 Photo & Video : 4.9658597144630665 Education : 3.662321539416512 Social Networking : 3.2898820608317814 Shopping : 2.60707635009311 Utilities : 2.5139664804469275 Sports : 2.1415270018621975 Music : 2.0484171322160147 Health & Fitness : 2.0173805090006205 Productivity : 1.7380509000620732 Lifestyle : 1.5828677839851024 News : 1.3345747982619491 Travel : 1.2414649286157666 Finance : 1.1173184357541899 Weather : 0.8690254500310366 Food & Drink : 0.8069522036002483 Reference : 0.5586592178770949 Business : 0.5276225946617008 Book : 0.4345127250155183 Navigation : 0.186219739292365 Medical : 0.186219739292365 Catalogs : 0.12414649286157665 Tools : 8.449909747292418 Entertainment : 6.069494584837545 Education : 5.347472924187725 Business : 4.591606498194946 Productivity : 3.892148014440433 Lifestyle : 3.892148014440433 Finance : 3.7003610108303246 Medical : 3.531137184115524 Sports : 3.463447653429603 Personalization : 3.3167870036101084 Communication : 3.2378158844765346 Action : 3.1024368231046933 Health & Fitness : 3.0798736462093865 Photography : 2.944494584837545 News & Magazines : 2.7978339350180503 Social : 2.6624548736462095 Travel & Local : 2.3240072202166067 Shopping : 2.2450361010830324 Books & Reference : 2.1435018050541514 Simulation : 2.0419675090252705 Dating : 1.861462093862816 Arcade : 1.8501805054151623 Video Players & Editors : 1.7712093862815883 Casual : 1.7599277978339352 Maps & Navigation : 1.3989169675090252 Food & Drink : 1.2409747292418771 Puzzle : 1.128158844765343 Racing : 0.9927797833935018 Role Playing : 0.9363718411552346 Libraries & Demo : 0.9363718411552346 Auto & Vehicles : 0.9250902527075812 Strategy : 0.9138086642599278 House & Home : 0.8235559566787004 Weather : 0.8009927797833934 Events : 0.7107400722021661 Adventure : 0.6768953068592057 Comics : 0.6092057761732852 Beauty : 0.5979241877256317 Art & Design : 0.5979241877256317 Parenting : 0.4963898916967509 Card : 0.45126353790613716 Casino : 0.42870036101083037 Trivia : 0.41741877256317694 Educational;Education : 0.39485559566787 Board : 0.3835740072202166 Educational : 0.3722924187725632 Education;Education : 0.33844765342960287 Word : 0.2594765342960289 Casual;Pretend Play : 0.236913357400722 Music : 0.2030685920577617 Racing;Action & Adventure : 0.16922382671480143 Puzzle;Brain Games : 0.16922382671480143 Entertainment;Music & Video : 0.16922382671480143 Casual;Brain Games : 0.13537906137184114 Casual;Action & Adventure : 0.13537906137184114 Arcade;Action & Adventure : 0.12409747292418773 Action;Action & Adventure : 0.10153429602888085 Educational;Pretend Play : 0.09025270758122744 Simulation;Action & Adventure : 0.078971119133574 Parenting;Education : 0.078971119133574 Entertainment;Brain Games : 0.078971119133574 Board;Brain Games : 0.078971119133574 Parenting;Music & Video : 0.06768953068592057 Educational;Brain Games : 0.06768953068592057 Casual;Creativity : 0.06768953068592057 Art & Design;Creativity : 0.06768953068592057 Education;Pretend Play : 0.056407942238267145 Role Playing;Pretend Play : 0.04512635379061372 Education;Creativity : 0.04512635379061372 Role Playing;Action & Adventure : 0.033844765342960284 Puzzle;Action & Adventure : 0.033844765342960284 Entertainment;Creativity : 0.033844765342960284 Entertainment;Action & Adventure : 0.033844765342960284 Educational;Creativity : 0.033844765342960284 Educational;Action & Adventure : 0.033844765342960284 Education;Music & Video : 0.033844765342960284 Education;Brain Games : 0.033844765342960284 Education;Action & Adventure : 0.033844765342960284 Adventure;Action & Adventure : 0.033844765342960284 Video Players & Editors;Music & Video : 0.02256317689530686 Sports;Action & Adventure : 0.02256317689530686 Simulation;Pretend Play : 0.02256317689530686 Puzzle;Creativity : 0.02256317689530686 Music;Music & Video : 0.02256317689530686 Entertainment;Pretend Play : 0.02256317689530686 Casual;Education : 0.02256317689530686 Board;Action & Adventure : 0.02256317689530686 Video Players & Editors;Creativity : 0.01128158844765343 Trivia;Education : 0.01128158844765343 Travel & Local;Action & Adventure : 0.01128158844765343 Tools;Education : 0.01128158844765343 Strategy;Education : 0.01128158844765343 Strategy;Creativity : 0.01128158844765343 Strategy;Action & Adventure : 0.01128158844765343 Simulation;Education : 0.01128158844765343 Role Playing;Brain Games : 0.01128158844765343 Racing;Pretend Play : 0.01128158844765343 Puzzle;Education : 0.01128158844765343 Parenting;Brain Games : 0.01128158844765343 Music & Audio;Music & Video : 0.01128158844765343 Lifestyle;Pretend Play : 0.01128158844765343 Lifestyle;Education : 0.01128158844765343 Health & Fitness;Education : 0.01128158844765343 Health & Fitness;Action & Adventure : 0.01128158844765343 Entertainment;Education : 0.01128158844765343 Communication;Creativity : 0.01128158844765343 Comics;Creativity : 0.01128158844765343 Casual;Music & Video : 0.01128158844765343 Card;Action & Adventure : 0.01128158844765343 Books & Reference;Education : 0.01128158844765343 Art & Design;Pretend Play : 0.01128158844765343 Art & Design;Action & Adventure : 0.01128158844765343 Arcade;Pretend Play : 0.01128158844765343 Adventure;Education : 0.01128158844765343 FAMILY : 18.907942238267147 GAME : 9.724729241877256 TOOLS : 8.461191335740072 BUSINESS : 4.591606498194946 LIFESTYLE : 3.9034296028880866 PRODUCTIVITY : 3.892148014440433 FINANCE : 3.7003610108303246 MEDICAL : 3.531137184115524 SPORTS : 3.395758122743682 PERSONALIZATION : 3.3167870036101084 COMMUNICATION : 3.2378158844765346 HEALTH_AND_FITNESS : 3.0798736462093865 PHOTOGRAPHY : 2.944494584837545 NEWS_AND_MAGAZINES : 2.7978339350180503 SOCIAL : 2.6624548736462095 TRAVEL_AND_LOCAL : 2.33528880866426 SHOPPING : 2.2450361010830324 BOOKS_AND_REFERENCE : 2.1435018050541514 DATING : 1.861462093862816 VIDEO_PLAYERS : 1.7937725631768955 MAPS_AND_NAVIGATION : 1.3989169675090252 FOOD_AND_DRINK : 1.2409747292418771 EDUCATION : 1.1620036101083033 ENTERTAINMENT : 0.9589350180505415 LIBRARIES_AND_DEMO : 0.9363718411552346 AUTO_AND_VEHICLES : 0.9250902527075812 HOUSE_AND_HOME : 0.8235559566787004 WEATHER : 0.8009927797833934 EVENTS : 0.7107400722021661 PARENTING : 0.6543321299638989 ART_AND_DESIGN : 0.6430505415162455 COMICS : 0.6204873646209386 BEAUTY : 0.5979241877256317 Social Networking : 71548.34905660378 Photo & Video : 28441.54375 Games : 22788.6696905016 Music : 57326.530303030304 Reference : 74942.11111111111 Health & Fitness : 23298.015384615384 Weather : 52279.892857142855 Utilities : 18684.456790123455 Travel : 28243.8 Shopping : 26919.690476190477 News : 21248.023255813954 Navigation : 86090.33333333333 Lifestyle : 16485.764705882353 Entertainment : 14029.830708661417 Food & Drink : 33333.92307692308 Sports : 23008.898550724636 Book : 39758.5 Finance : 31467.944444444445 Education : 7003.983050847458 Productivity : 21028.410714285714 Business : 7491.117647058823 Catalogs : 4004.0 Medical : 612.0 ART_AND_DESIGN : 1986335.0877192982 AUTO_AND_VEHICLES : 647317.8170731707 BEAUTY : 513151.88679245283 BOOKS_AND_REFERENCE : 8767811.894736841 BUSINESS : 1712290.1474201474 COMICS : 817657.2727272727 COMMUNICATION : 38456119.167247385 DATING : 854028.8303030303 EDUCATION : 1833495.145631068 ENTERTAINMENT : 11640705.88235294 EVENTS : 253542.22222222222 FINANCE : 1387692.475609756 FOOD_AND_DRINK : 1924897.7363636363 HEALTH_AND_FITNESS : 4188821.9853479853 HOUSE_AND_HOME : 1331540.5616438356 LIBRARIES_AND_DEMO : 638503.734939759 LIFESTYLE : 1437816.2687861272 GAME : 15588015.603248259 FAMILY : 3695641.8198090694 MEDICAL : 120550.61980830671 SOCIAL : 23253652.127118643 SHOPPING : 7036877.311557789 PHOTOGRAPHY : 17840110.40229885 SPORTS : 3638640.1428571427 TRAVEL_AND_LOCAL : 13984077.710144928 TOOLS : 10801391.298666667 PERSONALIZATION : 5201482.6122448975 PRODUCTIVITY : 16787331.344927534 PARENTING : 542603.6206896552 WEATHER : 5074486.197183099 VIDEO_PLAYERS : 24727872.452830188 NEWS_AND_MAGAZINES : 9549178.467741935 MAPS_AND_NAVIGATION : 4056941.7741935486