Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Collaborative Filtering Item Recommendation how can I create output "item_id" with title name

hi

I use Rapidminner for Collaborative Filtering Item Recommendation with user k-nn and the result at "item_id" is number like this

Image: https://us.v-cdn.net/6030995/uploads/editor/uu/ul5ft5t83cxy.png

so how can I replace Movie Name (title) instead of item_id.

Image: https://us.v-cdn.net/6030995/uploads/editor/uv/3zj0vhr8q5i7.png

I try to use set role operator and set additional roles : attribute 'title' with 'item identification' but output is the same. the "item_id" still be number.

Thanks you for your help

Find more posts tagged with

AI Studio

Replace

k-NN

Results View

Accepted answers

All comments

RolandJones

Hi @Karn,

Is the "item_id" the same as "movieId" in your other table? If so, I would use a join on the two tables using these two columns, and then optionally you can remove/rename columns to whatever output you need.

Any problems, please let me know.

Best,
Roland

Karn

@rjones13

Hi Thank you for the solution but I'm already use join but the result still the same, I have shared my process for reference below.

Could you please give me an advice how to solve this issue?

Thanks you for your help

RolandJones

Hi @Karn,

Are you able to share the process and the data? I can definitely look to build an example, I'm just not entirely familiar with this model that you're using so it might be a little easier.

Best,
Roland

Karn

Hi @rjones13

I have share process and the data as an attachment.

Thanks you for your help

Process&Data.zip

RolandJones

Hi @Karn,

Just as an update, I haven't come up with a solution right now. I've looked more into the extension, as there doesn't seem to be an immediate way to output it's mapping of item_id to the original titles. I found a website, but for now I don't seem to be able to access the workflow. I will keep investigating, and I may also see if we can come up with an alternative workflow in core operators which gets around this limitation.

Best,
Roland

Karn

Hi @rjones13

Thank for the update and I'm very appreciate what you've done for me.

In the meantime, I will try to find the solution the same.

Offer_vt

Can you share How to set target role as user identifiation. I think we have same problem and question.