Untitled

merged_data['average_score'] = merged_data[['normalized_score_1', 'normalized_score_2', 'normalized_score_3']].mean(axis=1, skipna=True)
merged_data['score_confirm'] = merged_data['score_confirm'].fillna(0)
merged_data['target'] = merged_data['score_confirm'] * 0.3 + merged_data['average_score']
#нормализация
min_target = merged_data['target'].min()
max_target = merged_data['target'].max()
merged_data['target'] = (merged_data['target'] - min_target) / (max_target - min_target)