1
#********** Begin #
row2 = [‘Instagram’, 0.0, ‘USD’, 2161558, 4.5]
print(row2)
row3 = [‘Clash of Clans’, 0.0, ‘USD’, 2130805, 4.5]
print(row3)
# End **********#
2
row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]
row_2 = [‘Instagram’, 0.0, ‘USD’, 2161558, 4.5]
row_3 = [‘Clash of Clans’, 0.0, ‘USD’, 2130805, 4.5]
#********** Begin #
ratings_1 = row_1[3]
ratings_2 = row_2[3]
ratings_3 = row_3[3]
total = ratings_1 + ratings_2 + ratings_3
average = total / 3
print(average)
# End **********#
3
row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]
row_2 = [‘Instagram’, 0.0, ‘USD’, 2161558, 4.5]
row_3 = [‘Clash of Clans’, 0.0, ‘USD’, 2130805, 4.5]
#********** Begin #
ratings_1 = row_1[-1]
ratings_2 = row_2[-1]
ratings_3 = row_3[-1]
total = ratings_1 + ratings_2 + ratings_3
average = total / 3
print(average)
# End **********#
4
row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]
row_2 = [‘Instagram’, 0.0, ‘USD’, 2161558, 4.5]
row_3 = [‘Clash of Clans’, 0.0, ‘USD’, 2130805, 4.5]
row_4 = [‘Temple Run’, 0.0, ‘USD’, 1724546, 4.5]
row_5 = [‘Pandora - Music & Radio’, 0.0, ‘USD’, 1126879, 4.0]
#********** Begin #
fb_rating_data = [row_1[0] , row_1[3] , row_1[4]]
insta_rating_data = [row_2[0] , row_2[3] , row_2[4]]
pandora_rating_data = [row_5[0] , row_5[3] , row_5[4]]
avg_rating = ((fb_rating_data[-1] + insta_rating_data[-1] + pandora_rating_data[-1]) / 3)
print(avg_rating)
# End **********#
5
row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]
row_2 = [‘Instagram’, 0.0, ‘USD’, 2161558, 4.5]
row_3 = [‘Clash of Clans’, 0.0, ‘USD’, 2130805, 4.5]
row_4 = [‘Temple Run’, 0.0, ‘USD’, 1724546, 4.5]
row_5 = [‘Pandora - Music & Radio’, 0.0, ‘USD’, 1126879, 4.0]
#********** Begin #
first_4_fb = row_1[0:4]
print(first_4_fb)
last_3_fb = row_1[-3:]
print(last_3_fb)
pandora_3_4 = row_5[-3:-1]
print(pandora_3_4)
# End **********#
6
row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]
row_2 = [‘Instagram’, 0.0, ‘USD’, 2161558, 4.5]
row_3 = [‘Clash of Clans’, 0.0, ‘USD’, 2130805, 4.5]
row_4 = [‘Temple Run’, 0.0, ‘USD’, 1724546, 4.5]
row_5 = [‘Pandora - Music & Radio’, 0.0, ‘USD’, 1126879, 4.0]
#********** Begin #
app_data_set = [row_1 , row_2 , row_3 , row_4 , row_5]
avg_rating = (app_data_set[0][-1] + app_data_set[1][-1] + app_data_set[2][-1] + app_data_set[3][-1] + app_data_set[4][-1])/5
print(avg_rating)
# End **********#
7
#********** Begin *#
opened_file = open(“AppleStore.csv”)
from csv import reader
read_file = reader(opened_file)
apps_data = list(read_file)
print(len(apps_data))
print(apps_data[:1])
print(apps_data[1:3])
# End **********#
8
row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]
row_2 = [‘Instagram’, 0.0, ‘USD’, 2161558, 4.5]
row_3 = [‘Clash of Clans’, 0.0, ‘USD’, 2130805, 4.5]
row_4 = [‘Temple Run’, 0.0, ‘USD’, 1724546, 4.5]
row_5 = [‘Pandora - Music & Radio’, 0.0, ‘USD’, 1126879, 4.0]
app_data_set = [row_1, row_2, row_3, row_4, row_5]
#********** Begin #
for each_list in app_data_set:
print(each_list[:5])
# End **********#
9
row_1 = [‘Facebook’, 0.0, ‘USD’, 2974676, 3.5]
row_2 = [‘Instagram’, 0.0, ‘USD’, 2161558, 4.5]
row_3 = [‘Clash of Clans’, 0.0, ‘USD’, 2130805, 4.5]
row_4 = [‘Temple Run’, 0.0, ‘USD’, 1724546, 4.5]
row_5 = [‘Pandora - Music & Radio’, 0.0, ‘USD’, 1126879, 4.0]
app_data_set = [row_1, row_2, row_3, row_4, row_5]
#********** Begin **********#
rating_sum = 0
for each_row in app_data_set:
rating_sum += each_row[-1]
print(rating_sum / 5)
#********** End **********#
10
opened_file = open(‘AppleStore.csv’)
from csv import reader
read_file = reader(opened_file)
apps_data = list(read_file)
#********** Begin **********#
opened_file = open(‘AppleStore.csv’)
from csv import reader
read_file = reader(opened_file)
apps_data = list(read_file)
rating_sum = 0
for rating in apps_data[1:]:
rating_sum += float(rating[7])
avg_rating = rating_sum / 7197
print(avg_rating)
#********** End **********#
11
opened_file = open(‘AppleStore.csv’)
from csv import reader
read_file = reader(opened_file)
apps_data = list(read_file)
#********** Begin **********#
all_ratings = []
for row in apps_data[1:]:
rating = float(row[7])
all_ratings.append(rating)
avg_rating = sum(all_ratings) / len(all_ratings)
print(avg_rating)
#********** End **********#