Reading Customer Reviews for Sentiment Analysis from Excel

rameshusa

Hi, 

I am new to using rapid miner for sentiment analysis/text mining. I watched couple of videos. I used the tokenize, filter, stop words etc. 

 

I have customer id, review date, year of review (Computed from 2nd), customer location (From web scaped data) and the customer review. The field name in Excel is Customer_reviews.When I import the excel, the customer_review comes up as polynomial. 

 

I also get all the positive/negative word list as one word in rapidminer, where as when I look it up in Notepad++, it is all in a separted lines.

 

How do I use the customer_review as a text to arrive at sentiments using postive/negative word list? 

 

Could some one point me the right direction? 

 

Thanks for your time.

 

Ramesh

 

 

 

bhupendra_patil

Hello @rameshusa

 

Check out the two articles here around sentiment analysis

 

http://community.rapidminer.com/t5/Text-Analytics/tkb-p/Text

 

They will provide you some ideas on how to sentiment analysis in RapidMiner.

Also there are two extensions on Rapidminer that you can leverage 

They are available via marketplace, Rosette and Aylien.

AYLIEN

Hi There, 

 

Through our Text Analysis by AYLIEN Extension we provide both Document-level Sentiment Analysis and Aspect-based Sentiment Analysis which works really nicely on customer reviews. 

 

Document-level Sentiment gives you the overall polarity of a customer review while Aspect-based sentiment identifies certain aspects mentioned in a review and determines the sentiment towards those aspects. 

 

You can read more about it here. http://blog.aylien.com/post/148356512853/aspect-based-sentiment-analysis-is-now-available

 

 

jesus_martinez_

Hi there,

 

I'm trying to use AYLIEN extension to conduct an Aspect-based Sentiment Analysis. 

There is a parameter called "domain" in which I have to choose between the following options: "cars", "hotels", "airlines" or "restaurants". My question is whether this extension is limited to only those domains. If not, which of them can we use as default?

 

Thanks in advance.

MartinLiebig

Hi Jesus,

 

the aspect based ones are w.r.t these aspects. Simply choose the generic Extract Sentiment to get a general one.

 

~Martin