Promoting the use of R in the NHS

Blog Article

This blog originally appeared in


There are a large number of file types that are able to store data. R is usually able to import most of them but there are some caveats. Below is a summary of methods I use for data imports using the most common file types.

It is worth saying that most datasets will come from excel or csv files. It is unusual to gain direct access to the database and these are the normal export types from most data storage systems.

Import csv or text

read.table("mydata.txt",header=T,stringsAsFActors=F)   #or, and using tab as a delimiter:  read_delim("SomeText.txt", "\t",trim_ws = TRUE)  #Maybe get a csv off the internet: tbl <- read.csv("")

To prevent strings being imported as factors, add the parameter stringsAsFActors=F

Import from excel

library(XLConnect) wk = loadWorkbook("~Mydata.xlsx") dfw = readWorksheet(wk, sheet="Sheet3",header=TRUE)  #Alternative and super friendly way #For excel imports using readxl package: library(readxl) read_excel("~Mydata.xlsx")

Import from database

library(RODBC) channel <- odbcConnect("MyDatabase", believeNRows=FALSE) Get one of the tables tbl_PatientDetails<-sqlFetch(channel, "tblPtDetails")

Leave a Reply