Package index • vectra

pkgdown/mathjax-config.html

Data sources

Open files for lazy query execution

tbl(): Create a lazy table reference from a .vtr file
tbl_csv(): Create a lazy table reference from a CSV file
tbl_sqlite(): Create a lazy table reference from a SQLite database
tbl_tiff(): Create a lazy table reference from a GeoTIFF raster
tbl_xlsx(): Create a lazy table reference from an Excel (.xlsx) file

Data sinks

Write query results or data.frames to disk

write_vtr(): Write data to a .vtr file
write_csv(): Write query results or a data.frame to a CSV file
write_sqlite(): Write query results or a data.frame to a SQLite table
write_tiff(): Write query results to a GeoTIFF file

File operations

Incremental updates to .vtr files

append_vtr(): Append rows to an existing .vtr file
delete_vtr(): Logically delete rows from a .vtr file
diff_vtr(): Compute the logical diff between two .vtr files
create_index(): Create a hash index on a .vtr file column
has_index(): Check if a hash index exists for a .vtr column

Single-table verbs

Transform, filter, and reshape

filter(): Filter rows of a vectra query
select(): Select columns from a vectra query
mutate(): Add or transform columns
transmute(): Keep only columns from mutate expressions
rename(): Rename columns
relocate(): Relocate columns
arrange(): Sort rows by column values
desc(): Mark a column for descending sort order
distinct(): Keep distinct/unique rows
slice_head() slice_tail() slice_min() slice_max(): Select first or last rows
slice(): Select rows by position
pull(): Extract a single column as a vector
head(<vectra_node>): Limit results to first n rows

Grouping and aggregation

group_by(): Group a vectra query by columns
summarise() summarize(): Summarise grouped data
ungroup(): Remove grouping from a vectra query
count() tally(): Count observations by group
reframe(): Summarise with variable-length output per group
across(): Apply a function across multiple columns

Joins

left_join() inner_join() right_join() full_join() semi_join() anti_join(): Join two vectra tables
cross_join(): Cross join two vectra tables
fuzzy_join(): Fuzzy join two vectra tables by string distance

Combining tables

bind_rows() bind_cols(): Bind rows or columns from multiple vectra tables

Block operations

In-memory materialization and lookup

materialize(): Materialize a vectra node into a reusable in-memory block
block_lookup(): Probe a materialized block by column value
block_fuzzy_lookup(): Fuzzy-match query keys against a materialized block

Diagnostics

explain(): Print the execution plan for a vectra query
collect(): Execute a lazy query and return a data.frame
glimpse(): Get a glimpse of a vectra table
print(<vectra_node>): Print a vectra query node