I have a data set, in excel format, with account names, reported symptoms, a determined root cause and a date in month year format for each row. I am trying to implement a mahout like system with a purpose of determining the likelihood symptoms an account can report by doing a user based similarity kind of a thing. Technically, I am just hoping to tweak the recommendation system into a deterministic system to spot out the probable symptoms an account can report on. Instead of ratings, I can get the frequency of symptoms by accounts. Is it possible to use a programming language or any other software to build such system?
Here is an example:
Account : X Symptoms : AB, AD, AB, AB
Account : Y Symptoms : AE, AE, AB, AB, EA
For the sake of this example, let's assume that all the dates are this month.
O/P: Account : X Symptom: AE
Here both of them have reported AB 2 or more times. I could fix such number as a threshold to look for probable symptoms.