One table verbs |
|
---|---|
Arrange rows by column values |
|
Count observations by group |
|
Subset distinct/unique rows |
|
Subset rows using column values |
|
Create, modify, and delete columns |
|
Extract a single column |
|
Change column order |
|
Rename columns |
|
Subset columns using their names and types |
|
Summarise each group to fewer rows |
|
|
Subset rows using their positions |
Two table verbs |
|
Efficiently bind multiple data frames by row and column |
|
Objects exported from other packages |
|
Set operations |
|
Mutating joins |
|
Nest join |
|
Filtering joins |
|
Grouping |
|
Group by one or more variables |
|
Select grouping variables |
|
Group input by rows |
|
Vector functions |
|
Apply a function (or functions) across multiple columns |
|
Combine values from multiple columns |
|
Do values in a numeric vector fall in specified range? |
|
A general vectorised if |
|
Find first non-missing element |
|
Cumulativate versions of any, all, and mean |
|
Descending order |
|
Vectorised if |
|
Compute lagged or leading values |
|
A helper function for ordering window function output |
|
|
Context dependent expressions |
Efficiently count the number of unique values in a set of vectors |
|
Convert values to NA |
|
Compare two numeric vectors |
|
Extract the first, last or nth value from a vector |
|
|
Windowed rank functions. |
Recode values |
|
Data |
|
Band membership |
|
Starwars characters |
|
Storm tracks data |
|
Remote tables |
|
Copy tables to same source, if necessary |
|
Force computation of a database query |
|
Copy a local data frame to a remote src |
|
Flag a character vector as SQL identifiers |
|
Explain details of a tbl |
|
Create a table from a data source |
|
SQL escaping. |
|
ExperimentalExperimental functions are a testing ground for new approaches that we believe to be worthy of greater exposure. There is no guarantee that these functions will stay around in the future, so please reach out if you find them useful. |
|
Apply a function to each group |
|
Trim grouping structure |
|
Split data frame by groups |
|
Perform an operation with temporary groups |
|
|
Manipulate individual rows |
QuestioningWe have our doubts about questioning functions. We’re not certain that they’re inadequate, or we don’t have a good replacement in mind, but these functions are at risk of removal in the future. |
|
Flexible equality comparison for data frames |
|
SupersededSuperseded functions have been replaced by new approaches that we believe to be superior, but we don’t want to force you to change until you’re ready, so the existing functions will stay around for several years. |
|
Sample n rows from a table |
|
Select top (or bottom) n rows (by value) |
|
Operate on a selection of variables |
|
Arrange rows by a selection of variables |
|
Select distinct rows by a selection of variables |
|
Filter within a selection of variables |
|
Group by a selection of variables |
|
|
Mutate multiple columns |
|
Summarise multiple columns |
Apply predicate to all variables |
|
Select variables |