Dealing with R and HANA

November 28, 2011

(This article was first published on Blag's bag of rants, and kindly contributed to R-bloggers)

First things first…what’s “R”? Simply put…is a programming language and software environment for statistical computing and graphics. More infomation can be found here R on Wikipedia

I have code in many programming languages, some of them very commercial, and some of them little known, but I got say, that from all, “R” is one of the most weird and awesome languages I have ever played with…and it has an amazing repository of custom add-ons.

If you have read the HANA Pocketbook you will realize that there’s a reference to “R” in the page 59. Now, that kind of integration between “R” and HANA haven’t been developed yet, but it doesn’t mean we can get our hands dirty doing some research and development.

What I did for this example was to simply show the information of my Analytic View on HANA and exported as an CSV file. From there, it’s easy to import it into “R” and start doing some nice things. (The idea is that we should be able to code “R” straight in the HANA environment…or at least that’s how I think it’s going to be…)

The first example that we’re going to build on “R” is a simple Pie graphic, using the information from the FORCURAM and CARRNAME fields.

In this example, we’re basically reading the CSV file, including the header. And doing an aggregation of the two fields we want to interact with. After that, it’s just a matter of pass the values, the names and call the pie.

Next example is a little bit more complex…and uses a custom package call Word Clouds

Here, we have to load the required libraries, read the CSV file, do the aggregation, create a matrix with the aggregation values, sort the matrix, create a new vector, get it’s length, create an array containing the names and finally assign the values and call the wordcloud graphic method…

Hope you like it…and stay tuned for more “R”…



To leave a comment for the author, please follow the link and comment on their blog: Blag's bag of rants. offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...

If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.


Mango solutions

RStudio homepage

Zero Inflated Models and Generalized Linear Mixed Models with R

Dommino data lab

Quantide: statistical consulting and training



CRC R books series

Six Sigma Online Training

Contact us if you wish to help support R-bloggers, and place your banner here.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)