Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
Update/ Thanks to Bernd I could improve the function of how to import the data, so here’s the updated script! /Update
In R, you often may have scripts or code snippets that will be reused. In such cases, you can write functions for your every-day-tasks. For instance, importing and converting data is such a task. I have written a small function importSPSS.R to do this:
importSPSS <- function(path) { require("foreign") data.spss <- read.spss(path, to.data.frame=TRUE, use.value.labels=FALSE) return(data.spss) } getValueLabels <- function(dat) { a <- lapply(dat, FUN = getValLabels) return (a) } getValLabels <- function(x){ rev(names(attr(x, "value.labels"))) }
This small function only gives little benefits regarding the saved typing effort. Referring to the code example under Migration, step 3: Importing (SPSS) variable and value labels, following things will change:
# Use "source" instead of "library" source("lib/importSPSS.R") # load data as data frame (function call) myDat <- importSPSS("NWIN-Buch/GER_Services_FU_PV_dt.sav") # copy all variable labels in separated list myDat_vars <- attr(myDat, "variable.labels") # copy all value labels as separated list (function call) myDat_labels <- getValueLabels(myDat)
The benefit especially lies in getting access to value labels. Instead of
hist(myDat[,86], main=myDat_vars[86], labels=rev(attr(myDat_labels[[86]], "names")), breaks=c(0:4), ylim=c(0,400), xlab=NULL, ylab=NULL)
we can now write
hist(myDat[,86], main=myDat_vars[86], labels=myDat_labels[[86]], breaks=c(0:4), ylim=c(0,400), xlab=NULL, ylab=NULL)
so we don’t need to call the attr-function nor remember to reverse the label order for plotting.
Tagged: R, rstats, SPSS, Statistik
R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.