Convert long table to confusion matrix

ebarnhill — Mon, 07 Jun 2021 21:23:34 GMT

I am looking to create a confusion matrix out of a tabled query of the form

[query] | table unchanged true pred

Where, due to circumstances upstream from me, unchanged is the result if the prediction was correct, true is the ground truth if the prediction was wrong and pred is the prediction if the prediction is wrong. Example tabular output, assuming categories are A, B, C:

unchanged | true | pred

A |

B |

| A | B

| C | A

etc.

I would like to accumulate the counts into a confusion matrix. So let's say the classifier categories are A, B, C. The table should count the matches from "unchanged" along the diagonal and put "pred" and "true" into the appropriate off-diagonal. Example table:

pred: A B C

true:

A 12 6 1

B 6 20 2

C 2 3 30

If you are familiar with confusion matrices you will have the idea. How can I generate such a summary table?

Re: Convert long table to confusion matrix

ITWhisperer — Mon, 07 Jun 2021 21:43:03 GMT

Would something like this work for you?

topic Re: Convert long table to confusion matrix in Splunk Search

Convert long table to confusion matrix

Re: Convert long table to confusion matrix