Posts Tagged ‘ RODBC ’

Using R to connect to a SQL Server and MySQL Database using MS Windows

September 8, 2012
By

Connecting to MySQL and Microsoft SQL Server Connecting to a MySQL database or MS SQL Server from the R environment can be extremely useful.  It allows a researcher direct access to the data without have to first export it from a database and then import it from a csv file or entering it directly into

Read more »

Slides: “Accessing Databases from R” #rstats

May 7, 2011
By
Slides: “Accessing Databases from R” #rstats

For the past few meetings of the Greater Boston useR Group, we have been opened with an introductory “useR Vignette” talk on a topic which may be helpful for new R users. This week, I presented an overview of accessing databases from R. Several people have tweeted and blogged nice things about my talk and

Read more »

Hierarchical Visualizations in R and the Javascript InfoVis Toolkit

July 12, 2010
By
Hierarchical Visualizations in R and the Javascript InfoVis Toolkit

I love R.  It is really a great language and platform for statistical work and graphing.  But every technology has its limits - and other tools can be meet different needs.  So in this post, I will start with R and move on to the JavaScr...

Read more »

R and Oracle HR Part II – Plotting a single variable

July 9, 2010
By
R and Oracle HR Part II – Plotting a single variable

If you have not done so already, make sure you have R and Oracle setup as described in the previous article.  If so, you should be able to create a connection from R and list the tables that are available in the HR schema.library('RODBC')ch <-o...

Read more »

R and Oracle HR Part I – Set Up and Connect

July 8, 2010
By
R and Oracle HR Part I – Set Up and Connect

There has been recent interest in the attention that Oracle has been giving to R.  This has been related to the use of Oracle Data Mining which is a paid option to Oracle.  This is the first in a series of posts that can be run using the Orac...

Read more »

Export Data Frames To Multi-worksheet Excel File

October 6, 2009
By
Export Data Frames To Multi-worksheet Excel File

A few weeks ago I needed to export a number of data frames to separate worksheets in an Excel file. Although one could output csv-files from R and then import them manually or with the help of VBA into Excel, I was after a more streamlined solution, as I would need to repeat this process

Read more »

How to Import MS Excel Data into R

September 26, 2009
By
How to Import MS Excel Data into R

s Sir Francis Bacon said, “Histories make men wise; poets witty; the mathematics subtile; natural philosophy deep; moral grave; logic and rhetoric able to contend.” And Windows stupid. He should have added the last sentence if he were a Windows user in this age. 1. Avoid Using M$ Excel A lot of R users often ask this question:

Read more »