tidyverse/dplyr

Name: dplyr

Owner: tidyverse

Description: Dplyr: A grammar of data manipulation

Created: 2012-10-28 13:39:17.0

Updated: 2018-01-17 18:58:02.0

Pushed: 2018-01-12 18:05:08.0

Homepage: http://dplyr.tidyverse.org

Size: 15764

Language: R

GitHub Committers

UserMost Recent Commit# Commits

Other Committers

UserEmailMost Recent Commit# Commits

README

dplyr

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

Overview

dplyr is a grammar of data manipulation, providing a consistent set of verbs that help you solve the most common data manipulation challenges:

These all combine naturally with group_by() which allows you to perform any operation “by group”. You can learn more about them in vignette("dplyr"). As well as these single-table verbs, dplyr also provides a variety of two-table verbs, which you can learn about in vignette("two-table").

dplyr is designed to abstract over how the data is stored. That means as well as working with local data frames, you can also work with remote database tables, using exactly the same R code. Install the dbplyr package then read vignette("databases", package = "dbplyr").

If you are new to dplyr, the best place to start is the data import chapter in R for data science.

Installation
e easiest way to get dplyr is to install the whole tidyverse:
all.packages("tidyverse")

ternatively, install just dplyr:
all.packages("dplyr")

 the development version from GitHub:
stall.packages("devtools")
ools::install_github("tidyverse/dplyr")

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.

Usage
ary(dplyr)

wars %>% 
lter(species == "Droid")
 A tibble: 5 x 13
 name  height  mass hair_color skin_color  eye_color birth_year gender
 <chr>  <int> <dbl> <chr>      <chr>       <chr>          <dbl> <chr> 
 C-3PO    167  75.0 <NA>       gold        yellow         112   <NA>  
 R2-D2     96  32.0 <NA>       white, blue red             33.0 <NA>  
 R5-D4     97  32.0 <NA>       white, red  red             NA   <NA>  
 IG-88    200 140   none       metal       red             15.0 none  
 BB8       NA  NA   none       none        black           NA   none  
 ... with 5 more variables: homeworld <chr>, species <chr>, films <list>,
   vehicles <list>, starships <list>

wars %>% 
lect(name, ends_with("color"))
 A tibble: 87 x 4
 name           hair_color skin_color  eye_color
 <chr>          <chr>      <chr>       <chr>    
 Luke Skywalker blond      fair        blue     
 C-3PO          <NA>       gold        yellow   
 R2-D2          <NA>       white, blue red      
 Darth Vader    none       white       yellow   
 Leia Organa    brown      light       brown    
 ... with 82 more rows

wars %>% 
tate(name, bmi = mass / ((height / 100)  ^ 2)) %>%
lect(name:mass, bmi)
 A tibble: 87 x 4
 name           height  mass   bmi
 <chr>           <int> <dbl> <dbl>
 Luke Skywalker    172  77.0  26.0
 C-3PO             167  75.0  26.9
 R2-D2              96  32.0  34.7
 Darth Vader       202 136    33.3
 Leia Organa       150  49.0  21.8
 ... with 82 more rows

wars %>% 
range(desc(mass))
 A tibble: 87 x 13
 name    height  mass hair_color skin_color  eye_color  birth_year gender
 <chr>    <int> <dbl> <chr>      <chr>       <chr>           <dbl> <chr> 
 Jabba ?    175  1358 <NA>       green-tan,? orange          600   herma?
 Grievo?    216   159 none       brown, whi? green, ye?       NA   male  
 IG-88      200   140 none       metal       red              15.0 none  
 Darth ?    202   136 none       white       yellow           41.9 male  
 Tarfful    234   136 brown      brown       blue             NA   male  
 ... with 82 more rows, and 5 more variables: homeworld <chr>,
   species <chr>, films <list>, vehicles <list>, starships <list>

wars %>%
oup_by(species) %>%
mmarise(
n = n(),
mass = mean(mass, na.rm = TRUE)
%>%
lter(n > 1)
 A tibble: 9 x 3
 species      n  mass
 <chr>    <int> <dbl>
 Droid        5  69.8
 Gungan       3  74.0
 Human       35  82.8
 Kaminoan     2  88.0
 Mirialan     2  53.1
 ... with 4 more rows

Please note that this project is released with a Contributor Code of Conduct. By participating in this project you agree to abide by its terms.


This work is supported by the National Institutes of Health's National Center for Advancing Translational Sciences, Grant Number U24TR002306. This work is solely the responsibility of the creators and does not necessarily represent the official views of the National Institutes of Health.