CSV Data Summarizer

Source: ComposioHQ/awesome-claude-skills Adapted for: LiYe OS Three-tier Architecture

When to Use This Skill

• Automatically generates data summaries and statistics
• Identifies patterns and trends in data
• Detects outliers
• Creates data visualizations
• Generates analysis reports

Core Capabilities

1. Automatic Data Summary

• Data type identification
• Missing value detection
• Data quality assessment
• Basic statistic calculation

2. Statistical Analysis

• Mean, median, standard deviation
• Quantile distribution
• Correlation analysis
• Grouped statistics

3. Outlier Detection

• Anomaly identification based on statistical methods
• Outlier marking
• Data quality warnings

4. Trend Identification

• Time series analysis
• Growth/decline trends
• Cyclical pattern identification
• Prediction recommendations

5. Automatic Visualization

• Distribution histograms
• Trend line charts
• Correlation heatmaps
• Category comparison charts

Usage Examples

Example 1: Sales Data Analysis

User: Analyze this sales data CSV
Claude: [Uses csv-summarizer to automatically generate insights such as sales trends, top products, abnormal orders, etc.]

Example 2: Keyword Performance Analysis

User: Help me analyze the performance of this keyword report
Claude: [Uses csv-summarizer to calculate CTR and conversion rates for each keyword, and mark outliers]

Example 3: User Behavior Analysis

User: Find valuable insights from this user data
Claude: [Uses csv-summarizer to generate user segmentation, behavior patterns, and retention analysis]

Dependencies

• Python: pandas, matplotlib, seaborn, scipy
• Or Node.js: csv-parse, chart.js

LiYe OS Integration

Business Domain References

• 07_Data_Science: General Data Analysis (Primary Domain)
• 02_Operation_Intelligence: Amazon Operation Report Analysis

Three-tier Architecture Position

• Physical Layer (This file): Skills/00_Core_Utilities/data-analysis/csv-summarizer/
• Logical Layer Index: Skills/{domain}/index.yaml
• L3 Instruction Layer: .claude/skills/{domain}/csv-summarizer/