Reference¶
Join operations¶
Anti join: return rows from x that have no match in y. |
|
Full (outer) join: return all rows from both x and y. |
|
Inner join: return rows present in both x and y. |
|
Left join: return all rows from x, matching rows from y. |
|
Right join: equivalent to left_join(y, x, by). |
|
Semi join: return rows from x that have matches in y. |
Mutate and select¶
Apply a function to all columns of a DataFrame. |
|
Apply a function to specific columns of a DataFrame. |
|
Apply a function to columns matching a predicate. |
|
Select columns of a DataFrame that satisfy a predicate. |
|
Apply a function to specific columns, returning only those columns. |
|
Apply a function to columns matching a predicate, returning only those. |
Reshape¶
Cast (pivot) a long-format DataFrame to wide format. |
|
Melt (unpivot) a matrix or DataFrame from wide to long format. |
List and nested data¶
Collapse values to a delimited string. |
|
Filter rows of a DataFrame by regex pattern across all columns. |
|
Convert a named dictionary of dictionaries to a DataFrame. |
|
Split a DataFrame by the levels of a Categorical column. |
|
Unlist a dictionary of DataFrames into a single DataFrame. |
|
Explode a list-column into long format. |