|
addConstantColumn()
|
Add constant to a table. |
|
buildJoinPlan()
|
Build a join plan |
|
dplyr_src_to_db_handle()
|
Obsolete with dplyr 0.7.0 and forward |
|
example_employeeAndDate()
|
build some example tables |
|
executeLeftJoinPlan()
|
Execute an ordered sequence of left joins. |
|
expandColumn()
|
Expand a column of vectors into one row per value of each vector. |
|
gapply()
|
grouped ordered apply |
|
`%land%` `%->%` `%->_%` `%land_%`
|
Land a value to variable from a pipeline. |
|
inspectDescrAndJoinPlan()
|
check that a join plan is consistent with table descriptions |
|
key_inspector_all_cols()
|
Return all columns as guess at preferred primary keys. |
|
key_inspector_postgresql()
|
Return all primary key columns as guess at preferred primary keys for a PostgreSQL handle. |
|
key_inspector_sqlite()
|
Return all primary key columns as guess at preferred primary keys for a SQLite handle. |
|
keysAreUnique()
|
Check uniqueness of rows with respect to keys. |
|
makeJoinDiagramSpec()
|
Build a drawable specification of the join diagram |
|
replyr
|
replyr: Patches to Use dplyr on Remote Data Sources |
|
replyr_add_ids()
|
Add unique ids to rows. Note: re-arranges rows in many cases. |
|
replyr_apply_f_mapped()
|
Apply a function to a re-mapped data frame. |
|
replyr_arrange()
|
arrange by a single column |
|
replyr_bind_rows()
|
Bind a list of items by rows (can't use dplyr::bind_rows or dplyr::combine on remote sources). Columns are intersected. |
|
replyr_check_ranks()
|
confirm data has good ranked groups |
|
replyr_coalesce()
|
Augment a data frame by adding additional rows. |
|
replyr_colClasses()
|
Get column classes. |
|
replyr_copy_from()
|
Bring remote data back as a local data frame tbl. |
|
replyr_copy_to()
|
Copy data to remote service. |
|
replyr_dim()
|
Compute dimensions of a data.frame (work around https://github.com/rstudio/sparklyr/issues/976 ). |
|
replyr_filter()
|
Filter a tbl on a column having values in a given set. |
|
replyr_get_src()
|
Get the "remote data source" where a data.frame like object lives. |
|
replyr_group_by()
|
group_by columns |
|
replyr_has_table()
|
check for a table |
|
replyr_hasrows()
|
Check if a table has rows. |
|
replyr_inTest()
|
Product a column noting if another columns values are in a given set. |
|
replyr_is_MySQL_data()
|
Test if data is MySQL. |
|
replyr_is_Spark_data()
|
Test if data is Spark. |
|
replyr_is_local_data()
|
Test if data is local. |
|
replyr_list_tables()
|
list tables |
|
replyr_mapRestrictCols()
|
Map names of columns to known values and drop other columns. |
|
replyr_ncol()
|
Compute number of columns of a data.frame (work around https://github.com/rstudio/sparklyr/issues/976 ). |
|
replyr_nrow()
|
Compute number of rows of a tbl. |
|
replyr_quantile()
|
Compute quantiles on remote column (NA's filtered out) using binary search. |
|
replyr_quantilec()
|
Compute quantiles on remote column (NA's filtered out) using cumsum. |
|
replyr_rename()
|
Rename a column |
|
replyr_reverseMap()
|
Reverse a name assignment map (which are written NEWNAME=OLDNAME). |
|
replyr_select()
|
select columns |
|
replyr_split()
|
split a data item by values in a column. |
|
replyr_summary()
|
Compute usable summary of columns of tbl. |
|
replyr_testCols()
|
Run test on columns. |
|
replyr_union_all()
|
Union two tables. |
|
replyr_uniqueValues()
|
Compute number of unique values for each level in a column. |
|
tableDescription()
|
Build a nice description of a table. |
|
topoSortTables()
|
Topologically sort join plan so values are available before uses. |