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:

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