@nova-lang/data

Nova data library — load CSV, JSON, YAML, Excel, and SQL data; transform and analyze datasets.

Install

npm install @nova-lang/data

Usage

@use "nova/data"

CSV

@data-load-csv("data.csv")                    @;// rows as arrays
@data-load-csv-dict("data.csv")               @;// rows as dicts
@data-load-csv-string("a,1\nb,2")             @;// parse from string
@data-load-tsv("data.tsv")

JSON

@data-load-json("data.json")
@data-load-jsonl("data.jsonl")

YAML

@data-load-yaml("config.yaml")

Excel

@data-load-excel("report.xlsx")               @;// all sheets
@data-load-excel-sheet("report.xlsx", "Sheet1")  @;// one sheet

SQL

@data-query-sqlite("data.db", "SELECT * FROM users WHERE age > ?", [18])
@data-query-postgres("postgresql://localhost/mydb", "SELECT * FROM orders")

Transform

@data-filter(rows, row => row.age > 18)
@data-sort(rows, (a, b) => a.age - b.age)
@data-group(rows, "city")
@data-select(rows, ["name", "age"])
@data-join(left, right, "id")

Stats

@data-mean(values)
@data-median(values)
@data-stddev(values)
@data-summary(values)

License

MIT