by Hadley Wickham

Monthly downloads



Type Package
URL https://github.com/hadley/dplyr
BugReports https://github.com/hadley/dplyr/issues
VignetteBuilder knitr
LinkingTo Rcpp (>= 0.12.0), BH (>= 1.58.0-1)
LazyData yes
License MIT + file LICENSE
Collate 'RcppExports.R' 'all-equal.r' 'bench-compare.r' 'bind.r' 'case_when.R' 'coalesce.R' 'colwise.R' 'compute-collect.r' 'copy-to.r' 'data-lahman.r' 'data-nasa.r' 'data-nycflights13.r' 'data-temp.r' 'data.r' 'dataframe.R' 'dbi-s3.r' 'desc.r' 'distinct.R' 'do.r' 'dplyr.r' 'explain.r' 'failwith.r' 'funs.R' 'group-by.r' 'group-indices.R' 'group-size.r' 'grouped-df.r' 'id.r' 'if_else.R' 'inline.r' 'join.r' 'lazy-ops.R' 'lead-lag.R' 'location.R' 'manip.r' 'na_if.R' 'near.R' 'nth-value.R' 'order-by.R' 'over.R' 'partial-eval.r' 'progress.R' 'query.r' 'rank.R' 'recode.R' 'rowwise.r' 'sample.R' 'select-utils.R' 'select-vars.R' 'sets.r' 'sql-build.R' 'sql-escape.r' 'sql-generic.R' 'sql-query.R' 'sql-render.R' 'sql-star.r' 'src-local.r' 'src-mysql.r' 'src-postgres.r' 'src-sql.r' 'src-sqlite.r' 'src-test.r' 'src.r' 'tally.R' 'tbl-cube.r' 'tbl-df.r' 'tbl-lazy.R' 'tbl-sql.r' 'tbl.r' 'tibble-reexport.r' 'top-n.R' 'translate-sql-helpers.r' 'translate-sql-base.r' 'translate-sql-window.r' 'translate-sql.r' 'utils-format.r' 'utils-replace-with.R' 'utils.r' 'view.r' 'zzz.r'
RoxygenNote 5.0.1
NeedsCompilation yes
Packaged 2016-06-23 21:54:41 UTC; hadley
Repository CRAN
Date/Publication 2016-06-24 15:37:11

A Grammar of Data Manipulation

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


Functions in dplyr

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


Get your badge !