+ Reply to Thread
Results 1 to 3 of 3

Help with Formula/ Power Query to calculate Precision and Recall metrics

  1. 01-05-2022, 01:11 PM #1
    chandramouliarun
    chandramouliarun is offline
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Red face 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 recall...In my input file the data is at a ctextid ,vbillid level...I need to compared the agentcode -code generated by human versus the predictcode (code generated by human)..

    The precision metric is calculated as follows: Overlap of count of codes between agentcode and predictcode/ len(predictcode) *100
    The recall metric is calculated as follows:Overlap of count of codes between agentcode and predictcode/ len(agentcode) *100

    Can you please help me here...

    Thanks,
    Arun
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-05-2022, 02:21 PM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,199

    Re: Help with Formula/ Power Query to calculate Precision and Recall metrics 

    Please Login or Register  to view this content.
    In E2

    =p_c($C2,$D2,1)

    in F2

    =p_c($C2,$D2,2)
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 01-05-2022, 02:51 PM #3
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Help with Formula/ Power Query to calculate Precision and Recall metrics

    Please try

    =ROWS(FILTERXML("<x><m>"&SUBSTITUTE(C2&","&D2,",","</m><m>")&"</m></x>","//m[preceding::*=.]"))/(LEN(C2:D2)-LEN(SUBSTITUTE(C2:D2,",",))+1)
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA or Marco of formula help to calculate metrics NEEDED!!!
    By elginamboree in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2021, 07:59 PM
  2. Alternative way of modelling data flow based on Power Query Table
    By jaryszek in forum Excel General
    Replies: 19
    Last Post: 06-30-2020, 03:16 AM
  3. [SOLVED] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  4. [SOLVED] How to add an Excel formula code into Power Query or create a new one in Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  5. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  6. Trying to calculate average with a Pivot table and/or Power query.
    By X82 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 03-29-2018, 11:29 AM
  7. Is it possible to draw this kind of chart (precision, recall, with f measure as reference)
    By jhs2zz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-05-2013, 06:54 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1