🦉 🎤   RapidMiner Wisdom 2020 - CALL FOR SPEAKERS   🦉 🎤

We are inviting all community members to submit proposals to speak at Wisdom 2020 in Boston.


Whether it's a cool RapidMiner trick or a use case implementation, we want to see what you have.
Form link is below and deadline for submissions is November 15. See you in Boston!

CLICK HERE TO GO TO ENTRY FORM

Sentiment Analysis using Excel-Spreadsheet

TextMiner123TextMiner123 Member Posts: 4 Contributor I
edited July 2 in Help
Hi Guys,

Hopefully you can give me some hints, as I dont know how to go on.
I have an Excel-Spreadsheet with Training Data containing two columns-One with the message, the other is the sentiment value (Positive or Negative).
For the training data, I used the process "Read Excel"--> " Data to Documents"--> "Process Documents"--> "Process Documents from Files"-->"W-J48".
I labeled the row "Sentiment value" on "Read Excel". But I always get the message "Input Example Set does not have a label attribute". I have no labels and directories in "Process Documents from Files". (as I have no single text files in directories). Therefore I build TextObjects on "Process Documents".
I have only a single Excel-Spreadsheet with thousands of messages including a column with the value "Positive" or "Negative" for each message. I want to apply machine learning. Any hints are welcome how to solve my problem.

Thanks and nice regards,
Brick

Answers

  • MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869   Unicorn
    Hi Brick,

    do you know the video tutorial on the Rapid-I website? http://rapid-i.com/content/view/189/212/lang,en/ They offer a great possibility to get in touch with RapidMiner and DataMining.

    For your specific problem concerning the label: Use the Set Role operator to define the column with negative/positive in it as label.

    Best Regards,
    Marius
Sign In or Register to comment.