dplyr: A Grammar of Data Manipulation

A fast, consistent tool for working with data frame like objects, both in memory and out of memory.

Author
Hadley Wickham [aut, cre], Romain Francois [aut], RStudio [cph]
Date of publication
2016-06-24 15:37:11
Maintainer
Hadley Wickham <hadley@rstudio.com>
License
MIT + file LICENSE
Version
0.5.0
URLs

View on CRAN

Man pages

add_rownames
Convert row names to an explicit variable.
all_equal
Flexible equality comparison for data frames.
arrange
Arrange rows by variables.
as.table.tbl_cube
Coerce a 'tbl_cube' to other data structures
as.tbl_cube
Coerce an existing data structure into a 'tbl_cube'
auto_copy
Copy tables to same source, if necessary.
backend_db
Database generics.
backend_sql
SQL generation.
backend_src
Source generics.
bench_compare
Evaluate, compare, benchmark operations of a set of srcs.
between
Do values in a numeric vector fall in specified range?
bind
Efficiently bind multiple data frames by row and column.
build_sql
Build a SQL string.
case_when
A general vectorised if.
coalesce
Find first non-missing element
common_by
Extract out common by variables
compute
Compute a lazy tbl.
copy_to
Copy a local data frame to a remote src.
copy_to.src_sql
Copy a local data frame to a sqlite src.
cumall
Cumulativate versions of any, all, and mean
desc
Descending order.
dim_desc
Describing dimensions
distinct
Select distinct/unique rows.
do
Do arbitrary operations on a tbl.
dplyr
dplyr: a grammar of data manipulation
explain
Explain details of a tbl.
failwith
Fail with specified value.
filter
Return rows with matching conditions.
funs
Create a list of functions calls.
group_by
Group a tbl by one or more variables.
group_by_prepare
Prepare for grouping.
grouped_df
Convert to a data frame
group_indices
Group id.
groups
Get/set the grouping variables for tbl.
group_size
Calculate group sizes.
id
Compute a unique numeric id for each unique row in a data...
if_else
Vectorised if.
join
Join two tbls together.
join.tbl_df
Join data frame tbls.
join.tbl_sql
Join sql tbls.
lahman
Cache and retrieve an 'src_sqlite' of the Lahman baseball...
lazy_ops
Lazy operations
lead-lag
Lead and lag.
location
Print the location in memory of a data frame
make_tbl
Create a "tbl" object
mutate
Add new variables.
n
The number of observations in the current group.
na_if
Convert values to NA.
named_commas
Provides comma-separated string out ot the parameters
nasa
NASA spatio-temporal data
n_distinct
Efficiently count the number of unique values in a set of...
near
Compare two numeric vectors.
nth
Extract the first, last or nth value from a vector.
nycflights13
Database versions of the nycflights13 data
order_by
A helper function for ordering window function output.
partial_eval
Partially evaluate an expression.
progress_estimated
Progress bar with estimated time.
query
Create a mutable query object.
ranking
Windowed rank functions.
recode
Recode values
reexports
Objects exported from other packages
rowwise
Group input by rows
same_src
Figure out if two sources are the same (or two tbl have the...
sample
Sample n rows from a table.
select
Select/rename variables by name.
select_helpers
Select helpers
select_if
Select columns using a predicate
select_vars
Select variables.
setops
Set operations.
slice
Select rows by position.
sql
SQL escaping.
sql_build
Build and render SQL from a sequence of lazy operations
sql_quote
Helper function for quoting sql elements.
sql_variant
Create an sql translator
src
Create a "src" object
src_local
A local source.
src_memdb
Per-session in-memory SQLite databases.
src_mysql
Connect to mysql/mariadb.
src_postgres
Connect to postgresql.
src_sql
Create a "sql src" object
src_sqlite
Connect to a sqlite database.
src_tbls
List all tbls provided by a source.
src-test
A set of DBI methods to ease unit testing dplyr with DBI
summarise
Summarise multiple values to a single value.
summarise_all
Summarise and mutate multiple columns.
summarise_each
Summarise and mutate multiple columns.
tally
Counts/tally observations by group.
tbl
Create a table from a data source
tbl_cube
A data cube tbl.
tbl_df
Create a data frame tbl.
tbl_sql
Create an SQL tbl (abstract)
tbl_vars
List variables provided by a tbl.
testing
Infrastructure for testing dplyr
top_n
Select top (or bottom) n rows (by value).
translate_sql
Translate an expression to sql.
vars
Select columns
with_order
Run a function with one order, translating result back to...

Files in this package

dplyr
dplyr/inst
dplyr/inst/doc
dplyr/inst/doc/two-table.html
dplyr/inst/doc/hybrid-evaluation.html
dplyr/inst/doc/new-sql-backend.Rmd
dplyr/inst/doc/nse.html
dplyr/inst/doc/new-sql-backend.html
dplyr/inst/doc/window-functions.R
dplyr/inst/doc/databases.Rmd
dplyr/inst/doc/window-functions.html
dplyr/inst/doc/introduction.R
dplyr/inst/doc/nse.Rmd
dplyr/inst/doc/hybrid-evaluation.Rmd
dplyr/inst/doc/two-table.R
dplyr/inst/doc/window-functions.Rmd
dplyr/inst/doc/nse.R
dplyr/inst/doc/data_frames.Rmd
dplyr/inst/doc/data_frames.R
dplyr/inst/doc/hybrid-evaluation.R
dplyr/inst/doc/two-table.Rmd
dplyr/inst/doc/introduction.html
dplyr/inst/doc/databases.R
dplyr/inst/doc/databases.html
dplyr/inst/doc/data_frames.html
dplyr/inst/doc/introduction.Rmd
dplyr/inst/doc/new-sql-backend.R
dplyr/inst/include
dplyr/inst/include/dplyr.h
dplyr/inst/include/solaris
dplyr/inst/include/solaris/solaris.h
dplyr/inst/include/tools
dplyr/inst/include/tools/delete_all.h
dplyr/inst/include/tools/SlicingIndex.h
dplyr/inst/include/tools/SymbolMap.h
dplyr/inst/include/tools/LazyDots.h
dplyr/inst/include/tools/wrap_subset.h
dplyr/inst/include/tools/hash.h
dplyr/inst/include/tools/Encoding.h
dplyr/inst/include/tools/tools.h
dplyr/inst/include/tools/match.h
dplyr/inst/include/tools/DotsOf.h
dplyr/inst/include/tools/ShrinkableVector.h
dplyr/inst/include/tools/get_single_class.h
dplyr/inst/include/tools/get_all_second.h
dplyr/inst/include/tools/all_na.h
dplyr/inst/include/tools/pointer_vector.h
dplyr/inst/include/tools/complex.h
dplyr/inst/include/tools/collapse.h
dplyr/inst/include/tools/StringUTF8.h
dplyr/inst/include/tools/Call.h
dplyr/inst/include/tools/FilteredListOf.h
dplyr/inst/include/dplyr
dplyr/inst/include/dplyr/CharacterVectorOrderer.h
dplyr/inst/include/dplyr/tbl_cpp.h
dplyr/inst/include/dplyr/subset_visitor.h
dplyr/inst/include/dplyr/DataFrameColumnVisitor.h
dplyr/inst/include/dplyr/visitor_set
dplyr/inst/include/dplyr/visitor_set/VisitorSetLess.h
dplyr/inst/include/dplyr/visitor_set/VisitorEqualPredicate.h
dplyr/inst/include/dplyr/visitor_set/VisitorSetHash.h
dplyr/inst/include/dplyr/visitor_set/VisitorSetEqualPredicate.h
dplyr/inst/include/dplyr/visitor_set/VisitorSetEqual.h
dplyr/inst/include/dplyr/visitor_set/VisitorSetIndexMap.h
dplyr/inst/include/dplyr/visitor_set/VisitorHash.h
dplyr/inst/include/dplyr/visitor_set/visitor_set.h
dplyr/inst/include/dplyr/visitor_set/VisitorSetGreater.h
dplyr/inst/include/dplyr/visitor_set/VisitorSetHasher.h
dplyr/inst/include/dplyr/visitor_set/VisitorSetGreaterPredicate.h
dplyr/inst/include/dplyr/visitor_set/VisitorSetLessPredicate.h
dplyr/inst/include/dplyr/visitor_set/VisitorSetIndexSet.h
dplyr/inst/include/dplyr/NamedListAccumulator.h
dplyr/inst/include/dplyr/EmptySubset.h
dplyr/inst/include/dplyr/Result
dplyr/inst/include/dplyr/Result/DelayedReducer.h
dplyr/inst/include/dplyr/Result/GroupedHybridCall.h
dplyr/inst/include/dplyr/Result/Count.h
dplyr/inst/include/dplyr/Result/LazyRowwiseSubsets.h
dplyr/inst/include/dplyr/Result/all.h
dplyr/inst/include/dplyr/Result/min.h
dplyr/inst/include/dplyr/Result/Count_Distinct.h
dplyr/inst/include/dplyr/Result/DelayedProcessor.h
dplyr/inst/include/dplyr/Result/max.h
dplyr/inst/include/dplyr/Result/Rank.h
dplyr/inst/include/dplyr/Result/Var.h
dplyr/inst/include/dplyr/Result/Result.h
dplyr/inst/include/dplyr/Result/GroupedCallProxy.h
dplyr/inst/include/dplyr/Result/Processor.h
dplyr/inst/include/dplyr/Result/Sum.h
dplyr/inst/include/dplyr/Result/CumMin.h
dplyr/inst/include/dplyr/Result/In.h
dplyr/inst/include/dplyr/Result/Mutater.h
dplyr/inst/include/dplyr/Result/CumMax.h
dplyr/inst/include/dplyr/Result/Lead.h
dplyr/inst/include/dplyr/Result/is_smaller.h
dplyr/inst/include/dplyr/Result/RowwiseSubset.h
dplyr/inst/include/dplyr/Result/VectorSliceVisitor.h
dplyr/inst/include/dplyr/Result/Mean.h
dplyr/inst/include/dplyr/Result/CumSum.h
dplyr/inst/include/dplyr/Result/CallProxy.h
dplyr/inst/include/dplyr/Result/Sd.h
dplyr/inst/include/dplyr/Result/Lag.h
dplyr/inst/include/dplyr/Result/Everything.h
dplyr/inst/include/dplyr/Result/GroupedCallReducer.h
dplyr/inst/include/dplyr/Result/LazyGroupedSubsets.h
dplyr/inst/include/dplyr/Result/ResultSet.h
dplyr/inst/include/dplyr/Result/CallElementProxy.h
dplyr/inst/include/dplyr/Result/ConstantResult.h
dplyr/inst/include/dplyr/Result/CallbackProcessor.h
dplyr/inst/include/dplyr/Result/factories.h
dplyr/inst/include/dplyr/Result/LazySubsets.h
dplyr/inst/include/dplyr/Result/GroupedSubset.h
dplyr/inst/include/dplyr/SubsetVectorVisitor.h
dplyr/inst/include/dplyr/vector_class.h
dplyr/inst/include/dplyr/DataFrameVisitors.h
dplyr/inst/include/dplyr/GroupedDataFrame.h
dplyr/inst/include/dplyr/JoinVisitor.h
dplyr/inst/include/dplyr/comparisons.h
dplyr/inst/include/dplyr/config.h
dplyr/inst/include/dplyr/workarounds.h
dplyr/inst/include/dplyr/SubsetVectorVisitorImpl.h
dplyr/inst/include/dplyr/DataFrameJoinVisitors.h
dplyr/inst/include/dplyr/VectorVisitor.h
dplyr/inst/include/dplyr/RowwiseDataFrame.h
dplyr/inst/include/dplyr/DataFrameColumnSubsetVisitor.h
dplyr/inst/include/dplyr/DataFrameSubsetVisitors.h
dplyr/inst/include/dplyr/FullDataFrame.h
dplyr/inst/include/dplyr/Gatherer.h
dplyr/inst/include/dplyr/SummarisedVariable.h
dplyr/inst/include/dplyr/white_list.h
dplyr/inst/include/dplyr/workarounds
dplyr/inst/include/dplyr/workarounds/static_assert.h
dplyr/inst/include/dplyr/comparisons_different.h
dplyr/inst/include/dplyr/BoolResult.h
dplyr/inst/include/dplyr/Order.h
dplyr/inst/include/dplyr/Replicator.h
dplyr/inst/include/dplyr/DataFrameVisitorsIndexMap.h
dplyr/inst/include/dplyr/OrderVisitorImpl.h
dplyr/inst/include/dplyr/visitor.h
dplyr/inst/include/dplyr/registration.h
dplyr/inst/include/dplyr/train.h
dplyr/inst/include/dplyr/MatrixColumnVisitor.h
dplyr/inst/include/dplyr/MatrixColumnSubsetVectorVisitor.h
dplyr/inst/include/dplyr/JoinVisitorImpl.h
dplyr/inst/include/dplyr/DataFrameVisitorsIndexSet.h
dplyr/inst/include/dplyr/OrderVisitor.h
dplyr/inst/include/dplyr/VectorVisitorImpl.h
dplyr/inst/include/dplyr/check_supported_type.h
dplyr/inst/include/dplyr/DataFrameAble.h
dplyr/inst/include/dplyr/Collecter.h
dplyr/inst/include/dplyr/MultipleVectorVisitors.h
dplyr/tests
dplyr/tests/testthat.R
dplyr/tests/testthat
dplyr/tests/testthat/test-equality.r
dplyr/tests/testthat/test-coalesce.R
dplyr/tests/testthat/test-group-by.r
dplyr/tests/testthat/test-filter-windowed.R
dplyr/tests/testthat/test-lead-lag.R
dplyr/tests/testthat/test-arrange.r
dplyr/tests/testthat/test-output.R
dplyr/tests/testthat/test-if-else.R
dplyr/tests/testthat/test-data_frame.R
dplyr/tests/testthat/test-sql-escape.r
dplyr/tests/testthat/test-nth-value.R
dplyr/tests/testthat/test-select.r
dplyr/tests/testthat/test-binds.R
dplyr/tests/testthat/test-near.R
dplyr/tests/testthat/test-mutate-windowed.R
dplyr/tests/testthat/test-as-data-frame.R
dplyr/tests/testthat/test-sql-joins.R
dplyr/tests/testthat/test-recode.R
dplyr/tests/testthat/test-do.R
dplyr/tests/testthat/test-sql-translation.r
dplyr/tests/testthat/test-top-n.R
dplyr/tests/testthat/test-joins.r
dplyr/tests/testthat/test-slice.r
dplyr/tests/testthat/output
dplyr/tests/testthat/output/iris-5-30.txt
dplyr/tests/testthat/output/iris-3-5.txt
dplyr/tests/testthat/output/iris--70.txt
dplyr/tests/testthat/output/iris-head-30-80.txt
dplyr/tests/testthat/output/mtcars-8-30.txt
dplyr/tests/testthat/test-union-all.R
dplyr/tests/testthat/test-mutate.r
dplyr/tests/testthat/test-case-when.R
dplyr/tests/testthat/test-tally.R
dplyr/tests/testthat/test-sql-render.R
dplyr/tests/testthat/test-sample.R
dplyr/tests/testthat/test-distinct.R
dplyr/tests/testthat/test-colwise.R
dplyr/tests/testthat/test-compute.R
dplyr/tests/testthat/test-combine.R
dplyr/tests/testthat/test-sets.R
dplyr/tests/testthat/test-sql-build.R
dplyr/tests/testthat/test-summarise.r
dplyr/tests/testthat/test-lazy-ops.R
dplyr/tests/testthat/test-group-indices.R
dplyr/tests/testthat/test-select-helpers.R
dplyr/tests/testthat/helper-output.R
dplyr/tests/testthat/test-na-if.R
dplyr/tests/testthat/test-count.r
dplyr/tests/testthat/helper-src.R
dplyr/tests/testthat/test-group-size.R
dplyr/tests/testthat/test-tbl-sql.r
dplyr/tests/testthat/test-copying.R
dplyr/tests/testthat/test-window.R
dplyr/tests/testthat/test-filter.r
dplyr/tests/testthat/test-internals.r
dplyr/tests/testthat/test-tbl-cube.R
dplyr/tests/testthat/utf-8.R
dplyr/tests/testthat/test-equiv-manip.r
dplyr/src
dplyr/src/Makevars
dplyr/src/nth.cpp
dplyr/src/api.cpp
dplyr/src/strings_addresses.cpp
dplyr/src/summarise.cpp
dplyr/src/combine_variables.cpp
dplyr/src/distinct.cpp
dplyr/src/join.cpp
dplyr/src/group_indices.cpp
dplyr/src/address.cpp
dplyr/src/select.cpp
dplyr/src/arrange.cpp
dplyr/src/dplyr.cpp
dplyr/src/bind.cpp
dplyr/src/window.cpp
dplyr/src/filter.cpp
dplyr/src/Makevars.win
dplyr/src/init.cpp
dplyr/src/RcppExports.cpp
dplyr/src/between.cpp
dplyr/src/test.cpp
dplyr/NAMESPACE
dplyr/NEWS.md
dplyr/data
dplyr/data/nasa.rda
dplyr/R
dplyr/R/explain.r
dplyr/R/data-nasa.r
dplyr/R/failwith.r
dplyr/R/data-temp.r
dplyr/R/rank.R
dplyr/R/src-local.r
dplyr/R/tbl.r
dplyr/R/sql-query.R
dplyr/R/id.r
dplyr/R/bind.r
dplyr/R/src-mysql.r
dplyr/R/translate-sql-base.r
dplyr/R/coalesce.R
dplyr/R/utils-replace-with.R
dplyr/R/translate-sql.r
dplyr/R/tbl-lazy.R
dplyr/R/view.r
dplyr/R/distinct.R
dplyr/R/sql-star.r
dplyr/R/group-by.r
dplyr/R/group-indices.R
dplyr/R/sets.r
dplyr/R/data-lahman.r
dplyr/R/grouped-df.r
dplyr/R/sample.R
dplyr/R/case_when.R
dplyr/R/near.R
dplyr/R/dataframe.R
dplyr/R/rowwise.r
dplyr/R/lead-lag.R
dplyr/R/utils-format.r
dplyr/R/sql-escape.r
dplyr/R/do.r
dplyr/R/colwise.R
dplyr/R/data-nycflights13.r
dplyr/R/select-utils.R
dplyr/R/lazy-ops.R
dplyr/R/query.r
dplyr/R/utils.r
dplyr/R/join.r
dplyr/R/recode.R
dplyr/R/select-vars.R
dplyr/R/src-sql.r
dplyr/R/progress.R
dplyr/R/partial-eval.r
dplyr/R/funs.R
dplyr/R/sql-render.R
dplyr/R/desc.r
dplyr/R/tbl-cube.r
dplyr/R/dbi-s3.r
dplyr/R/src-postgres.r
dplyr/R/copy-to.r
dplyr/R/bench-compare.r
dplyr/R/RcppExports.R
dplyr/R/nth-value.R
dplyr/R/src-sqlite.r
dplyr/R/manip.r
dplyr/R/zzz.r
dplyr/R/tally.R
dplyr/R/sql-build.R
dplyr/R/dplyr.r
dplyr/R/inline.r
dplyr/R/src.r
dplyr/R/sql-generic.R
dplyr/R/translate-sql-helpers.r
dplyr/R/translate-sql-window.r
dplyr/R/location.R
dplyr/R/tibble-reexport.r
dplyr/R/top-n.R
dplyr/R/src-test.r
dplyr/R/if_else.R
dplyr/R/order-by.R
dplyr/R/data.r
dplyr/R/all-equal.r
dplyr/R/group-size.r
dplyr/R/compute-collect.r
dplyr/R/tbl-sql.r
dplyr/R/tbl-df.r
dplyr/R/na_if.R
dplyr/R/over.R
dplyr/vignettes
dplyr/vignettes/new-sql-backend.Rmd
dplyr/vignettes/databases.Rmd
dplyr/vignettes/windows.png
dplyr/vignettes/notes
dplyr/vignettes/notes/postgres-setup.Rmd
dplyr/vignettes/notes/mysql-setup.Rmd
dplyr/vignettes/notes/vagrant-setup.Rmd
dplyr/vignettes/disabled
dplyr/vignettes/disabled/benchmark-baseball.Rmd
dplyr/vignettes/nse.Rmd
dplyr/vignettes/hybrid-evaluation.Rmd
dplyr/vignettes/window-functions.Rmd
dplyr/vignettes/data_frames.Rmd
dplyr/vignettes/two-table.Rmd
dplyr/vignettes/introduction.Rmd
dplyr/vignettes/windows.graffle
dplyr/README.md
dplyr/MD5
dplyr/build
dplyr/build/vignette.rds
dplyr/DESCRIPTION
dplyr/man
dplyr/man/copy_to.src_sql.Rd
dplyr/man/tbl.Rd
dplyr/man/group_by_prepare.Rd
dplyr/man/group_by.Rd
dplyr/man/select_helpers.Rd
dplyr/man/tbl_df.Rd
dplyr/man/n.Rd
dplyr/man/testing.Rd
dplyr/man/nycflights13.Rd
dplyr/man/sql_variant.Rd
dplyr/man/join.tbl_df.Rd
dplyr/man/backend_db.Rd
dplyr/man/named_commas.Rd
dplyr/man/all_equal.Rd
dplyr/man/backend_src.Rd
dplyr/man/case_when.Rd
dplyr/man/src_sqlite.Rd
dplyr/man/tbl_sql.Rd
dplyr/man/failwith.Rd
dplyr/man/setops.Rd
dplyr/man/id.Rd
dplyr/man/mutate.Rd
dplyr/man/distinct.Rd
dplyr/man/src-test.Rd
dplyr/man/order_by.Rd
dplyr/man/select_vars.Rd
dplyr/man/with_order.Rd
dplyr/man/bind.Rd
dplyr/man/src_memdb.Rd
dplyr/man/summarise_each.Rd
dplyr/man/bench_compare.Rd
dplyr/man/partial_eval.Rd
dplyr/man/desc.Rd
dplyr/man/explain.Rd
dplyr/man/do.Rd
dplyr/man/vars.Rd
dplyr/man/nasa.Rd
dplyr/man/lead-lag.Rd
dplyr/man/src.Rd
dplyr/man/tbl_cube.Rd
dplyr/man/same_src.Rd
dplyr/man/as.table.tbl_cube.Rd
dplyr/man/between.Rd
dplyr/man/auto_copy.Rd
dplyr/man/summarise_all.Rd
dplyr/man/build_sql.Rd
dplyr/man/progress_estimated.Rd
dplyr/man/ranking.Rd
dplyr/man/src_postgres.Rd
dplyr/man/n_distinct.Rd
dplyr/man/rowwise.Rd
dplyr/man/add_rownames.Rd
dplyr/man/select_if.Rd
dplyr/man/compute.Rd
dplyr/man/sql_quote.Rd
dplyr/man/copy_to.Rd
dplyr/man/funs.Rd
dplyr/man/dplyr.Rd
dplyr/man/backend_sql.Rd
dplyr/man/groups.Rd
dplyr/man/src_tbls.Rd
dplyr/man/src_mysql.Rd
dplyr/man/reexports.Rd
dplyr/man/join.tbl_sql.Rd
dplyr/man/translate_sql.Rd
dplyr/man/lahman.Rd
dplyr/man/arrange.Rd
dplyr/man/cumall.Rd
dplyr/man/nth.Rd
dplyr/man/coalesce.Rd
dplyr/man/join.Rd
dplyr/man/sql_build.Rd
dplyr/man/src_sql.Rd
dplyr/man/dim_desc.Rd
dplyr/man/lazy_ops.Rd
dplyr/man/filter.Rd
dplyr/man/query.Rd
dplyr/man/src_local.Rd
dplyr/man/location.Rd
dplyr/man/tbl_vars.Rd
dplyr/man/top_n.Rd
dplyr/man/group_size.Rd
dplyr/man/group_indices.Rd
dplyr/man/make_tbl.Rd
dplyr/man/sql.Rd
dplyr/man/slice.Rd
dplyr/man/na_if.Rd
dplyr/man/near.Rd
dplyr/man/if_else.Rd
dplyr/man/common_by.Rd
dplyr/man/sample.Rd
dplyr/man/tally.Rd
dplyr/man/recode.Rd
dplyr/man/as.tbl_cube.Rd
dplyr/man/grouped_df.Rd
dplyr/man/select.Rd
dplyr/man/summarise.Rd
dplyr/LICENSE