The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

how to compare similairity of one column data from different excel files

LeiLei Member Posts: 12 Learner I
I have three excel files. They all have a column named "word" with 300 rows.

for example:
file A (word column)               file B (word column)                  file C (word column)
book                                      pen                                          desk
plate                                      book                                        dictionary
studio                                    studio                                       book

I want to compare similarity of these three columns. Which operator is suitable, data to similarity operator, and how to realize it?

Is anyone who can give me ideas or rapidminer code?
Thank you.
Tagged:
Sign In or Register to comment.