Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Sentiment Analysis using Excel-Spreadsheet

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

Find more posts tagged with

AI Studio

Excel

Sentiment Analysis

Accepted answers

All comments

MariusHelf

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