dplyr: a grammar of data manipulation


[Up] [Top]

Documentation for package ‘dplyr’ version 0.2

Help Pages

A B C D E F G H I J L M N O P R S T U misc

dplyr-package The dplyr package.

-- A --

all.equal.tbl_df Provide a useful implementation of all.equal for data.frames.
all.equal.tbl_dt Provide a useful implementation of all.equal for data.frames.
anti_join Join two tbls together.
anti_join.tbl_df Join data table tbls.
anti_join.tbl_dt Join data table tbls.
anti_join.tbl_sql Join sql tbls.
arrange Data manipulation functions.
arrange.data.table Data manipulation for data tables.
arrange.grouped_dt Data manipulation for grouped data tables.
arrange.tbl_df Data manipulation for data frames.
as.tbl Create a table from a data source
as.tbl_cube Coerce an existing data structure into a 'tbl_cube'
as.tbl_cube.array Coerce an existing data structure into a 'tbl_cube'
as.tbl_cube.data.frame Coerce an existing data structure into a 'tbl_cube'
as.tbl_cube.matrix Coerce an existing data structure into a 'tbl_cube'
as.tbl_cube.table Coerce an existing data structure into a 'tbl_cube'

-- B --

bench_compare Evaluate, compare, benchmark operations of a set of srcs.
bench_tbls Evaluate, compare, benchmark operations of a set of srcs.
build_sql Build a SQL string.

-- C --

chain Chain together multiple operations.
chain_q Chain together multiple operations.
changes Print the location in memory of a data frame
collapse Compute a lazy tbl.
collect Compute a lazy tbl.
compare_tbls Evaluate, compare, benchmark operations of a set of srcs.
compute Compute a lazy tbl.
compute.tbl_sql Compute a lazy tbl.
copy_to Copy a local data frame to a remote src.
copy_to.src_sql Copy a local data fram to a sqlite src.
cumall Cumulativate versions of any, all, and mean
cumany Cumulativate versions of any, all, and mean
cume_dist Windowed rank functions.
cummean Cumulativate versions of any, all, and mean

-- D --

dense_rank Windowed rank functions.
desc Descending order.
do Do arbitrary operations on a tbl.
do.tbl_sql Do arbitrary operations on a tbl.
dplyr The dplyr package.

-- E --

eval_tbls Evaluate, compare, benchmark operations of a set of srcs.
explain Explain details of an object
explain.tbl_sql Show sql and query plans.
explain_sql Show sql and query plans.

-- F --

failwith Fail with specified value.
filter Data manipulation functions.
filter.data.table Data manipulation for data tables.
filter.grouped_dt Data manipulation for grouped data tables.
filter.tbl_df Data manipulation for data frames.
first Extract the first, last or nth value from a vector.
funs Create a list of functions calls.
funs_q Create a list of functions calls.

-- G --

glimpse Get a glimpse of your data.
grouped_dt A grouped data table.
groups Get/set the grouping variables for tbl.
group_by Group a tbl by one or more variables.
group_size Calculate the size of each group

-- H --

has_lahman Cache and retrieve an 'src_sqlite' of the Lahman baseball database.

-- I --

inner_join Join two tbls together.
inner_join.tbl_df Join data table tbls.
inner_join.tbl_dt Join data table tbls.
inner_join.tbl_sql Join sql tbls.
intersect Set operations.
intersect.data.frame Set operations for data frames.
is.grouped_dt A grouped data table.
is.tbl Create a table from a data source

-- J --

join Join two tbls together.
join.tbl_df Join data table tbls.
join.tbl_dt Join data table tbls.
join.tbl_sql Join sql tbls.

-- L --

lag Lead and lag.
lahman Cache and retrieve an 'src_sqlite' of the Lahman baseball database.
lahman_bigquery Cache and retrieve an 'src_sqlite' of the Lahman baseball database.
lahman_df Cache and retrieve an 'src_sqlite' of the Lahman baseball database.
lahman_dt Cache and retrieve an 'src_sqlite' of the Lahman baseball database.
lahman_monetdb Cache and retrieve an 'src_sqlite' of the Lahman baseball database.
lahman_mysql Cache and retrieve an 'src_sqlite' of the Lahman baseball database.
lahman_postgres Cache and retrieve an 'src_sqlite' of the Lahman baseball database.
lahman_sqlite Cache and retrieve an 'src_sqlite' of the Lahman baseball database.
lahman_srcs Cache and retrieve an 'src_sqlite' of the Lahman baseball database.
last Extract the first, last or nth value from a vector.
lead Lead and lag.
lead-lag Lead and lag.
left_join Join two tbls together.
left_join.tbl_df Join data table tbls.
left_join.tbl_dt Join data table tbls.
left_join.tbl_sql Join sql tbls.
location Print the location in memory of a data frame

-- M --

manip Data manipulation functions.
manip_df Data manipulation for data frames.
manip_dt Data manipulation for data tables.
manip_grouped_dt Data manipulation for grouped data tables.
min_rank Windowed rank functions.
mutate Data manipulation functions.
mutate.data.table Data manipulation for data tables.
mutate.grouped_dt Data manipulation for grouped data tables.
mutate.tbl_df Data manipulation for data frames.
mutate_each Summarise and mutate multiple columns.
mutate_each_q Summarise and mutate multiple columns.

-- N --

n The number of observations in the current group.
nasa NASA spatio-temporal data
nth Extract the first, last or nth value from a vector.
ntile Windowed rank functions.
n_distinct Efficiently count the number of unique values in a vector.

-- O --

order_by A helper function for ordering window function output.

-- P --

percent_rank Windowed rank functions.

-- R --

ranking Windowed rank functions.
rbind_all Efficiently rbind multiple data frames.
rbind_list Efficiently rbind multiple data frames.
regroup Get/set the grouping variables for tbl.
rowwise Group input by rows
row_number Windowed rank functions.

-- S --

sample Sample n rows from a table.
sample_frac Sample n rows from a table.
sample_n Sample n rows from a table.
select Data manipulation functions.
select.data.table Data manipulation for data tables.
select.grouped_dt Data manipulation for grouped data tables.
select.tbl_df Data manipulation for data frames.
semi_join Join two tbls together.
semi_join.tbl_df Join data table tbls.
semi_join.tbl_dt Join data table tbls.
semi_join.tbl_sql Join sql tbls.
setdiff Set operations.
setdiff.data.frame Set operations for data frames.
setequal Set operations.
setequal.data.frame Set operations for data frames.
setops Set operations.
setops-data.frame Set operations for data frames.
show_sql Show sql and query plans.
src_bigquery A bigquery data source.
src_monetdb Connect to MonetDB (http://www.monetdb.org), an Open Source analytics-focused database
src_mysql Connect to mysql/mariadb.
src_postgres Connect to postgresql.
src_sqlite Connect to a sqlite database.
src_tbls List all tbls provided by a source.
summarise Data manipulation functions.
summarise.data.table Data manipulation for data tables.
summarise.grouped_dt Data manipulation for grouped data tables.
summarise.tbl_df Data manipulation for data frames.
summarise_each Summarise and mutate multiple columns.
summarise_each_q Summarise and mutate multiple columns.
summarize Data manipulation functions.

-- T --

tally Tally observations by group.
tbl Create a table from a data source
tbl.src_bigquery A bigquery data source.
tbl.src_monetdb Connect to MonetDB (http://www.monetdb.org), an Open Source analytics-focused database
tbl.src_mysql Connect to mysql/mariadb.
tbl.src_postgres Connect to postgresql.
tbl.src_sqlite Connect to a sqlite database.
tbl_cube A data cube tbl.
tbl_df Create a data frame tble.
tbl_dt Create a data table tbl.
tbl_vars List variables provided by a tbl.
top_n Select top n rows (by value).
translate_sql Translate an expression to sql.
translate_sql_q Translate an expression to sql.

-- U --

ungroup Get/set the grouping variables for tbl.
union Set operations.
union.data.frame Set operations for data frames.

-- misc --

%.% Chain together multiple operations.
%>% Chain together multiple operations.
.datatable.aware Create a data table tbl.