Requirements
- suggested package: data.table
- suggested package: readr
- suggested package: readxl
In
| Format |
Functions |
| CSV |
read.csv , data.table::fread , readr::read_csv |
| Excel |
readxl::read_excel |
| Database |
RODBC::sqlQuery , DBI::dbGetQuery |
| SPSS / SAS / Stata |
haven::read_[prog] |
Out
| Format |
Functions |
| CSV |
write.csv |
| Excel |
openxlsx::write.xlsx |
| Database |
RODBC::sqlSave , DBI::dbWriteTable |
| SPSS / SAS / Stata |
foreign::write.foreign |
Other file types
As well standard formats, there's a lot of connector packages out there, including a suite for Hadoop.