RapidMiner

How do I "Write Excel" out of ExampleSet output of "Analyze Sentiment"?

SOLVED
Learner I qchung
Learner I

How do I "Write Excel" out of ExampleSet output of "Analyze Sentiment"?

Hello community experts,

Tweets were collected using "Search Twitter" and the output was sent to "Analyze Sentiment" of AYLIEN. I'm happy about the output, and I want to export it. Is there a way to export the output from "Analyze Sentiment" to an Excel file? "Write Excel" operator seems to expect "out" (from a preceding operator) for its "inp".

Thanks!

2 REPLIES
Highlighted
RM Certified Expert
RM Certified Expert
Solution

Re: How do I "Write Excel" out of ExampleSet output of "Analyze Sentiment"?

If you have the output already in an example dataset, it should work.  I just tested the Aylien "analyze sentiment" operator and it works with the "write excel" operator, although it does give a warning (probably because it isn't transferring the correct metadata about its output).  However, if you've done some additional text processing after the "analyze sentiment" operator then you many need to add the "document to data" operator to convert it back to a normal example dataset before using the "write excel" or "write csv" file.  After that it should work fine!  

 

Brian T., Lindon Ventures - www.lindonventures.com
Analytics Consulting by Certified RapidMiner Analysts
Learner I qchung
Learner I
Solution

Re: How do I "Write Excel" out of ExampleSet output of "Analyze Sentiment"?

Thank you, Brian. So, it was a false alarm! And, yes, as you said, it worked just fine despite the warning.