get_statistics

Analyze numerical data columns to compute descriptive statistics including count, mean, standard deviation, min/max values, and percentiles for data quality assessment and distribution analysis.

Instructions

Get comprehensive statistical summary of numerical columns.

Computes descriptive statistics for all or specified numerical columns including count, mean, standard deviation, min/max values, and percentiles. Optimized for AI workflows with clear statistical insights and data understanding.

Returns: Comprehensive statistical analysis with per-column summaries

Statistical Metrics: 📊 Count: Number of non-null values 📈 Mean: Average value 📉 Std: Standard deviation (measure of spread) 🔢 Min/Max: Minimum and maximum values 📊 Percentiles: 25th, 50th (median), 75th quartiles

Examples: # Get statistics for all numeric columns stats = await get_statistics("session_123")

# Analyze specific columns only stats = await get_statistics("session_123", columns=["price", "quantity"]) # Analyze all numeric columns (percentiles always included) stats = await get_statistics("session_123")

AI Workflow Integration: 1. Essential for data understanding and quality assessment 2. Identifies data distribution and potential issues 3. Guides feature engineering and analysis decisions 4. Provides context for outlier detection thresholds

Input Schema

Name	Required	Description	Default
`columns`	Yes	List of specific columns to analyze (None = all numeric columns)

Input Schema (JSON Schema)

{ "properties": { "columns": { "anyOf": [ { "items": { "type": "string" }, "type": "array" }, { "type": "null" } ], "description": "List of specific columns to analyze (None = all numeric columns)" } }, "required": [ "columns" ], "type": "object" }

DataBeak

get_statistics

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from DataBeak

Related Tools

MCP directory API