The purpose of this project is to see which types of app attracts more user. This key insight would help the company make data driven decision The project I am assigned puts me in a role of a data analyst that works for a company that builds free apps and their main source of revenue in in-app advertisements. My job is to recommend which types of apps would be the most profitable for the company
The first step would be to access the dataset of both the AppleStore and Google play.
As of September 2018, there were approximately 2 million iOS apps available on the App Store, and 2.1 million Android apps on Google Play.
Collecting data for over four million apps requires a significant amount of time and money, so analyzing a sample of data is optimal. To avoid spending resources with collecting new data, let’s see if I can find any relevant existing data at no cost. Luckily, these are two data sets that seem suitable for our purpose:
A dataset containing data about approximately ten thousand Android apps from Google Play.
A dataset set containing data about approximately seven thousand iOS apps from the App Store.
Let's start by opening the two data sets and then continue with exploring the data.
from csv import reader
# Apple Store Dataset
opened_file_IOS = open('AppleStore.csv', encoding="utf8")
read_file = reader(opened_file_IOS)
IOS = list(read_file)
IOS_header = IOS[0]
IOS = IOS[1:]
# GooglePlay Store Dataset
opened_file_andriod = open('googleplaystore.csv', encoding="utf8")
read_file = reader(opened_file_andriod)
andriod = list(read_file)
andriod_header = andriod[0]
andriod = andriod[1:]
Then defining a function which would help us explore and understand the data is important. This is key because this will let us know the data that is relevant for this analysis and provides with us the detail of what information the dataset has.
def explore_data(dataset, start, end, rows_and_columns=False):
dataset_slice = dataset[start:end]
for row in dataset_slice:
print(row)
print('\n')
if rows_and_columns:
print('Number of rows:', len(dataset))
print('Number of columns:', len(dataset[0]))
After defining a function let’s explore both the datasets
# AppleStore Dataset explore
print(IOS_header)
print('\n')
explore_data(IOS, 0, 5, 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'] ['420009108', 'Temple Run', '65921024', 'USD', '0.0', '1724546', '3842', '4.5', '4.0', '1.6.2', '9+', 'Games', '40', '5', '1', '1'] ['284035177', 'Pandora - Music & Radio', '130242560', 'USD', '0.0', '1126879', '3594', '4.0', '4.5', '8.4.1', '12+', 'Music', '37', '4', '1', '1'] Number of rows: 7197 Number of columns: 16
Now we can see that the AppleStore has a total of 7197 apps and 16 columns. The ones that can be useful to our analysis are track name , price, prime_genre, rating_count_tot and rating_count_ver. Details about each column could be see here
# Googleplay Dataset explore
print(andriod_header)
print('\n')
explore_data(andriod, 0, 5, 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'] ['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'] ['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'] Number of rows: 10841 Number of columns: 13
Now we can see that the GooglePlay store has a total of 10841 apps and 13 columns. The ones that can be useful to our analysis are App, Category, Installs, Price and Genre.
Before moving further there is an entire dedicated section to a discusion about row 10472 of the app Life Made WI-Fi TouchScreen Frame which has a missing data and has a rating of 19 which is incorrect because the max rating on GooglePlay Store is 5. Let’s first check this and then if it is incorrect then delete the row
print(andriod_header)
print('\n')
print(andriod[10472])
print('\n')
len(andriod)
del andriod[10472]
len(andriod)
['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']
10840
Exploring the datase multiple duplicate entries were found. These entries have to be removed
duplicate_rows = []
unique_rows = []
for apps in andriod:
name = apps[0]
if name in unique_rows:
duplicate_rows.append(name)
else:
unique_rows.append(name)
print('Number of duplicate apps:' ,len(duplicate_rows))
print('\n')
Number of duplicate apps: 1181
We can simply delete all the duplicate entries but first lets look at the duplicate entries
print(duplicate_rows)
['Quick PDF Scanner + OCR FREE', 'Box', 'Google My Business', 'ZOOM Cloud Meetings', 'join.me - Simple Meetings', 'Box', 'Zenefits', 'Google Ads', 'Google My Business', 'Slack', 'FreshBooks Classic', 'Insightly CRM', 'QuickBooks Accounting: Invoicing & Expenses', 'HipChat - Chat Built for Teams', 'Xero Accounting Software', 'MailChimp - Email, Marketing Automation', 'Crew - Free Messaging and Scheduling', 'Asana: organize team projects', 'Google Analytics', 'AdWords Express', 'Accounting App - Zoho Books', 'Invoice & Time Tracking - Zoho', 'join.me - Simple Meetings', 'Invoice 2go — Professional Invoices and Estimates', 'SignEasy | Sign and Fill PDF and other Documents', 'Quick PDF Scanner + OCR FREE', 'Genius Scan - PDF Scanner', 'Tiny Scanner - PDF Scanner App', 'Fast Scanner : Free PDF Scan', 'Mobile Doc Scanner (MDScan) Lite', 'TurboScan: scan documents and receipts in PDF', 'Tiny Scanner Pro: PDF Doc Scan', 'Docs To Go™ Free Office Suite', 'OfficeSuite : Free Office + PDF Editor', 'Slack', 'QuickBooks Accounting: Invoicing & Expenses', 'WhatsApp Messenger', 'Messenger – Text and Video Chat for Free', 'imo free video calls and chat', 'Viber Messenger', 'Hangouts', 'WeChat', 'Telegram', 'Who', 'Google Voice', 'Android Messages', 'Firefox Focus: The privacy browser', 'Google Allo', 'Google Chrome: Fast & Secure', 'Firefox Browser fast & private', 'Puffin Web Browser', 'Opera Browser: Fast and Secure', 'Opera Mini - fast web browser', 'UC Browser Mini -Tiny Fast Private & Secure', 'UC Browser - Fast Download Private & Secure', 'Calls & Text by Mo+', 'Viber Messenger', 'Call Blocker', 'Gmail', 'Yahoo Mail – Stay Organized', 'Hangouts', 'imo free video calls and chat', 'free video calls and chat', 'Viber Messenger', 'Skype - free IM & video calls', 'WeChat', 'Glide - Video Chat Messenger', 'Talkray - Free Calls & Texts', 'LINE: Free Calls & Messages', 'KakaoTalk: Free Calls & Text', 'OkCupid Dating', 'CMB Free Dating App', 'Hily: Dating, Chat, Match, Meet & Hook up', 'Hinge: Dating & Relationships', 'BBW Dating & Plus Size Chat', 'Casual Dating & Adult Singles - Joyride', 'EliteSingles – Dating for Single Professionals', 'Clover Dating App', 'Moco - Chat, Meet People', 'Hot or Not - Find someone right now', 'Just She - Top Lesbian Dating', 'Once - Quality Matches Every day', 'Sudy – Meet Elite & Rich Single', 'muzmatch: Muslim & Arab Singles, Marriage & Dating', 'Chispa, the Dating App for Latino, Latina Singles', 'Blendr - Chat, Flirt & Meet', 'Find Real Love — YouLove Premium Dating', 'Cougar Dating Life : Date Older Women Sugar Mummy', 'stranger chat - anonymous chat', 'Millionaire Match: Rich Singles Dating App', 'Dating for 50 plus Mature Singles – FINALLY', 'Moco+ - Chat, Meet People', 'Chat Rooms, Avatars, Date - Galaxy', 'FastMeet: Chat, Dating, Love', 'Christian Dating For Free App', 'Meet24 - Love, Chat, Singles', 'Black White Interracial Dating - Interracial Match', 'Gay Sugar Daddy Dating & Hookup – Sudy Gay', 'Adult Dirty Emojis', 'Hide App, Private Dating, Safe Chat - PrivacyHider', 'Meet4U - Chat, Love, Singles!', '95Live -SG#1 Live Streaming App', 'Just She - Top Lesbian Dating', 'Hily: Dating, Chat, Match, Meet & Hook up', 'O-Star', 'Random Video Chat', 'Black People Meet Singles Date', 'Howlr', 'Free Dating & Flirt Chat - Choice of Love', 'Cardi B Live Stream Video Chat - Prank', 'Chat Kids - Chat Room For Kids', 'muzmatch: Muslim & Arab Singles, Marriage & Dating', 'BBW Dating & Plus Size Chat', 'Transenger – Ts Dating and Chat for Free', 'BBW Dating & Curvy Singles Chat- LargeFriends', 'MouseMingle', 'FlirtChat - ♥Free Dating/Flirting App♥', 'Live Talk - Free Text and Video Chat', 'Adult Dirty Emojis', 'Free Cam Girls - Live Webcam', 'Random Video Chat App With Strangers', 'Live Girls Talk - Free Video Chat', 'Girls Live Chat - Free Text & Video Chat', 'Free Dating App - Meet Local Singles - Flirt Chat', 'iPair-Meet, Chat, Dating', 'Free Dating Hook Up Messenger', 'Free Dating App - YoCutie - Flirt, Chat & Meet', 'Khan Academy', 'TED', 'Lumosity: #1 Brain Games & Cognitive Training App', 'Udemy - Online Courses', 'Khan Academy', 'TED', 'Duolingo: Learn Languages Free', 'Quizlet: Learn Languages & Vocab with Flashcards', 'Coursera: Online courses', 'Udemy - Online Courses', 'Udacity - Lifelong Learning', 'edX - Online Courses by Harvard, MIT & more', 'Lynda - Online Training Videos', 'Learn languages, grammar & vocabulary with Memrise', 'Brilliant', 'Babbel – Learn Languages', 'Duolingo: Learn Languages Free', 'Rosetta Stone: Learn to Speak & Read New Languages', 'Learn languages, grammar & vocabulary with Memrise', 'Learn English with Wlingua', 'Quizlet: Learn Languages & Vocab with Flashcards', 'Google Classroom', 'Duolingo: Learn Languages Free', 'Learn 50 languages', 'Mango Languages: Lovable Language Courses', 'Rosetta Stone: Learn to Speak & Read New Languages', 'Learn languages, grammar & vocabulary with Memrise', 'Babbel – Learn Languages', 'busuu: Learn Languages - Spanish, English & More', 'My Class Schedule: Timetable', 'Socratic - Math Answers & Homework Help', 'Google Classroom', 'ClassDojo', 'HelloTalk — Chat, Speak & Learn Foreign Languages', 'Quizlet: Learn Languages & Vocab with Flashcards', 'busuu: Learn Languages - Spanish, English & More', 'Rosetta Stone: Learn to Speak & Read New Languages', 'Movies by Flixster, with Rotten Tomatoes', 'IMDb Movies & TV', 'Netflix', 'IMDb Movies & TV', 'Netflix', 'Tubi TV - Free Movies & TV', 'Crunchyroll - Everything Anime', 'STARZ', 'Crackle - Free TV & Movies', 'CBS - Full Episodes & Live TV', 'Nick', 'Hulu: Stream TV, Movies & more', 'FOX NOW - On Demand & Live TV', 'The CW', 'HISTORY: Watch TV Show Full Episodes & Specials', 'HBO NOW: Stream TV & Movies', 'A&E - Watch Full Episodes of TV Shows', 'VH1', 'Lifetime - Watch Full Episodes & Original Movies', 'BET NOW - Watch Shows', 'Netflix', 'Tubi TV - Free Movies & TV', 'Crackle - Free TV & Movies', 'Crunchyroll - Everything Anime', 'Nick', 'STARZ', 'Hulu: Stream TV, Movies & more', 'Food Network', 'FOX NOW - On Demand & Live TV', 'Movies by Flixster, with Rotten Tomatoes', 'HISTORY: Watch TV Show Full Episodes & Specials', 'Viki: Asian TV Dramas & Movies', 'The CW', 'Univision NOW - Live TV and On Demand', 'HBO NOW: Stream TV & Movies', 'A&E - Watch Full Episodes of TV Shows', 'VH1', 'SHOWTIME', 'MTV', 'Lifetime - Watch Full Episodes & Original Movies', 'Comedy Central', 'BET NOW - Watch Shows', 'FOX', 'Telemundo Now', 'Viki: Asian TV Dramas & Movies', 'Nick', 'Fandango Movies - Times + Tickets', 'Google Pay', 'Wells Fargo Daily Change', 'Credit Karma', 'Robinhood - Investing, No Fees', 'Digit Save Money Automatically', 'Acorns - Invest Spare Change', 'Money Lover: Expense Tracker, Budget Planner', 'Mint: Budget, Bills, Finance', 'Simple - Better Banking', 'PayPal', 'Google Pay', 'Wells Fargo Mobile', 'Capital One® Mobile', 'Grubhub: Food Delivery', 'Postmates Food Delivery: Order Eats & Alcohol', "Domino's Pizza USA", 'Chick-fil-A', 'Zomato - Restaurant Finder and Food Delivery App', 'Run with Map My Run', 'Weight Loss Running by Verv', 'Nike+ Run Club', 'Runtastic Running App & Mile Tracker', '8fit Workouts & Meal Planner', 'Daily Yoga - Yoga Fitness Plans', 'Pocket Yoga', 'Calorie Counter - MyFitnessPal', 'Weight Loss Running by Verv', 'Nike+ Run Club', 'Seven - 7 Minute Workout Training Challenge', 'Weight Watchers Mobile', 'Walk with Map My Walk', 'Workout Trainer: fitness coach', 'Run with Map My Run', 'Nike Training Club - Workouts & Fitness Plans', 'Fitbit Coach', 'Calorie Counter - MyFitnessPal', 'Endomondo - Running & Walking', 'Runkeeper - GPS Track Run Walk', 'Nike+ Run Club', 'Runtastic Running App & Mile Tracker', 'Calorie Counter - MyFitnessPal', 'Lose It! - Calorie Counter', 'Calorie Counter - MyNetDiary', '10 Best Foods for You', 'MyPlate Calorie Tracker', 'Weight Loss Tracker - RecStyle', 'Calorie Counter by FatSecret', 'Calorie Counter - Macros', 'My Diet Diary Calorie Counter', 'Lark - 24/7 Health Coach', 'Weight Watchers Mobile', 'Calorie Counter & Diet Tracker', 'MealLogger-Photo Food Journal', 'Health and Nutrition Guide', 'Food Calorie Calculator', 'Calorie Counter - MyFitnessPal', 'Lose It! - Calorie Counter', 'Relax Meditation: Sleep with Sleep Sounds', 'Meditation Music - Relax, Yoga', '21-Day Meditation Experience', 'Fabulous: Motivate Me! Meditate, Relax, Sleep', 'Calm - Meditate, Sleep, Relax', 'Relax Melodies: Sleep Sounds', 'Simple Habit Meditation', 'Headspace: Meditation & Mindfulness', 'Daily Yoga - Yoga Fitness Plans', 'Houzz Interior Design Ideas', 'Mortgage by Zillow: Calculator & Rates', 'Redfin Real Estate', 'Apartment List: Housing, Apt, and Property Rentals', 'Realtor.com Real Estate: Homes for Sale and Rent', 'Trulia Real Estate & Rentals', 'Zillow: Find Houses for Sale & Apartments for Rent', 'Apartments & Rentals - Zillow', 'Trulia Rent Apartments & Homes', 'Apartments.com Rental Search', 'Houzz Interior Design Ideas', 'Vaniday - Beauty Booking App', 'StyleSeat', 'JOANN - Crafts & Coupons', 'Fashion in Vogue', 'Wheretoget: Shop in style', 'My Dressing - Fashion closet', 'Chictopia', 'Scarf Fashion Designer', 'Fashion in Vogue', 'Zara', 'Subway Surfers', 'ROBLOX', 'Pou', '8 Ball Pool', 'Clash of Clans', 'Candy Crush Saga', 'Plants vs. Zombies FREE', 'My Talking Angela', 'Bubble Shooter', 'Word Search', 'Candy Crush Soda Saga', 'Fishdom', 'Block Puzzle', 'Clash Royale', 'Sniper 3D Gun Shooter: Free Shooting Games - FPS', 'Granny', 'Galaxy Attack: Alien Shooter', 'Angry Birds Rio', 'Zombie Catchers', 'Zombie Hunter King', 'Temple Run 2', 'Zombie Tsunami', 'Farm Heroes Saga', 'Super Jim Jump - pixel 3d', 'slither.io', 'Angry Birds Classic', 'Flow Free', 'ROBLOX', 'Helix Jump', 'Subway Surfers', 'Candy Crush Saga', 'Toon Blast', 'Granny', '8 Ball Pool', 'Sniper 3D Gun Shooter: Free Shooting Games - FPS', 'slither.io', 'Temple Run 2', 'Kick the Buddy', 'Magic Tiles 3', 'Bowmasters', 'Wordscapes', 'Block Craft 3D: Building Simulator Games For Free', 'Helix Jump', 'PUBG MOBILE', 'Wordscapes', 'DRAGON BALL LEGENDS', 'ROBLOX', 'Candy Crush Saga', '8 Ball Pool', 'Harry Potter: Hogwarts Mystery', 'PUBG MOBILE', 'MARVEL Strike Force', 'Merge Dragons!', 'Honkai Impact 3rd', 'Candy Crush Saga', 'ROBLOX', '8 Ball Pool', 'Subway Surfers', 'Candy Crush Soda Saga', 'Zombie Hunter King', 'Bubble Shooter', 'Toon Blast', 'Toy Blast', 'Clash Royale', 'Clash of Clans', 'Farm Heroes Saga', 'Plants vs. Zombies FREE', 'Word Search', 'Block Puzzle', 'Super Jim Jump - pixel 3d', 'Pou', 'Temple Run 2', 'Flow Free', 'Homescapes', 'Wordscapes', 'My Talking Angela', 'slither.io', 'Cooking Fever', 'Gardenscapes', 'Fishdom', 'Galaxy Attack: Alien Shooter', 'Score! Hero', 'Zombie Catchers', 'Magic Tiles 3', 'Granny', 'Dream League Soccer 2018', 'Fruits Bomb', 'Angry Birds Classic', 'Talking Tom Gold Run', 'Bowmasters', 'My Talking Tom', 'Hill Climb Racing', 'Sniper 3D Gun Shooter: Free Shooting Games - FPS', 'Pixel Art: Color by Number Game', 'Rider', 'Zombie Tsunami', 'Garena Free Fire', 'Subway Surfers', 'Helix Jump', 'Temple Run 2', 'slither.io', 'Bowmasters', 'Talking Tom Gold Run', 'Zombie Catchers', 'Sniper 3D Gun Shooter: Free Shooting Games - FPS', 'Miraculous Ladybug & Cat Noir - The Official Game', 'Kick the Buddy', 'DRAGON BALL LEGENDS', 'Zombie Hunter King', 'Garena Free Fire', 'Candy Crush Saga', 'Plants vs. Zombies FREE', 'Block Puzzle', 'Helix Jump', '8 Ball Pool', 'Bubble Shooter', 'Solitaire', 'Traffic Racer', 'Hill Climb Racing', 'Earn to Die 2', 'Bubble Shooter 2', 'Flow Free', 'Zombie Catchers', 'Angry Birds Rio', 'Candy Crush Jelly Saga', 'Cut the Rope FULL FREE', 'Jewels Star: OZ adventure', 'Hungry Shark Evolution', 'Angry Birds Classic', 'Best Fiends - Free Puzzle Game', 'Hill Climb Racing 2', 'Swamp Attack', 'Bowmasters', 'Magic Tiles 3', 'Block Puzzle Classic Legend !', 'Pixel Art: Color by Number Game', 'Score! Hero', 'Zombie Tsunami', 'DEAD TARGET: FPS Zombie Apocalypse Survival Games', 'Word Search', 'Farm Heroes Saga', 'YouTube Kids', 'Candy Bomb', 'ROBLOX', 'Solitaire', 'Princess Coloring Book', 'Hello Kitty Nail Salon', 'Dog Run - Pet Dog Simulator', 'Coloring book moana', 'Bubble Shooter', 'Barbie™ Fashion Closet', 'Minion Rush: Despicable Me Official Game', 'No.Draw - Colors by Number 2018', 'Duolingo: Learn Languages Free', 'Super ABC! Learning games for kids! Preschool apps', 'ROBLOX', 'PJ Masks: Moonlight Heroes', 'Minion Rush: Despicable Me Official Game', 'Dog Run - Pet Dog Simulator', 'Hot Wheels: Race Off', 'Farming Simulator 14', 'Mcqueen Coloring pages', 'Monster Truck Driver & Racing', 'Strawberry Shortcake BerryRush', 'DC Super Hero Girls™', 'Toca Kitchen 2', 'DC Super Hero Girls™', 'Strawberry Shortcake BerryRush', 'Disney Magic Kingdoms: Build Your Own Magical Park', 'Toca Life: City', 'Papumba Academy - Fun Learning For Kids', 'Kids Balloon Pop Game Free 🎈', 'Sounds for Toddlers FREE', 'Elmo Calls by Sesame Street', 'Sago Mini Friends', 'Papumba Academy - Fun Learning For Kids', 'Tee and Mo Bath Time Free', 'Bita and the Animals - Pelos Ares', 'TO-FU Oh!SUSHI', 'DreamWorks Friends', 'Avokiddo Emotions', 'Nighty Night Circus', 'Sago Mini Babies', "Dr. Panda & Toto's Treehouse", 'ROBLOX', 'PlayKids - Educational cartoons and games for kids', 'YouTube Kids', 'Baby Panda Care', 'Monster High™', 'Duolingo: Learn Languages Free', 'Shopkins World!', 'DisneyNOW – TV Shows & Games', 'Equestria Girls', 'Frozen Free Fall', 'Nick', 'Thomas & Friends: Race On!', 'Inside Out Thought Bubbles', 'Sago Mini Friends', 'School of Dragons', 'Peak – Brain Games & Training', 'Period Tracker', 'Vargo Anesthesia Mega App', 'Monash Uni Low FODMAP Diet', 'mySugr: the blood sugar tracker made just for you', 'Human Anatomy Atlas 2018: Complete 3D Human Body', 'ASCCP Mobile', 'Paramedic Protocol Provider', '2017 EMRA Antibiotic Guide', 'Essential Anatomy 3', 'EMT PASS', 'Block Buddy', 'EMT Review Plus', 'Journal Club: Medicine', 'Pedi STAT', 'AnatomyMapp', 'Diabetes & Diet Tracker', 'A Manual of Acupuncture', 'PTA Content Master', 'Muscle Premium - Human Anatomy, Kinesiology, Bones', 'Cardiac diagnosis (heart rate, arrhythmia)', 'Medical ID - In Case of Emergency (ICE)', 'IBM Micromedex Drug Info', 'Advanced Comprehension Therapy', 'Hospitalist Handbook', 'Teladoc Member', 'Ada - Your Health Guide', 'Ovia Fertility Tracker & Ovulation Calculator', 'Youper - AI Therapy', 'MoodSpace', 'Super Hearing Super Ear Amplifier', 'Penn State Health OnDemand', 'ScriptSave WellRx Rx Discounts', 'Free Blood Pressure', 'All Mental disorders', 'Nurse Grid', 'JH Blood Pressure Monitor', 'Blood Pressure', 'RT 516 VET', 'Anthem Anywhere', 'Sway Medical', "fred's Pharmacy", 'Breastfeeding Tracker Baby Log', 'Banfield Pet Health Tracker', '1800 Contacts - Lens Store', 'TextNow - free text + calls', 'Tumblr', 'Snapchat', 'Instagram', 'Periscope - Live Video', 'Snapchat', 'Instagram', 'Pinterest', 'MeetMe: Chat & Meet New People', 'ooVoo Video Calls, Messaging & Stories', 'LinkedIn', 'Tango - Live Video Broadcast', 'SayHi Chat, Meet New People', 'Tapatalk - 100,000+ Forums', 'Badoo - Free Chat & Dating App', 'Nextdoor - Local neighborhood news & classifieds', 'MeetMe: Chat & Meet New People', 'Meetup', 'Text Free: WiFi Calling App', 'textPlus: Free Text & Calls', 'Meetup', 'POF Free Dating App', 'MeetMe: Chat & Meet New People', 'Tagged - Meet, Chat & Dating', 'LOVOO', 'SKOUT - Meet, Chat, Go Live', 'Badoo - Free Chat & Dating App', 'Jaumo Dating, Flirt & Live Video', 'SayHi Chat, Meet New People', 'Couple - Relationship App', 'Meetup', 'Wish - Shopping Made Fun', 'SnipSnap Coupon App', 'Extreme Coupon Finder', 'Checkout 51: Grocery coupons', 'The Coupons App', 'RetailMeNot - Coupons, Deals & Discount Shopping', 'Groupon - Shop Deals, Discounts & Coupons', 'Stocard - Rewards Cards Wallet', 'Extreme Coupon Finder', 'eBay: Buy & Sell this Summer - Discover Deals Now!', 'Checkout 51: Grocery coupons', 'Gyft - Mobile Gift Card Wallet', 'Shopkick: Free Gift Cards, Shop Rewards & Deals', 'The Coupons App', 'Shopular: Coupons, Weekly Ads & Shopping Deals', 'Wish - Shopping Made Fun', 'Carousell: Snap-Sell, Chat-Buy', 'Walmart', 'Ibotta: Cash Back Savings, Rewards & Coupons App', 'AliExpress - Smarter Shopping, Better Living', 'LivingSocial - Local Deals', 'Amazon Shopping', 'RetailMeNot - Coupons, Deals & Discount Shopping', 'Poshmark - Buy & Sell Fashion', 'Target - now with Cartwheel', 'ZALORA Fashion Shopping', 'eBay: Buy & Sell this Summer - Discover Deals Now!', 'Fancy', "Modcloth – Unique Indie Women's Fashion & Style", 'Gyft - Mobile Gift Card Wallet', "JackThreads: Men's Shopping", 'LivingSocial - Local Deals', 'Zappos – Shoe shopping made simple', 'Wanelo Shopping', 'Etsy: Handmade & Vintage Goods', 'Groupon - Shop Deals, Discounts & Coupons', 'eBay: Buy & Sell this Summer - Discover Deals Now!', "JackThreads: Men's Shopping", 'AliExpress - Smarter Shopping, Better Living', 'Slickdeals: Coupons & Shopping', 'Target - now with Cartwheel', 'Wish - Shopping Made Fun', 'Fancy', 'ASOS', 'Google Photos', 'Shutterfly: Free Prints, Photo Books, Cards, Gifts', 'InstaBeauty -Makeup Selfie Cam', 'B612 - Beauty & Filter Camera', 'BeautyPlus - Easy Photo Editor & Selfie Camera', 'YouCam Perfect - Selfie Photo Editor', 'Google Photos', 'Muzy - Share photos & collages', 'QuickPic - Photo Gallery with Google Drive Support', 'Flickr', 'Shutterfly: Free Prints, Photo Books, Cards, Gifts', 'Open Camera', 'Camera for Android', 'Cymera Camera- Photo Editor, Filter,Collage,Layout', 'Candy Camera - selfie, beauty camera, photo editor', 'Camera360: Selfie Photo Editor with Funny Sticker', 'Facetune - For Free', 'Photo Editor Selfie Camera Filter & Mirror Image', 'HD Camera for Android', 'Photo Editor Pro', 'YouCam Makeup - Magic Selfie Makeovers', 'Photo Editor-', 'Camera for Android', 'Photo Editor', 'Cymera Camera- Photo Editor, Filter,Collage,Layout', 'Adobe Photoshop Express:Photo Editor Collage Maker', 'BeautyPlus - Easy Photo Editor & Selfie Camera', 'InstaSize Photo Filters & Collage Editor', 'Candy Camera - selfie, beauty camera, photo editor', 'YouCam Perfect - Selfie Photo Editor', 'Camera360: Selfie Photo Editor with Funny Sticker', 'Facetune - For Free', 'Shutterfly: Free Prints, Photo Books, Cards, Gifts', 'BeautyPlus - Easy Photo Editor & Selfie Camera', 'CBS Sports App - Scores, News, Stats & Watch Live', 'Yahoo Fantasy Sports - #1 Rated Fantasy App', 'ESPN', 'NFL', 'Bleacher Report: sports news, scores, & highlights', 'ESPN Fantasy Sports', 'theScore: Live Sports Scores, News, Stats & Videos', 'CBS Sports App - Scores, News, Stats & Watch Live', 'ESPN', 'MLB At Bat', 'CBS Sports App - Scores, News, Stats & Watch Live', 'WatchESPN', 'Hole19: Golf GPS App, Rangefinder & Scorecard', 'Yahoo Fantasy Sports - #1 Rated Fantasy App', 'ESPN Fantasy Sports', 'CBS Sports Fantasy', 'ESPN', 'Bleacher Report: sports news, scores, & highlights', 'theScore: Live Sports Scores, News, Stats & Videos', 'CBS Sports App - Scores, News, Stats & Watch Live', 'ESPN', 'Bleacher Report: sports news, scores, & highlights', 'MLB At Bat', 'theScore: Live Sports Scores, News, Stats & Videos', 'CBS Sports App - Scores, News, Stats & Watch Live', 'Yahoo Sports - scores, stats, news, & highlights', 'WatchESPN', 'FotMob - Live Soccer Scores', 'Yahoo Fantasy Sports - #1 Rated Fantasy App', 'ESPN', 'NFL', 'US Open Tennis Championships 2018', 'Bleacher Report: sports news, scores, & highlights', 'MLB At Bat', 'FIFA - Tournaments, Soccer News & Live Scores', 'theScore: Live Sports Scores, News, Stats & Videos', 'Golfshot: Golf GPS + Tee Times', 'BBC Sport', 'CBS Sports App - Scores, News, Stats & Watch Live', 'Yahoo Sports - scores, stats, news, & highlights', 'WatchESPN', 'MLB Ballpark', 'FOX Sports: Live Streaming, Scores & News', 'Fantasy Football', 'PGA TOUR', 'UFC', 'trivago: Hotels & Travel', 'Expedia Hotels, Flights & Car Rental Travel Deals', 'TripAdvisor Hotels Flights Restaurants Attractions', 'Skyscanner', 'Booking.com Travel Deals', 'TripAdvisor Hotels Flights Restaurants Attractions', 'Priceline Hotel Deals, Rental Cars & Flights', 'United Airlines', 'Expedia Hotels, Flights & Car Rental Travel Deals', 'Southwest Airlines', 'Hopper - Watch & Book Flights', 'Fly Delta', 'KAYAK Flights, Hotels & Cars', 'American Airlines', 'Skyscanner', 'Priceline Hotel Deals, Rental Cars & Flights', 'trivago: Hotels & Travel', 'Expedia Hotels, Flights & Car Rental Travel Deals', 'KAYAK Flights, Hotels & Cars', 'Orbitz - Hotels, Flights & Package Deals', 'Skyscanner', 'Hotels.com: Book Hotel Rooms & Find Vacation Deals', 'Booking.com Travel Deals', 'Hostelworld: Hostels & Cheap Hotels Travel App', 'TripAdvisor Hotels Flights Restaurants Attractions', 'Airbnb', 'Skyscanner', 'HotelTonight: Book amazing deals at great hotels', 'Maps - Navigate & Explore', 'Google Street View', 'Calculator', 'Gboard - the Google Keyboard', 'ZEDGE™ Ringtones & Wallpapers', 'ZEDGE™ Ringtones & Wallpapers', 'Nova Launcher', 'Apex Launcher', 'Smart Launcher 5', 'Google Keep', 'Evernote – Organizer, Planner for Notes & Memos', 'ES File Explorer File Manager', 'Microsoft Word', 'Google Drive', 'Adobe Acrobat Reader', 'Google PDF Viewer', 'Microsoft Excel', 'Google Docs', 'Microsoft PowerPoint', 'Microsoft OneNote', 'Google Calendar', 'Google Keep', 'Wunderlist: To-Do List & Tasks', 'Evernote – Organizer, Planner for Notes & Memos', 'Any.do: To-do list, Calendar, Reminders & Planner', 'Todoist: To-do lists for task management & errands', 'Microsoft OneNote', 'Planner Pro-Personal Organizer', 'Google Calendar', 'Google Drive', 'Microsoft OneDrive', 'Dropbox', 'MX Player', 'Video Editor', 'Google News', 'Flipboard: News For Our Time', 'BBC News', 'Fox News – Breaking News, Live Video & News Alerts', 'USA TODAY', 'CNN Breaking US & World News', 'Twitter', 'BBC News', 'NPR News', 'Fox News – Breaking News, Live Video & News Alerts', 'Haystack TV: Local & World News - Free', 'ABC News - US & World News', 'USA TODAY', 'NBC News', 'The Wall Street Journal: Business & Market News', 'CNN Breaking US & World News', 'NYTimes - Latest News', 'Newsroom: News Worth Sharing', 'Google News', 'BuzzFeed: News, Tasty, Quizzes', 'Flipboard: News For Our Time', 'Snapchat', 'Flashlight', 'Pou', 'Agar.io', 'Angry Birds Classic', 'My Talking Tom', 'Netflix', 'Bubble Shooter', 'Adobe Acrobat Reader', 'Subway Surfers', 'LEGO® Juniors Create & Cruise', 'WhatsApp Messenger', 'Google Translate', 'Pokémon GO', 'Instagram', 'My Talking Angela', 'YouTube Kids', 'PAC-MAN', 'Colorfy: Coloring Book for Adults - Free', 'Toca Kitchen 2', 'Amazon Shopping', 'Chick-fil-A', 'YouTube', 'Flow Free', 'Microsoft Word', "Alto's Adventure", 'Zombie Tsunami', 'Facebook', 'B612 - Beauty & Filter Camera', 'Block Craft 3D: Building Simulator Games For Free', '8 Ball Pool', 'VPN Free - Betternet Hotspot VPN & Private Browser', 'EMT Tutor NREMT-B Study Guide', 'EMT-B Pocket Prep', 'UC Browser - Fast Download Private & Secure', 'Hungry Shark Evolution', 'Diary with lock', 'Clash of Clans', 'Clash Royale', 'C Programming', 'CppDroid - C/C++ IDE', 'Candy Crush Saga', 'Google Chrome: Fast & Secure', 'Learn C++', 'Hill Climb Racing', 'ZEDGE™ Ringtones & Wallpapers', 'Minion Rush: Despicable Me Official Game', 'Google Duo - High Quality Video Calls', 'Crossy Road', 'Temple Run 2', 'Dropbox', 'Sniper 3D Gun Shooter: Free Shooting Games - FPS', 'Plants vs. Zombies FREE', 'Dream League Soccer 2018', 'eBay: Buy & Sell this Summer - Discover Deals Now!', 'ESPN', 'ES File Explorer File Manager', 'Firefox Browser fast & private', 'E*TRADE Mobile', 'WWE', 'Amazon Kindle', 'Evernote – Organizer, Planner for Notes & Memos', 'Microsoft Edge', 'Microsoft Outlook', 'Pinterest', 'ClassDojo', 'The Coupons App', 'Ebook Reader', 'Gmail', 'Maps - Navigate & Explore', 'AliExpress - Smarter Shopping, Better Living', 'Flipkart Online Shopping App', 'Wish - Shopping Made Fun', 'Messenger – Text and Video Chat for Free', 'Facebook Lite', 'Messenger Lite: Free Calls & Messages', 'Twitter', 'LINE: Free Calls & Messages', 'imo beta free calls and text', 'Geometry Dash World', 'Google+', 'PUBG MOBILE', 'Gboard - the Google Keyboard', 'Granny', 'Google', 'Hangouts', 'G Cloud Backup', 'Google Drive', 'Helix Jump', 'H&M', 'H TV', 'Talking Ben the Dog', 'imo free video calls and chat', 'free video calls and chat', 'slither.io', 'POF Free Dating App', 'Skype - free IM & video calls', 'Sonic Dash', 'Text Free: WiFi Calling App', 'Talkatone: Free Texts, Calls & Phone Number', 'Textgram - write on photos', 'Zombie Catchers', 'Jetpack Joyride', 'Anger of stick 5 : zombie', 'Cut the Rope FULL FREE', 'Turbo FAST', 'K PLUS', 'PowerDirector Video Editor App: 4K, Slow Mo & More', 'Fuzzy Numbers: Pre-K Number Foundation', 'KakaoTalk: Free Calls & Text', 'LiveMe - Video chat, new friends, and make money', 'Talking Tom Gold Run', 'letgo: Buy & Sell Used Stuff, Cars & Real Estate', 'Love Balls', 'Last Day on Earth: Survival', 'Minecraft', 'MEGA', 'MX Player', 'I’m Expecting - Pregnancy App', 'Diabetes:M', 'Opera Mini - fast web browser', 'Opera Browser: Fast and Secure', 'O-Star', 'PicsArt Photo Studio: Collage Maker & Pic Editor', 'Quora', 'ROBLOX', 'SHAREit - Transfer & Share', 'Tumblr', 'Topbuzz: Breaking News, Videos & Funny GIFs', 'Twitch: Livestream Multiplayer Games & Esports', 'Telegram', 'myAT&T', 'Truecaller: Caller ID, SMS spam blocking & Dialer', 'Showtime Anytime', 'UC Browser Mini -Tiny Fast Private & Secure', 'Uber', 'Viber Messenger', 'VLC for Android', 'Vigo Video', 'WeChat', 'Wattpad 📖 Free Books', 'Waze - GPS, Maps, Traffic Alerts & Live Navigation', 'Dating App, Flirt & Chat : W-Match', 'WPS Office - Word, Docs, PDF, Note, Slide & Sheet', 'LINE WEBTOON - Free Comics', 'WhatsApp Business', 'We Heart It', 'TripAdvisor Hotels Flights Restaurants Attractions', 'Telegram X', 'Share Music & Transfer Files - Xender', 'Yandex Browser with Protect', 'YouTube Studio', 'Yahoo Mail – Stay Organized', 'PBS KIDS Video', 'YouTube Gaming', 'GO Keyboard - Emoticon keyboard, Free Theme, GIF', 'Zello PTT Walkie Talkie', 'Z Camera - Photo Editor, Beauty Selfie, Collage', 'Six Pack in 30 Days - Abs Workout', 'Angry Birds 2', 'Angry Birds Rio', 'AC - Tips & News for Android™', 'CM Browser - Ad Blocker , Fast Download , Privacy', 'Google Ads', 'Mobi Calculator free & AD free!', 'Flipp - Weekly Shopping', 'A&E - Watch Full Episodes of TV Shows', 'Camera FV-5 Lite', 'Cardiac diagnosis (heart rate, arrhythmia)', 'Open Camera', 'All Football - Latest News & Videos', 'Maricopa AH', 'Youper - AI Therapy', 'Animal Jam - Play Wild!', 'RULES OF SURVIVAL', 'Amazon for Tablets', 'Final Fantasy XV: A New Empire', 'The Sims™ FreePlay', 'Text free - Free Text + Call', 'Google Photos', '365Scores - Live Scores', 'DINO HUNTER: DEADLY SHORES', 'AP Mobile - Breaking News', 'Reuters News', 'Puffin Web Browser', 'AccuWeather: Daily Forecast & Live Weather Reports', 'Moovit: Bus Time & Train Time Live Info', 'Jurassic World™ Alive', 'Houzz Interior Design Ideas', 'NYTimes - Latest News', 'Overstock – Home Decor, Furniture Shopping', 'Google Voice', 'Choices: Stories You Play', 'Runtastic Sleep Better: Sleep Cycle & Smart Alarm', 'Google Pay', 'Ringtone Maker', 'Google Allo', 'Plants vs. Zombies™ Heroes', 'CM FILE MANAGER HD', 'MLB At Bat', 'HotelTonight: Book amazing deals at great hotels', 'realestate.com.au - Buy, Rent & Sell Property', 'Video Player All Format', 'DEER HUNTER 2018', 'Video Editor', 'Google Play Games', 'ai.type Free Emoji Keyboard', 'Manga AZ - Manga Comic Reader', 'British Airways', 'American Airlines', 'Anthem BC Anywhere', 'Transit: Real-Time Transit App', 'PMHNP-BC Pocket Prep', 'BeautyPlus - Easy Photo Editor & Selfie Camera', 'Bowmasters', 'Nick', 'mySugr: the blood sugar tracker made just for you', 'Backgrounds HD (Wallpapers)', 'Blur Image Background', 'Newegg Mobile', 'Moco - Chat, Meet People', 'Hot or Not - Find someone right now', 'MeetMe: Chat & Meet New People', 'TED', 'English Dictionary - Offline', 'OkCupid Dating', 'Mint: Budget, Bills, Finance', 'English Grammar Test', 'Daily Manga - Comic & Webtoon', 'BBM - Free Calls & Messages', 'BeyondMenu Food Delivery', 'NOOK: Read eBooks & Magazines', 'NOOK App for NOOK Devices', 'Badoo - Free Chat & Dating App', 'HBO GO: Stream with TV Package', 'No Crop & Square for Instagram', 'Hungry Shark World', 'iBP Blood Pressure', 'Blood Pressure', 'Blood Pressure Log - MyDiary', 'Blood Pressure(BP) Diary', 'BP Journal - Blood Pressure Diary', 'Blood Pressure Monitor', 'Blood Pressure Companion', 'Free Blood Pressure', 'High Blood Pressure Symptoms', 'QR Scanner & Barcode Scanner 2018', 'Camera FV-5', 'Camera MX - Free Photo & Video Camera', 'Bleacher Report: sports news, scores, & highlights', 'Cardboard', 'Kick the Buddy', 'Maps & GPS Navigation — OsmAnd', 'Beautiful Widgets Pro', 'Beautiful Widgets Free', 'HD Widgets', 'Color by Number – New Coloring Book', 'Photo Editor by Aviary', 'UNICORN - Color By Number & Pixel Art Coloring', 'Elmo Calls by Sesame Street', '420 BZ Budeze Delivery', 'BZWBK24 mobile', 'Zoosk Dating App: Meet Singles', 'Cricbuzz - Live Cricket Scores & News', 'Cheapflights – Flight Search', 'Chrome Beta', 'Chrome Dev', 'CJmall', 'Credit Karma', 'Castle Clash: Heroes of the Empire US', 'CM Launcher 3D - Theme, Wallpapers, Efficient', 'CM Locker - Security Lockscreen', 'CM Flashlight (Compass, SOS)', 'Ruler', 'QuickPic - Photo Gallery with Google Drive Support', 'Cartoon Network App', 'LEGO® TV', 'DisneyNOW – TV Shows & Games', 'Brit + Co', 'CT Scan Cross Sectional Anatomy', 'Shadow Fight 2', 'Curriculum vitae App CV Builder Free Resume Maker', 'The CW', 'CW Seed', 'Hulu: Stream TV, Movies & more', 'Cymera Camera- Photo Editor, Filter,Collage,Layout', 'Camera360 Lite - Selfie Camera', 'Mapy.cz - Cycling & Hiking offline maps', 'Face Filter, Selfie Editor - Sweet Camera', 'Metal Soldiers 2', "COOKING MAMA Let's Cook!", 'Run Sausage Run!', 'Knife Hit', 'DRAGON BALL LEGENDS', 'DC Comics', 'DC Super Hero Girls™', 'MARVEL Contest of Champions', 'MARVEL Strike Force', 'wetter.com - Weather and Radar', 'Babbel – Learn Languages', 'CallApp: Caller ID, Blocker & Phone Call Recorder', 'LINE Camera - Photo editor', 'Racing in Car 2', 'Google PDF Viewer', 'Periscope - Live Video', 'Dungeon Hunter Champions: Epic Online Action RPG', 'Red Bull TV: Live Sports, Music & Entertainment', 'Idle Heroes', 'Duolingo: Learn Languages Free', 'Free phone calls, free texting SMS on free number', 'Phone Tracker : Family Locator', 'My Photo Keyboard', 'Whoscall - Caller ID & Block', 'Google Sheets', 'Video Downloader', 'Google Docs', 'Any.do: To-do list, Calendar, Reminders & Planner', 'Notepad & To do list', 'Polaris Office - Word, Docs, Sheets, Slide, PDF', 'Google Keep', 'Do It Later: Tasks & To-Dos', 'Todoist: To-do lists for task management & errands', 'To-Do Calendar Planner', 'Wunderlist: To-Do List & Tasks', 'TickTick: To Do List with Reminder, Day Planner', 'ColorNote Notepad Notes', 'Apex Launcher', 'Dude Perfect 2', 'Dairy Queen', 'SONIC Drive-In', "McDonald's", 'Wendy’s – Food and Offers', "Dunkin' Donuts", 'SUBWAY®', 'Panera Bread', 'Starbucks', "Dr. Panda & Toto's Treehouse", 'Cache Cleaner-DU Speed Booster (booster & cleaner)', 'DU Browser—Browse fast & fun', 'Real Racing 3', 'Equestria Girls', 'My Little Pony Celebration', 'Miraculous Ladybug & Cat Noir - The Official Game', 'My Little Pony: Harmony Quest', 'PJ Masks: Moonlight Heroes', 'The Emirates App', 'Phogy, 3D Camera', 'Weather by eltiempo.es', 'The Game of Life', 'Spanish English Translator', 'Human Anatomy Atlas 2018: Complete 3D Human Body', "Game for KIDS: KIDS match'em", 'CBS Sports App - Scores, News, Stats & Watch Live', 'Yahoo Fantasy Sports - #1 Rated Fantasy App', 'Dictionary - Merriam-Webster', 'Edmodo', 'busuu: Learn Languages - Spanish, English & More', 'Chess Free', 'Oxford Dictionary of English : Free', 'Masha and the Bear Child Games', 'Frozen Free Fall', 'Episode - Choose Your Story', 'The NBC App - Watch Live TV and Full Episodes', 'Moto File Manager', 'HBO NOW: Stream TV & Movies', 'Moneycontrol – Stocks, Sensex, Mutual Funds, IPO', 'CNBC: Breaking Business News & Live Market Data', 'Google Earth', 'Groupon - Shop Deals, Discounts & Coupons', 'Google News', 'Amino: Communities and Chats', 'Nike Training Club - Workouts & Fitness Plans', 'Hangouts Dialer - Call Phones', 'Offline Maps & Navigation', 'Strawberry Shortcake Ice Cream Island', 'Home Workout - No Equipment', 'Home Security Camera WardenCam - reuse old phones', 'Food Network', 'Web Browser for Android', 'Airway Ex - Intubate. Anesthetize. Train.', 'FilterGrid - Cam&Photo Editor', 'Messages, Text and Video Chat for Messenger', 'All Social Networks', 'Premier League - Official App', 'Farm Heroes Saga', 'ESPN Fantasy Sports', 'Fallout Shelter', 'Facebook Pages Manager', 'Facebook Ads Manager', 'Who Viewed My Facebook Profile - Stalkers Visitors', 'The 5th Stand', 'Garena Free Fire', 'osmino Wi-Fi: free WiFi', 'Fun Kid Racing - Motocross', 'Podcast App: Free & Offline Podcasts by Player FM', 'Motorola FM Radio', 'FarmersOnly Dating', 'Firefox Focus: The privacy browser', 'FP Notebook', 'Slickdeals: Coupons & Shopping', 'AAFP']
We see that instagram is one of them so let's look further
for apps in andriod:
name = apps[0]
if name == 'Instagram':
print(apps)
print('\n')
['Instagram', 'SOCIAL', '4.5', '66577313', 'Varies with device', '1,000,000,000+', 'Free', '0', 'Teen', 'Social', 'July 31, 2018', 'Varies with device', 'Varies with device'] ['Instagram', 'SOCIAL', '4.5', '66577446', 'Varies with device', '1,000,000,000+', 'Free', '0', 'Teen', 'Social', 'July 31, 2018', 'Varies with device', 'Varies with device'] ['Instagram', 'SOCIAL', '4.5', '66577313', 'Varies with device', '1,000,000,000+', 'Free', '0', 'Teen', 'Social', 'July 31, 2018', 'Varies with device', 'Varies with device'] ['Instagram', 'SOCIAL', '4.5', '66509917', 'Varies with device', '1,000,000,000+', 'Free', '0', 'Teen', 'Social', 'July 31, 2018', 'Varies with device', 'Varies with device']
So we notice something interesting that the review column for each entry changes. This means the column is updated by number of reviews. So instead of deleting the entries with randomly, we shall only delete those which do not have the maximum number of reviews.
To do that, we will:
reviews_max = {}
for rows in andriod:
name = rows[0]
n_reviews = float(rows[3])
if name in reviews_max and reviews_max[name] < n_reviews:
reviews_max[name] = n_reviews
if name not in reviews_max:
reviews_max[name] = n_reviews
print('Expected Lenght: ' , len(andriod) - len(duplicate_rows))
print('Actual Lenght: ' , len(reviews_max))
Expected Lenght: 9659 Actual Lenght: 9659
Now that we have separated the duplicate rows from each other based on number of reviews, let's start removing the duplicates that we don’t need.
This is done by the code shown below:
andriod_clean = []
already_added = []
for apps in andriod:
name = apps[0]
n_reviews = float(apps[3])
if (n_reviews == reviews_max[name]) and (name not in already_added):
andriod_clean.append(apps)
already_added.append(name)
Now let's explore the data
explore_data(andriod_clean, 0 ,5)
print('Total rows: ' , len(andriod_clean))
['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'] ['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'] ['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'] Total rows: 9659
As expected the number of rows are 9659
Exploring the dataset it was found that there were various non english apps.
print(IOS[813][1])
print('\n')
print(andriod_clean[7940][0])
爱奇艺PPS -《欢乐颂2》电视剧热播 لعبة تقدر تربح DZ
These have to be removed since our analysis is based on English apps only
We shall first define a function which checks whether an app is in English or not based on the ASCII code. Along with this because some apps have emojis and punctuations in them as well, the function will allow less than three non-ASCII characters.
def check_english(string):
non_ASCII = 0
for character in string:
if ord(character) > 127:
non_ASCII +=1
if non_ASCII > 3 :
return False
return True
print(check_english('Instagram'))
print(check_english('Docs To Go™ Free Office Suite'))
print(check_english('Instachat 😜'))
print(check_english('爱奇艺PPS -《欢乐颂2》电视剧热播'))
True True True False
Although the above function isn’t the most optimal solution, very few non-English app will pass through the filter and will not affect the analysis that much.
After creating the filter, we will define two lists that will contain English apps for both the Googleplay store and Apple Store
andriod_english = []
ios_english = []
for rows in andriod_clean:
name = rows[0]
if check_english(name):
andriod_english.append(rows)
for rows in IOS:
name = rows[1]
if check_english(name):
ios_english.append(rows)
print('Number of rows in andriod:' , len(andriod_english))
print('Number of rows in IOS:' , len(ios_english))
print('\n')
explore_data(andriod_english, 0 ,3 , True)
print('\n')
explore_data(ios_english, 0 ,3 , True)
Number of rows in andriod: 9614 Number of rows in IOS: 6183 ['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
We can see that we're left with 9614 Android apps and 6183 iOS apps
As I mentioned in the introduction, the company only build apps that are free to download and install, and so their main source of revenue consists of in-app ads. Our data sets contain both free and non-free apps, and we'll need to isolate only the free apps for our analysis. Below, we isolate the free apps for both our data sets.
final_andriod = []
final_ios = []
for rows in andriod_english:
price = rows[7]
if price == '0':
final_andriod.append(rows)
for rows in ios_english:
price = rows[4]
if price == '0.0':
final_ios.append(rows)
print('Number of rows in andriod:' , len(final_andriod))
print('\n')
print('Number of rows in IOS:' , len(final_ios))
Number of rows in andriod: 8864 Number of rows in IOS: 3222
By now we are left with 8864 apps for the GooglePlay store and 3222 for the AppleStore. Our analysis should be performed on them
By now a large part of the data has been cleaned of
The validation strategy for the analysis is as follows:
In order to do this, we need to find common app genres on both the markets. For this, building a frequency table for the prime_genre column of the App Store data set, and the Genres and Category columns of the Google Play data set will help us.
I'll build two functions we can use to analyze the frequency tables:
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])
Now lets starting exploring the dataset
display_table(final_ios, -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
After looking at the output more than 58% of the apps are games, followed by entertainment and photo & videos. This lets us to conclude that 70% of the apps are designed for fun, while apps with practical purposes (education, shopping, utilities, productivity, lifestyle, etc.) are rarer. However, the fact that fun apps are the most numerous doesn't also imply that they also have the greatest number of users — the demand might not be the same as the offer
Now lets examine the Google Play store dataset
display_table(final_andriod, 1)
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
We can see that the top most demanded categories are family and games. These are followed my more pratical apps like (Tools, business, lifestyle, productivity). This creates a stark differnce between the both dataset because as it can seen practical apps are more popular on Google Play store than Apple store.
display_table(final_andriod, -4)
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
As we can see the genre column is just a more granular approach to the category column. We're only looking for the bigger picture at the moment, so we'll only work with the Category column moving forward
One way to find out what genres are the most popular (have the most users) is to calculate the average number of installs for each app genre. For the Google Play data set, we can find this information in the Installs column, but for the App Store data set this information is missing. As a workaround, we'll take the total number of user ratings as a proxy, which we can find in the rating_count_tot app
We do this for the Apple Store data first
genres_ios = freq_table(final_ios, -5)
for genre in genres_ios:
total = 0
len_genre = 0
for apps in final_ios:
genre_app = apps[-5]
if genre_app == genre:
n_ratings = float(apps[5])
total += n_ratings
len_genre +=1
average_user_ratings = total/len_genre
print(genre , ':' , average_user_ratings)
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
Navigation and social networking apps followed by refrences have the highest number of reviews. This is misdirecting because for all of these genres there are a few giants that dominate the market
# For social networking apps
for apps in final_ios:
genre = apps[-5]
if genre == 'Social Networking':
print(apps[1], ':', apps[5])
Facebook : 2974676 Pinterest : 1061624 Skype for iPhone : 373519 Messenger : 351466 Tumblr : 334293 WhatsApp Messenger : 287589 Kik : 260965 ooVoo – Free Video Call, Text and Voice : 177501 TextNow - Unlimited Text + Calls : 164963 Viber Messenger – Text & Call : 164249 Followers - Social Analytics For Instagram : 112778 MeetMe - Chat and Meet New People : 97072 We Heart It - Fashion, wallpapers, quotes, tattoos : 90414 InsTrack for Instagram - Analytics Plus More : 85535 Tango - Free Video Call, Voice and Chat : 75412 LinkedIn : 71856 Match™ - #1 Dating App. : 60659 Skype for iPad : 60163 POF - Best Dating App for Conversations : 52642 Timehop : 49510 Find My Family, Friends & iPhone - Life360 Locator : 43877 Whisper - Share, Express, Meet : 39819 Hangouts : 36404 LINE PLAY - Your Avatar World : 34677 WeChat : 34584 Badoo - Meet New People, Chat, Socialize. : 34428 Followers + for Instagram - Follower Analytics : 28633 GroupMe : 28260 Marco Polo Video Walkie Talkie : 27662 Miitomo : 23965 SimSimi : 23530 Grindr - Gay and same sex guys chat, meet and date : 23201 Wishbone - Compare Anything : 20649 imo video calls and chat : 18841 After School - Funny Anonymous School News : 18482 Quick Reposter - Repost, Regram and Reshare Photos : 17694 Weibo HD : 16772 Repost for Instagram : 15185 Live.me – Live Video Chat & Make Friends Nearby : 14724 Nextdoor : 14402 Followers Analytics for Instagram - InstaReport : 13914 YouNow: Live Stream Video Chat : 12079 FollowMeter for Instagram - Followers Tracking : 11976 LINE : 11437 eHarmony™ Dating App - Meet Singles : 11124 Discord - Chat for Gamers : 9152 QQ : 9109 Telegram Messenger : 7573 Weibo : 7265 Periscope - Live Video Streaming Around the World : 6062 Chat for Whatsapp - iPad Version : 5060 QQ HD : 5058 Followers Analysis Tool For Instagram App Free : 4253 live.ly - live video streaming : 4145 Houseparty - Group Video Chat : 3991 SOMA Messenger : 3232 Monkey : 3060 Down To Lunch : 2535 Flinch - Video Chat Staring Contest : 2134 Highrise - Your Avatar Community : 2011 LOVOO - Dating Chat : 1985 PlayStation®Messages : 1918 BOO! - Video chat camera with filters & stickers : 1805 Qzone : 1649 Chatous - Chat with new people : 1609 Kiwi - Q&A : 1538 GhostCodes - a discovery app for Snapchat : 1313 Jodel : 1193 FireChat : 1037 Google Duo - simple video calling : 1033 Fiesta by Tango - Chat & Meet New People : 885 Google Allo — smart messaging : 862 Peach — share vividly : 727 Hey! VINA - Where Women Meet New Friends : 719 Battlefield™ Companion : 689 All Devices for WhatsApp - Messenger for iPad : 682 Chat for Pokemon Go - GoChat : 500 IAmNaughty – Dating App to Meet New People Online : 463 Qzone HD : 458 Zenly - Locate your friends in realtime : 427 League of Legends Friends : 420 豆瓣 : 407 Candid - Speak Your Mind Freely : 398 知乎 : 397 Selfeo : 366 Fake-A-Location Free ™ : 354 Popcorn Buzz - Free Group Calls : 281 Fam — Group video calling for iMessage : 279 QQ International : 274 Ameba : 269 SoundCloud Pulse: for creators : 240 Tantan : 235 Cougar Dating & Life Style App for Mature Women : 213 Rawr Messenger - Dab your chat : 180 WhenToPost: Best Time to Post Photos for Instagram : 158 Inke—Broadcast an amazing life : 147 Mustknow - anonymous video Q&A : 53 CTFxCmoji : 39 Lobi : 36 Chain: Collaborate On MyVideo Story/Group Video : 35 botman - Real time video chat : 7 BestieBox : 0 MATCH ON LINE chat : 0 niconico ch : 0 LINE BLOG : 0 bit-tube - Live Stream Video Chat : 0
# Navigation apps
for apps in final_ios:
genre = apps[-5]
if genre == 'Navigation':
print(apps[1], ':', apps[5])
Waze - GPS Navigation, Maps & Real-time Traffic : 345046 Google Maps - Navigation & Transit : 154911 Geocaching® : 12811 CoPilot GPS – Car Navigation & Offline Maps : 3582 ImmobilienScout24: Real Estate Search in Germany : 187 Railway Route Search : 5
for apps in final_ios:
genre = apps[-5]
if genre == 'Reference':
print(apps[1], ':', apps[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
The dataset is skewed towards a few dominators of the market. Facebook and Pintrest for the Social Networking genre, Waze and google maps for Navigation and bible for the reference’s genre.
Other genres that seem popular include weather, book, food and drink, or finance. These other genres don't seem too interesting to us:
Weather apps — people generally don't spend too much time in-app, and the chances of making profit from in-app adds are low. Also, getting reliable live weather data may require us to connect our apps to non-free APIs.
Food and drink — examples here include Starbucks, Dunkin' Donuts, McDonald's, etc. So, making a popular food and drink app requires actual cooking and a delivery service, which is outside the scope of our company.
Finance apps — these apps involve banking, paying bills, money transfer, etc. Building a finance app requires domain knowledge, and we don't want to hire a finance expert just to build an app.
Now lets do it for the Google play store
We will have to explore the install column to figure this out
display_table(final_andriod, 5)
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
One problem with this data is that is not precise. For instance, we don't know whether an app with 100,000+ installs has 100,000 installs, 200,000, or 350,000. However, we don't need very precise data for our purposes — we only want to get an idea which app genres attract the most users, and we don't need perfect precision with respect to the number of users.
We're going to leave the numbers as they are, which means that we'll consider that an app with 100,000+ installs has 100,000 installs, and an app with 1,000,000+ installs has 1,000,000 installs, and so on.
To perform computations, however, we'll need to convert each install number to float — this means that we need to remove the commas and the plus characters, otherwise the conversion will fail and raise an error. We'll do this directly in the loop below, where we also compute the average number of installs for each genre (category)
categories_android = freq_table(final_andriod, 1)
for category in categories_android:
total = 0
len_category = 0
for app in final_andriod:
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)
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
We see that the most popular genre on average is communication(38 million), video players(24 million), productivity(16 million) and social(23 million) but again after the analysis of the Apple Store Data there probably are a few key players that dominate this market as well so let’s look at them with more detail.
for app in final_andriod:
if app[1] == 'COMMUNICATION' and (app[5] == '1,000,000,000+'
or app[5] == '500,000,000+'
or app[5] == '100,000,000+'):
print(app[0], ':', app[5])
WhatsApp Messenger : 1,000,000,000+ imo beta free calls and text : 100,000,000+ Android Messages : 100,000,000+ Google Duo - High Quality Video Calls : 500,000,000+ Messenger – Text and Video Chat for Free : 1,000,000,000+ imo free video calls and chat : 500,000,000+ Skype - free IM & video calls : 1,000,000,000+ Who : 100,000,000+ GO SMS Pro - Messenger, Free Themes, Emoji : 100,000,000+ LINE: Free Calls & Messages : 500,000,000+ Google Chrome: Fast & Secure : 1,000,000,000+ Firefox Browser fast & private : 100,000,000+ UC Browser - Fast Download Private & Secure : 500,000,000+ Gmail : 1,000,000,000+ Hangouts : 1,000,000,000+ Messenger Lite: Free Calls & Messages : 100,000,000+ Kik : 100,000,000+ KakaoTalk: Free Calls & Text : 100,000,000+ Opera Mini - fast web browser : 100,000,000+ Opera Browser: Fast and Secure : 100,000,000+ Telegram : 100,000,000+ Truecaller: Caller ID, SMS spam blocking & Dialer : 100,000,000+ UC Browser Mini -Tiny Fast Private & Secure : 100,000,000+ Viber Messenger : 500,000,000+ WeChat : 100,000,000+ Yahoo Mail – Stay Organized : 100,000,000+ BBM - Free Calls & Messages : 100,000,000+
For the communication market its Whatsapp with over 1 billion downloads which is a well instablished brand and hard to compete with
for app in final_andriod:
if app[1] == 'SOCIAL' and (app[5] == '1,000,000,000+'
or app[5] == '500,000,000+'
or app[5] == '100,000,000+'):
print(app[0], ':', app[5])
Facebook : 1,000,000,000+ Facebook Lite : 500,000,000+ Tumblr : 100,000,000+ Pinterest : 100,000,000+ Google+ : 1,000,000,000+ Badoo - Free Chat & Dating App : 100,000,000+ Tango - Live Video Broadcast : 100,000,000+ Instagram : 1,000,000,000+ Snapchat : 500,000,000+ LinkedIn : 100,000,000+ Tik Tok - including musical.ly : 100,000,000+ BIGO LIVE - Live Stream : 100,000,000+ VK : 100,000,000+
Its the same case with social apps with some leading players (Facebook, Tumbler, Pintrest) dominating the market
for app in final_andriod:
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+
for app in final_andriod:
if app[1] == 'VIDEO_PLAYERS' and (app[5] == '1,000,000,000+'
or app[5] == '500,000,000+'
or app[5] == '100,000,000+'):
print(app[0], ':', app[5])
YouTube : 1,000,000,000+ Motorola Gallery : 100,000,000+ VLC for Android : 100,000,000+ Google Play Movies & TV : 1,000,000,000+ MX Player : 500,000,000+ Dubsmash : 100,000,000+ VivaVideo - Video Editor & Photo Movie : 100,000,000+ VideoShow-Video Editor, Video Maker, Beauty Camera : 100,000,000+ Motorola FM Radio : 100,000,000+
This trend continues for all the genres we analyzed
So, let’s try to find a market niche that we can capitalize on. For this reason, I decided to perform my analyses on the photography genre
for app in final_andriod:
if app[1] == 'PHOTOGRAPHY' and (app[5] == '1,000,000,000+'
or app[5] == '500,000,000+'
or app[5] == '100,000,000+'):
print(app[0], ':', app[5])
B612 - Beauty & Filter Camera : 100,000,000+ YouCam Makeup - Magic Selfie Makeovers : 100,000,000+ Sweet Selfie - selfie camera, beauty cam, photo edit : 100,000,000+ Google Photos : 1,000,000,000+ Retrica : 100,000,000+ Photo Editor Pro : 100,000,000+ BeautyPlus - Easy Photo Editor & Selfie Camera : 100,000,000+ PicsArt Photo Studio: Collage Maker & Pic Editor : 100,000,000+ Photo Collage Editor : 100,000,000+ Z Camera - Photo Editor, Beauty Selfie, Collage : 100,000,000+ PhotoGrid: Video & Pic Collage Maker, Photo Editor : 100,000,000+ Candy Camera - selfie, beauty camera, photo editor : 100,000,000+ YouCam Perfect - Selfie Photo Editor : 100,000,000+ Camera360: Selfie Photo Editor with Funny Sticker : 100,000,000+ S Photo Editor - Collage Maker , Photo Collage : 100,000,000+ AR effect : 100,000,000+ Cymera Camera- Photo Editor, Filter,Collage,Layout : 100,000,000+ LINE Camera - Photo editor : 100,000,000+ Photo Editor Collage Maker Pro : 100,000,000+
As we can see there are not a lot of distinct market leaders in this genre and below we can see that there are a lot mix of apps and any one can gain a competitive advantage in the market ranging from photo editors, collage makers and to video editors
for app in final_andriod:
if app[1] == 'PHOTOGRAPHY':
print(app[0], ':', app[5])
TouchNote: Cards & Gifts : 1,000,000+ FreePrints – Free Photos Delivered : 1,000,000+ Groovebook Photo Books & Gifts : 500,000+ Moony Lab - Print Photos, Books & Magnets ™ : 50,000+ LALALAB prints your photos, photobooks and magnets : 1,000,000+ Snapfish : 1,000,000+ Motorola Camera : 50,000,000+ HD Camera - Best Cam with filters & panorama : 5,000,000+ LightX Photo Editor & Photo Effects : 10,000,000+ Sweet Snap - live filter, Selfie photo edit : 10,000,000+ HD Camera - Quick Snap Photo & Video : 1,000,000+ B612 - Beauty & Filter Camera : 100,000,000+ Waterfall Photo Frames : 1,000,000+ Photo frame : 100,000+ Huji Cam : 5,000,000+ Unicorn Photo : 1,000,000+ HD Camera : 5,000,000+ Makeup Editor -Beauty Photo Editor & Selfie Camera : 1,000,000+ Makeup Photo Editor: Makeup Camera & Makeup Editor : 1,000,000+ Moto Photo Editor : 5,000,000+ InstaBeauty -Makeup Selfie Cam : 50,000,000+ Garden Photo Frames - Garden Photo Editor : 500,000+ Photo Frame : 10,000,000+ Selfie Camera - Photo Editor & Filter & Sticker : 50,000,000+ Sweet Snap Lite - live filter, Selfie photo editor : 500,000+ Selfie Camera: Beauty Camera, Photo Editor,Collage : 1,000,000+ Night Photo Frame : 1,000,000+ YouCam Makeup - Magic Selfie Makeovers : 100,000,000+ Selfie Photo Editor : 1,000,000+ ASUS Gallery : 50,000,000+ Kids Photo Frames : 1,000,000+ Pencil Photo Sketch-Sketching Drawing Photo Editor : 1,000,000+ Pretty Makeup, Beauty Photo Editor & Snappy Camera : 5,000,000+ Photo Collage - Layout Editor : 10,000,000+ DSLR Camera Hd Ultra Professional : 1,000,000+ Snap Cat Face Camera : 1,000,000+ Silent Camera [High Quality] : 5,000,000+ Sweet Camera - Selfie Filters, Beauty Camera : 10,000,000+ Photo Frames : 10,000,000+ Sweet Selfie - selfie camera, beauty cam, photo edit : 100,000,000+ Candy selfie - photo editor, live filter camera : 10,000,000+ Open Camera : 10,000,000+ Beauty Makeup – Photo Makeover : 1,000,000+ Blur Image Background Editor (Blur Photo Editor) : 5,000,000+ Muzy - Share photos & collages : 5,000,000+ QuickPic - Photo Gallery with Google Drive Support : 10,000,000+ Flickr : 10,000,000+ Camera for Android : 10,000,000+ Photo Mixer : 10,000,000+ Wondershare PowerCam : 10,000,000+ love : 1,000,000+ KVAD Camera +: Selfie, Photo Filter, Grids : 1,000,000+ Camera51 - a smarter camera : 1,000,000+ InstaCam - Camera for Selfie : 1,000,000+ Sweet Camera : 5,000,000+ RetroSelfie - Selfie Editor : 10,000,000+ Mega Photo : 1,000,000+ Blur Image Background : 10,000,000+ MIX by Camera360 : 5,000,000+ Google Photos : 1,000,000,000+ SuperPhoto - Effects & Filters : 5,000,000+ Camera FV-5 Lite : 10,000,000+ HD Camera Ultra : 10,000,000+ Cameringo Lite. Filters Camera : 10,000,000+ Camera ZOOM FX - FREE : 5,000,000+ HD Camera Pro for Android : 1,000,000+ GoPro (formerly Capture) : 10,000,000+ Beauty Makeup Snappy Collage Photo Editor - Lidow : 10,000,000+ Samsung SMART CAMERA App : 1,000,000+ Square InPic - Photo Editor & Collage Maker : 50,000,000+ High-Speed Camera (GIF,Burst) : 5,000,000+ Camera MX - Free Photo & Video Camera : 10,000,000+ EyeEm - Camera & Photo Filter : 10,000,000+ Retrica : 100,000,000+ VSCO : 50,000,000+ PhotoWonder: Pro Beauty Photo Editor Collage Maker : 50,000,000+ Photo Effects Pro : 50,000,000+ Photo Editor Selfie Camera Filter & Mirror Image : 50,000,000+ No Crop & Square for Instagram : 10,000,000+ Picture Grid Builder : 5,000,000+ HD Camera for Android : 10,000,000+ Photo Studio : 10,000,000+ Photo Editor Pro : 100,000,000+ Photo Editor- : 5,000,000+ Mirror Photo:Editor Collage (HD) : 10,000,000+ Pic Stitch - #1 Collage Maker : 1,000,000+ PhotoDirector Photo Editor App : 10,000,000+ Pic Collage - Photo Editor : 50,000,000+ Photo Editor by Aviary : 50,000,000+ Video Editor Music,Cut,No Crop : 50,000,000+ Pixlr – Free Photo Editor : 50,000,000+ Photo Editor : 10,000,000+ Photo Collage Maker : 10,000,000+ Adobe Photoshop Express:Photo Editor Collage Maker : 50,000,000+ BeautyPlus - Easy Photo Editor & Selfie Camera : 100,000,000+ PicsArt Photo Studio: Collage Maker & Pic Editor : 100,000,000+ Photo Collage Editor : 100,000,000+ Color Touch Effects : 10,000,000+ InstaSize Photo Filters & Collage Editor : 50,000,000+ Z Camera - Photo Editor, Beauty Selfie, Collage : 100,000,000+ PhotoGrid: Video & Pic Collage Maker, Photo Editor : 100,000,000+ Candy Camera - selfie, beauty camera, photo editor : 100,000,000+ YouCam Perfect - Selfie Photo Editor : 100,000,000+ Pixgram- video photo slideshow : 5,000,000+ Fotor Photo Editor - Photo Collage & Photo Effects : 10,000,000+ Snapseed : 50,000,000+ Camera360: Selfie Photo Editor with Funny Sticker : 100,000,000+ Font Studio- Photo Texts Image : 10,000,000+ Add Text To Photo : 1,000,000+ Phonto - Text on Photos : 10,000,000+ Collage&Add Stickers papelook : 5,000,000+ Shutterfly: Free Prints, Photo Books, Cards, Gifts : 5,000,000+ Photo Collage - InstaMag : 10,000,000+ Meitu – Beauty Cam, Easy Photo Editor : 10,000,000+ Bestie - Camera360 Selfie : 10,000,000+ B Tiff Viewer : 100,000+ F-Stop Gallery : 1,000,000+ How Do I Look : 500,000+ Keepsafe Photo Vault: Hide Private Photos & Videos : 50,000,000+ MakeupPlus - Your Own Virtual Makeup Artist : 50,000,000+ Pixlr-o-matic : 10,000,000+ PixelLab - Text on pictures : 10,000,000+ Leica Q : 10,000+ S Photo Editor - Collage Maker , Photo Collage : 100,000,000+ U Camera : Phone 6s OS 9 style : 500,000+ V.360° Camera : 100,000+ Profile w/o crop for Telegram : 10,000+ Z Camera : 10,000+ Six Pack Abs Photo Editor : 1,000,000+ Brica BPRO5 AE : 500,000+ AfterFocus : 10,000,000+ DSLR camera - Auto Focus and Blur Professional : 10,000+ AR effect : 100,000,000+ ASUS PixelMaster Camera : 10,000,000+ easyFocus : 500,000+ Blur Image - DSLR focus effect : 5,000,000+ Camera Pro : 1,000,000+ HD Camera - silent shutter : 1,000,000+ A Better Camera : 5,000,000+ Auto Dslr Photo Effect : Auto Focus Effect : 1,000+ PhotoScan by Google Photos : 10,000,000+ Afterlight : 1,000,000+ Blurfoto : Auto blur photo background & DSLR focus : 500,000+ Blur : 1,000,000+ Picai - Smart AI Camera : 100,000+ Adobe Illustrator Draw : 5,000,000+ FaceApp : 10,000,000+ AI Image Recognizer (beta) : 500+ AJ Cam : 100+ Selfie With Champion AJ Style : 500+ A.J. Styles HD Wallpapers 2018 : 100+ Scoompa Video - Slideshow Maker and Video Editor : 10,000,000+ AEE AP : 1,000+ SNOW - AR Camera : 50,000,000+ Add Watermark Free : 1,000,000+ camera zoom moon : 500,000+ AZ Camera - Manual Pro Cam : 100,000+ BC Camera : 500+ Photo Editor by BeFunky : 10,000,000+ Be Fabulous PHOTO BOOTH : 10,000+ Adobe Photoshop Fix : 5,000,000+ Photo BG Changer : 1,000+ BG Editor : 5+ PhotoLayers〜Superimpose,Eraser : 10,000,000+ Blender BG - Photo Blend With Background : 100+ Auto Background Changer : 1,000,000+ Change photo background : 5,000,000+ Background Eraser : 10,000,000+ Background Changer & Eraser : 500,000+ Cut Out : Background Eraser and background changer : 1,000,000+ Ultimate Background Eraser : 1,000,000+ DSLR Photography Training apps : 100,000+ Photo Editor - BPhoto : 1,000+ 24 megapixel hd camera : 100,000+ BK Photography : 1,000+ BL 1-Click Camera - Free : 10,000+ BL Portfolio : 100+ BQ Camera : 1,000,000+ BT Camera : 500,000+ BlitzWolf Shutter - BW Shutter : 50,000+ Black & White Camera - Lovely BW : 100,000+ Analog BW - Camera filter effect foto film retouch : 100+ Hypocam : 1,000,000+ B&W Photo Filter Editor : 50,000+ CB VIDEO VISION : 100+ CB Hair Png - New Hair Png For CB Editing : 500+ CB Edits PNG & CB Backgrounds : 5,000+ CG Prints : 100+ Gold Teeth Photo Editor : 100,000+ Night Camera Blur Effect : 10,000+ Camera V7 24 Megapixel : 100,000+ Leica CL : 1,000+ Canon CameraWindow : 1,000,000+ Cymera Camera- Photo Editor, Filter,Collage,Layout : 100,000,000+ Camera360 Lite - Selfie Camera : 10,000,000+ Wallpaper.cz : 100+ Face Filter, Selfie Editor - Sweet Camera : 10,000,000+ Visage Lab – face retouch : 5,000,000+ LC-DB-LITE : 100+ DC-014 : 500+ Bokeh (Background defocus) : 10,000,000+ Love Collage - Photo Editor : 10,000,000+ LINE Camera - Photo editor : 100,000,000+ DF Night Selfies : 10,000+ My Photo Keyboard : 10,000,000+ Story Saver for Instagram : 5,000,000+ Boomerang from Instagram : 50,000,000+ Insave-Download for Instagram : 1,000,000+ DP Editor : 5,000+ DP Maker : 100,000+ Square DP For Whatsapp : 10,000+ DP Creator for WhatsApp : 100,000+ Dp For FB : 1,000+ Magical Insta DP : 1,000+ All Types DP & Status Maker : 1,000+ DP Photo Editor : 10,000+ Fifa World Cup 2018: Photo Frame Editor & DP Maker : 100,000+ Insta Square Profile DP : 5,000+ DP Status 2017 : 50,000+ LightMeter Free : 1,000,000+ DS-L4 Viewer : 1,000+ DU GIF Maker: GIF Maker, Video to GIF & GIF Editor : 500,000+ DU Collage Maker - Photo Collage & Grid & Layout : 100,000+ Live DV : 1,000+ DV-4036 by Somikon : 1,000+ Touch DV : 50+ XDV : 1,000,000+ DV Lottery Photo Tool : 50,000+ DV KING 4K : 100+ Wifi Action Camera : 50,000+ 4K Ultra Camera : 100,000+ DV KING : 100+ DENVER ACTION CAM 3 : 10,000+ SportLook : 100,000+ Displaying You VR : 50+ i am EB : 10+ Retro Camera : 10,000,000+ Footej Camera : 1,000,000+ Video Maker with Photo and Music : 1,000,000+ Phogy, 3D Camera : 1,000,000+ Photo Lab Picture Editor: face effects, art frames : 50,000,000+ MomentCam Cartoons & Stickers : 50,000,000+ A+ Gallery - Photos & Videos : 10,000,000+ Light Meter - EV : 1,000+ FilterGrid - Cam&Photo Editor : 1,000,000+ ez Share Android app : 100,000+ Ez iCam : 1,000,000+ Facejjang : 10,000,000+ Cover Camera for FB : 100,000+ FB Photographie : 1,000+ FD Fotografia : 100+ Ghost In Photo : 5,000,000+ FH WiFiCam : 10,000+ PIP Selfie Camera Photo Editor : 10,000,000+ FL Drone 2 : 5,000+ FN Cam : 10,000+ PIP-Camera FN Photo Effect : 1,000+ Photo Editor Collage Maker Pro : 100,000,000+ Free Slideshow Maker & Video Editor : 10,000,000+ Thumbnail Maker : 1,000,000+ PhotoFunia : 10,000,000+
Lets do the same analysis for Apple Store for the photos and videos genre
for apps in final_ios:
genre = apps[-5]
if genre == 'Photo & Video':
print(apps[1], ':', apps[5])
Instagram : 2161558 Snapchat : 323905 YouTube - Watch Videos, Music, and Live Streams : 278166 Pic Collage - Picture Editor & Photo Collage Maker : 123433 Funimate video editor: add cool effects to videos : 123268 musical.ly - your video social network : 105429 Photo Collage Maker & Photo Editor - Live Collage : 93781 Vine Camera : 90355 Google Photos - unlimited photo and video storage : 88742 Flipagram : 79905 Mixgram - Picture Collage Maker - Pic Photo Editor : 54282 Shutterfly: Prints, Photo Books, Cards Made Easy : 51427 Pic Jointer – Photo Collage, Camera Effects Editor : 51330 Color Pop Effects - Photo Editor & Picture Editing : 45320 Photo Grid - photo collage maker & photo editor : 40531 iSwap Faces LITE : 39722 MOLDIV - Photo Editor, Collage & Beauty Camera : 39501 Photo Editor by Aviary : 39501 Photo Lab: Picture Editor, effects & fun face app : 34585 Rookie Cam - Photo Editor & Filter Camera : 33921 FotoRus -Camera & Photo Editor & Pic Collage Maker : 32558 PicsArt Photo Studio: Collage Maker & Pic Editor : 29078 Quik – GoPro Video Editor to edit clips with music : 28654 Splice - Video Editor + Movie Maker by GoPro : 28189 FreePrints – Photos Delivered : 26060 Triller - Music Video & Film Maker : 25683 Ghost Lens+Scary Photo Video Edit&Collage Maker : 18316 Camera360 - Selfie Filter Camera, Photo Editor : 16729 InstaMag - Free Pic and Photo Collage Maker : 16221 Over— Edit Photos, Add Text & Captions to Pictures : 16221 Photo Transfer App - Easy backup of photos+videos : 15654 InstaSize: Photo Editor, Picture Effects & Collage : 15605 Prisma: Photo Editor, Art Filters Pic Effects : 15060 Filterra – Photo Editor, Effects for Pictures : 14744 YouCam Makeup: Magic Makeup Selfie Cam : 14188 MSQRD — Live Filters & Face Swap for Video Selfies : 12982 Artisto – Video and Photo Editor with Art Filters : 12963 InShot Video Editor Music, No Crop, Cut : 12779 Layout from Instagram : 12616 Face Swap App- Funny Face Changer Photo Effects : 11977 Moments - private albums with friends and family : 11955 VSCO : 11174 Retrica - Selfie Camera with Filter, Sticker & GIF : 11021 VivaVideo - Best Video Editor & Photo Movie Maker : 10618 Prime Photos from Amazon : 10511 Canva - Graphic Design & Photo Editing : 9114 Photo Editor- : 9095 Snapseed : 8683 You Doodle - draw on photos & pictures, add text : 8520 PIP Camera-Selfie Cam&Pic Collage&Photo Editor : 8454 BeautyPlus - Selfie Camera for a Beautiful Image : 7503 Baby Story - Pregnancy Pics Baby Milestones Photo : 6700 Capture - Control Your GoPro Camera - Share Video : 6542 Meitu : 6478 Visage makeup editor plus photo teeth whitener : 5767 Video & TV Cast for Chromecast: Best Browser to cast and stream webvideos and local videos on TV & Displays : 5676 Adobe Photoshop Mix - Cut out, combine, create : 5253 Collageable - Photo Collage Maker, Pic Grid Free : 5112 Bazaart Photo Editor Pro and Picture Collage Maker : 4909 InstaBeauty -Camera&Photo Editor&Pic Collage Maker : 4818 YouCam Perfect - Photo & Selfie Editor : 4293 PHHHOTO - Look Alive : 4280 MuseCam - Edit Photos & Manual Camera : 4267 VR Tube - Virtual Reality 360 Video Player : 4142 Fyuse - 3D Photos : 4126 MakeupPlus - Natural, Professional Makeup Looks : 3987 LINE Camera - Photo editor, Animated Stamp, Filter : 3978 Printicular Print Photos - 1 Hour Pickup : 3909 Lumyer - augmented reality camera effects : 3896 KODAK Kiosk Connect App : 3711 Cool Wallpapers for Pokemon : 3694 Pro Editor - Video Maker for FaceBook & Youtube : 3668 Lomotif Music Video Editor - Add Music & Effects! : 3507 Epson iPrint : 2838 YouCam Fun - Live Selfie Video Filters : 2522 A Color Story : 2436 Boomerang from Instagram : 2373 B612 - Trendy Filters, Selfiegenic Camera : 2275 Polarr Photo Editor - Photo Editing Tools for All : 2246 Retouch Vogue - Facetune Wrinkles & Pimples Makeup : 2235 Kanvas - Express Yourself : 2177 Easy Save - Repost your Instagram Photos & Videos : 2159 Meitu HD : 2150 Pixlr - Photo Collages, Effects, Overlays, Filters : 2099 Patternator Pattern Maker Backgrounds & Wallpapers : 2092 BeautyCam - AR Carnie selfie : 2082 GIPHY. The GIF Search Engine for All the GIFs : 2069 Adobe Photoshop Lightroom for iPad : 2005 SuperPhoto - Photo Effects & Filters : 1952 Solo Selfie : 1799 Felt: Birthday & Greeting Cards & Thank You Card : 1724 Perfect Image - Pic Collage Maker, Add Text to Photo, Cool Picture Editor : 1646 InstaBoard for Instagram - photos & videos repost : 1571 Adobe Photoshop Lightroom for iPhone : 1494 PhotoScan - scanner by Google Photos : 1421 RealTimes: Video Maker : 1274 Meipai : 1190 POTO - Photo Collage Maker : 1149 SNOW - Selfie, Motion sticker, Fun camera : 1115 Bestie-Beauty Camera 360 & Portrait Selfie Editor : 1035 Facetune 2 : 1009 Pitu : 968 intoLive - Custom Live Photos wallpaper maker : 938 LOL Movie: Change your face + voice! : 849 Camcorder - Record VHS Home Videos : 830 Anime Power FX : 807 Squaready for Video - Convert Rectangle Movie Clip into Square Shape for Instagram : 778 Canon PRINT Inkjet/SELPHY : 689 Microsoft Pix Camera : 678 Kwai - Share your video moments : 668 Polaroid Print App - ZIP : 631 Photo Quilt - Auto Collage Maker : 599 Cymera - Photo & Beauty Editor & Collage : 523 FACIE : 514 Photo Editing Effects & Collage Maker - Effectshop : 422 Pic-it Collage - Photo Collage Maker and Editor : 415 Candy Camera : 397 Microsoft Selfie : 375 Color Pop Free - Selective Color Splash Effects and Black & White Photography Editor : 352 SelfieCity : 252 InstaSave for Instagram - Download & Repost your own Videos & Photos for Free : 243 CATCHY Photos-Easter Bunny, Tooth Fairy and more.. : 228 SW/NG - Living Photos. Memories that Swing. : 222 SlideStory - Create a slideshow movie and a snap video : 220 April - Layouts, Photo Collage, and Poster Maker : 165 PopCam Photo : 160 Foodie - Delicious Camera for Food : 144 FreeVRPlayer : 134 Confetti - Geofilter Design Maker for Snapchat : 120 Philm-Video&Photo Editor,REAL-TIME Magic Filter : 103 Digital Domain : 102 Homido 360 VR player : 100 Best 9 for Instagram : 88 VR Video World - Virtual Reality : 88 FilmStory - For All Your Video Editing Needs : 66 GIFYme - Create video loops and gifs with amazing filters for Whatsapp and Instagram : 65 Kiosk Photo Transfer by Fujifilm : 58 Pikazo – AI art that YOU control : 56 lollicam - photo, video, and selfie camera : 51 LOOKS - Real Makeup Camera : 25 C CHANNEL -Watch tips & tricks videos for girls : 21 in-capturing moments in life : 16 Everfilter - transform your photos into artworks : 15 GoSnaps - Share Screenshots for Pokémon GO : 12 NightShooting : 9 MixChannel : 6 Simple Camera - Fast Minimal Design : 3 SwapperFace - Face Swap Free, Live Mask Effects : 2 LINE Moments - Capture Your Fun Moments : 1 Video speed editor - VBooster : 1 Video Smith - A Powerful video editing tool set : 1 MeiCam - Video Production Master : 0 Instant X - Take instant-camera-like photo with double exposure and bulb mode : 0 EOPAN : 0 StageCameraHD : 0 Pictalive for Live Photos - Create from videos : 0 BlurEffect-Blur Photo & Video, Hide Face : 0 camera for filter : 0 Emojil - original emoji stamp, decoration camera : 0 CelebrityDiagnosis! : 0
As we can see the photo and video editor apps don’t have dominant market leader( ignoring Instagram, Snapchat and YouTube because they operate in a more social media market model).
In this project, I analyzed data about the App Store and Google Play mobile apps with the goal of recommending an app profile that can be profitable for both markets.
The best approach would be to design a photo/video editor application. There is no dominant market leader and the market still draws many users. In order to get a competitive advantage in the genre a novel feature being introduced like a retro filter which is something possible or somehow allowing people to have pictures like polaroid but online because these are some of the features that are in high demand in the market.