Aggregate SedonaDB DataFrames to a single row per group — sd_summarise • sedonadb

Aggregate SedonaDB DataFrames to a single row per group

sd_summarise(.data, ..., .env = parent.frame())

sd_summarize(.data, ..., .env = parent.frame())

Arguments

.data: A sedonadb_dataframe or an object that can be coerced to one.
...: Aggregate expressions. These are evaluated in the same way as dplyr::summarise() except the outer expression must be an aggregate expression (e.g., sum(x) + 1 is not currently possible).
.env: The calling environment for programmatic usage

Value

An object of class sedonadb_dataframe

Examples

data.frame(x = c(10:1, NA)) |> sd_summarise(x = sum(x, na.rm = TRUE))
#> <sedonab_dataframe: ?? x 1>
#> ┌───────┐
#> │   x   │
#> │ int64 │
#> ╞═══════╡
#> │    55 │
#> └───────┘
#> Preview of up to 6 row(s)