I got this error when I submit my prediction.
Missing entries for IDs 0_P, 0_K, 0_Mg, 0_pH, and 3_P.
submission = pd.DataFrame(data = predictions, columns=["P", "K", "Mg", "pH"]).
submission.to_csv("submission.csv", index_label="sample_index").
Here the which fix my error.
sample_index = gt_df['sample_index']
submission_df = pd.DataFrame(adjusted_test_preds, columns=['P', 'K', 'Mg', 'pH'])
submission_df['sample_index'] = sample_index
submission_tall = submission_df.melt(id_vars='sample_index',
value_vars=['P', 'K', 'Mg', 'pH'],
var_name='Parameter',
value_name='Target')
submission_tall['sample_index'] = submission_tall['sample_index'].astype(str)
submission_tall['sample_index'] = submission_tall['sample_index'] + '_' + submission_tall['Parameter']
submission_tall = submission_tall[['sample_index', 'Target']]
submission_tall.to_csv('submission_Tall.csv', index=False)
Here the which fix my error.
sample_index = gt_df['sample_index']
submission_df = pd.DataFrame(adjusted_test_preds, columns=['P', 'K', 'Mg', 'pH'])
submission_df['sample_index'] = sample_index
submission_tall = submission_df.melt(id_vars='sample_index',
value_vars=['P', 'K', 'Mg', 'pH'],
var_name='Parameter',
value_name='Target')
submission_tall['sample_index'] = submission_tall['sample_index'].astype(str)
submission_tall['sample_index'] = submission_tall['sample_index'] + '_' + submission_tall['Parameter']
submission_tall = submission_tall[['sample_index', 'Target']]
submission_tall.to_csv('submission_Tall.csv', index=False)