
dplyr is our go to package for fast data manipulation. This collection includes all the packages in this section, plus many more for data import, tidying, and visualization listed here.ĭplyr - Essential shortcuts for subsetting, summarizing, rearranging, and joining together data sets.

Tidyverse - An opinionated collection of R packages designed for data science that share an underlying design philosophy, grammar, and data structures. If you have even more exotic data, consult the CRAN guide to data import and export.įor more information about using R with databases see db. Just use the functions read.csv, read.table, and read.fwf. R can handle plain text files – no package required. Haven - Enables R to read and write data from SAS, SPSS, and Stata. csv's.įoreign - Want to read a SAS data set into R? Or an SPSS data set? Foreign provides functions that help you load data files from other programs into R. You can also just export your spreadsheets from Excel as. XLConnect, xlsx - These packages help you read and write Micorsoft Excel files from R. Choose the package that fits your type of database. RMySQL, RPostgresSQL, RSQLite - If you'd like to read in data from a database, these packages are a good place to start.
#Text file time series in r drivers
Note: RStudio professional products come with professional drivers for some of the most popular databases. Odbc - Use any ODBC driver with the odbc package to connect R to your database. Packages that connect R to databases depend on the DBI package. To load dataĭBI - The standard for for communication between R and relational database management systems. But you don't have to take our word for it, these packages are also some of the top most downloaded R packages. We've used each of these, and found them to be outstanding – we've even written some of them. To help you out, we've compiled this guide to some of the best. There are thousands of helpful R packages for you to use, but navigating them all can be a challenge.

Once you have a package installed, you can make its contents available to use in your current R session by running library("") R will download the package from CRAN, so you'll need to be connected to the internet.
#Text file time series in r install
To install an R package, open an R session and type at the command line install.packages("") Many useful R function come in packages, free libraries of code written by R's active user community.
