def filter_by_genre(data, genre):
    result = []
    for row in data:
        genres = row[4]
        if genre in genres:
            result.append(row)
    return result


def column_sum(data, column):
    result = 0
    for row in data:
        result += row[column]
    return result


def column_mean(data, column):
    total = column_sum(data, column)
    mean = total / len(data)
    return mean


def add_roi(data):
    for i in range(len(data)):
        budget = data[i][5]
        gross = data[i][6]
        roi = (gross - budget) / budget
        data[i].append(roi)


def add_price_per_minute(data):
    for i in range(len(data)):
        length = data[i][3]
        budget = data[i][5]
        price_per_minute = budget / length
        data[i].append(price_per_minute)


selected_genres = ["история", "мелодрама", "криминал", "биография", "триллер"]

add_roi(oscar_data)
add_price_per_minute(oscar_data)

genres_means = []
for genre in selected_genres:
    filt_data = filter_by_genre(oscar_data, genre)
    mean_score = column_mean(filt_data, 2)
    mean_length = column_mean(filt_data, 3)
    mean_roi = column_mean(filt_data, 7)
    mean_ppm = column_mean(filt_data, 8)
    genres_means.append([genre, mean_score, mean_length, mean_roi, mean_ppm])

print("Жанр      | Рейтинг | Длина  | ROI   | Бюджет за минуту")
print("-------------------------------------------------------")
for row in genres_means:
    print("{: <9} | {: >7.2f} | {: >5.2f} | {: >5.2f} | {: >16.2f}".format(
        row[0], row[1], row[2], row[3], row[4]))