TweetSentiments now in the cRest Excel library

Interpreting sentiment from phrases.

I came across http://tweetsentiments.com/ the other day, which is a service that tries to analyze the sentiment expressed in a phrase. The are using a technique called Support Vector machines.  You can read about this implementation here http://www.csie.ntu.edu.tw/~cjlin/libsvm/
Note: Tweetsentiments.com has withdrawn free access to it’s API. This example has been removed from the example workbook for now – August 2012
I wondered if this could be applied to phrases outside the world of twitter – say to data collected in a spreadsheet from some other medium.
In a previous entry, I described how to add new entries to the rest-Excel libraryHere’s another new library entry for tweetsentiments using their API. You can use this to get the data straight into Excel. 
The input data is just a column of phrases that need their sentiment analyzed, and the output is positive, negative or neutral. Here are some random phrases I tried and got the results shown below.
The full code along with the other rest library examples can be downloaded in the cDataSet workbook, which is  one of the projects on the ramblings website .
I’ll be adding more to this library from time to time as I come across useful APIS. If you would like to see one implemented, tell me about it at the ramblings forum.
Here are the library entries added so far.

        “google patents”        “twitter”        “google books by isbn”        “yahoo geocode”        “imdb by title”        “itunes movie”        “google finance”        “whatthetrend”        “tweetsentiments”

 
 
About brucemcp 225 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.