Untitled

df['Correct'] = df['Labels'] == df['Predictions']

accuracy_by_checker_and_label = df.groupby(['CheckerName', 'Labels'])['Correct'].mean().unstack(fill_value=None)
accuracy_by_checker_and_label.columns = ['Accuracy_Label_0', 'Accuracy_Label_1']
print(accuracy_by_checker_and_label)


accuracy_by_checker = df.groupby('CheckerName')['Correct'].mean()
accuracy_by_checker.name = 'Overall_Accuracy'
print(accuracy_by_checker)

result = pd.concat([accuracy_by_checker_and_label, accuracy_by_checker], axis=1).reset_index()

print(result)

result.to_csv('accuracy_result.csv', index=False)