This report is automatically generated with the R
package knitr
(version 1.5
)
.
# Chapter 12 Getting Data into and out of R NOTE : Most of the code depends on actions, # directories and the presence of files. Code that isn't runnable is commented out. # Getting Data into R Entering data in the R text editor elements <- data.frame() # elements <- edit(elements) print(elements) Using the Clipboard to copy and paste Reminder # : This only works on Windows # x <- readClipboard() x # x <- readClipboard() x x <- # read.table(file = 'clipboard', sep = '\t', header=TRUE) x Reading data in CSV files # Using read.csv() to import data elements <- read.csv(file.path('f:', 'elements.csv')) # str(elements) elements <- read.csv(file.path('f:', 'elements.csv'), # stringsAsFactors=FALSE) str(elements) Using read.table() to import tabular data in text # files Reading data from Excel install.packages('XLConnect') library('XLConnect') # excel.file <- file.path('~/Elements.xlsx') elements <- readWorksheetFromFile(excel.file, # sheet=1) elements <- readWorksheetFromFile(excel.file, sheet='Sheet1') Working with other # data types library(foreign) read.spss(file='location/of/myfile') Getting Your Data out of # R writeClipboard(names(iris)) write.table(head(iris), file='clipboard', sep='\t', # row.names=FALSE) Working with Files and Folders Understanding the working directory getwd()
## [1] "C:/Users/Andrie/Documents/GitHub/rfordummies/rfordummies/inst/scripts/3-html"
# setwd('F:/git/roxygen2') getwd() setwd('F:\\git\\stringr') getwd() file.path("f:", "git", "surveyor")
## [1] "f:/git/surveyor"
# setwd(file.path('F:', 'git', 'roxygen2')) getwd() file.path("F:", "git", "roxygen2", "roxygen2", "README.md")
## [1] "F:/git/roxygen2/roxygen2/README.md"
## Manipulating files list.files(file.path('F:', 'git', 'roxygen2')) my.file <- tempfile() my.file
## [1] "C:\\Users\\Andrie\\AppData\\Local\\Temp\\RtmpKC3x2f\\file36d06b3321f2"
write.csv(iris, file = my.file) list.files(tempdir())
## [1] "file36d0111f22c3" ## [2] "file36d0118f7c19" ## [3] "file36d01260574f" ## [4] "file36d012891846.html" ## [5] "file36d0130e2e0f" ## [6] "file36d0185a6657" ## [7] "file36d018e8340f" ## [8] "file36d01bc0161c" ## [9] "file36d01c3278dd" ## [10] "file36d020c11cc" ## [11] "file36d022b556e6" ## [12] "file36d022d027ba" ## [13] "file36d02305811" ## [14] "file36d0243c6f1d" ## [15] "file36d0259661ad" ## [16] "file36d027d65af9" ## [17] "file36d02a424f49" ## [18] "file36d02a8373bc" ## [19] "file36d02d453c97" ## [20] "file36d02e1864e3" ## [21] "file36d02ed3bf8" ## [22] "file36d02f65766c" ## [23] "file36d02fc64ed6" ## [24] "file36d02fe62fe0" ## [25] "file36d030f942fb" ## [26] "file36d031296066" ## [27] "file36d032c118a" ## [28] "file36d0359b3b4f" ## [29] "file36d03743466" ## [30] "file36d038c93875" ## [31] "file36d03b182058" ## [32] "file36d03c0364a3" ## [33] "file36d03ce017f5" ## [34] "file36d03e7a2a0d" ## [35] "file36d03f8d531d" ## [36] "file36d03ffe5964" ## [37] "file36d0459d4b68" ## [38] "file36d045d469c3" ## [39] "file36d045d95084" ## [40] "file36d048087b57" ## [41] "file36d049653dcc" ## [42] "file36d04e4b45e0.html" ## [43] "file36d04fef4384" ## [44] "file36d0509b50b7" ## [45] "file36d0516d5739" ## [46] "file36d051b7cdb" ## [47] "file36d058333319" ## [48] "file36d05840101d" ## [49] "file36d05c682b5" ## [50] "file36d05d4c60c4" ## [51] "file36d05eee16fd" ## [52] "file36d0613f1290" ## [53] "file36d061ce7370" ## [54] "file36d065572ab6" ## [55] "file36d065a87150" ## [56] "file36d066d162f3" ## [57] "file36d067554d73" ## [58] "file36d06876a19" ## [59] "file36d06b3321f2" ## [60] "file36d06ead4880" ## [61] "file36d06f755e60" ## [62] "file36d070746b34" ## [63] "file36d072461660" ## [64] "file36d07aea174a" ## [65] "file36d07b6f7a50" ## [66] "file36d07ca4f68" ## [67] "file36d07d5150e1" ## [68] "file36d07e2424e" ## [69] "file36d07eb87f1a" ## [70] "file36d08eb2d" ## [71] "file36d09713819" ## [72] "file36d0b2b7f5d" ## [73] "file36d0c768a" ## [74] "file36d0c857681" ## [75] "file36d0d0f4fb1" ## [76] "file36d0d531862" ## [77] "libloc_194_393488e2.rds" ## [78] "libloc_194_69469b3c.rds" ## [79] "libloc_197_fc1ea7ea.rds" ## [80] "repos_http%3a%2f%2fcran.ma.imperial.ac.uk%2fbin%2fwindows%2fcontrib%2f3.0.rds" ## [81] "repos_http%3a%2f%2fcran.ma.imperial.ac.uk%2fsrc%2fcontrib.rds" ## [82] "repos_http%3a%2f%2fwww.bioconductor.org%2fpackages%2f2.13%2fbioc%2fbin%2fwindows%2fcontrib%2f3.0.rds" ## [83] "repos_http%3a%2f%2fwww.bioconductor.org%2fpackages%2f2.13%2fbioc%2fsrc%2fcontrib.rds" ## [84] "sorttable.js"
file.iris <- read.csv(my.file) file.remove(my.file)
## [1] TRUE
list.files(tempdir())
## [1] "file36d0111f22c3" ## [2] "file36d0118f7c19" ## [3] "file36d01260574f" ## [4] "file36d012891846.html" ## [5] "file36d0130e2e0f" ## [6] "file36d0185a6657" ## [7] "file36d018e8340f" ## [8] "file36d01bc0161c" ## [9] "file36d01c3278dd" ## [10] "file36d020c11cc" ## [11] "file36d022b556e6" ## [12] "file36d022d027ba" ## [13] "file36d02305811" ## [14] "file36d0243c6f1d" ## [15] "file36d0259661ad" ## [16] "file36d027d65af9" ## [17] "file36d02a424f49" ## [18] "file36d02a8373bc" ## [19] "file36d02d453c97" ## [20] "file36d02e1864e3" ## [21] "file36d02ed3bf8" ## [22] "file36d02f65766c" ## [23] "file36d02fc64ed6" ## [24] "file36d02fe62fe0" ## [25] "file36d030f942fb" ## [26] "file36d031296066" ## [27] "file36d032c118a" ## [28] "file36d0359b3b4f" ## [29] "file36d03743466" ## [30] "file36d038c93875" ## [31] "file36d03b182058" ## [32] "file36d03c0364a3" ## [33] "file36d03ce017f5" ## [34] "file36d03e7a2a0d" ## [35] "file36d03f8d531d" ## [36] "file36d03ffe5964" ## [37] "file36d0459d4b68" ## [38] "file36d045d469c3" ## [39] "file36d045d95084" ## [40] "file36d048087b57" ## [41] "file36d049653dcc" ## [42] "file36d04e4b45e0.html" ## [43] "file36d04fef4384" ## [44] "file36d0509b50b7" ## [45] "file36d0516d5739" ## [46] "file36d051b7cdb" ## [47] "file36d058333319" ## [48] "file36d05840101d" ## [49] "file36d05c682b5" ## [50] "file36d05d4c60c4" ## [51] "file36d05eee16fd" ## [52] "file36d0613f1290" ## [53] "file36d061ce7370" ## [54] "file36d065572ab6" ## [55] "file36d065a87150" ## [56] "file36d066d162f3" ## [57] "file36d067554d73" ## [58] "file36d06876a19" ## [59] "file36d06ead4880" ## [60] "file36d06f755e60" ## [61] "file36d070746b34" ## [62] "file36d072461660" ## [63] "file36d07aea174a" ## [64] "file36d07b6f7a50" ## [65] "file36d07ca4f68" ## [66] "file36d07d5150e1" ## [67] "file36d07e2424e" ## [68] "file36d07eb87f1a" ## [69] "file36d08eb2d" ## [70] "file36d09713819" ## [71] "file36d0b2b7f5d" ## [72] "file36d0c768a" ## [73] "file36d0c857681" ## [74] "file36d0d0f4fb1" ## [75] "file36d0d531862" ## [76] "libloc_194_393488e2.rds" ## [77] "libloc_194_69469b3c.rds" ## [78] "libloc_197_fc1ea7ea.rds" ## [79] "repos_http%3a%2f%2fcran.ma.imperial.ac.uk%2fbin%2fwindows%2fcontrib%2f3.0.rds" ## [80] "repos_http%3a%2f%2fcran.ma.imperial.ac.uk%2fsrc%2fcontrib.rds" ## [81] "repos_http%3a%2f%2fwww.bioconductor.org%2fpackages%2f2.13%2fbioc%2fbin%2fwindows%2fcontrib%2f3.0.rds" ## [82] "repos_http%3a%2f%2fwww.bioconductor.org%2fpackages%2f2.13%2fbioc%2fsrc%2fcontrib.rds" ## [83] "sorttable.js"
The R session information (including the OS info, R version and all packages used):
sessionInfo()
## R version 3.0.2 (2013-09-25) ## Platform: x86_64-w64-mingw32/x64 (64-bit) ## ## locale: ## [1] LC_COLLATE=English_United Kingdom.1252 LC_CTYPE=English_United Kingdom.1252 ## [3] LC_MONETARY=English_United Kingdom.1252 LC_NUMERIC=C ## [5] LC_TIME=English_United Kingdom.1252 ## ## attached base packages: ## [1] stats graphics grDevices utils datasets methods base ## ## other attached packages: ## [1] BiocInstaller_1.12.1 ggplot2_0.9.3.1 reshape2_1.2.2 sos_1.3-8 ## [5] brew_1.0-6 stringr_0.6.2 knitr_1.5 plyr_1.8 ## [9] Revobase_7.1.0 RevoMods_7.1.0 RevoScaleR_7.1.0 lattice_0.20-27 ## [13] rpart_4.1-2 ## ## loaded via a namespace (and not attached): ## [1] codetools_0.2-8 colorspace_1.2-4 dichromat_2.0-0 digest_0.6.4 ## [5] evaluate_0.5.1 foreach_1.4.1 formatR_0.10 fortunes_1.5-2 ## [9] grid_3.0.2 gtable_0.1.2 highr_0.3 iterators_1.0.6 ## [13] labeling_0.2 MASS_7.3-29 munsell_0.4.2 proto_0.3-10 ## [17] RColorBrewer_1.0-5 scales_0.2.3 tools_3.0.2
Sys.time()
## [1] "2014-05-13 15:06:05 BST"