DataFrame — Columnar Data Operations
Sovereign columnar DataFrame engine: create tables from JSON, compute summary statistics (mean, std, min, max, count, median), filter rows by condition, group by columns with aggregation, sort, select
7 toolsdataframe
Create
Create a DataFrame from JSON column data. Input: object mapping column names to arrays of values. Returns schema and row
columns
Describe
Compute summary statistics for a numeric column: count, non_null, mean, std_dev, min, max, median. Provide the full Data
columnscolumn
Filter
Filter rows where a column meets a condition. Operators: eq, neq, gt, gte, lt, lte, contains (string substring). Returns
columnscolumnoperatorvalue
Group By
Group rows by one or more columns and compute aggregations. Agg types: sum, mean, min, max, count, first, last, n_unique
columnsgroup_colsaggs
Sort
Sort a DataFrame by a column. Returns sorted rows as JSON.
columnsby
Select
Select a subset of columns from a DataFrame, optionally dropping columns instead.
columns
Join
Join two DataFrames on shared key columns. Join types: inner, left, right, outer, semi, anti. Provide left and right Dat
leftrighton