Analysis

Route data and analysis requests across knowledge networks, tables and metrics

Find which table or view holds a dataset and who owns it governance-wise

Register a CSV, TSV, JSON or GeoJSON file as a dataset in a PortalJS portal

Make a PortalJS portal harvestable with DCAT catalog feeds in several formats

Add a data dictionary or extra file to an existing PortalJS dataset

Audit a CSV or TSV file for nulls, types, duplicates and schema issues

Infer Frictionless table schemas and add dataset metadata for a PortalJS portal

Fill missing spreadsheet cells by researching each row and writing into open Excel

Answer business questions with data and avoid confident wrong answers

Generate data analysis reports with ECharts HTML visuals from database queries

Check datasets for leakage, split errors, label health and mock data before modeling

Pull air quality snapshots, nearby monitors and AQI history from OpenAQ and AirNow

Search Airtable bases offline, merge CSVs into tables and catch schema drift

Convert Italian cadastral references to GPS coordinates online or offline

Search and analyze CFPB consumer complaint records and aggregate trends

Turn Pakistan's plant-level power generation pages into a queryable local panel

Query OpenSky Network aircraft state vectors and flight tracking data from the CLI

Build a local Pakistan price panel from weekly Bureau food and essentials prices

Geocode Dutch addresses, reverse-geocode coordinates and convert RD to WGS84

Pull US CPI, unemployment, Census and BEA data for quick regional briefs

Query World Bank indicators offline and rank countries with SQL

Sync official Zillow Research housing datasets and analyze local housing markets

Analyze Excel data, review ad performance, compute ROI and build reports and slides

Calculate sample sizes for diagnostic, efficacy, etiology and prognosis studies

Clean clinical trial data and convert raw CRF records to CDISC SDTM

Run t-tests and ANOVA on experimental data and report results reproducibly

Analyze and map geospatial vector data with GeoPandas, CRS and spatial joins

Generate and test hypotheses on tabular datasets with LLM-driven exploration

Impute missing values in expression matrices with group-aware KNN after gene filtering

Clean and extract features from ECG, EEG, EDA and other biosignals in Python

Detect and handle outliers in a dataset with explicit assumptions and checks

Reduce numeric tabular data with PCA and export components as CSV or TXT

Run Pearson or Spearman correlation analysis with auto format detection and CSV output

Estimate per-group sample sizes for t-tests, chi-square and proportion comparisons

Calculate sample size and power for survival, clustered and multi-arm designs

Merge, clean and analyze CSV and Excel data with formulas, charts and recalculation

Pick the right statistical test, check assumptions and report APA-style results

Recommend statistical methods such as t-test or ANOVA for a given study design

Draw publication-ready Kaplan-Meier survival curves with log-rank statistics

Fit regression, Cox and mixed-effects models with odds and hazard ratios

Plan and check statistics for imaging studies: CIs, AUC, survival and sample size

Read, create and edit XLSX files while keeping templates and recalculating formulas

Build KPI frameworks, dashboards and predictive models for business analysis

Split a response variable's variance across factors with R-squared decomposition

Read, clean and write CSV sensor and time-series data with pandas

Recover missing spreadsheet values from totals, shares, YoY changes and CAGR

Run statistical analysis, predictive models and data-driven business insights

Match company and people names across datasets despite typos and spelling variants

Compute distances and spatial filters on earthquake and plate data with geopandas