Compare multiple columns and return the most frequent word

Options
OllieCramer
OllieCramer Registered Posts: 1 ✭✭✭✭

Hi,



I'd like to write a formula that compares multiple columns and returns the most frequent word. I am aiming to aggregate multiple machine learning models to see if it improves accuracy. As an example, based on the image below the 1st row would return "Handling" as this is the most common word in the SVC, RandForest and LogisticRegression. The 2nd row would return "Handling - Operations" - ignore TicketRootCause as this is the real answer.

I have done this in excel with the formula below but can't find the functions in DSS. Any ideas of how I could do this? Either based off converting the excel function below into DSS or another method?

=INDEX(F2:N2,MODE(MATCH(F2:N2,F2:N2,0)))



Thanks,

Ollie

Answers

Setup Info
    Tags
      Help me…