data-analysis - SKILL.md Agent Skill

name: data-analysis description: "Analyze datasets, generate statistics, create data pipelines, and produce insights. Use when asked to analyze data, create reports, or process CSV/JSON data." license: MIT metadata: author: claude-php-agent version: "1.0.0" tags: [data, analysis, statistics, csv, json]

Data Analysis

Overview

Analyze datasets and generate actionable insights. Supports CSV, JSON, and database data sources. Produces statistical summaries, trend analysis, and formatted reports.

Capabilities

1. Data Loading

CSV file parsing with header detection
JSON file and API response parsing
Database query result processing
Stream processing for large datasets

2. Statistical Analysis

Descriptive statistics (mean, median, mode, std dev)
Distribution analysis
Correlation analysis
Outlier detection using IQR method
Time series trend analysis

3. Data Transformation

Filtering and sorting
Grouping and aggregation
Pivot tables
Data normalization
Missing value handling

4. Report Generation

Summary tables
Key findings with supporting data
Comparison analysis
Trend identification

PHP Implementation Pattern

// Load CSV data
$data = array_map('str_getcsv', file('data.csv'));
$headers = array_shift($data);

// Calculate statistics
$values = array_column($data, $columnIndex);
$mean = array_sum($values) / count($values);
$sorted = $values;
sort($sorted);
$median = $sorted[intdiv(count($sorted), 2)];

// Group and aggregate
$grouped = [];
foreach ($data as $row) {
    $key = $row[$groupByIndex];
    $grouped[$key][] = $row;
}

Output Format

Provide analysis results as:

Executive Summary - Key findings in 2-3 sentences
Detailed Statistics - Tables with relevant metrics
Insights - Patterns and anomalies discovered
Recommendations - Actionable next steps based on data