Data · Analytics · Python

Data Studio

Local-first analytics workbench for cleaning, joining, analyzing, visualizing and reporting on tabular data using DuckDB.

View on GitHub Download ZIP

Overview

Data Studio is a local-first desktop app that lets you tidy, chart, and save data files. Underneath is the full analytics engine: kernel contracts, project format, CLI and API phases 0—“4 including typed analyses, time series, semantic dashboards, and Excel-like formula bar.

Analyses

  • descriptive_stats, value_counts, crosstab, correlation, quality_profile, t_test, anova, chi_square, proportion_test, pairwise_tests, linear_regression, logistic_regression, time_series_summary, acf_pacf, seasonal_decompose, trend_test, arima_forecast

Setup

python -m venv .venv
.\\.venv\\Scripts\\Activate.ps1
pip install -e ".[dev]"

Run the new stack

data-studio doctor
data-studio init .\examples\demo --name "Demo"
data-studio verify-project .\examples\demo
data-studio serve --project .\examples\demo --port 8765

HTTP API

POST /api/v1/model        GET/PUT model
POST /api/v1/model/derive    POST /api/v1/model/date-table
GET /api/v1/datasets/{id}/format
DELETE /api/v1/model          POST /api/v1/model/query
GET /api/v1/model/dimensions/{n}/values
GET/POST /api/v1/dashboards   POST /api/v1/dashboards/{id}/render
← Back to RepositoriesMore Help →