dplyr v0.4.0


Monthly downloads



by Hadley Wickham

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
join.tbl_df Join data frame tbls.
build_sql Build a SQL string.
sql SQL escaping.
copy_to Copy a local data frame to a remote src.
slice Select rows by position.
as.tbl_cube Coerce an existing data structure into a tbl_cube
grouped_df A grouped data frame.
glimpse Get a glimpse of your data.
desc Descending order.
tbl Create a table from a data source
make_tbl Create a "tbl" object
rowwise Group input by rows
join.tbl_sql Join sql tbls.
nth Extract the first, last or nth value from a vector.
src_mysql Connect to mysql/mariadb.
nycflights13 Database versions of the nycflights13 data
order_by A helper function for ordering window function output.
group_size Calculate group sizes.
copy_to.src_sql Copy a local data frame to a sqlite src.
src Create a "src" object
as_data_frame Coerce a list to a data frame.
add_rownames Convert row names to an explicit variable.
join Join two tbls together.
temp_srcs Connect to temporary data sources.
src_tbls List all tbls provided by a source.
tbl_df Create a data frame tbl.
backend_db Database generics.
backend_src Source generics.
funs Create a list of functions calls.
bench_compare Evaluate, compare, benchmark operations of a set of srcs.
filter Return rows with matching conditions.
knit_print.trunc_mat knit_print method for trunc mat
sql_quote Helper function for quoting sql elements.
group_by Group a tbl by one or more variables.
lahman Cache and retrieve an src_sqlite of the Lahman baseball database.
ranking Windowed rank functions.
arrange Arrange rows by variables.
tbl_vars List variables provided by a tbl.
rbind_all Efficiently bind multiple data frames by row and column.
n The number of observations in the current group.
join.tbl_dt Join data table tbls.
compute Compute a lazy tbl.
grouped_dt A grouped data table.
do Do arbitrary operations on a tbl.
distinct Select distinct/unique rows.
setops Set operations.
chain Chain together multiple operations.
base_scalar Create an sql translator
partial_eval Partially evaluate an expression.
groups Get/set the grouping variables for tbl.
n_distinct Efficiently count the number of unique values in a vector.
src_local A local source.
select_vars Select variables.
query Create a mutable query object.
tally Counts/tally observations by group.
summarise_each Summarise and mutate multiple columns.
id Compute a unique numeric id for each unique row in a data frame.
print.tbl_df Tools for describing matrices
type_sum Provide a succint summary of a type
summarise Summarise multiple values to a single value.
explain Explain details of an tbl.
group_indices Group id.
with_order Run a function with one order, translating result back to original order
nasa NASA spatio-temporal data
data_frame Build a data frame.
dplyr dplyr: a grammar of data manipulation
tbl_dt Create a data table tbl.
tbl_cube A data cube tbl.
translate_sql Translate an expression to sql.
all.equal.tbl_df Provide a useful implementation of all.equal for data.frames.
select Select/rename variables by name.
failwith Fail with specified value.
between Do values in a numeric vector fall in specified range?
backend_sql SQL generation.
src_sqlite Connect to a sqlite database.
mutate Add new variables.
location Print the location in memory of a data frame
top_n Select top n rows (by value).
same_src Figure out if two sources are the same (or two tbl have the same source)
cumall Cumulativate versions of any, all, and mean
sample Sample n rows from a table.
tbl_sql Create an SQL tbl (abstract)
dplyr-cluster Cluster management.
src_postgres Connect to postgresql.
lead-lag Lead and lag.
progress_estimated Progress bar with estimated time.
src_sql Create a "sql src" object
No Results!

Last month downloads


Type Package
URL https://github.com/hadley/dplyr
BugReports https://github.com/hadley/dplyr/issues
VignetteBuilder knitr
LazyData yes
LinkingTo Rcpp (>= 0.11.3), BH (>= 1.51.0-2)
License MIT + file LICENSE
Collate 'RcppExports.R' 'all-equal.r' 'bench-compare.r' 'chain.r' 'cluster.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' 'glimpse.R' 'group-by.r' 'group-indices.R' 'group-size.r' 'grouped-df.r' 'grouped-dt.r' 'id.r' 'inline.r' 'join.r' 'lead-lag.R' 'location.R' 'manip.r' 'nth-value.R' 'order-by.R' 'over.R' 'partial-eval.r' 'progress.R' 'query.r' 'rank.R' 'rbind.r' 'rowwise.r' 'sample.R' 'select-utils.R' 'select-vars.R' 'sets.r' 'sql-escape.r' 'sql-star.r' 'src-local.r' 'src-mysql.r' 'src-postgres.r' 'src-sql.r' 'src-sqlite.r' 'src.r' 'tally.R' 'tbl-cube.r' 'tbl-df.r' 'tbl-dt.r' 'tbl-sql.r' 'tbl.r' 'top-n.R' 'translate-sql-helpers.r' 'translate-sql-base.r' 'translate-sql-window.r' 'translate-sql.r' 'type-sum.r' 'utils-dt.R' 'utils-format.r' 'utils.r' 'view.r' 'zzz.r'
Packaged 2015-01-07 22:59:41 UTC; hadley
NeedsCompilation yes
Repository CRAN
Date/Publication 2015-01-08 11:12:43

Include our badge in your README