dplyr 0.5.0

A Grammar of Data Manipulation

Homepage: https://github.com/hadley/dplyr

Platform: CRAN

Language: R

License: MIT

View on registry: https://cran.r-project.org/package=dplyr

Documentation: http://cran.r-project.org/web/packages/dplyr/dplyr.pdf

Direct download link: https://cran.r-project.org/src/contrib/dplyr_0.5.0.tar.gz


dplyr

Build Status AppVeyor Build Status CRAN\_Status\_Badge Coverage Status

dplyr is the next iteration of plyr, focussed on tools for working with data frames (hence the d in the name). It has three main goals:

  • Identify the most important data manipulation tools needed for data analysis and make them easy to use from R.

  • Provide blazing fast performance for in-memory data by writing key pieces in C++.

  • Use the same interface to work with data no matter where it's stored, whether in a data frame, a data table or database.

You can install:

  • the latest released version from CRAN with

    install.packages("dplyr")
  • the latest development version from github with

    if (packageVersion("devtools") < 1.6) {
      install.packages("devtools")
    }
    devtools::install_github("hadley/lazyeval")
    devtools::install_github("hadley/dplyr")

You'll probably also want to install the data packages used in most examples: install.packages(c("nycflights13", "Lahman")).

If you encounter a clear bug, please file a minimal reproducible example on github. For questions and other discussion, please use the manipulatr mailing list.

Learning dplyr

To get started, read the notes below, then read the intro vignette: vignette("introduction", package = "dplyr"). To make the most of dplyr, I also recommend that you familiarise yourself with the principles of tidy data: this will help you get your data into a form that works well with dplyr, ggplot2 and R's many modelling functions.

If you need more, help I recommend the following (paid) resources:

  • dplyr on datacamp, by Garrett Grolemund. Learn the basics of dplyr at your own pace in this interactive online course.

  • Introduction to Data Science with R: How to Manipulate, Visualize, and Model Data with the R Language, by Garrett Grolemund. This O'Reilly video series will teach you the basics needed to be an effective analyst in R.

Key data structures

The key object in dplyr is a tbl, a representation of a tabular data structure. Currently dplyr supports:

You can create them as follows:

library(dplyr) # for functions
library(nycflights13) # for data
flights
#> Source: local data frame [336,776 x 16]
#> 
#>     year month   day dep_time dep_delay arr_time arr_delay carrier tailnum
#>    (int) (int) (int)    (int)     (dbl)    (int)     (dbl)   (chr)   (chr)
#> 1   2013     1     1      517         2      830        11      UA  N14228
#> 2   2013     1     1      533         4      850        20      UA  N24211
#> 3   2013     1     1      542         2      923        33      AA  N619AA
#> 4   2013     1     1      544        -1     1004       -18      B6  N804JB
#> 5   2013     1     1      554        -6      812       -25      DL  N668DN
#> 6   2013     1     1      554        -4      740        12      UA  N39463
#> 7   2013     1     1      555        -5      913        19      B6  N516JB
#> 8   2013     1     1      557        -3      709       -14      EV  N829AS
#> 9   2013     1     1      557        -3      838        -8      B6  N593JB
#> 10  2013     1     1      558        -2      753         8      AA  N3ALAA
#> ..   ...   ...   ...      ...       ...      ...       ...     ...     ...
#> Variables not shown: flight (int), origin (chr), dest (chr), air_time
#>   (dbl), distance (dbl), hour (dbl), minute (dbl).

# Caches data in local SQLite db
flights_db1 <- tbl(nycflights13_sqlite(), "flights")

# Caches data in local postgres db
flights_db2 <- tbl(nycflights13_postgres(), "flights")

Each tbl also comes in a grouped variant which allows you to easily perform operations "by group":

carriers_df  <- flights %>% group_by(carrier)
carriers_db1 <- flights_db1 %>% group_by(carrier)
carriers_db2 <- flights_db2 %>% group_by(carrier)

Single table verbs

dplyr implements the following verbs useful for data manipulation:

  • select(): focus on a subset of variables
  • filter(): focus on a subset of rows
  • mutate(): add new columns
  • summarise(): reduce each group to a smaller number of summary statistics
  • arrange(): re-order the rows

They all work as similarly as possible across the range of data sources. The main difference is performance:

system.time(carriers_df %>% summarise(delay = mean(arr_delay)))
#>    user  system elapsed 
#>   0.040   0.001   0.043
system.time(carriers_db1 %>% summarise(delay = mean(arr_delay)) %>% collect())
#>    user  system elapsed 
#>   0.348   0.302   1.280
system.time(carriers_db2 %>% summarise(delay = mean(arr_delay)) %>% collect())
#>    user  system elapsed 
#>   0.015   0.000   0.142

Data frame methods are much much faster than the plyr equivalent. The database methods are slower, but can work with data that don't fit in memory.

system.time(plyr::ddply(flights, "carrier", plyr::summarise,
  delay = mean(arr_delay, na.rm = TRUE)))
#>    user  system elapsed 
#>   0.104   0.029   0.134

do()

As well as the specialised operations described above, dplyr also provides the generic do() function which applies any R function to each group of the data.

Let's take the batting database from the built-in Lahman database. We'll group it by year, and then fit a model to explore the relationship between their number of at bats and runs:

by_year <- lahman_df() %>% 
  tbl("Batting") %>%
  group_by(yearID)
by_year %>% 
  do(mod = lm(R ~ AB, data = .))
#> Source: local data frame [144 x 2]
#> Groups: <by row>
#> 
#>    yearID     mod
#>     (int)  (list)
#> 1    1871 <S3:lm>
#> 2    1872 <S3:lm>
#> 3    1873 <S3:lm>
#> 4    1874 <S3:lm>
#> 5    1875 <S3:lm>
#> 6    1876 <S3:lm>
#> 7    1877 <S3:lm>
#> 8    1878 <S3:lm>
#> 9    1879 <S3:lm>
#> 10   1880 <S3:lm>
#> ..    ...     ...

Note that if you are fitting lots of linear models, it's a good idea to use biglm because it creates model objects that are considerably smaller:

by_year %>% 
  do(mod = lm(R ~ AB, data = .)) %>%
  object.size() %>%
  print(unit = "MB")
#> 22.7 Mb

by_year %>% 
  do(mod = biglm::biglm(R ~ AB, data = .)) %>%
  object.size() %>%
  print(unit = "MB")
#> 0.8 Mb

Multiple table verbs

As well as verbs that work on a single tbl, there are also a set of useful verbs that work with two tbls at a time: joins and set operations.

dplyr implements the four most useful joins from SQL:

  • inner_join(x, y): matching x + y
  • left_join(x, y): all x + matching y
  • semi_join(x, y): all x with match in y
  • anti_join(x, y): all x without match in y

And provides methods for:

  • intersect(x, y): all rows in both x and y
  • union(x, y): rows in either x or y
  • setdiff(x, y): rows in x, but not y

Plyr compatibility

You'll need to be a little careful if you load both plyr and dplyr at the same time. I'd recommend loading plyr first, then dplyr, so that the faster dplyr functions come first in the search path. By and large, any function provided by both dplyr and plyr works in a similar way, although dplyr functions tend to be faster and more general.

Related approaches


Imports Dependencies Requirements Latest Stable Latest Release Licenses
assertthat * 0.1 GPL-3.0
DBI >= 0.4.1 0.3.1 0.5-1 Other
lazyeval >= 0.1.10 0.2.0 0.2.0 GPL-3.0
magrittr * 1.0.1 1.5 MIT
R6 * 2.2.0 2.2.0 MIT
Rcpp >= 0.12.3 0.12.7 0.12.7 GPL-2.0+
tibble * 1.2 MIT
utils *
Explore the resolved imports dependency tree for dplyr 0.5.0
Depends Dependencies Requirements Latest Stable Latest Release Licenses
R >= 3.1.2
Explore the resolved depends dependency tree for dplyr 0.5.0
Suggests Dependencies Requirements Latest Stable Latest Release Licenses
RSQLite >= 1.0.0 1.0.0 1.1-1 Other
Explore the resolved suggests dependency tree for dplyr 0.5.0

Releases

  • 0.5.0 - June 24, 2016 00:00
  • 0.4.3 - September 01, 2015 00:00
  • 0.4.2 - June 16, 2015 11:24
  • 0.4.1 - January 14, 2015 00:00
  • 0.4.0 - January 08, 2015 11:12
  • 0.3.0.2 - October 11, 2014 07:43
  • 0.3.0.1 - October 08, 2014 05:21
  • 0.3 - October 04, 2014 06:39
  • 0.2 - May 21, 2014 08:20
  • 0.1.3 - March 15, 2014 00:36
See all 13 releases

Project Statistics

SourceRank 21
Dependencies 0
Dependent projects 411
Dependent repositories 1.93K
Total releases 13
Latest release
First release
Stars 1.64K
Forks 651
Watchers 211
Contributors 102
Repo Size: 11.2 MB

Top Contributors See all

Hadley Wickham Romain François Kirill Müller lindbrook Hannes Mühleisen Jim Hester Kevin Ushey Lionel Henry Ian Lyttle Ilari Scheinin sfirke Leon du Toit Sergey Goder Jennifer (Jenny) Bryan Javier Luraschi coolbutuseless Harold Pimentel Eduardo Ibanez Arun Nick Carchedi

Something wrong with this page? Make a suggestion

Export .ABOUT file for this library

Last synced: 2016-06-26 06:40:56 UTC

Login to resync this project