Syntelli blog - tutorial - PASSING DATA FROM TERR INTO R INIn a previous post, our interns demonstrated how to perform a simple sentiment analysis on Tweets during the World Cup Match. Recently, we had an interesting request from a client to analyze Tweets in a similar manner. The difference here will be to analyze Tweets which are specifically determined by Spotfire end users.

Simply put, the request was to query Twitter in Spotfire followed by and scoring the returned Tweets. We decided to welcome this challenge by treating it as another formidable task that could not be ignored. In other words, we couldn’t turn down a chance to just go for it.

An additional challenge for this particular request was that it needed to be contained within the standard Spotfire tools as opposed to the Spotfire Statistics Service. To accomplish this, we had to perform the API call either in TIBCO Enterprise Runtime for R (TERR), IronPython, or C#. We decided to go with TERR.

The basis for making the solution work in TERR was twofold:
• R has a robust community development of Twitter analytics tools.
• Our existing code base for Twitter sentiment analysis was already in R.

As you may recall from my previous post, TERR does not play nice with Curl. This meant we had to use REvaluate() to access Twitter. However, using REvaluate() presented another challenge in and of itself. That is, we knew how to get data out of REvaluate() and into Spotfire, but we did not know how to get data into REvaluate().

Due to a non-disclosure agreement, I cannot provide code specifics. But what I can do is share a brief tutorial of how to get data from Spotfire into TERR, then into R, and finally, how to get the data right back out.

[button size=”small” color=”red” href=”http://go.syntelli.com/passing-data-from-terr-into-r-in-spotfire” ]Access TERR Tutorial[/button]

As always, feel free to reach out with any questions that you may have!

Take your TERR knowledge to the next level with our latest Ebook!

[button size=”small” color=”red” href=”http://go.syntelli.com/download-syntelli-terr-ebook” ]Download TERR Ebook[/button]


Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

Tip of the Week

How To Create Bump Charts In Power BI

Bump charts are a visually appealing way to view a rank over time. Although not native to Power BI, bump charts can be created using the RANKX function in DAX in a line chart and Read more…

Tip of the Week

Up And Running With Row-Level Security In Power BI

It has quickly become the norm for companies to maximize their data potential by using data in their everyday business processes. And as your data grows and users increase, the need for limiting data to Read more…


Analytics For The ‘MAaaSes’: Solutions For A Competitive Edge

Managed Analytics as a Service (MAaaS) gives you valuable insights fast at a predictable price. In the era of ‘Big Data’, companies are eager to use data analysis technologies and procedures to gain valuable business Read more…



Register | Lost your password?