efg's R Notes: Input/Output

Placeholder page for now - work in progress

Input/Output (Examples for KC Users Group, Jan 18/Feb 8)

Working with directories: choose.dir(); getwd(); setwd(), dir.create(path)

Working with files: choose.files(), file.choose(), dir() or list.files(), fileinfo(), file.exists(), glob2rx(); unlink(), basename(path), dirname(path)

Reading / writing data

writeLines() / readLines() Examples
read.csv() / write.csv() Examples
read.delim() / read.table() / write.table()
save() / load()
Reading Excel files: readWorksheetFromFile in XLConnect package and read.xlsx in xlsx package use Java, read.xls in gdata package uses PERL, sqlFetch or sqlQuery in RODBC uses ODBC ... and there are other packages, too.
Reading Databases: RODBC, RMySQL (Linux), ..., other packages
Write arbitrary text file: connection <- file(filename, "w"); cat(..., file=connection); ...; close(connection)

Future topics

Connections, including reading from text connection
download.file(); RCurl package
Reading JSON files: RJSON, RJSONIO packages
Working with binary data: readBin / writeBin
scan()
dput() / dget()
clipboard: file("clipboard")
unzip()
read.socrata() from RSocrata packge to read files from data.kcmo.org and other Socrata sites
Reading data from other statistical packages: foreign package
Troubleshooting: count.fields(), character count

Related

"Reading/Writing Data" in R, YouTube videos from Coursera class Computing for Data Analysis by Roger Peng: Part 1 (12:56) • Part 2 (9:26)

Lab main page

efg, 2014-01-08