ID mismatch between two excels

[alirezadizaji]

P42_R_DM_MLO has an asymmetry (according to Radiology_manual_annotations.xlsx), However there is no recorded information about its location at Radiology_hand_drawn_segmentations_V2.csv.

[alirezadizaji]

there is a full list of them:
WARNING: Annotation was found for a normal sample, check P10_L_DM_CC
WARNING: Annotation was found for a normal sample, check P10_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P29_L_DM_CC
WARNING: Annotation was found for a normal sample, check P31_L_DM_CC
WARNING: Annotation was found for a normal sample, check P31_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P38_R_DM_CC
WARNING: Annotation was found for a normal sample, check P38_R_DM_MLO
WARNING: There must be at least one annotation but nothing was found for P42_R_DM_MLO
WARNING: There must be at least one annotation but nothing was found for P50_L_DM_CC
WARNING: There must be at least one annotation but nothing was found for P69_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P71_L_DM_MLO
WARNING: There must be at least one annotation but nothing was found for P94_L_DM_CC
WARNING: There must be at least one annotation but nothing was found for P114_R_DM_CC
WARNING: There must be at least one annotation but nothing was found for P114_R_DM_MLO
WARNING: Annotation was found for a normal sample, check P137_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P138_L_DM_CC
WARNING: Annotation was found for a normal sample, check P138_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P140_L_DM_CC
WARNING: Annotation was found for a normal sample, check P140_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P143_L_DM_CC
WARNING: There must be at least one annotation but nothing was found for P147_R_DM_CC
WARNING: There must be at least one annotation but nothing was found for P147_R_DM_MLO
WARNING: only one annotation was found for P161_L_DM_CC, while there are more than one lesions
WARNING: only one annotation was found for P161_L_DM_MLO, while there are more than one lesions
WARNING: Annotation was found for a normal sample, check P167_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P170_R_DM_CC
WARNING: Annotation was found for a normal sample, check P170_R_DM_MLO
WARNING: Annotation was found for a normal sample, check P170_L_DM_CC
WARNING: Annotation was found for a normal sample, check P170_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P179_L_DM_CC
WARNING: Annotation was found for a normal sample, check P179_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P180_L_DM_CC
WARNING: Annotation was found for a normal sample, check P180_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P189_R_DM_MLO
WARNING: Annotation was found for a normal sample, check P196_L_DM_CC
WARNING: Annotation was found for a normal sample, check P196_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P201_R_DM_MLO
WARNING: Annotation was found for a normal sample, check P209_R_DM_CC
WARNING: Annotation was found for a normal sample, check P209_R_DM_MLO
WARNING: Annotation was found for a normal sample, check P214_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P221_L_DM_CC
WARNING: There must be at least one annotation but nothing was found for P222_L_DM_CC
WARNING: Annotation was found for a normal sample, check P224_L_DM_CC
WARNING: Annotation was found for a normal sample, check P238_L_DM_CC
WARNING: Annotation was found for a normal sample, check P238_L_DM_MLO
WARNING: There must be at least one annotation but nothing was found for P272_R_DM_CC
WARNING: There must be at least one annotation but nothing was found for P272_R_DM_MLO
WARNING: Annotation was found for a normal sample, check P278_R_DM_CC
WARNING: Annotation was found for a normal sample, check P278_R_DM_MLO
WARNING: There must be at least one annotation but nothing was found for P282_L_DM_CC
WARNING: There must be at least one annotation but nothing was found for P282_L_DM_MLO
WARNING: Annotation was found for a normal sample, check P305_L_DM_CC
WARNING: Annotation was found for a normal sample, check P317_R_DM_CC
WARNING: Annotation was found for a normal sample, check P317_R_DM_MLO