Guided Project: Profitable App Profiles for the App Store and Google Play Markets

Objective

Analyze data to help our developers understand what kind of applications will have the best chance of attracting users.

Opening and Exploring the Data

SA sample from a data set is to be analyzed. A dataset (from 2018) that contains data on approximately ten thousand Android applications from Google Play which can be downloaded here A dataset that contains data (from 2017) on approximately seven thousand iOS applications from the App Store that It can be downloaded here. The first step is to open the dataset

In [1]:
#opeen dataset apple
open_file= open('AppleStore.csv',encoding='UTF8')
from csv import reader
read_file=reader(open_file)
data=list(read_file)
apple_header=data[0]
apple_data=data[1:]

#open dataset google
open_file2= open('googleplaystore.csv',encoding='UTF8')
from csv import reader
read_file2=reader(open_file2)
data2=list(read_file2)
google_header=data2[0]
google_data=data2[1:]

To facilitate the exploration of the data set, a function called explore_data. In this way we can explore the rows we want. It will also show the number of rows and columns the data set contains.

In [2]:
def explore_data(dataset, start, end, rows_and_columns=False):
    dataset_slice=dataset[start:end]
    for row in dataset_slice:
        print(row)
        print('\n') #create a new line empty after each row
        
    if rows_and_columns:
        print('Number of rows:', len(dataset))
        print('Number of columns:', len(dataset[0]))

To test that the function works correctly, it is used to know the first three rows of the data sets.

In [3]:
explore_data(google_data,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']


['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
In [4]:
explore_data(apple_data,0,3,True)
['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

Now it would help us a lot to know the name of the columns to be able to carry out the analysis

In [5]:
print(google_header)
print('\n')
print(apple_header)
['App', 'Category', 'Rating', 'Reviews', 'Size', 'Installs', 'Type', 'Price', 'Content Rating', 'Genres', 'Last Updated', 'Current Ver', 'Android Ver']


['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']

Data cleaning

It must be ensured that the data to be analyzed is correct. Why should: Detect inaccurate data and correct or delete it. Detect duplicate data and remove duplicates. In addition, it must be taken into account that the applications created by the company are free and in the English language. Applications that are not in English will be removed Applications that are not free will be removed

Deleting Wrong Data

There is an error in the Google Play dataset specifically in the Installs column. To check this, the row is printed and compared with other rows.

In [6]:
print(google_header[5])
print(google_data[10472])
print(google_data[10472][5])
print(google_data[10473][5])
print(google_data[10474][5])
Installs
['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']
Free
10,000,000+
1,000+

Row 10472 of the google dataset is wrong. Therefore it is deleted, to check it the number of rows is printed before and after executing the command del. The command should only be run once del

In [7]:
print(len(google_data))
del google_data[10472]  #runs once
print(len(google_data))
10841
10840

Removing Duplicate Entries

Now you want to remove duplicates. This shows the number of duplicates and some of the duplicate applications.

In [8]:
duplicate_names=[]
unique_names=[]

for app in google_data:
    name= app[0]
    if name in unique_names:
        duplicate_names.append(name)
    else:
        unique_names.append(name)
print('Numero de duplicados:', len(duplicate_names))
print('\n')
print('Duplicados:', duplicate_names[:15])
Numero de duplicados: 1181


Duplicados: ['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']

If there are several duplicates of the same application, they will not be removed randomly. The row with the highest number of reviews will be taken into consideration, since the greater the number of reviews, the more reliable the ratings will be. Create a dictionary where each key is a unique application name, and the value is the highest number of revisions of that application Use the dictionary to create a new dataset, which will have only one entry per application (and we will only select the applications with the highest number of reviews)

  • First, the name of the app with the number of revisions is saved in a dictionary. As there are several apps with the same name, only the one with the highest number of reviews will be saved..
In [9]:
reviews_max={}
for row in google_data:
    name= row[0]
    n_reviews=float(row[3])
    if name in reviews_max and (reviews_max[name]< n_reviews):
        reviews_max[name]= n_reviews
    elif name not in reviews_max:
        reviews_max[name]=n_reviews
#print(reviews_max)

We found that there are 1,181 cases where an application occurs more than once, so the length of our dictionary (of unique applications) should be equal to the difference between the length of our dataset and 1,181.

In [10]:
print(len(reviews_max))
9659

Now the reviews_max dictionary is used to remove duplicates. For duplicate cases, we will only keep the entries with the highest number of reviews. In the code cell below:

We start by initializing two empty lists, android_clean and already_added. We loop through the Android dataset and for each iteration: We isolate the application name (row2 [0]) and the number of reviews (row2 [3]). We add the current row (row2) to the android_clean list and the application name (name) to the already_added list if:

  • The number of reviews for the current application matches the number of reviews for that application as described in the reviews_max dictionary; and
  • The name of the application is not yet in the list already_added. We need to add this supplementary condition to take into account those cases where the highest number of revisions of a duplicate application is the same for more than one entry (for example, the Box application has three entries and the number of revisions is the same) . If we just search for reviews_max [name] == n_reviews, we will still end up with duplicate entries for some apps.
In [12]:
android_clean=[]
alredy_added=[]
for row2 in google_data:
    name2=row2[0]
    n_reviews2=float(row2[3])
    if n_reviews2 == reviews_max[name2] and (name2 not in alredy_added):
        android_clean.append(row2)
        alredy_added.append(name2)
        
#print(android_clean)
#print(len(android_clean))       

Removing Non-English Apps

As mentioned above, only applications in English should be analyzed. Therefore, applications that do not meet this requirement are now removed. For this, a function is made that detects the characters of the string. The letters used in English range from 0 to 127 of the ASCII code. Therefore, if they are greater than this range they are not in English and return false. However, it should be taken into account that some application names have emojis and characters that are outside the aforementioned range but are still applications in English. For this reason there is a condition that if it has less than 3 characters out of the range, they will be considered Applications in English.

In [13]:
def prueba(cad):
    cuenta=0;
    for caracteristica in cad:
        if ord(caracteristica)>127:
            cuenta += 1
    if cuenta>3:
        return False
    else:
        return True
        
#prueba('Instagram')
#prueba('爱奇艺PPS -《欢乐颂2》电视剧热播')
#prueba('Docs To Go™ Free Office Suite')
#prueba('Instachat 😜')
prueba('Docs To Go™ Free😜')
Out[13]:
True

Now using the above function, only the applications that are in English for both datasets will be filtered and saved in a separate list.

In [14]:
android_ingles=[]
apple_ingles=[]

for row in android_clean:
    name=row[0]
    if prueba(name):
        android_ingles.append(row)

for row in apple_data:
    name=row[1]
    if prueba(name):
        apple_ingles.append(row)
explore_data(android_ingles, 0, 3, True)
print('\n')
explore_data(apple_ingles, 0, 3, True)
#print(android_ingles[0])
    
['Photo Editor & Candy Camera & Grid & ScrapBook', 'ART_AND_DESIGN', '4.1', '159', '19M', '10,000+', 'Free', '0', 'Everyone', 'Art & Design', 'January 7, 2018', '1.0.0', '4.0.3 and up']


['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

Isolating the Free Apps

Now from the previously created lists, the applications that are free are filtered, since as mentioned above, only the applications that are free and in English will be analyzed.

In [15]:
android_ing_free=[]
apple_ing_free=[]
for row in android_ingles:
    precio=row[7] #column 7 is the price
    if precio=='0':
        android_ing_free.append(row)

for row in apple_ingles:
    precio=float(row[4])  #column 4 is the price
    if precio ==0.0:
        apple_ing_free.append(row)
        
explore_data(android_ing_free, 0, 3, True)
explore_data(apple_ing_free, 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: 8864
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: 3222
Number of columns: 16

Most Common Apps by Genre

Our objective is to determine which types of applications attract more users since the more people use the application, the higher the profitability. As we mentioned in the introduction, our goal is to determine the types of applications that are likely to attract more users because our income is highly influenced by the number of people who use our applications.

To minimize risk and overhead, our validation strategy for an application idea consists of three steps:

Create a minimal Android version of the app and add it to Google Play. If the application has a good response from users, we will develop it further. If the app is profitable after six months, we also create an iOS version of the app and add it to the App Store. Because our ultimate goal is to add the app to both the App Store and Google Play, we need to find app profiles that are successful in both markets. For example, a profile that could work well for both markets could be a productivity app that uses gamification.

Let's start the analysis by getting an idea of the most common genres for each market. For this, we will create a frequency table for the prime_genre column of the App Store dataset and the Genres and Category columns of the Google Play dataset. A function is created that returns a dictionary with the category and its frequency percentage

In [16]:
#apple prime_genre:11
# google ----- genres: 9   ------- Category: 1

def freq_table(dataset,index):
    freq={}
    freq_prop={}
    freq_percentage={}
    suma=0
    for row in dataset:
        med=row[index]
        if med in freq:
            freq[med]+=1
        else:
            freq[med]=1
    for raw in freq:       #add the quantity of elements
        suma+=(freq[raw]) 
    for raw in freq:
        prop=freq[raw]/suma
        perce=prop*100
        freq_percentage[raw]=perce
    return freq_percentage
            
freq_table(apple_ing_free,11)
Out[16]:
{'Social Networking': 3.2898820608317814,
 'Photo & Video': 4.9658597144630665,
 'Games': 58.16263190564867,
 'Music': 2.0484171322160147,
 'Reference': 0.5586592178770949,
 'Health & Fitness': 2.0173805090006205,
 'Weather': 0.8690254500310366,
 'Utilities': 2.5139664804469275,
 'Travel': 1.2414649286157666,
 'Shopping': 2.60707635009311,
 'News': 1.3345747982619491,
 'Navigation': 0.186219739292365,
 'Lifestyle': 1.5828677839851024,
 'Entertainment': 7.883302296710118,
 'Food & Drink': 0.8069522036002483,
 'Sports': 2.1415270018621975,
 'Book': 0.4345127250155183,
 'Finance': 1.1173184357541899,
 'Education': 3.662321539416512,
 'Productivity': 1.7380509000620732,
 'Business': 0.5276225946617008,
 'Catalogs': 0.12414649286157665,
 'Medical': 0.186219739292365}

Sort from highest to lowest

Now that each category has its respective percentage, it needs to be ordered from highest to lowest. To do this, we use the command sorted. However sorted does not order dictionaries well but lists tuples. To guarantee that they are going to be ordered correctly, you must first put the value and then the key. Store it in a list. Then this list is executed the command sorted and is reordered so that first is the key and then the value.

In [17]:
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(apple_ing_free,11)
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

According to the list generated, it is observed that among the free applications in English, the majority are Games (58.16%) followed by Entertainment (7.88%). In general, in the AppleStore most applications (free and in English) are designed for entertainment (games, photos and videos, social networks, sports, music). However, the fact that entertainment applications are the most numerous does not mean that they also have the largest number of users.

In [18]:
display_table(android_ing_free,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

In Google Play according to CATEGORY the majority of applications (free and in English) are FAMILY (18.9%) followed by GAMES (9.72%). It can be seen that unlike the Apple Store most applications are designed for practical purposes (family, tools, business, lifestyle, productivity, etc.). However, when entering Google Play, we can see that the family category (which represents almost 19% of applications) mainly means games for children. Despite this, applications for practical purposes represent the highest percentage of applications compared to the Apple Store. This can be confirmed with the list according to Gender of Google Play

In [19]:
display_table(android_ing_free,9) #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

In the Google Play according to GENDER the majority of applications (free and in English) are TOOLS (8.4%) followed by ENTERTAINMENT (6%). It can be seen that, considering the first ten genres, most applications are designed for practical purposes (family, tools, business, lifestyle, productivity, etc.).

The difference between the Genres and Category columns is not clear, but one thing we can notice is that the Genres column has more categories. Therefore, for now we will work with CATEGORIES

So far, we have discovered that most apps in the App Store are designed for fun, while Google Play is more balanced with practical and fun apps. Next, we will try to know the type of applications that most users have.

Calculating the average number of installations for each genre of application can help us know which genres have the greatest number of users. The Google Play dataset gives you that information in the facilities column, but the App Store dataset does not provide you with that data. In this case, the total user ratings found in the rating_count_tot column will have to be used.

Below, we calculate the average number of user ratings by app genre at App Store:

In [20]:
prime_genre= freq_table(apple_ing_free,11)
for genre in prime_genre:
    total=0 #sum of user ratings
    len_genre=0 #number of applications for each gender
    for row in apple_ing_free:
        genre_app= row[11]
        if genre_app==genre:
            valor=float(row[5])
            total+=valor
            len_genre+=1
    prom_usuar=total/len_genre
    print (genre, ':', prom_usuar)
        
    
    
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

On average, music is one of the most reviewed. Within this genre Pandora - Music & Radio (1126879) and Spotify Music (878563)

In [21]:
for row in apple_ing_free:
    if row[11]=='Music':
        print(row[1] ,':', row[5])
Pandora - Music & Radio : 1126879
Spotify Music : 878563
Shazam - Discover music, artists, videos & lyrics : 402925
iHeartRadio – Free Music & Radio Stations : 293228
SoundCloud - Music & Audio : 135744
Magic Piano by Smule : 131695
Smule Sing! : 119316
TuneIn Radio - MLB NBA Audiobooks Podcasts Music : 110420
Amazon Music : 106235
SoundHound Song Search & Music Player : 82602
Sonos Controller : 48905
Bandsintown Concerts : 30845
Karaoke - Sing Karaoke, Unlimited Songs! : 28606
My Mixtapez Music : 26286
Sing Karaoke Songs Unlimited with StarMaker : 26227
Ringtones for iPhone & Ringtone Maker : 25403
Musi - Unlimited Music For YouTube : 25193
AutoRap by Smule : 18202
Spinrilla - Mixtapes For Free : 15053
Napster - Top Music & Radio : 14268
edjing Mix:DJ turntable to remix and scratch music : 13580
Free Music - MP3 Streamer & Playlist Manager Pro : 13443
Free Piano app by Yokee : 13016
Google Play Music : 10118
Certified Mixtapes - Hip Hop Albums & Mixtapes : 9975
TIDAL : 7398
YouTube Music : 7109
Nicki Minaj: The Empire : 5196
Sounds app - Music And Friends : 5126
SongFlip - Free Music Streamer : 5004
Simple Radio - Live AM & FM Radio Stations : 4787
Deezer - Listen to your Favorite Music & Playlists : 4677
Ringtones for iPhone with Ringtone Maker : 4013
Bose SoundTouch : 3687
Amazon Alexa : 3018
DatPiff : 2815
Trebel Music - Unlimited Music Downloader : 2570
Free Music Play - Mp3 Streamer & Player : 2496
Acapella from PicPlayPost : 2487
Coach Guitar - Lessons & Easy Tabs For Beginners : 2416
Musicloud - MP3 and FLAC Music Player for Cloud Platforms. : 2211
Piano - Play Keyboard Music Games with Magic Tiles : 1636
Boom: Best Equalizer & Magical Surround Sound : 1375
Music Freedom - Unlimited Free MP3 Music Streaming : 1246
AmpMe - A Portable Social Party Music Speaker : 1047
Medly - Music Maker : 933
Bose Connect : 915
Music Memos : 909
UE BOOM : 612
LiveMixtapes : 555
NOISE : 355
MP3 Music Player & Streamer for Clouds : 329
Musical Video Maker - Create Music clips lip sync : 320
Cloud Music Player - Downloader & Playlist Manager : 319
Remixlive - Remix loops with pads : 288
QQ音乐HD : 224
Blocs Wave - Make & Record Music : 158
PlayGround • Music At Your Fingertips : 150
Music and Chill : 135
The Singing Machine Mobile Karaoke App : 130
radio.de - Der Radioplayer : 64
Free Music -  Player & Streamer  for Dropbox, OneDrive & Google Drive : 46
NRJ Radio : 38
Smart Music: Streaming Videos and Radio : 17
BOSS Tuner : 13
PetitLyrics : 0

Another genre that has more reviews is references. Within this genre, Bible (985920) and Dictionary.com Dictionary & Thesaurus (200047).

In [22]:
for row in apple_ing_free:
    if row[11]=='Reference':
        print(row[1] ,':', row[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

Finally, we can see that another genre with a large number of reviews is Health & Fitness. As a recommendation I would propose an application related to this genre because many people want to exercise at home but do not know how to do it or what routines to do. Therefore, an application that serves as an exercise routine and also gives you advice on a balanced diet could be a good alternative.

In [23]:
for row in apple_ing_free:
    if row[11]=='Health & Fitness':
        print(row[1] ,':', row[5])
Calorie Counter & Diet Tracker by MyFitnessPal : 507706
Lose It! – Weight Loss Program and Calorie Counter : 373835
Weight Watchers : 136833
Sleep Cycle alarm clock : 104539
Fitbit : 90496
Period Tracker Lite : 53620
Nike+ Training Club - Workouts & Fitness Plans : 33969
Plant Nanny - Water Reminder with Cute Plants : 27421
Sworkit - Custom Workouts for Exercise & Fitness : 16819
Clue Period Tracker: Period & Ovulation Tracker : 13436
Headspace : 12819
Fooducate - Lose Weight, Eat Healthy,Get Motivated : 11875
Runtastic Running, Jogging and Walking Tracker : 10298
WebMD for iPad : 9142
8fit - Workouts, meal plans and personal trainer : 8730
Garmin Connect™ Mobile : 8341
Record by Under Armour, connects with UA HealthBox : 7754
Fitstar Personal Trainer : 7496
My Cycles Period and Ovulation Tracker : 7469
Seven - 7 Minute Workout Training Challenge : 6808
RUNNING for weight loss: workout & meal plans : 6407
Lifesum – Inspiring healthy lifestyle app : 5795
Waterlogged - Daily Hydration Tracker : 5000
J&J Official 7 Minute Workout : 4861
Fitbod Workout Log: Strength Lifting Bodybuilding : 4668
Runtastic Six Pack Abs Workout & Core Trainer : 4283
Sweat: Kayla Itsines' Bikini Body Fitness Workouts : 3788
Smart Alarm Clock : sleep cycle & snoring recorder : 3779
My Challenge Tracker : 3682
Charity Miles: Walking & Running Distance Tracker : 3115
Ab & Core Sworkit - Free Workout Trainer : 2901
Simple Habit : 2494
Asana Rebel - Yoga Inspired Fitness : 2459
Life Cycle - Track Your Time Automatically : 1760
Freeletics Bodyweight - Workouts and Training : 1722
Runtastic Results: Workout & Bodyweight Training : 1718
My Water Balance: Daily Drink Tracker & Reminder : 1601
Butt Sworkit - Free Workout Trainer to tone & lift : 960
My Score Plus Weight Loss, Food & Exercise Tracker : 467
Sleep Meister - Sleep Cycle Alarm Lite : 445
Walk for a Dog : 412
Quick Fit - 7 Minute Workout, Abs, and Yoga : 407
Fit Girls Guide : 397
Walking for Weight Loss: training plans, GPS, tips : 397
Zen : 298
Model My Diet - Women - Weight Loss Motivation : 236
Runtastic Butt Workout & Booty Trainer Plans : 222
Dot - A Period & Fertility Tracker : 142
YAZIO – Calorie Counter & Nutrition Tracker : 115
SmartFit - Wristband : 105
Dr. Oz : 99
Crane Connect : 94
Morning Routine : Daily Habit Tracker : 40
Wellbeyond Meditation for Kids : 36
SenseSleep - Train Your Brain To Sleep Better : 22
Snail Sleep-Dream Talk Recording : 19
ameli, l'Assurance Maladie : 8
VIBO RealMassager : 6
FizzUp – Online Fitness Trainer : 5
2Face Fitpack - Dein Trainingsprogramm mit persönlichem Ernährungsplan, Kalorienrechner und Trainingsplan : 0
GYMONDO – Fitness Training für Zuhause : 0
Superdrug : 0
airweave sleep analysis : 0
Sonia Tlev : 0
Intuition Guidances : 0

In Google play the largest number of applications are in the category of COMMUNICATIONS, VIDEO_PLAYERS AND PHOTOGRAPHY

In [24]:
category_android=freq_table(android_ing_free,1)
for category in category_android:
    total=0  #sum of specific facilities for each gender
    len_category=0 #number of specific applications for gender
    for row in android_ing_free:
        category_app=row[1]
        if category_app == category:
            instal=row[5]
            instal=instal.replace('+','')
            instal=instal.replace(',','')
            total+=float(instal)
            len_category+=1
    prom_instal=total/len_category
    print(category, ':',prom_instal)
    
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

In the COMMUNICATIONS category, WhatsApp, Facebook Messenger, Skype, Google Chrome, Gmail and Hangouts stand out, and some others with more than 100 and 500 million installations

In [25]:
for app in android_ing_free:
    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+

On the other hand, the HEALTH AND FITNESS category also has, as in the Apple Store, a large number of installations.

In [26]:
for app in android_ing_free: 
    if app[1] == 'HEALTH_AND_FITNESS':
        print(app[0], ':', app[5])
Step Counter - Calorie Counter : 500,000+
Lose Belly Fat in 30 Days - Flat Stomach : 5,000,000+
Pedometer - Step Counter Free & Calorie Burner : 1,000,000+
Six Pack in 30 Days - Abs Workout : 10,000,000+
Lose Weight in 30 Days : 10,000,000+
Pedometer : 10,000,000+
LG Health : 10,000,000+
Step Counter - Pedometer Free & Calorie Counter : 10,000,000+
Pedometer, Step Counter & Weight Loss Tracker App : 10,000,000+
Sportractive GPS Running Cycling Distance Tracker : 1,000,000+
30 Day Fitness Challenge - Workout at Home : 10,000,000+
Home Workout for Men - Bodybuilding : 1,000,000+
Fat Burning Workout - Home Weight lose : 100,000+
Buttocks and Abdomen : 500,000+
Walking for Weight Loss - Walk Tracker : 100,000+
Running & Jogging : 500,000+
Sleep Sounds : 1,000,000+
Fitbit : 10,000,000+
Lose Belly Fat-Home Abs Fitness Workout : 50,000+
Cycling - Bike Tracker : 500,000+
Abs Training-Burn belly fat : 100,000+
Calorie Counter - EasyFit free : 1,000,000+
Aunjai i lert u : 500,000+
Garmin Connect™ : 10,000,000+
BetterMe: Weight Loss Workouts : 5,000,000+
Bike Computer - GPS Cycling Tracker : 1,000,000+
Six Packs for Man–Body Building with No Equipment : 100,000+
Running Distance Tracker + : 1,000,000+
The TK-App - everything under control : 100,000+
Runkeeper - GPS Track Run Walk : 10,000,000+
Walking: Pedometer diet : 1,000,000+
Recipes for hair and face tried : 500,000+
Abs Workout - 30 Days Fitness App for Six Pack Abs : 100,000+
8fit Workouts & Meal Planner : 10,000,000+
Keep Trainer - Workout Trainer & Fitness Coach : 1,000,000+
Couch to 10K Running Trainer : 500,000+
PumpUp — Fitness Community : 1,000,000+
Home workouts - fat burning, abs, legs, arms,chest : 1,000,000+
Running Weight Loss Walking Jogging Hiking FITAPP : 1,000,000+
Strava Training: Track Running, Cycling & Swimming : 10,000,000+
Workout Trainer: fitness coach : 10,000,000+
Fabulous: Motivate Me! Meditate, Relax, Sleep : 5,000,000+
StrongLifts 5x5 Workout Gym Log & Personal Trainer : 1,000,000+
Run with Map My Run : 5,000,000+
7 Minute Workout : 10,000,000+
Workout Tracker & Gym Trainer - Fitness Log Book : 500,000+
Freeletics: Personal Trainer & Fitness Workouts : 10,000,000+
Fitbit Coach : 1,000,000+
JEFIT Workout Tracker, Weight Lifting, Gym Log App : 5,000,000+
Map My Ride GPS Cycling Riding : 1,000,000+
Daily Workouts - Exercise Fitness Routine Trainer : 10,000,000+
Google Fit - Fitness Tracking : 10,000,000+
Weight Loss Running by Verv : 1,000,000+
Sworkit: Workouts & Fitness Plans : 5,000,000+
Map My Fitness Workout Trainer : 1,000,000+
Sports Tracker Running Cycling : 5,000,000+
Seven - 7 Minute Workout Training Challenge : 1,000,000+
Daily Yoga - Yoga Fitness Plans : 5,000,000+
Relax Meditation: Sleep with Sleep Sounds : 1,000,000+
Free Meditation - Take a Break : 100,000+
Meditate OM : 1,000,000+
Yoga - Track Yoga : 500,000+
My Chakra Meditation : 500,000+
Relax with Andrew Johnson Lite : 100,000+
Meditation Music - Relax, Yoga : 1,000,000+
Down Dog: Great Yoga Anywhere : 500,000+
21-Day Meditation Experience : 100,000+
My Chakra Meditation 2 : 100,000+
Simply Yoga - Fitness Trainer for Workouts & Poses : 1,000,000+
Relax Melodies: Sleep Sounds : 5,000,000+
Simple Habit Meditation : 500,000+
Headspace: Meditation & Mindfulness : 10,000,000+
Yoga Studio: Mind & Body : 100,000+
Pregnancy & Baby Tracker : 1,000,000+
My Cycles Period and Ovulation : 1,000,000+
I’m Expecting - Pregnancy App : 1,000,000+
The Bump Pregnancy Tracker : 1,000,000+
My Days - Ovulation Calendar & Period Tracker ™ : 5,000,000+
Best Ovulation Tracker Fertility Calendar App Glow : 1,000,000+
Eve Period Tracker - Love, Sex & Relationships App : 1,000,000+
Fertility Friend Ovulation App : 1,000,000+
Pregnancy Tracker : 500,000+
Period Tracker : 10,000,000+
Spot On Period, Birth Control, & Cycle Tracker : 500,000+
OvuView: Ovulation and Fertility : 1,000,000+
Period Tracker - Period Calendar Ovulation Tracker : 100,000,000+
Period Tracker Clue: Period and Ovulation Tracker : 10,000,000+
Calorie Counter - MyFitnessPal : 50,000,000+
WomanLog Calendar : 5,000,000+
Geocaching® : 5,000,000+
Map My Hike GPS Hiking : 500,000+
ViewRanger - Hike, Ride or Walk : 1,000,000+
Runtastic Mountain Bike GPS Tracker : 1,000,000+
AllTrails: Hiking, Running & Mountain Bike Trails : 1,000,000+
Water Drink Reminder : 10,000,000+
Zombies, Run! 5k Training (Free) : 50,000+
Tracks : 50,000+
YAZIO Calorie Counter, Nutrition Diary & Diet Plan : 5,000,000+
Technutri - calorie counter, diet and carb tracker : 5,000,000+
Couch to 5K by RunDouble : 1,000,000+
Fooducate Healthy Weight Loss & Calorie Counter : 1,000,000+
Weight Watchers Mobile : 5,000,000+
Walk with Map My Walk : 5,000,000+
My Diet Coach - Weight Loss Motivation & Tracker : 10,000,000+
Endomondo - Running & Walking : 10,000,000+
Nike+ Run Club : 10,000,000+
Lose It! - Calorie Counter : 10,000,000+
Runtastic Running App & Mile Tracker : 10,000,000+
Calorie Counter - MyNetDiary : 1,000,000+
10 Best Foods for You : 500,000+
MyPlate Calorie Tracker : 1,000,000+
My Diet Diary Calorie Counter : 1,000,000+
Calorie Counter - Macros : 100,000+
Weight Loss Tracker - RecStyle : 1,000,000+
Lark - 24/7 Health Coach : 100,000+
MealLogger-Photo Food Journal : 50,000+
Health and Nutrition Guide : 500,000+
Calorie Counter & Diet Tracker : 1,000,000+
Food Calorie Calculator : 100,000+
Monitor Your Weight : 5,000,000+
Calorie Counter by FatSecret : 10,000,000+
Eat Fit - Diet and Health Free : 100,000+
Self Healing : 500,000+
Happify : 100,000+
Binaural Beats Therapy : 1,000,000+
Pacifica - Stress & Anxiety : 500,000+
Relaxing Sounds : 100,000+
White Sound Pro : 500,000+
Insight Timer - Free Meditation App : 1,000,000+
Self-help Anxiety Management : 500,000+
Brain Waves - Binaural Beats : 500,000+
Prana Breath: Calm & Meditate : 1,000,000+
7 Cups: Anxiety & Stress Chat : 500,000+
Calm - Meditate, Sleep, Relax : 5,000,000+
White Noise Lite : 1,000,000+
Stop, Breathe & Think: Meditation & Mindfulness : 1,000,000+
Oral-B App : 1,000,000+
f.lux (preview, root-only) : 500,000+
HPlus : 100,000+
H Band 2.0 : 500,000+
H-Connect : 5,000+
H Band : 10,000+
J - Style Pro : 10,000+
K Health : 50,000+
Vi Trainer : 5,000+
30 Day Ab Challenge : 500,000+
Ultimate Ab & Core Workouts : 1,000,000+
Abs Workout - Burn Belly Fat with No Equipment : 10,000,000+
6 Pack Promise - Ultimate Abs : 1,000,000+
Abs, Core & Back Workout Challenge : 100,000+
AB Mobile App : 100,000+
Daily Ab Workout - Core & Abs Fitness Exercises : 10,000,000+
Abs workout 7 minutes : 1,000,000+
30 Day Ab Challenge FREE : 1,000,000+
ABS Workout - Belly workout, 30 days AB : 100,000+
7 minute abs workout - Daily Ab Workout : 100,000+
5 Minute Ab Workouts : 50,000+
30 Day AB Challenge - Lumowell : 10,000+
Ab Workouts : 1,000,000+
Ab Workouts - Ab Generator : 1,000+
Abs workout - 21 Day Fitness Challenge : 1,000,000+
Ladies' Ab Workout FREE : 1,000,000+
30-Day Ab Challenge Tracker : 10,000+
AF Hydro : 10,000+
AF Nutrition - Integratori : 100+
AH Connect (Adventist Health) : 1,000+
be'ah : 10+
We're Working Out - Al Kavadlo : 50,000+
AQ Dentals : 10+
Sleep as Android Gear Addon : 100,000+
Sleep as Android Garmin Addon : 10,000+
Samsung Health : 500,000,000+
Runtastic Sleep Better: Sleep Cycle & Smart Alarm : 5,000,000+
Twilight: Blue light filter : 5,000,000+
MediBeat for AW - Android (1) : 500+
Q7 SmartWatch : 10,000+
AY Oakmont : 10+
Cures A-Z : 100,000+
BA Accesible : 1,000+
Fitness Dance for Zum.ba Workout Exercise : 50,000+
BD Provider App : 5,000+
BF Scale Health Fitness Tool : 1,000+
Women"s Health Tips(Breast,Face,Body,weight lose) : 1,000,000+
Revita.bg : 10+
Blood Glucose Tracker : 100,000+
BH by Kinomap : 10,000+
BH - Fitness & Nutrition : 1+
FitConsole : 50,000+
Run on Earth : 50,000+
Treadmill Workouts Free (P) : 1,000+
The Daily BJ : 500+
Hungry Girl Diet Bk. Companion : 1,000+
BL ONLINE PERSONAL TRAINING : 5+
Poop Tracker - Toilet Log : 10,000+
BM Pharmacy : 1,000+
BM Physiotherapy Clinic : 100+
My BP Lab : 10,000+
BP Tracker : 1,000+
MI-BP : 50+
Deep Breathe BP : 1,000+
BP Toolbox : 1,000+
Blood pressure : 500,000+
Bacterial Vaginosis : 100+
Bacterial Vaginosis 🇺🇸 : 500+
Bacteria Vaginosis : 1,000,000+
Bacterial vaginosis Treatment - Sexual disease : 500+
Home Remedies for Bacterial Infections : 50+
Benefit Extras Mobile App : 1,000+
Kick Axe Bx : 1+
CB Martial Arts : 10+
CB NFC Pendant : 50+
CB Fit : 10+
C B Patel Health Club : 100+
CF SPOT : 100+
CF Talenti : 100+
Thrive CF : 100+
CF Townsville : 100+
CF Etowah : 100+
Cystic Fibrosis Symptoms, Doctors & Treatments : 100+
CF Themis : 100+
CF Riga : 100+
Casa CF : 500+
CampGladiator : 50,000+
CG Fit Scale : 1,000+
Pharmacy CI - Pharmacies de garde Côte d'Ivoire : 100,000+
Pharmacie de Garde CI et Prix : 100,000+
CJ Fitness : 10,000+
The CJ Rubric : 100+
CK SKILLZ : 50+
CK Life : 100+
CK Pharmacies : 100+
CK Active : 10+
CL-Customer Care : 5+
CL Strength : 50+
The ClubHouse CR : 100+
Evolution Marketing CR : 1,000+
I AM C.T. : 1,000+
Cy's Elma Pharmacy : 10+
DG Fitness : 100+
DG Xplained : 100+
Stop Smoking - EasyQuit free : 500,000+
Dr. Muscle : 10,000+
DS Companion : 50+
Eat Right Diet (by Dt Shreya's Family Diet Clinic) : 10+
Dt. Jyothi Srinivas : 100+
DT NO.I : 1,000+
Bodyworks DW : 10+
D.W Bien Être : 10+
Cloud DX Connected Health : 100+
DY Fitness : 10+
PHARMAGUIDE (DZ) : 5,000+
DEM DZ : 100+
Eb & flow Yoga Studio : 10+
EF Coach : 500+
EF Academy : 50+
Period Tracker, Pregnancy Calculator & Calendar 🌸 : 10,000+
EO App. SelfCompassion to you : 100+
Nike Training Club - Workouts & Fitness Plans : 10,000,000+
Ideal Weight, BMI Calculator : 5,000,000+
Fitness & Bodybuilding : 5,000,000+
CALIOPE EU: Air Quality : 1,000+
Home Workout - No Equipment : 10,000,000+
EW MOTION THERAPY : 10+
SCI-Ex : 1,000+
X your Ex - Break Up Treatment : 5,000+
Dream EZ : 10,000+
FD Fitness : 50+
L!FE Premium Training : 100+
Santa Fe Thrive : 50+
Burn Your Fat With Me! FG : 1,000,000+
FH Calculator : 500+
Restaurant Inspections - FL : 10,000+
Florida Blue : 100,000+
In [27]:
for app in android_ing_free:
    if app[1] == 'HEALTH_AND_FITNESS' and (app[5] == '1,000,000,000+'
                                            or app[5] == '500,000,000+'
                                            or app[5] == '100,000,000+'
                                            or app[5] == '10,000,000+'):
        print(app[0], ':', app[5])
Six Pack in 30 Days - Abs Workout : 10,000,000+
Lose Weight in 30 Days : 10,000,000+
Pedometer : 10,000,000+
LG Health : 10,000,000+
Step Counter - Pedometer Free & Calorie Counter : 10,000,000+
Pedometer, Step Counter & Weight Loss Tracker App : 10,000,000+
30 Day Fitness Challenge - Workout at Home : 10,000,000+
Fitbit : 10,000,000+
Garmin Connect™ : 10,000,000+
Runkeeper - GPS Track Run Walk : 10,000,000+
8fit Workouts & Meal Planner : 10,000,000+
Strava Training: Track Running, Cycling & Swimming : 10,000,000+
Workout Trainer: fitness coach : 10,000,000+
7 Minute Workout : 10,000,000+
Freeletics: Personal Trainer & Fitness Workouts : 10,000,000+
Daily Workouts - Exercise Fitness Routine Trainer : 10,000,000+
Google Fit - Fitness Tracking : 10,000,000+
Headspace: Meditation & Mindfulness : 10,000,000+
Period Tracker : 10,000,000+
Period Tracker - Period Calendar Ovulation Tracker : 100,000,000+
Period Tracker Clue: Period and Ovulation Tracker : 10,000,000+
Water Drink Reminder : 10,000,000+
My Diet Coach - Weight Loss Motivation & Tracker : 10,000,000+
Endomondo - Running & Walking : 10,000,000+
Nike+ Run Club : 10,000,000+
Lose It! - Calorie Counter : 10,000,000+
Runtastic Running App & Mile Tracker : 10,000,000+
Calorie Counter by FatSecret : 10,000,000+
Abs Workout - Burn Belly Fat with No Equipment : 10,000,000+
Daily Ab Workout - Core & Abs Fitness Exercises : 10,000,000+
Samsung Health : 500,000,000+
Nike Training Club - Workouts & Fitness Plans : 10,000,000+
Home Workout - No Equipment : 10,000,000+

Conclusion

As a recommendation we will propose the category HEALTH_AND_FITNESS. Despite not being one of the largest number of facilities or being the one with the most reviews, it can be a good option since it is not as exploited as the entertainment category. In addition, health and sport are very important for human beings, but due to the situation the world is going through, it is necessary to have as little contact with another person as possible and avoid crowds. Therefore, one way to be healthy is to exercise at home through an application that gives you an exercise routine, that gives you advice on a balanced diet, information on how many calories you burn per exercise and that is something more personalized.