data-analyst

Analyze CSV datasets, impute missing values, and generate Plotly Dash dashboards.

2|1|Updated Jun 12, 2025
One-click install
npx skills add https://github.com/agent-trust-protocol/atp-core --skill data-analyst-agent-trust-protocol
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analyst
Source: https://github.com/agent-trust-protocol/atp-core/tree/main/.claude/skills/data-analyst
Command: npx skills add https://github.com/agent-trust-protocol/atp-core --skill data-analyst-agent-trust-protocol

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, numpy, scikit-learn, plotly, dash, dash-bootstrap-components, and includes scripts (resource) and references (resource) components.

What problem does it solve? Working with real-world CSV data often means dealing with missing values, unclear data quality, and the manual effort of building visualizations. This Skill automates the full exploratory data analysis workflow: it detects missing value patterns, applies appropriate imputation methods per column, and produces an interactive dashboard for trend and distribution analysis. ## Core Features & Use Cases - Missing Value Analysis: Scans CSV files to detect missing data, identify column types (numeric, categorical, temporal, ID), and recommend imputation strategies with reasoning, outputting a JSON report. - Intelligent Imputation: Applies mean, median, mode, KNN, forward fill, interpolation, or constant-value imputation based on each column's characteristics, automatically dropping columns with over 70% missing data and rows missing critical IDs. - Interactive Dashboards: Generates Plotly Dash dashboards with summary statistics, time series plots, distribution histograms, correlation heatmaps, categorical bar charts, and scatter plot matrices, with optional static HTML export. - Use Case: Given a sales dataset with gaps in revenue and customer fields, run the full workflow to analyze data quality, impute missing values with statistically appropriate methods, and explore the cleaned data in an interactive browser dashboard. ## Quick Start Analyze the attached CSV file for missing values, impute them with appropriate methods, and create an interactive dashboard to visualize the trends.

Frequently Asked Questions about data-analyst

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I handle missing values in a CSV file with Python?▼

Run the analysis script to detect missing values and get recommended strategies per column, then run the imputation script to apply them. Methods include mean, median, mode, KNN, forward fill, and constant values, chosen based on each column's detected data type and distribution.

How to create an interactive dashboard from a CSV file?▼

Run the dashboard script with your CSV file, an output directory, and a port number. It auto-detects numeric, categorical, and time columns, then launches a Plotly Dash server with summary statistics, time series, histograms, correlation heatmaps, and scatter matrices.

When should I use KNN imputation vs mean or median?▼

Use mean for normally distributed numeric data and median for skewed distributions. KNN imputation is better when numeric variables are correlated, since it leverages relationships between columns, but it is computationally expensive for datasets over 50k rows.

What happens to columns with too many missing values?▼

Columns with more than 70% missing values are automatically dropped during imputation. Columns with over 50% missing are flagged for review, and you can optionally create binary missing-indicator columns to preserve the missingness signal.

Why does the dashboard fail to start on port 8050?▼

The default port 8050 may already be in use by another process. Pass a different port number as the third argument to the dashboard script, such as 8051, to resolve the conflict.

What are the limitations of automatic imputation for small datasets?▼

For datasets under 50 rows, simple methods like mean, median, or mode are more stable. KNN should be avoided because there are insufficient neighbors, and dropping rows may be preferable to imputing unreliable values.