Once upon a time, in a cold Monday morning, I had a call with an imaginary boss. He told me that he wanted to build an app.
Imaginary Boss: "Hello? Imaginary Subordinate? Build me an app."
Me: "Hello, Imaginary Boss. Ok, but could you be more specific, please?"
Imaginary Boss: "I want it to be a mobile app for Android and iOS. Y'know, standard stuff."
Me: "You want it to be free or just be greedy?"
Imaginary Boss: "Nah. I'm feeling generous. Just make it free to download and see how in-app ads help us generate revenue. Get some historical data about this mobile apps and think about the factors that could influence the revenue."
Me: "Sure. I can look at the user numbers, especially those who see and engage with the ads. Giving them incentive for viewing ads might increase the revenue, too. I'll just take a look what type of apps people like the most."
Imaginary Boss: "Ok, looks like you already know what to do. Give me a report by today."
Me: "You're crazy."
Imaginary Boss: "I'm imaginary, I can be as crazy as I want."
Me: "Well, fine if you see it that way. Since I'm imaginary too, I can be crazier than you and have it sent by noon."
Imaginary Boss: "Ooh. Nice. I'll treat you some imaginary coffee after this."
Me: "Sure."
Being as lazy as I can be (i.e. to reduce the potential time and money cost for data collection), I tried to find any existing data to analyze my task. Luckily, I found some:
Let's check it out.
from csv import reader
# Google Play dataset
opened_file = open('googleplaystore.csv')
read_file = reader(opened_file)
android = list(read_file)
android_header = android[0]
android = android[1:]
# App Store dataset
opened_file = open('AppleStore.csv')
read_file = reader(opened_file)
ios = list(read_file)
ios_header = ios[0]
ios = ios[1:]
def explore_data(dataset, start, end, rows_and_columns=False):
dataset_slice = dataset[start:end]
for row in dataset_slice:
print(row)
print('\n') # adds a new (empty) line after each row
if rows_and_columns:
print('Number of rows:', len(dataset))
print('Number of columns:', len(dataset[0]))
print(ios_header)
print('\n')
explore_data(ios, 0, 3, True)
['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
Ooh, I love these iOS apps. Shoot, I don't understand what the header means. Some are self-explanatory, but others aren't. Based on the documentation, I think 'track name'
, 'currency'
, 'rating_count_tot'
, 'rating_count_ver'
, and 'prime_genre'
are useful.
Let's check the Android apps.
print(android_header)
print('\n')
explore_data(android, 0, 3, True)
['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: 10841 Number of columns: 13
Oh, I haven't use any of these apps before, BU. Anyway, I think 'App'
, 'Category'
, 'Reviews'
, 'Installs'
, 'Type'
, 'Price'
, and 'Genres'
are useful.
So, I strolled around the discussion section to see any potential problems with this data sets. And yes, in the Google Play data set, someone pointed out there's an error for row 10472 (missing category so the data shifted to the left). Let's see.
print(android_header)
print('\n')
print(android[10472]) # incorrect row
print('\n')
print(android[14]) # example of a correct row
['App', 'Category', 'Rating', 'Reviews', 'Size', 'Installs', 'Type', 'Price', 'Content Rating', 'Genres', 'Last Updated', 'Current Ver', 'Android Ver'] ['Life Made WI-Fi Touchscreen Photo Frame', '1.9', '19', '3.0M', '1,000+', 'Free', '0', 'Everyone', '', 'February 11, 2018', '1.0.19', '4.0 and up'] ['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']
Well, it looks like row 10472 has a 'Rating'
of 19 which clearly doesn't make any sense since the maximum rating for a Google Play app is 5. It looks like this happened because this row is missing 'Category'
. I have two options here: correcting it (someone stated in the discussion that it belongs to the 'Lifestyle' section), or remove it. Let's just delete it.
print(len(android))
del android[10472]
print(len(android))
10841 10840
Large data sets should raise the suspicion of data duplication. Let's check the first app listed in the above explore data output (Facebook).
for app in android:
name = app[0]
if name == 'Facebook':
print(app)
['Facebook', 'SOCIAL', '4.1', '78158306', 'Varies with device', '1,000,000,000+', 'Free', '0', 'Teen', 'Social', 'August 3, 2018', 'Varies with device', 'Varies with device'] ['Facebook', 'SOCIAL', '4.1', '78128208', 'Varies with device', '1,000,000,000+', 'Free', '0', 'Teen', 'Social', 'August 3, 2018', 'Varies with device', 'Varies with device']
Yup. Suspicion confirmed. Let's go through them all.
duplicate_apps = []
unique_apps = []
for app in android:
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('Example of duplicate apps:', duplicate_apps[:5])
Number of duplicate apps: 1181 Example of duplicate apps: ['Quick PDF Scanner + OCR FREE', 'Box', 'Google My Business', 'ZOOM Cloud Meetings', 'join.me - Simple Meetings']
I need to remove the duplicates for the analysis, but I need to know first which one to remove. Based on the information on the Facebook app, there is a difference in the 'Review'
column (number of reviews). I'll go with a row that has the highest review number to make the analysis more reliable and remove the others.
To do this, I'll create a new data set from a dictionary where each key is a unique app name with the value based on the highest number of reviews of that app.
reviews_max = {}
for app in android:
name = app[0]
n_reviews = float(app[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('Expected length:', len(android) - 1181)
#1181 is the number of duplicated app
print('Actual length:', len(reviews_max))
Expected length: 9659 Actual length: 9659
Now the reviews_max
dictionary is ready to be used as a pointer to remove the duplicates.
I will add the current row (app
) to the android_clean
list, and the app name (name
) to the already_added
list if:
app
matches the one in the reviews_max
dictionary.name
is not already in the already_added
list. This is to account for cases where the highest number of reviews of a duplicate app is the same for more than one entry (e.g. Facebook app has four entries, and each has the same number of reviews). If I just check for the reviews_max[name] == n_reviews
, the rows for that app that have the same number of reviews will still be included.android_clean = []
already_added = []
for app in android:
name = app[0]
n_reviews = float(app[3])
if (reviews_max[name] == n_reviews) and (name not in already_added):
android_clean.append(app)
already_added.append(name)
It's time to test the new data set! If it shows 9659 rows, then I have successfully removed the correct duplicates.
explore_data(android_clean, 0, 3, True)
['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'] ['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'] ['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'] Number of rows: 9659 Number of columns: 13
As a monolingual, obviously the target market of my imaginary boss is English-speaking users (though I tried to teach him ありがとう and 谢谢 a few times already, but yeah).
So, let's get rid of those non-English apps by considering the ASCII standard characters and the built-in ord()
function. Symbols are a bit tricky, because there might be quite a significant number of apps that use symbols, so we can't be too perfect here.
...and, oh. My imaginary boss is allergic to emojis. He won't, ever, like, EVER, put too many emojis on his apps titles. So it's better to be careful not to consider app with way too many emojis in this data.
def is_english(string):
for character in string:
if ord(character) > 127:
return False
return True
print(is_english('Facebook'))
print(is_english('爱奇艺PPS -《欢乐颂2》电视剧热播'))
print(is_english('Docs To Go™ Free Office Suite'))
print(is_english('Instachat 😜'))
print(ord('™'))
print(ord('😜'))
True False False False 8482 128540
Now, let's only remove the apps with more than three non-ASCII characters to minimize losses.
def is_english(string):
non_ascii = 0
for character in string:
if ord(character) > 127:
non_ascii += 1
if non_ascii > 3:
return False
else:
return True
print(is_english('Docs To Go™ Free Office Suite'))
print(is_english('Instachat 😜'))
True True
android_english = []
ios_english = []
for app in android_clean:
name = app[0]
if is_english(name):
android_english.append(app)
for app in ios:
name = app[1]
if is_english(name):
ios_english.append(app)
explore_data(android_english, 0, 3, True)
print('\n')
explore_data(ios_english, 0, 3, True)
['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'] ['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'] ['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'] Number of rows: 9614 Number of columns: 13 ['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: 6183 Number of columns: 16
android_final = []
ios_final = []
for app in android_english:
price = app[7]
if price == '0':
android_final.append(app)
for app in ios_english:
price = app[4]
if price == '0.0':
ios_final.append(app)
print(len(android_final))
print(len(ios_final))
8864 3222
I want to see what kind of apps more likely to attract users because the revenue will be heavily influenced by the number of users.
The validation for that aim is as follows:
I suspect gamification apps will have many users. It's useful for any age, fun for kids, and better to have it in multiple operating systems just in case the user have many devices with different OS, and would like to sync their progress.
I'll create a frequency table to get a sense of the most common apps by using the prime_genre
column in the App Store data set and Genre
and Category
for the Google Play data set.
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
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])
display_table(ios_final, -5)
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
Games alone already taken up more than half of the free apps genre (58.1%), followed by the Entertainment genre (7.8%). I wonder if the developers think that users mostly download apps for fun and won't pay much for entertainment purposes, and therefore they won't be too bothered about in-app ads because it's free anyway, so the developers can generate revenue from it. But the numbers of fun apps don't imply they also have the greatest number of users.
It might be different for free productivity or educational app, users might expect a much more professional or polished ad-free paid app to ensure no ads are going to distract them, and hope that paid apps developers will consider best user experience to help them work or study.
display_table(android_final, 1) #Category
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
The most common genre is Family, which I suspect is full of kids games. But overall, Google Play store offers a more balanced apps than the App Store which has more games.
display_table(android_final, -4) # Genres
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
This 'Genre'
column is more granular than the 'Category'
. Let's just stick with the 'Category'
as it gives more general sense.
To know what genres are the most popular (have the most users), I'll calculate the average number of installs per each genre.
To get the average numbers of installs per each genre, I have to isolate the apps of each genre, sum up the user ratings of that genre, and divide that sum by the number of apps belonging to that genre.
I can use Installs
column for Google Play data, but since there is no counterpart for this in the App Store data, I'm going to use the rating_count_tot
.
genres_ios = freq_table(ios_final, -5)
for genre in genres_ios:
total = 0 #to store the sum of user ratings (number, not actual)
len_genre = 0 #to store the genre-specific apps number
for app in ios_final:
genre_app = app[-5]
if genre_app == genre:
n_ratings = float(app[5])
total += n_ratings
len_genre += 1
avg_n_ratings = total / len_genre
print(genre, ':', avg_n_ratings)
Games : 22788.6696905016 Music : 57326.530303030304 Health & Fitness : 23298.015384615384 Social Networking : 71548.34905660378 News : 21248.023255813954 Business : 7491.117647058823 Navigation : 86090.33333333333 Travel : 28243.8 Medical : 612.0 Entertainment : 14029.830708661417 Photo & Video : 28441.54375 Utilities : 18684.456790123455 Reference : 74942.11111111111 Food & Drink : 33333.92307692308 Finance : 31467.944444444445 Shopping : 26919.690476190477 Weather : 52279.892857142855 Lifestyle : 16485.764705882353 Education : 7003.983050847458 Book : 39758.5 Sports : 23008.898550724636 Catalogs : 4004.0 Productivity : 21028.410714285714
for app in ios_final:
if app[-5] == 'Reference':
print(app[1], ':', app[5])
Bible : 985920 Dictionary.com Dictionary & Thesaurus : 200047 Dictionary.com Dictionary & Thesaurus for iPad : 54175 Google Translate : 26786 Muslim Pro: Ramadan 2017 Prayer Times, Azan, Quran : 18418 New Furniture Mods - Pocket Wiki & Game Tools for Minecraft PC Edition : 17588 Merriam-Webster Dictionary : 16849 Night Sky : 12122 City Maps for Minecraft PE - The Best Maps for Minecraft Pocket Edition (MCPE) : 8535 LUCKY BLOCK MOD ™ for Minecraft PC Edition - The Best Pocket Wiki & Mods Installer Tools : 4693 GUNS MODS for Minecraft PC Edition - Mods Tools : 1497 Guides for Pokémon GO - Pokemon GO News and Cheats : 826 WWDC : 762 Horror Maps for Minecraft PE - Download The Scariest Maps for Minecraft Pocket Edition (MCPE) Free : 718 VPN Express : 14 Real Bike Traffic Rider Virtual Reality Glasses : 8 教えて!goo : 0 Jishokun-Japanese English Dictionary & Translator : 0
Navigation, Music, Social Networking, Weather and Reference apps seem to be in the most average numbers.
I don't think we can get much benefit if we create an app under the Music and Social networking genre, since there are many big players there. Book genre is also dominated by Kindle.
Weather won't do much either since people won't look at their weather app for such a long time. Finance genre will require a specific domain knowledge, and it's impractical for now. Food & drink and shopping genres are popular because they have a real store for that, and we don't, so this won't be an option. Sports and Travel seem nice too, but could be too niche.
We can go with Reference, Photo & Video, Productivity, and Health & Fitness. I think all of these are potential. We can have popular books to be turned into an app under the Reference genre. Users always love new filters for their photos, so we can create an app for the Photo & Video genre. Gamified pomodoro technique for Productivity might also work because people will use that app for quite some time. Health & Fitness gamification will also increase engagement with the users and we're promoting good health.
But let's see whether any of these potential genres overlap with the categories in the Google Play. Hopefully so.
I can use Installs
column for Google Play data, so let's check it out.
display_table(android_final, 5) # Installs
1,000,000+ : 15.726534296028879 100,000+ : 11.552346570397113 10,000,000+ : 10.548285198555957 10,000+ : 10.198555956678701 1,000+ : 8.393501805054152 100+ : 6.915613718411552 5,000,000+ : 6.825361010830325 500,000+ : 5.561823104693141 50,000+ : 4.7721119133574 5,000+ : 4.512635379061372 10+ : 3.5424187725631766 500+ : 3.2490974729241873 50,000,000+ : 2.3014440433213 100,000,000+ : 2.1322202166064983 50+ : 1.917870036101083 5+ : 0.78971119133574 1+ : 0.5076714801444043 500,000,000+ : 0.2707581227436823 1,000,000,000+ : 0.22563176895306858 0+ : 0.04512635379061372 0 : 0.01128158844765343
Ok, apparently the data is open-ended (100+, 1,000+, etc.). To keep things simple, I'll consider the number for what it is (500,000+ means 500,000 installs, 100+ installs means 100 installs, etc.). To do this, I have to remove the comma and plus symbols to avoid errors.
categories_android = freq_table(android_final, 1)
for category in categories_android:
total = 0
len_category = 0
for app in android_final:
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 += 1
avg_n_installs = total / len_category
print(category, ':', avg_n_installs)
SPORTS : 3638640.1428571427 BOOKS_AND_REFERENCE : 8767811.894736841 HOUSE_AND_HOME : 1331540.5616438356 PHOTOGRAPHY : 17840110.40229885 FAMILY : 3695641.8198090694 HEALTH_AND_FITNESS : 4188821.9853479853 NEWS_AND_MAGAZINES : 9549178.467741935 LIBRARIES_AND_DEMO : 638503.734939759 PRODUCTIVITY : 16787331.344927534 ENTERTAINMENT : 11640705.88235294 TOOLS : 10801391.298666667 WEATHER : 5074486.197183099 SOCIAL : 23253652.127118643 EVENTS : 253542.22222222222 LIFESTYLE : 1437816.2687861272 DATING : 854028.8303030303 PARENTING : 542603.6206896552 SHOPPING : 7036877.311557789 COMMUNICATION : 38456119.167247385 EDUCATION : 1833495.145631068 FOOD_AND_DRINK : 1924897.7363636363 AUTO_AND_VEHICLES : 647317.8170731707 GAME : 15588015.603248259 BUSINESS : 1712290.1474201474 BEAUTY : 513151.88679245283 COMICS : 817657.2727272727 MEDICAL : 120550.61980830671 ART_AND_DESIGN : 1986335.0877192982 VIDEO_PLAYERS : 24727872.452830188 FINANCE : 1387692.475609756 PERSONALIZATION : 5201482.6122448975 MAPS_AND_NAVIGATION : 4056941.7741935486 TRAVEL_AND_LOCAL : 13984077.710144928
Since my imaginary boss would like to have the app in both OS, I'll focus on the genres that I've already decided based on the iOS app earlier.
I'll suggest that we build an app for the Photography, Health and Fitness, Productivity and Books and Reference categories.
Wait, what's that Tools category? Seems interesting.
for app in android_final:
if app[1] == 'TOOLS':
print(app[0], ':', app[5])
Google : 1,000,000,000+ Google Translate : 500,000,000+ Moto Display : 10,000,000+ Motorola Alert : 50,000,000+ Motorola Assist : 50,000,000+ Moto Suggestions ™ : 1,000,000+ Moto Voice : 10,000,000+ Calculator : 100,000,000+ Device Help : 100,000,000+ Account Manager : 100,000,000+ myMetro : 10,000,000+ File Manager : 50,000,000+ My Telcel : 50,000,000+ Calculator - free calculator, multi calculator app : 10,000,000+ ASUS Sound Recorder : 10,000,000+ iWnn IME for Nexus : 5,000,000+ Samsung Max - Data Savings & Privacy Protection : 10,000,000+ Android TV Remote Service : 1,000,000+ ZenUI Help : 10,000,000+ Calculator - free calculator ,multi calculator app : 100,000+ SHAREit - Transfer & Share : 500,000,000+ ZenUI Keyboard – Emoji, Theme : 10,000,000+ Files Go by Google: Free up space on your phone : 10,000,000+ SD card backup : 1,000,000+ Nokia mobile support : 5,000,000+ File Manager -- Take Command of Your Files Easily : 10,000,000+ Samsung Calculator : 100,000,000+ Clear : 10,000,000+ Phone : 10,000,000+ HTC Lock Screen : 10,000,000+ Gboard - the Google Keyboard : 500,000,000+ Google Korean Input : 100,000,000+ AT&T Smart Wi-Fi : 10,000,000+ Google app for Android TV : 10,000,000+ Sound Recorder: Recorder & Voice Changer Free : 10,000,000+ Remote Link (PC Remote) : 10,000,000+ HTC Sense Input : 10,000,000+ Share Music & Transfer Files - Xender : 100,000,000+ App vault : 10,000,000+ TouchPal Keyboard for vivo : 1,000,000+ Google Assistant Go : 500,000+ My love : 10,000,000+ DuraSpeed : 10,000,000+ HTC Sense Input-LV : 50,000+ HTC Sense Input-CA : 100,000+ HTC Sense Input-AR : 100,000+ Digital Alarm Clock : 10,000,000+ Alarm Clock Free : 10,000,000+ Puzzle Alarm Clock ⏰ : 1,000,000+ Alarm Clock : 5,000,000+ I Can't Wake Up! Alarm Clock : 1,000,000+ High-Powered Flashlight : 10,000,000+ Brightest Flashlight - LED Light : 50,000,000+ LED Flashlight : 10,000,000+ Tiny Flashlight + LED : 100,000,000+ Flashlight & LED Torch : 10,000,000+ Color Flashlight : 50,000,000+ CM Flashlight (Compass, SOS) : 5,000,000+ Flashlight HD LED : 50,000,000+ Flashlight - Torch LED Light : 10,000,000+ Super Flashlight + LED : 5,000,000+ Brightest LED Flashlight : 5,000,000+ Brightest Flashlight Free ® : 50,000,000+ Fraction Calculator Plus Free : 5,000,000+ Calculator Plus Free : 10,000,000+ CALCU™ Stylish Calculator Free : 5,000,000+ Mobi Calculator free & AD free! : 5,000,000+ Calculator with Percent (Free) : 1,000,000+ Graphing Calculator : 1,000,000+ Unit Converter : 1,000,000+ Calculator ++ : 1,000,000+ MyScript Calculator : 10,000,000+ ConvertPad - Unit Converter : 10,000,000+ Unit Converter Pro : 1,000,000+ Classic Calculator : 5,000,000+ Scientific Calculator Free : 1,000,000+ weight conversion calculator : 100,000+ Age Calculator : 1,000,000+ EzCalculator : 100,000+ SuperVPN Free VPN Client : 50,000,000+ Hideman VPN : 5,000,000+ Fast Secure VPN : 1,000,000+ Free & Premium VPN - FinchVPN : 1,000,000+ Hotspot Shield Free VPN Proxy & Wi-Fi Security : 50,000,000+ OpenVPN Connect – Fast & Safe SSL VPN Client : 10,000,000+ VPN - Fast, Secure & Unlimited WiFi with VyprVPN : 1,000,000+ FREEDOME VPN Unlimited anonymous Wifi Security : 1,000,000+ SurfEasy Secure Android VPN : 5,000,000+ TunnelBear VPN : 5,000,000+ VPN Free - Betternet Hotspot VPN & Private Browser : 10,000,000+ Smart Keyboard Trial : 10,000,000+ Emoji keyboard - Cute Emoticons, GIF, Stickers : 50,000,000+ GO Keyboard - Cute Emojis, Themes and GIFs : 100,000,000+ Google Handwriting Input : 10,000,000+ Wifi Analyzer : 10,000,000+ Network Signal Info : 1,000,000+ Speedtest by Ookla : 100,000,000+ osmino Wi-Fi: free WiFi : 10,000,000+ WiFi Overview 360 : 1,000,000+ Speedcheck : 1,000,000+ Internet Speed Meter Lite : 10,000,000+ Wifi Inspector : 5,000,000+ WiFi Automatic : 1,000,000+ NETGEAR WiFi Analytics : 1,000,000+ Keypad Lock Screen : 10,000,000+ photo keypad lockscreen : 10,000,000+ CM Locker - Security Lockscreen : 100,000,000+ Solo Locker (DIY Locker) : 10,000,000+ Lock Screen : 1,000,000+ ZERO Lock Screen : 1,000,000+ AppLock - Fingerprint : 10,000,000+ Applock : 100,000,000+ Smart AppLock (App Protect) : 10,000,000+ Screen Off and Lock : 10,000,000+ Screen Lock : 1,000,000+ Flashlight : 10,000,000+ B-BLE(BLE4.0 Scan) : 10,000+ Servers Ultimate Pack B : 50,000+ Clean Master- Space Cleaner & Antivirus : 500,000,000+ Bridge-C - Get More Storage : 1,000+ Screen Lock - with Fingerprint Simulator : 10,000,000+ Tuner - gStrings Free : 10,000,000+ Lookout Security & Antivirus : 100,000,000+ Video Downloader for Facebook : 50,000,000+ FlashLight F.Light : 100,000+ F-Secure SENSE : 5,000+ F-Secure KEY Password manager : 100,000+ F-Secure SAFE : 500,000+ F-Secure AV Test : 50,000+ F-Secure Mobile Security : 500,000+ F : 500+ Convert degree Celsius to Fahrenheit or °F to °C : 5,000+ Google Now Launcher : 100,000,000+ Speedometer with G-FORCE meter : 50,000+ Car G-Force Meter : 10,000+ HSPA+ Tweaker (3G booster) : 5,000,000+ DNS Changer - BEST (Gprs/Edge/3G/H/H+/4G) : 5,000+ Force LTE Only : 1,000,000+ Mobile Number Tracker : 5,000,000+ I Screen Dialer : 1,000,000+ J Touch : 100,000+ Smart TV Remote : 10,000,000+ K keyboard - Myanmar : 100,000+ K-Chiing VPN (Free) : 5,000+ 360-M Flight : 10,000+ GTS-M : 5,000+ M Notifier for M Launcher : 100,000+ O Launcher 8.0 for Android™ O Oreo Launcher : 1,000,000+ AC Remote for O General - NOW FREE : 50,000+ O Launcher : 100,000+ O Multiple - App Cloner, Duals APP, tarallel : 50,000+ Super P Launcher for Android P 9.0 launcher, theme : 100,000+ P9 Launcher - Android™ 9.0 P Launcher Style : 100,000+ Android P Rotation : 10,000+ Android P Launcher 9.0 launcher : 10,000+ Q-See QC View : 100,000+ Q Remote Control : 500,000+ myQ : 100,000+ QR Code Reader : 50,000,000+ Q Call : 1,000+ Q-See QT View : 100,000+ .R : 10,000+ R File Manager : 50+ 360 Security - Free Antivirus, Booster, Cleaner : 100,000,000+ S Player - Lightest and Most Powerful Video Player : 1,000,000+ Samsung Smart Switch Mobile : 100,000,000+ S S9 Launcher - Galaxy S8/S9 Launcher, theme, cool : 1,000,000+ S Pen Keeper : 50,000+ T-Mobile : 10,000,000+ T-Mobile Visual Voicemail : 50,000,000+ AT&T FamilyMap® : 10,000,000+ Don't touch my phone : 5,000,000+ U-Scan : 50,000+ Parallel U - App Cloner, Duals APP, tarallel : 500,000+ U get - Wireless Speed Test : 5,000+ U Guard : 10,000+ Remote For ATT U-verse TV - NOW FREE : 5,000+ Ace Screen Recorder w facecam : 100,000+ WIFI WPS WPA TESTER : 10,000,000+ Flashlight Free w/ compass : 10,000+ App Lock: Locker w/ fingerprint, Parental Control : 1,000,000+ Open in WhatsApp (click to chat) : 1,000,000+ WPSApp : 10,000,000+ X-VPN - Free Unlimited VPN Proxy : 5,000,000+ Phone X Launcher, OS 11 iLauncher & Control Center : 5,000,000+ Lock Screen Phone X Style OS 11 : 100,000+ Control Center iOS 11 - Phone X Control Panel : 100,000+ X-plore File Manager : 10,000,000+ Flashlight X : 1,000,000+ iSwipe Phone X : 1,000,000+ X Home Bar - Free : 100,000+ [ROOT] X Privacy Installer : 1,000,000+ Control Center iOS 11 - Phone X notifications : 50,000+ Antivirus & Mobile Security : 10,000,000+ Flashlight Ultimate : 1,000,000+ Avast Mobile Security 2018 - Antivirus & App Lock : 100,000,000+ ZArchiver : 10,000,000+ Zapya - File Transfer, Sharing : 10,000,000+ CPU-Z : 10,000,000+ Moto Z Market : 1,000,000+ AB Screen Recorder : 10,000+ Universal AC Remote Control : 1,000,000+ Smart Air Conditioner : 500,000+ AC Remote Control : 100,000+ Air conditioner remote control : 1,000,000+ AC WIFI : 10,000+ A/C Air Conditioner Remote : 1,000,000+ Smart Air Conditioner(CAC) : 50,000+ Carrier Air Conditioner : 100,000+ AC Troubleshooter : 10,000+ TOSHIBA Smart AC : 10,000+ Trane Interactive Smart AC : 10,000+ AC remote control mobile : 100,000+ AC Remote for Haier - NOW FREE : 50,000+ AC Remote for Daikin - NOW FREE : 50,000+ A/C Universal Remote Control : 1,000,000+ AC Remote for LG - NOW FREE : 100,000+ Plug-in app (System AC) : 10,000+ AC Remote for Midea - NOW FREE : 100,000+ Ac remote control : 50,000+ Mi Remote controller - for TV, STB, AC and more : 10,000,000+ AC Remote For LG : 100,000+ Hi-Smart AC : 1,000+ AC Remote for Sharp - NOW FREE : 50,000+ AC Remote for Samsung - NOW FREE : 100,000+ AC Remote for Carrier - NOW FREE : 10,000+ AC & TV, DVD, Set Top Box - Remote control IR : 1,000,000+ ac remote control : 500,000+ AppBrain Ad Detector : 1,000,000+ AdClear Ad blocker for Samsung : 500,000+ Adguard Content Blocker : 1,000,000+ Ad Detector : 50,000+ Anti Adware : 1,000,000+ Ad Block REMOVER - NEED ROOT : 100,000+ Photo Compress 2.0 - Ad Free : 1,000,000+ Emo Ads Blocker Browser : 100,000+ Apps Ads Detector : 100,000+ AE Order : 1,000+ AE Manager : 100+ AppFinder by AppTap : 5,000,000+ DSLR Blur Camera Auto Focus : 10,000+ AppLock : 100,000,000+ Ag Tools : 1,000+ AG Screen Recorder : 1,000+ SOLEM AG : 1,000+ BRL AG : 100+ AG test : 100+ AG Track : 100+ WoW AH Tracker : 10,000+ Cathy AH : 1+ SMS AI Bot : 10,000+ Ai File Viewer : 10,000+ ParaTek Ai Speech generator : 50,000+ AI Benchmark : 5,000+ Virtual Eye AI : 500+ AK47 Assault Rifle : 10,000+ AK Booster : 10,000+ Where Am I? : 100,000+ A. O. Smith : 10,000+ AP Manager : 10,000+ Access Point Browser : 1,000+ AP Installer : 5,000+ Access Point Proximity : 1,000+ UniFi : 500,000+ Ap Video Downloader for fb New 2018 : 100,000+ HotSpot Tethering Free/WiFi AP : 100,000+ Fate GO Ap Counter : 1,000+ APN Settings : 1,000,000+ AQ wisdom + : 100+ AQ SMS Notify : 10+ QR BARCODE SCANNER : 10,000,000+ ARuler - AR Ruler app, Measure tools : 100,000+ Image 2 Wallpaper : 5,000,000+ Powershop AU : 10,000+ AVG AntiVirus 2018 for Android Security : 100,000,000+ AV Tools : 100,000+ Remote for Onkyo AV Receivers & Smart TV/Blu-Ray : 100,000+ LG AV REMOTE : 1,000,000+ Norton Security and Antivirus : 10,000,000+ Remote For Pioneer AV Receivers and Blu-Ray : 50,000+ Kaspersky Mobile Antivirus: AppLock & Web Security : 50,000,000+ Samsung TV AV Guide 2016 : 5,000+ Bitdefender Antivirus Free : 1,000,000+ Avast Cleanup & Boost, Phone Cleaner, Optimizer : 10,000,000+ Analog Clock AW Plus-7 : 100,000+ Analog Clock AW-7 : 100,000+ Watch AW-7 : 50,000+ Digital Clock AW-7 : 100,000+ Analog and Digital Clock AW-7 : 50,000+ AW CAMERA : 100+ AW Browser with Chrome Custom Tabs : 500+ Roman Clock AW-7 : 5,000+ Square Analog Clock AW-7 : 50,000+ Axxess AX-DSP : 5,000+ AX Window : 5+ Axxess Updater : 10,000+ AX-PIC Pedidos : 1,000+ AY Recorder - Screen Recorder, Live, Video Editor : 500+ Ay Yıldız Keyboard : 1,000+ Display Phone Screen On TV : 1,000,000+ AZ Screen Recorder pro : 5,000+ AZ PLAYER HD : 10,000+ AZ REMOTE CONTROL : 50,000+ Loreal - BA Makeup : 1,000+ Elif Ba Oyunu : 5,000+ BC Wildfire : 5,000+ BD tools : 10,000+ Remote for Samsung TV & BluRay Players (Read Desc) : 500,000+ Vehicle Case Checker BD : 10,000+ Remote for Sony TV & Sony Blu-Ray Players MyAV : 1,000,000+ Remote for Panasonic TV+BD+AVR : 100,000+ Unseen - No Last Seen : 5,000,000+ BF-Calc : 100,000+ BG Advisor™ : 1,000+ HTC Sense Input-BG : 100,000+ HTC Sense Input - BG : 10,000+ ReactNative BG Geolocation : 1,000+ Simple Photo BG Changer : 10+ BG Remover & Eraser Pro : 500+ BG-FLEET : 10+ Bg+ Call Blocker : 10,000+ ScorePal : 10,000+ GEM™ : 500+ VIVA BH : 100,000+ bi-Cube Mobile Token : 1,000+ All Language Translator : 5,000,000+ Virtual DJ Sound Mixer : 500,000+ Metal Detector Pro 2015 : 100,000+ BK Formula Calculator 2 : 100+ Service Disabler : 100,000+ BK Formula Calculator : 100+ K-Rain BL : 1,000+ BM Online OEC Verification : 100,000+ TuenMun BM : 1,000+ BM speed test : 10+ Sam.BN : 1,000+ BP Assist : 100+ BQ Services : 1,000,000+ BQ Scan : 100+ Software Update : 1,000,000+ BQ Scanner : 100+ System Update Free : 100,000+ Free antivirus and VPN : 1,000,000+ Simple Gallery : 1,000,000+ Zetup, print in one click : 1,000+ Next Portuguese(BR) Langpack : 100,000+ BS Battery+ : 50,000+ BS Where Am I : 50+ BS TRACK CLIENT : 10+ CABLE SIZE CALCULATOR BS 7671 : 100,000+ VOLT DROP CALCULATOR BS 7671 : 10,000+ BTNotification : 5,000,000+ Little Magnet BT : 100,000+ BT Notifier : 1,000,000+ Bt Notifier -Smartwatch notice : 500,000+ ProGrade BT : 500+ BT Controller : 1,000,000+ Mediatek SmartDevice : 1,000,000+ LG BT Reader Plus : 500,000+ Bluetooth Control BT->uC FREE : 10,000+ Autool BT-BOX : 500+ BT Remote (SPP) for Bluetooth : 10,000+ BT Satmeter : 100+ Battery Notifier BT Free : 1,000,000+ BT Position Sender - Bluetooth Position Sender : 10+ OSRAM BT Control : 1,000+ Jabbla BT : 100+ SenseView BT Zephyr Sensor : 5,000+ VictronConnect : 50,000+ BW Smart : 5,000+ BW SmartLife : 100+ Bixby Button Remapper - bxActions : 1,000,000+ Bx Access 4d : 100+ QR & Barcode Scanner BX PRO : 1,000+ LEDSHOWTW : 500+ Limbo PC Emulator QEMU ARM x86 : 1,000,000+ Project Fi by Google : 1,000,000+ BZ Conferencing : 1,000+ WISE- MOBILE PORTAL : 500+ Putzmeister Experts : 1,000+ Bubble : 5,000,000+ CA Mobile OTP : 100,000+ CA Auth ID : 10,000+ CA DMV : 1,000,000+ CB Frequencies FREE! : 100,000+ Frequencies Free : 100,000+ CBRadioTab : 50,000+ CB SMART LIFE : 500+ CB SmartCAR Monitor : 10+ Antenna Tool : 50,000+ CD View Lite : 100+ Disc Label Print : 10,000+ CD View : 500+ РееI Smart Remote MP3 CD Player : 5,000+ CE on the go : 10,000+ CE Smart : 100+ CCleaner : 50,000,000+ Terminal Emulator for Android : 10,000,000+ Ceasa CE : 50+ CF.lumen : 100,000+ CF-Bench : 100,000+ iOBD2-CF : 500+ CF cal : 10,000+ CG Shikshak Mitan : 50,000+ CG 3D Model Viewer: view 3D models interactively : 100+ CG Wizard : 100+ Bhunaksha CG : 10,000+ gps tracker cg : 50+ Green Build - An unofficial Travis CI client : 100+ mySharpBranded CI Test : 1+ Mesure CI : 500+ CK Shop : 1,000+ CL Reader for Craigslist(For sale, jobs, rental..) : 1,000+ CL REPL : 1,000+ CL Keyboard - Myanmar Keyboard (No Ads) : 5,000+ CL Notifier : 100+ MPS CL : 10+ Turnotronik CL : 10+ Security Master - Antivirus, VPN, AppLock, Booster : 500,000,000+ Clean Master Lite - For Low-End Phone : 50,000,000+ CM Security Open VPN - Free, fast unlimited proxy : 1,000,000+ CM Security Lite - Antivirus : 10,000,000+ CM Apps : 100,000+ CM AppLock : 100,000+ Ruler(cm, inch) : 500,000+ AppLock - Fingerprint Unlock : 5,000,000+ Battery Doctor-Battery Life Saver & Battery Cooler : 100,000,000+ Speed Booster - Ram, Battery & Game Speed Booster : 1,000,000+ CM FILE MANAGER : 50,000,000+ Height Converter feet-inch cm : 100,000+ CM Secure Browser (Authorized) : 100,000+ 📏 Smart Ruler ↔️ cm/inch measuring for homework! : 10,000+ Ruler cm : 100,000+ Length Converter: convert mm,cm,m, feet,yard,mile : 50,000+ CM AppLock Fingerprint 2018 : 100,000+ m, cm, mm to yard, feet, inch converter tool : 100,000+ Calculator CM : 500+ Inches to cm conversion : 10,000+ Centimeter Ruler : 10,000+ CM S Pen Add-on(ROOT) : 10,000+ Ruler : 1,000,000+ Ruler & Area Measurement (cm, inch) : 10,000+ Inches to Centimeters : 100,000+ Speed Test - WiFi / Cellular speed test : 1,000,000+ cm to inches | centimeters to inches conversion : 5,000+ In to cm : 10+ Co Checker : 1,000+ Remote | Fire TV | Android TV | KODI | CetusPlay : 1,000,000+ Hercules CP Mobile : 1,000+ Poke Genie - Safe IV Calculator : 1,000,000+ IV Calc CP Calculator Toolkit : 10,000+ gCMOB : 1,000,000+ Ditto CP Calculator GO : 1,000+ Evolve CP Calc. for PokemonGo : 10,000+ Contents Provider(C.P.)Explorer : 100+ Calcy IV : 1,000,000+ Meu Calendário CP : 100+ CQ Key : 100+ Webmail web mobile app : 100,000+ Battle Result Predictor for CR : 1,000,000+ Deck Advisor for CR : 5,000,000+ Card Creator for CR : 10,000,000+ Deck Analyzer for CR : 100,000+ Deck Simulator for CR : 10,000+ Counter Deck Calculator for CR : 500,000+ CR Calculator : 50,000+ DCUO|CR Calculator Lite : 10,000+ CR -Call Recorder : 100+ JavaScript Editor CR : 5,000+ Chest Tracker for Clash Royale : 5,000,000+ Java Editor CR : 50,000+ XML Editor CR : 5,000+ CR Tracker for Chests : 50+ Helper for CS:GO : 10,000+ CT - DTC Lookup : 10,000+ Simpli CT : 100+ Remote CT - Smart Remote : 1,000,000+ HTC Transfer Tool : 5,000,000+ Free CV Creator : 10,000+ CV maker for Job Applications and Resume Maker : 10,000+ CV Maker for Job Applications:Photo Resume Builder : 10,000+ Easy Resume Builder, Resume help, Curriculum vitae : 50,000+ Resume Maker / CV creator & Templates : 5,000+ My CW : 100+ Morse Notifier Free : 1,000+ Cx File Explorer : 10,000+ CX Ram Booster : 500+ Secret Codes For Android : 500,000+ ABTO CY-ET1 : 100+ CZ File Manager : 1,000,000+ HTC Sense Input - CZ : 10,000+ CZ Kompas : 10+ What is my IP address : 500,000+ Master for Minecraft(Pocket Edition)-Mod Launcher : 50,000,000+ Translate: text & voice translator : 5,000,000+ The Zueira's Voice : 1,000,000+ Battery Calibration : 5,000,000+ FVD - Free Video Downloader : 10,000,000+ Download Manager for Android : 10,000,000+ SQLite DB Reader : 50,000+ DB Browser : 50,000+ Sound Meter : 10,000,000+ dB: Sound Meter Pro : 5,000+ dB Sound Level Meter : 10,000+ DB Sound Meter: Measure Noise Level- Decibel Meter : 10,000+ Check DB Benchmark : 100+ dB Meter - measure sound & noise level in Decibel : 10,000+ DB LINK RGB : 500+ DB TOS - Pocket Helper : 10,000+ Patron DB : 5,000+ Bowers & Wilkins DB Subwoofers : 10,000+ dB Sound Meter : 5,000+ Preferences Manager and SQLite DB Viewer : 1,000+ SW-DB : 10,000+ DC Universe Online Map : 50,000+ Vote 4 DC : 1,000+ APUS File Manager (Explorer) : 50,000,000+ Easy Language Translator : 10,000,000+ Satellite Director : 10,000,000+ df : 1,000+ Digital Falak : 50,000+ DF-CAM : 100+ DF Wall Plus – Droid Firewall : 500+ DF SmartPlus : 10+ ProconLegis-DF : 5+ Consultar Infracciones de Transito DF y Mexico : 10+ PDF Reader – PDF Editor 2018 : 500,000+ DG Smart life : 1,000+ Roland DG Mobile Panel : 1,000+ DG-App : 500+ Digoo·Cloud : 10,000+ DiskDigger photo recovery : 50,000,000+ Automatic Call Recorder : 100,000,000+ Virtual DJ Mixer : 100,000+ Mix Virtual DJ 2018 : 100,000+ Advanced Download Manager : 10,000,000+ GetThemAll Any File Downloader : 5,000,000+ Downloader & Private Browser : 50,000,000+ Download All Files : 10,000,000+ Download Accelerator Plus : 1,000,000+ Download Manager : 10,000,000+ Fast Download Manager : 1,000,000+ Turbo Download Manager (and Browser) : 5,000,000+ Download Blazer : 5,000,000+ Download Manager For Android Free : 100,000+ Turbo Downloader : 5,000,000+ Advanced Download Manager Holo : 1,000,000+ G-Download Manager : 50,000+ TorrDroid - Torrent Downloader : 1,000,000+ Download Manager - File & Video : 1,000,000+ DM airdisk : 1,000+ DM HiDisk : 5,000+ DM airdisk Pro : 1,000+ DM security - Dragon Mobile : 1,000+ DM 24/7 : 1,000+ DM AirDisk HDD : 100+ DM AirDisk NAS : 50+ File Viewer for Android : 1,000,000+ EasyNote Notepad | To Do List : 1,000,000+ Download Instant DP (Full HD) : 100,000+ DQ Akses : 1+ Anti-virus Dr.Web Light : 100,000,000+ dr.fone - Recovery & Transfer wirelessly & Backup : 5,000,000+ Dr. Battery - Fast Charger - Super Cleaner 2018 : 1,000,000+ Dr. Safety - Antivirus, Booster, Cleaner, AppLock : 10,000,000+ Dr.Web Security Space : 10,000,000+ Dr. Booster - Boost Game Speed : 10,000,000+ DS finder : 500,000+ DS get : 5,000,000+ DS cloud : 500,000+ DS router : 50,000+ DS Creator 2.0 : 500+ DS App Manager : 1,000+ DS Connector 2.0 : 500+ NDS-controller : 1,000+ Deep Sleep Battery Saver : 1,000,000+ DS Flashlight : 10,000+ DT Smart : 1,000+ DT Baby Cam : 500+ DT future1 cam : 50+ WhatsVPN - Unlimited Free VPN : 500,000+ Cache Cleaner-DU Speed Booster (booster & cleaner) : 100,000,000+ DU Battery Saver - Battery Charger & Battery Life : 100,000,000+ DU Antivirus Security - Applock & Privacy Guard : 10,000,000+ DU Cleaner – Memory cleaner & clean phone cache : 10,000,000+ DU Security : 100,000+ DU Browser Mini(Small&Fast) : 1,000,000+ Lock Screen - DU Locker & Lock screen wallpaper : 100,000+ DU Emoji Keyboard(Simeji) : 500,000+ DU Flashlight - Brightest LED & Flashlight Free : 5,000,000+ Upgrade for Android DU Master : 1,000,000+ GO Security-AntiVirus, AppLock, Booster : 10,000,000+ AKASO DV : 10,000+ Selfie DV : 1,000+ SDV Cam : 10,000+ DV Portfolio : 50+ DV - Digito Verificador : 500+ SportCAM : 100,000+ DW VMAX : 100,000+ DW Contacts Wear : 5,000+ Digi Dex for DW Next Order @PS4 : 10,000+ DW Timer : 100+ DW Uninstall Applications : 10+ DW Cleaner : 500+ DW Missed call cleaner patch : 5,000+ KeePass DX : 5,000+ DX Spots Free : 1,000+ DX Alert : 1,000+ MBU DX Cluster : 500+ edp re:dy : 10,000+ edp re:dy smarthome : 5,000+ Hidden Camera Detector : 10,000+ 3G/4G Config Dz : 100,000+ Files To SD Card Pro : 100,000+ My Ooredoo Algeria : 100,000+ DZ sim : 10,000+ 3G to 4G Converter - Simulator : 10,000+ Dz Camera : 10+ Bihar Land Records - RoR and EB Quick Pay : 1,000+ TNEB Reading : 10,000+ Tamilnadu Electricity Info : 10,000+ Punjab Online - Land Records • EB Bill Pay • RC/DL : 5,000+ energyly (TNEB,BESCOM,MH,DL..) : 10,000+ TN Patta, Chitta, EC : 100,000+ TN Patta Chitta EC Info : 100,000+ Barry EC : 1,000+ Walk Freely (Ec Shlire) : 1,000+ EC Apps List : 100+ Victoria EC : 500+ EC Designer 2.0 : 50+ Kiamichi EC : 1,000+ HOLSTON EC : 1,000+ Marítimo EC : 10+ EF Utilities : 5+ EG Movi : 1,000+ Energenie EG-PM1W Setup Wizard : 1,000+ qEG APP / Química EG SRL : 10+ VITEK EH DVR Viewer (Pro) : 10,000+ EH kontrollrakendus : 5,000+ Ei Electronics AudioLINK : 10,000+ Code on the egg : 10,000+ EI Calculator : 100+ Verdant EI : 50+ ei Calc : 10+ Painel EJ SSH - INTERNET GRÁTIS : 50+ Alex Fuel Calculator for EK : 500+ Sanu Ek Pal Chain - Raid : 500+ SIM Card Info : 1,000,000+ The translator : 1,000,000+ Instabridge - Free WiFi Passwords and Hotspots : 10,000,000+ Keyboard ManMan : 10,000,000+ HTC Sense Input - EN : 5,000,000+ Bluetooth Pair : 1,000,000+ ep-liggare - Elektronisk personalliggare : 100+ Tester EP : 100+ EP Kalkulator el. energije : 100+ ES App Locker : 1,000,000+ ES File Explorer : 100,000+ ES Dark Theme for free : 1,000,000+ ES Classic Theme : 1,000,000+ ES Holo Theme : 500,000+ ES File Explorer & Manager, Locker Xplorer 2018 : 1,000+ ES Summer Chill Theme for Free : 100,000+ OpenGL ES Extensions - The OpenGL Utility : 50,000+ File Ex - ES File Explorer : 1,000+ OpenGL ES CapsViewer : 10,000+ OpenGL-ES Info : 10,000+ Dr. ES PV Calculator : 500+ ES File Explorer & File Manager 2018 : 5,000+ HTC Sense Input - ES : 1,000,000+ 2019 Tricks Es File Explores : 1,000+ RAR : 50,000,000+ File Manager by Xiaomi: release file storage space : 10,000,000+ Moto File Manager : 10,000,000+ Epson iPrint : 10,000,000+ Schengen/EU App : 1,000+ HondaLink EV : 10,000+ EV Finder : 1,000+ Texas Hold'em EV Calculator : 1,000+ EV Calculator : 1,000+ Mee-EW : 5+ EW Widgets for Zooper : 100+ EW Neuron Scan : 10+ EdiRange : 100,000+ Ex Explorer : Dual view exproler / file manager : 50,000+ Papyrus Ex : 100,000+ Fuel Calculator for EY : 1,000+ Third Eye : 1,000,000+ Hey That's Pretty Good! : 10,000+ EZ Cleaner - Booster Optimizer : 500,000+ EZ Bluetooth : 50,000+ EZ-GUI Ground Station : 50,000+ E-Z App™ Train Control : 1,000+ EZ App Installer : 100,000+ EZ Pass : 5,000+ EZ-VPNGate : 5,000+ EZ LED : 1,000+ EZ Screenshot : 5,000+ EZ Utilities Extension : 5,000+ EZ-Placard - Free Placard Calculator : 1,000+ HTC Sense Input - FA : 100,000+ Farsi Keyboard : 1,000,000+ Authy 2-Factor Authentication : 1,000,000+ Flash Light on Call & SMS : 1,000,000+ Mini for fb lite : 100,000+ Video Downloader For FB: Save FB Videos 2018 : 50,000+ Video Download For FB : 100,000+ Video Downloader for FB : 5,000+ Download Facebook Photo Albums : 100,000+ FD Shift Calendar Widget : 100,000+ FD CANNECT : 1+ FE Connect : 5,000+ FE IP : 1,000+ FE Connect Fhoton : 100+ FG On-The-Go : 1,000+ FG Finder : 10,000+ FH CODE : 100+ My Truck : 10,000+ Signal Info : 10,000+ Signal Spy - Monitor Signal Strength & Data Usage : 100,000+ LG Hi-Fi Plus Manager : 10,000+ [root] Pry-Fi : 500,000+ Wi-Fi settings shortcut : 50,000+ Wi-Fi Master : 500,000+ Wi-Fi Visualizer : 50,000+ HD Wallpaper - Toyota FJ Cruiser : 100+ FJ WiFi HDD : 5,000+ FJ-link : 10+ FK Crvena Zvezda Izzy : 50,000+ Florida 511 : 50,000+ Lottery Ticket Checker - Florida Results & Lotto : 500+ Calculator Fn : 500+ Fo File Manager : 100,000+ Fon WiFi App – WiFi Connect : 50,000+ MOD-MASTER for Minecraft PE (Pocket Edition) Free : 10,000,000+ Draw with FP sDraw : 100,000+ Fingerprint Quick Action : 1,000,000+ FP Opgaver : 1,000+ Finger Scanner Gestures : 100,000+ FreedomPop Friends for Free Data : 5,000+ Fisher-Price® Smart Connect™ : 50,000+ Fingerprint Lock Screen Prank : 1,000,000+ FP NFC Rewrite : 1,000+ FreedomPop Diagnostics : 100,000+ ChopAssistant : 50,000+ Reindeer VPN - Proxy VPN : 100,000+ Inf VPN - Global Proxy & Unlimited Free WIFI VPN : 1,000,000+ FR Roster : 5,000+ My FR App : 100+ HTC Sense Input - FR : 100,000+
for app in android_final:
if app[1] == 'TOOLS' and (app[5] == '1,000,000,000+'
or app[5] == '500,000,000+'
or app[5] == '100,000,000+'):
print(app[0], ':', app[5])
Google : 1,000,000,000+ Google Translate : 500,000,000+ Calculator : 100,000,000+ Device Help : 100,000,000+ Account Manager : 100,000,000+ SHAREit - Transfer & Share : 500,000,000+ Samsung Calculator : 100,000,000+ Gboard - the Google Keyboard : 500,000,000+ Google Korean Input : 100,000,000+ Share Music & Transfer Files - Xender : 100,000,000+ Tiny Flashlight + LED : 100,000,000+ GO Keyboard - Cute Emojis, Themes and GIFs : 100,000,000+ Speedtest by Ookla : 100,000,000+ CM Locker - Security Lockscreen : 100,000,000+ Applock : 100,000,000+ Clean Master- Space Cleaner & Antivirus : 500,000,000+ Lookout Security & Antivirus : 100,000,000+ Google Now Launcher : 100,000,000+ 360 Security - Free Antivirus, Booster, Cleaner : 100,000,000+ Samsung Smart Switch Mobile : 100,000,000+ Avast Mobile Security 2018 - Antivirus & App Lock : 100,000,000+ AppLock : 100,000,000+ AVG AntiVirus 2018 for Android Security : 100,000,000+ Security Master - Antivirus, VPN, AppLock, Booster : 500,000,000+ Battery Doctor-Battery Life Saver & Battery Cooler : 100,000,000+ Automatic Call Recorder : 100,000,000+ Anti-virus Dr.Web Light : 100,000,000+ Cache Cleaner-DU Speed Booster (booster & cleaner) : 100,000,000+ DU Battery Saver - Battery Charger & Battery Life : 100,000,000+
Ooookay, there are so many apps that we can build under this category: alarm, calculator, flash lights, voice recorder, keyboards, etc. Cool.
Now, let's check the Productivity category.
for app in android_final:
if app[1] == 'PRODUCTIVITY' and (app[5] == '1,000,000,000+'
or app[5] == '500,000,000+'
or app[5] == '100,000,000+'):
print(app[0], ':', app[5])
Microsoft Word : 500,000,000+ Microsoft Outlook : 100,000,000+ Microsoft OneDrive : 100,000,000+ Microsoft OneNote : 100,000,000+ Google Keep : 100,000,000+ ES File Explorer File Manager : 100,000,000+ Dropbox : 500,000,000+ Google Docs : 100,000,000+ Microsoft PowerPoint : 100,000,000+ Samsung Notes : 100,000,000+ SwiftKey Keyboard : 100,000,000+ Google Drive : 1,000,000,000+ Adobe Acrobat Reader : 100,000,000+ Google Sheets : 100,000,000+ Microsoft Excel : 100,000,000+ WPS Office - Word, Docs, PDF, Note, Slide & Sheet : 100,000,000+ Google Slides : 100,000,000+ ColorNote Notepad Notes : 100,000,000+ Evernote – Organizer, Planner for Notes & Memos : 100,000,000+ Google Calendar : 500,000,000+ Cloud Print : 500,000,000+ CamScanner - Phone PDF Creator : 100,000,000+
I can see giant players here like Microsoft and Google in the top ranks. Let's see the middle ranks, maybe we can fit in there.
for app in android_final:
if app[1] == 'PRODUCTIVITY' and (app[5] == '10,000,000+'
or app[5] == '5,000,000+'
or app[5] == '1,000,000+'):
print(app[0], ':', app[5])
All-In-One Toolbox: Cleaner, Booster, App Manager : 10,000,000+ AVG Cleaner – Speed, Battery & Memory Booster : 10,000,000+ QR Scanner & Barcode Scanner 2018 : 10,000,000+ Chrome Beta : 10,000,000+ Google PDF Viewer : 10,000,000+ My Claro Peru : 5,000,000+ Power Booster - Junk Cleaner & CPU Cooler & Boost : 1,000,000+ Google Assistant : 10,000,000+ Metro name iD : 10,000,000+ Archos File Manager : 5,000,000+ ASUS SuperNote : 10,000,000+ HTC File Manager : 10,000,000+ MyMTN : 1,000,000+ ASUS Quick Memo : 10,000,000+ HTC Calendar : 10,000,000+ ASUS Calling Screen : 10,000,000+ lifebox : 5,000,000+ Yandex.Disk : 5,000,000+ Content Transfer : 5,000,000+ HTC Mail : 10,000,000+ MyVodafone (India) - Online Recharge & Pay Bills : 10,000,000+ Microsoft Translator : 5,000,000+ Hacker's Keyboard : 1,000,000+ Security & Privacy : 1,000,000+ Loop - Habit Tracker : 1,000,000+ TickTick: To Do List with Reminder, Day Planner : 1,000,000+ Keeper: Free Password Manager & Secure Vault : 10,000,000+ Pushbullet - SMS on PC : 1,000,000+ Wunderlist: To-Do List & Tasks : 10,000,000+ Planner Pro-Personal Organizer : 1,000,000+ Todoist: To-do lists for task management & errands : 10,000,000+ Cozi Family Organizer : 1,000,000+ IFTTT : 1,000,000+ Trello : 5,000,000+ Easy Voice Recorder : 10,000,000+ Dashlane Free Password Manager : 1,000,000+ CM FILE MANAGER HD : 10,000,000+ Solid Explorer Classic : 1,000,000+ The Maner : 5,000,000+ AndroZip™ FREE File Manager : 10,000,000+ Solid Explorer File Manager : 1,000,000+ Smart File Manager : 1,000,000+ Polaris Office - Word, Docs, Sheets, Slide, PDF : 10,000,000+ Note Everything : 5,000,000+ Simple Notepad : 1,000,000+ Keep My Notes - Notepad & Memo : 5,000,000+ Sticky Note + : Sync Notes : 1,000,000+ Notepad : 10,000,000+ Squid - Take Notes & Markup PDFs : 1,000,000+ Ultimate Notepad : 5,000,000+ Notepad & To do list : 10,000,000+ JotterPad - Writer, Screenplay, Novel : 1,000,000+ Any.do: To-do list, Calendar, Reminders & Planner : 10,000,000+ Calendar+ Schedule Planner App : 1,000,000+ Today Calendar 2017 : 1,000,000+ To-Do Calendar Planner : 1,000,000+ New Calendar : 1,000,000+ Calendar Widget Month + Agenda : 5,000,000+ DigiCal Calendar Agenda : 5,000,000+ Time Recording - Timesheet App : 1,000,000+ Jorte Calendar & Organizer : 10,000,000+ Business Calendar 2 : 5,000,000+ aCalendar - Android Phone : 10,000,000+ G Cloud Backup : 5,000,000+ Amazon Drive : 1,000,000+ SugarSync : 1,000,000+ pCloud: Free Cloud Storage : 1,000,000+ MediaFire : 5,000,000+ Fake Call - Fake Caller ID : 10,000,000+ AutoCAD - DWG Viewer & Editor : 10,000,000+ Mobile Security & Antivirus : 10,000,000+ EX File Explorer File Manager : 1,000,000+ EBookDroid - PDF & DJVU Reader : 5,000,000+ Emoji Android L Keyboard : 1,000,000+ Multiling O Keyboard + emoji : 1,000,000+ S Note : 10,000,000+ S’more - Earn Cash Rewards : 1,000,000+ AT&T Mobile Transfer : 10,000,000+ Můj T-Mobile Business : 1,000,000+ U+Box : 10,000,000+ NQ Mobile Security & Antivirus : 10,000,000+ Adblock Fast : 1,000,000+ Google AdSense : 1,000,000+ Extreme- Personal Voice Assistant : 1,000,000+ Lyra Virtual Assistant : 1,000,000+ AL Voice Recorder : 1,000,000+ PDF Viewer & Book Reader : 5,000,000+ Mobile Security: Antivirus, Web Scan & App Lock : 10,000,000+ ALL-IN-ONE PACKAGE TRACKING : 1,000,000+ Chrome Canary (Unstable) : 1,000,000+ Ultimate Chest Tracker : 1,000,000+ Resume Free : 1,000,000+ CY Security Antivirus Cleaner : 1,000,000+ Phone Clean Best Speed Booster : 1,000,000+ LOCX Applock Lock Apps & Photo : 10,000,000+ e-Boks.dk : 1,000,000+ Mahalaxmi Dindarshika 2018 : 1,000,000+ Microsoft To-Do: List, Task & Reminder : 1,000,000+ To Do List : 5,000,000+ To Do Reminder with Alarm : 1,000,000+ Do it (Tomorrow) : 1,000,000+ To-Do List Widget : 1,000,000+ NoteToDo. Notes. To do list : 1,000,000+ Cal - Google Calendar + Widget : 1,000,000+ Adobe Fill & Sign: Easy PDF Form Filler : 1,000,000+ DS file : 1,000,000+ Clean My Android : 5,000,000+ APUS Booster - Space Cleaner & Booster : 10,000,000+ Epson iProjection : 1,000,000+ Ginger Keyboard - Emoji, GIFs, Themes & Games : 5,000,000+ ES Material Theme for Pro : 1,000,000+ iTranslate Translator & Dictionary : 10,000,000+ Chelsea FC Official Keyboard : 1,000,000+ Avast Wi-Fi Finder : 1,000,000+
I think Productivity category is also potential. We can create these apps: to do list, reminder, calendar, notepad, habit tracker, and that pomodoro technique app that I mentioned earlier.
Me: "Hello? Imaginary Boss? Can you hear me?"
Imaginary Boss: "Yup. So, what did you get?"
Me: "We can build an app that falls under the Photography and Health & Fitness categories, which are already popular but might be a good idea to get into as long as we can add special features. For example, for the Photography app, we can add monthly filter or celebrities-inspired filters, or even user-generated filters and make a contest out of it. Or for the Productivity app, we can create pomodoro app with gamification, or any other productivity app with gamification, since it's always be nice to have some fun during work and study. And for the Tools category apps, the options are pretty much limitless, we can create alarms, calculators, flashlights, or maybe some kind of survival-related app."
Imaginary Boss: "Well, sounds like we can have a good brainstorming session on this. Thanks, and enjoy your imaginary coffee!"
Me: "Thanks!"