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
"[SOLVED] Difficulty in Creating Word Vector from Excel."
waynestate13
Member Posts: 3 
Contributor I
Hi All,
I am having difficulty in creating a word vector from an excel input in which I am trying to convert to documents.
How do I go about reading an excel file in Rapid Miner. I am starting with Read Excel but where do I go from there to convert the data.
I am trying to do something simliar to this tutorial:
http://www.youtube.com/watch?v=vhMzUi-FMy0
expect, I do not have separate documents but one document with comments on each row.
Thank you in advance for any feedback!!! i have been going at this for a week but unable to crate a word vector.
I am having difficulty in creating a word vector from an excel input in which I am trying to convert to documents.
How do I go about reading an excel file in Rapid Miner. I am starting with Read Excel but where do I go from there to convert the data.
I am trying to do something simliar to this tutorial:
http://www.youtube.com/watch?v=vhMzUi-FMy0
expect, I do not have separate documents but one document with comments on each row.
Thank you in advance for any feedback!!! i have been going at this for a week but unable to crate a word vector.
Tagged:
0
Answers
• Import the file as CSV (or Excel) using "Read CSV"
• Set data type to “text” (I used the import wizard to do this on the last screen I think it was)
• Then ran output through the “Data to Documents” operator to convert each text line into a document
• Then ran everything through the “Process Documents” operator as usual
Hope that helps!