In this post we will show how to import data from other sources into the R workspace.<\/p>\n
R can import datasets from SPSS with the function Here is an example:<\/p>\n To import a dataset from Stata into R, the function To import a dataset from First use the code below in SAS (not R) to export data:<\/p>\n Now that your data is exported you can import in R by using the code below:<\/p>\n Another way to upload SAS files ( You can import data from This is the code we use to import Often I use the function To import text file into R use the function In some cases I find this code useful for importing the data:<\/p>\n Or this code:<\/p>\n To load Save the dataset:<\/p>\n Load data in R:<\/p>\n Other interesting functions are We finish this post here. Feel free to post a comment if you have any question or suggestion about this post.<\/p>\n","protected":false},"excerpt":{"rendered":" In this post we will show how to import data from other sources into the R workspace. Import data from SPSS R can import datasets from SPSS with the function read.spss() from the package foreign. Alternatively, the function spss.get() from Hmisc package can be used. While foreign is a default package in R, the Hmisc […]<\/p>\n","protected":false},"author":1,"featured_media":1268,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[80,232],"class_list":["post-1265","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-getting-data","tag-import-data","tag-rstats"],"views":68663,"_links":{"self":[{"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/posts\/1265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/comments?post=1265"}],"version-history":[{"count":0,"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/posts\/1265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/media\/1268"}],"wp:attachment":[{"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/media?parent=1265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/categories?post=1265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascienceplus.com\/wp-json\/wp\/v2\/tags?post=1265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}read.spss()<\/code> from the package foreign<\/code>. Alternatively, the function spss.get()<\/code> from Hmisc<\/code> package can be used. While foreign<\/code> is a default package in R, the Hmisc<\/code> package need to be installed.<\/p>\n\r\nlibrary(foreign)\r\ndf <- read.spss(\"dataset.sav\", use.value.label=TRUE, to.data.frame=TRUE)\r\n<\/pre>\n
df<\/code> is the name of data frame I created in R, and dataset.sav<\/code> is the file name of SPSS dataset we want to import, and use.value.label=TRUE<\/code> to convert variables with value labels in SPSS into R factors, and to.data.frame=TRUE<\/code> to make as data frame.<\/p>\nImport data from Stata<\/h2>\n
read.dta()<\/code> from foreign<\/code> package is used. More specifically look the code below:<\/p>\n\r\nlibrary(foreign)\r\ndf <- read.dta(\"dataset.dta\")\r\n<\/pre>\n
df<\/code> is the name of data frame in R, and dataset.dta<\/code> is the file name of Stata dataset we want to import.<\/p>\nImport data from SAS<\/h2>\n
SAS<\/code> into R<\/code> there are different methods, but most recommended is to export first the dataset from SAS<\/code> into CSV<\/code> and then to import in R<\/code>.<\/p>\n\r\n# run in SAS\r\nproc export data=dataset\r\noutfile=\"datast.csv\"\r\ndbms=csv;\r\nrun;\r\n<\/pre>\n
\r\ndf <- read.csv(\"dataset.csv\",header=T,as.is=T)\r\n<\/pre>\n
.XPT<\/code>) direct to R environment is by using Hmisc<\/code> package.<\/p>\n\r\nlibrary(Hmisc)\r\ndf <- sasxport.get(\"\/filename.xpt\") \r\n<\/pre>\n
Import data from CSV<\/h2>\n
csv<\/code> into R<\/code> by using read.table()<\/code> function similarly as we used with importing txt<\/code> files. Basically, this function reads a csv<\/code> file in table format and saves it as a data frame.<\/p>\ncsv<\/code> file into R<\/p>\n\r\ndf <- read.table(\"dataset.csv\", header=TRUE, sep=\",\")\r\n<\/pre>\n
read.csv()<\/code> to import csv file into R<\/p>\n\r\ndf <- read.csv(\"dataset.csv\",header=T,as.is=T)\r\n<\/pre>\n
Import data from TXT<\/h2>\n
read.table()<\/code>. This function reads a file in table format and saves it as a data frame. The code used to import text file is in example below.<\/p>\n\r\ndf <- read.table(\"dataset.txt\", as.is=TRUE, header=T)\r\n<\/pre>\n
\r\ndf <- read.table(\"dataset.txt\", header=TRUE, sep=\",\")\r\n<\/pre>\n
\r\ndf <- read.table(\"dataset.txt\", header=T, strings=F)\r\n<\/pre>\n
Load data in R<\/h2>\n
Rdata<\/code> in R<\/code> is easy and straightforward method. However, first we need to know how to save the dataframe in R. The function used for saving the dataframe is save(objectlist, file=\"myfile\")<\/code>, where objectlist<\/code> is the name of your current dataframe and myfile<\/code> is the filename of RDATA you will save on your computer. The function to upload the Rdata in R is load()<\/code>.<\/p>\n\r\nsave(df, file=\"mydata.Rdata\")<\/pre>\n
load(\"mydata.Rdata\")<\/pre>\n
ls()<\/code> which list the objects in the current workspace, rm(objectlist)<\/code> which delete objects in your workspace.<\/p>\n