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

dplyr (version 0.3.0.2)

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,618,991

Version

0.3.0.2

License

MIT + file LICENSE

Issues

103

Pull Requests

19

Stars

4,891

Forks

2,126

Maintainer

Hadley Wickham

Last Published

October 11th, 2014

Functions in dplyr (0.3.0.2)

src_tbls

List all tbls provided by a source.
sample

Sample n rows from a table.
grouped_df

A grouped data frame.
group_by

Group a tbl by one or more variables.
copy_to.src_sql

Copy a local data fram to a sqlite src.
id

Compute a unique numeric id for each unique row in a data frame.
select_vars

Select variables.
build_sql

Build a SQL string.
distinct

Select distinct/unique rows.
arrange

Arrange rows by variables.
all.equal.tbl_df

Provide a useful implementation of all.equal for data.frames.
partial_eval

Partially evaluate an expression.
src

Create a "src" object
base_scalar

Create an sql translator
backend_sql

SQL generation.
copy_to

Copy a local data frame to a remote src.
dplyr-cluster

Cluster management.
nth

Extract the first, last or nth value from a vector.
join

Join two tbls together.
funs

Create a list of functions calls.
backend_src

Source generics.
ranking

Windowed rank functions.
select

Select/rename variables by name.
tbl_df

Create a data frame tbl.
dplyr

The dplyr package.
setops

Set operations.
group_size

Calculate group sizes.
backend_db

Database generics.
n_distinct

Efficiently count the number of unique values in a vector.
tbl

Create a table from a data source
sql_quote

Helper function for quoting sql elements.
tbl_vars

List variables provided by a tbl.
failwith

Fail with specified value.
between

Do values in a numeric vector fail in specified range?
as.tbl_cube

Coerce an existing data structure into a tbl_cube
join.tbl_dt

Join data table tbls.
groups

Get/set the grouping variables for tbl.
join.tbl_df

Join data frame tbls.
lead-lag

Lead and lag.
cumall

Cumulativate versions of any, all, and mean
chain

Chain together multiple operations.
src_mysql

Connect to mysql/mariadb.
print.tbl_df

Tools for describing matrices
translate_sql

Translate an expression to sql.
tbl_dt

Create a data table tbl.
lahman

Cache and retrieve an src_sqlite of the Lahman baseball database.
nasa

NASA spatio-temporal data
sql

SQL escaping.
rowwise

Group input by rows
make_tbl

Create a "tbl" object
slice

Select rows by position.
src_sql

Create a "sql src" object
src_local

A local source.
query

Create a mutable query object.
rbind_list

Efficiently rbind multiple data frames.
top_n

Select top n rows (by value).
desc

Descending order.
with_order

Run a function with one order, translating result back to original order
same_src

Figure out if two sources are the same (or two tbl have the same source)
do

Do arbitrary operations on a tbl.
mutate

Add new variables.
temp_srcs

Connect to temporary data sources.
order_by

A helper function for ordering window function output.
grouped_dt

A grouped data table.
type_sum

Provide a succint summary of a type
compute

Compute a lazy tbl.
explain

Explain details of an tbl.
join.tbl_sql

Join sql tbls.
summarise

Summarise multiple values to a single value.
tbl_sql

Create an SQL tbl (abstract)
src_sqlite

Connect to a sqlite database.
n

The number of observations in the current group.
tbl_cube

A data cube tbl.
nycflights13

Database versions of the nycflights13 data
location

Print the location in memory of a data frame
progress_estimated

Progress bar with estimated time.
src_postgres

Connect to postgresql.
bench_compare

Evaluate, compare, benchmark operations of a set of srcs.
tally

Counts/tally observations by group.
glimpse

Get a glimpse of your data.
filter

Return rows with matching conditions.
summarise_each

Summarise and mutate multiple columns.
data_frame

Build a data frame.