Analyzing Data from the App Store - Which App Genre has the Most User Engagements?

open('AppleStore.csv')

def explore_data(dataset, start, end, rows_and_columns=False):
    dataset_slice = dataset[start:end]    
    for row in dataset_slice:
        print(row)
        print('\n') # adds a new (empty) line after each row

    if rows_and_columns:
        print('Number of rows:', len(dataset))
        print('Number of columns:', len(dataset[0]))

from csv import reader

opened_file = open('googleplaystore.csv')
read_file = reader(opened_file)
android = list(read_file)
android_header = android[0]
android = android[1:]

explore_data(android, 2, 5)

explore_data(android, 2, 5, True)

opened_file = open('AppleStore.csv')
read_file = reader(opened_file)
ios = list(read_file)
ios_header = ios[0]
ios = ios[1:]

explore_data(ios, 1, 7)

explore_data(ios, 2, 5, True)

print(ios_header)
print("\n")
print(android_header)

print(android[10472])  # incorrect row
print('\n')
print(android_header)  # header
print('\n')
print(android[0]) 

del android[10472]

print(android[10472]) 

for app in android:
    name = app[0]
    if name == 'Instagram':
        print(app)
    

duplicate_apps = []
unique_apps = []
for app in android:
    name = app[0]
    if name in unique_apps:
        duplicate_apps.append(name)
    else:
        unique_apps.append(name)
        
print(len(duplicate_apps))
print("\n")
print(len(unique_apps))
print("\n")
print(len(android))

reviews_max = {} #dictionary of {name, highest review}
for app in android:
    name = app[0]
    n_reviews = float(app[3])
    if name in reviews_max and reviews_max[name] < n_reviews:
        reviews_max[name] = n_reviews
    elif name not in reviews_max:
        reviews_max[name] = n_reviews
print(len(reviews_max))

android_clean = []
already_added = []
for app in android:
    name = app[0]
    n_reviews = float(app[3])
    if n_reviews == reviews_max[name] and name not in already_added:
        android_clean.append(app)
        already_added.append(name)
        
print(len(android_clean))

duplicate_apps = []
unique_apps = []
for app in android_clean:
    name = app[0]
    if name in unique_apps:
        duplicate_apps.append(name)
    else:
        unique_apps.append(name)
        
print(len(duplicate_apps))
print("\n")
print(len(unique_apps))

def is_English(string):
    count = 0
    for i in string:
        if ord(i) > 127:
            count += 1
        if count > 3:
            return False
    return True

is_English("Poop")

is_English("爱奇艺PPS -《欢乐颂2》电视剧热播")

is_English("Instachat 😜")

android_english = []
for app in android_clean:
    name = app[0]
    if is_English(name):
        android_english.append(app)
ios_english = []

for app in ios:
    name = app[1]
    if is_English(name):
        ios_english.append(app)

print(len(android_english))
print("\n")
print(len(ios_english))

android_free_apps = []
for app in android_english:
    name = app[0]
    price = app[7]
    if price == '0':
        android_free_apps.append(app)
        
print(len(android_free_apps))

ios_free_apps = []
for app in ios_english:
    name = app[1]
    price = app[4]
    if price == '0.0':
        ios_free_apps.append(app)
        
print(len(ios_free_apps))

def freq_table(dataset, index):
    table = {}
    total = 0
    
    for row in dataset:
        total += 1
        value = row[index]
        if value in table:
            table[value] += 1
        else:
            table[value] = 1
    
    table_percentages = {}
    for key in table:
        percentage = (table[key] / total) * 100
        table_percentages[key] = percentage 
    
    return table_percentages


def display_table(dataset, index):
    table = freq_table(dataset, index)
    table_display = []
    for key in table:
        key_val_as_tuple = (table[key], key)
        table_display.append(key_val_as_tuple)
        
    table_sorted = sorted(table_display, reverse = True)
    for entry in table_sorted:
        print(entry[1], ':', entry[0])

display_table(ios_free_apps, -5)

display_table(android_free_apps, 1)

genres_ios = freq_table(ios_free_apps, -5)

for genre in genres_ios:
    total = 0
    len_genre = 0
    for app in ios_free_apps:
        genre_app = app[-5]
        if genre_app == genre:            
            n_ratings = float(app[5])
            total += n_ratings
            len_genre += 1
    avg_n_ratings = total / len_genre
    print(genre, ':', avg_n_ratings)

categories_android = freq_table(android_free_apps, 1)

for category in categories_android:
    total = 0
    len_category = 0
    for app in android_free_apps:
        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)