Untitled

data_actual_without_userscore = data_actual.query('user_score != 0').reset_index()

data_actual_without_userscore[data_actual_without_userscore['platform'] == 'PS4'] \
    .pivot_table(index='user_score', values='total_sales') \
    .plot(style='o', grid=True)

print('Коэффициент корреляции мнения пользователей и продаж:')
print(
    data_actual_without_userscore.query('platform == "PS4"')['user_score']\
    .corr(data_actual_without_userscore.query('platform == "PS4"')['total_sales'])\
    .round(2)
)