Learn R Programming
⚠️There's a newer version (1.0.10) of this package.Take me there.

dplyr (version 0.4.0)

A Grammar of Data Manipulation

Description

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

Copy Link

Version

Install

install.packages('dplyr')

Monthly Downloads

1,703,833

Version

0.4.0

License

MIT + file LICENSE

Issues

97

Pull Requests

17

Stars

4,867

Forks

2,127

Maintainer

Hadley Wickham

Last Published

January 8th, 2015

Functions in dplyr (0.4.0)

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