Working on Recommendation System case study - Predicting Book rating, issue with the prediction value

I am using the Book recommendation case study to predict the book ratings, the variable rating scale is 1-5, but when the Spark Collaborative filtering Learner node is used to learn the data and Spark Prediction(MLlib) node is used for prediction, the predicted variable value is ranging between -2.5 to 7.7.
Not able to understand why the predicted value is ranging between -2.5 to 7.7 and not between 1 to 5.
Tried normalizing the predicted variable, but still the range remais same.

Sharing the workflow for your reference, i need clarity on the predicted value.

Please do the needfull quickly
Workflow - Book Recommendation1.knwf.knwf (46.6 KB)


@SK_GL you example does not contain any data. Maybe you can add those:

Share KNIME Workflows with data

1 Like

Sharing the workflow with data stored inside. Please have a look and assist.
Workflow - Book Recommendation1.knwf (47.1 KB)

1 Like

@SK_GL there still is no data attached. In the meantime you could check this example about how such a recommendation system might work:

I think you will have to check how you set up the logic of the recommendation. Maybe you set aside a portion of unknown recommendations by user. Question is if the setup would do this in the current form.


@mlauber71, thanks for sharing the references, but it dint help.
The file size exceeds 4mb, hence unable to upload the workflow. Any other way to upload the work flow or dataset? Tried to upload the datset,but even that file size exceeds 4mb.

please assist.


1 Like

You can create a sample file using

and post it on forum. Say, sample 5% of the original file.

1 Like