650 search results for "SQL"

Easier Database Querying with R

July 29, 2013
By
Easier Database Querying with R

I have a strong distaste for database connection management.  All I want to do when I want to query one of our many databases at work is to simply supply the query, and package the result into an R data.frame or data.table. R has many great database connection tools, including but not limited to RPostgreSQL,

Read more »

SAP HANA and R – Keep shining

SAP HANA and R – Keep shining

Since I discovered Shiny and published my blog A Shiny example - SAP HANA, R and Shiny I always wanted to actually run a Shiny application from SAP HANA Studio, instead of having to call it from RStudio and having to use an ODBC connection.A couple of ...

Read more »

Read Excel files from R

July 21, 2013
By

Many people still save their data into Microsoft Excel files. This is an unhappy choice for many reasons but many was already written about this topic. Furthermore, unfortunately Excel become a de facto standard in many business environment and this … Continue reading →

Read more »

An excellent introduction to MapReduce and Hadoop

July 19, 2013
By
An excellent introduction to MapReduce and Hadoop

by Yanchang Zhao, RDataMining.com The lectures in week 3 of a free online course Introduction to Data Science give an excellent introduction to MapReduce and Hadoop, and demonstrate with examples how to use MapReduce to do various tasks, such as, … Continue reading →

Read more »

Oracle R Connector for Hadoop 2.2.0 released

July 19, 2013
By

Oracle R Connector for Hadoop 2.2.0 is now available for download. The Oracle R Connector for Hadoop 2.x series has introduced numerous enhancements, which are highlighted in this article and summarized as follows:  ORCH 2.0.0  ORCH 2.1.0  ORCH...

Read more »

Connect R with Myrrix – Mahout & Cloudera’s real-time, scalable recommender system

Connect R with Myrrix – Mahout & Cloudera’s real-time, scalable recommender system

(This article was first published on BNOSAC - Belgium Network of Open Source Analytical Consultants, and kindly contributed to R-bloggers) Myrrix is probably more known by java developers and users of Mahout than R users. This is because most of the times java and R developers live in a different community.  If you go to the website of Myrrix...

Read more »

Read GRASS raster directly into R?

July 15, 2013
By
Read GRASS raster directly into R?

There was always the issue which bugged me: Why do I have to go through an intermediate format on disk when I want to import a GRASS raster layer into R? At the moment, when I use readRAST6(), the raster layer is exported from GRASS into an intermediate formate (I don’t recall which format it

Read more »

analyze the surveillance epidemiology and end results (seer) with r and monetdb

July 15, 2013
By

the surveillance epidemiology and end results program is the aggregation of all cancer registry statistics in the united states.  created by congressional decree, seer has captured a nationally-representative quarter of american cancer incidence s...

Read more »

Throw some, throw some STATS on that map…(Part 1)

July 12, 2013
By
Throw some, throw some STATS on that map…(Part 1)

R is a very powerful and free (and fun) software package that allows you to do, pretty much anything you could ever want. Someone told me that there’s even code that allows you to order pizza (spoiler alert: you actually cannot order pizza using R :( ). But if you’re not hungry, the statistical capabilities

Read more »

A Rough Guide to Data Science

July 9, 2013
By
A Rough Guide to Data Science

If Big Data was last year's buzzword, Data Science may reach the same level of hype this year. There's no shortage of discussion about the high demand for data scientists, the term's usefulness as a designation, and even declarations of its "sexiness" as a career. And as with many terms that reach a critical mass on social media, data...

Read more »