get_column_statistics
Compute detailed statistics for a specific column in your CSV data.
Instructions
Get detailed statistics for a specific column.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| session_id | Yes | ||
| column | Yes |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- src/csv_editor/server.py:289-290 (registration)Import of get_column_statistics from the analytics module, aliased as _get_column_statistics.
from .tools.analytics import detect_outliers as _detect_outliers from .tools.analytics import get_column_statistics as _get_column_statistics - src/csv_editor/server.py:309-314 (registration)MCP tool registration of get_column_statistics via the @mcp.tool decorator. The function is a thin wrapper that delegates to _get_column_statistics.
@mcp.tool async def get_column_statistics( session_id: str, column: str, ctx: Context = None ) -> dict[str, Any]: """Get detailed statistics for a specific column.""" return await _get_column_statistics(session_id, column, ctx) - src/csv_editor/tools/analytics.py:99-199 (handler)Core handler for get_column_statistics: retrieves session data, validates the column, computes detailed statistics for numeric columns (mean, median, std, skewness, quantiles, etc.) and categorical/string columns (value counts, frequencies, string length stats), records the operation, and returns results.
async def get_column_statistics( session_id: str, column: str, ctx: Context = None ) -> dict[str, Any]: """ Get detailed statistics for a specific column. Args: session_id: Session identifier column: Column name to analyze ctx: FastMCP context Returns: Dict with detailed column statistics """ try: manager = get_session_manager() session = manager.get_session(session_id) if not session or session.df is None: return {"success": False, "error": "Invalid session or no data loaded"} df = session.df if column not in df.columns: return {"success": False, "error": f"Column '{column}' not found"} col_data = df[column] result = { "column": column, "dtype": str(col_data.dtype), "total_count": len(col_data), "null_count": int(col_data.isna().sum()), "null_percentage": round(col_data.isna().sum() / len(col_data) * 100, 2), "unique_count": int(col_data.nunique()), "unique_percentage": round(col_data.nunique() / len(col_data) * 100, 2), } # Numeric column statistics if pd.api.types.is_numeric_dtype(col_data): non_null = col_data.dropna() result.update( { "type": "numeric", "mean": float(non_null.mean()), "median": float(non_null.median()), "mode": float(non_null.mode()[0]) if len(non_null.mode()) > 0 else None, "std": float(non_null.std()), "variance": float(non_null.var()), "min": float(non_null.min()), "max": float(non_null.max()), "range": float(non_null.max() - non_null.min()), "sum": float(non_null.sum()), "skewness": float(non_null.skew()), "kurtosis": float(non_null.kurt()), "25%": float(non_null.quantile(0.25)), "50%": float(non_null.quantile(0.50)), "75%": float(non_null.quantile(0.75)), "iqr": float(non_null.quantile(0.75) - non_null.quantile(0.25)), "zero_count": int((col_data == 0).sum()), "positive_count": int((col_data > 0).sum()), "negative_count": int((col_data < 0).sum()), } ) # Categorical column statistics else: value_counts = col_data.value_counts() top_values = value_counts.head(10).to_dict() result.update( { "type": "categorical", "most_frequent": str(value_counts.index[0]) if len(value_counts) > 0 else None, "most_frequent_count": ( int(value_counts.iloc[0]) if len(value_counts) > 0 else 0 ), "top_10_values": {str(k): int(v) for k, v in top_values.items()}, } ) # String-specific stats if col_data.dtype == "object": str_data = col_data.dropna().astype(str) if len(str_data) > 0: str_lengths = str_data.str.len() result["string_stats"] = { "min_length": int(str_lengths.min()), "max_length": int(str_lengths.max()), "mean_length": round(str_lengths.mean(), 2), "empty_string_count": int((str_data == "").sum()), } session.record_operation( OperationType.ANALYZE, {"type": "column_statistics", "column": column} ) return {"success": True, "statistics": result} except Exception as e: logger.error(f"Error getting column statistics: {e!s}") return {"success": False, "error": str(e)} - src/csv_editor/server.py:310-312 (schema)The typed signature for get_column_statistics defines the input schema: session_id (str), column (str), and ctx (optional Context).
async def get_column_statistics( session_id: str, column: str, ctx: Context = None ) -> dict[str, Any]: - Imports for the analytics module: pandas, numpy, FastMCP Context, session manager, and OperationType enum used by get_column_statistics.
"""Analytics tools for CSV data analysis.""" import logging from typing import Any import numpy as np import pandas as pd from fastmcp import Context from ..models.csv_session import get_session_manager from ..models.data_models import OperationType logger = logging.getLogger(__name__)