Forum Discussion
Help with Formula/ Power Query to calculate Precision and Recall metrics
Hi Team, I have the coding data generated by an automated model and then the coding data being generated by a human agent..I want to compare the same to generate the two metrics -precision and rec...
Please check in attached.
Hi @Sergei: The power query is predicting based on the occurence of the codes...But it should be considering only the number of codes intersecting...
ctextid vbillid agentcode predictcode precision recall
1171 23 H6692,J309 J309, H6692 50.0% 50.0%
I am getting the above result...Both precision and recall should be 100% here...
ctextid vbillid agentcode predictcode precision recall
1171 23 H6692,J309 J309, H6692 50.0% 50.0%
I am getting the above result...Both precision and recall should be 100% here...
That's since extra space between codes which was considered as part of the code. I trim the spaces, now