📊 Data Processing
📖 Official
Multi-CSV Analysis and Summary
Analyze multiple CSV files, extract statistics and generate comprehensive summary reports
★★☆ Intermediate 10-20 min January 12, 2026
📋
Scenario
I have a set of CSV files with sales data and need to analyze trends, calculate key metrics, and generate an executive summary.
💬
Prompt
Analyze all CSV files in /sales-data: - Calculate totals, averages, and trends for each metric - Identify top performers and outliers - Compare month-over-month and year-over-year changes - Create a summary report with key findings and charts
✨
Expected Result
Claude reads all CSV files, calculates statistics (totals, averages, trends), identifies top performers and outliers, compares MoM and YoY changes, generates summary report with key findings and visualizations.
💡
Tips
- • Ensure CSV files have consistent format (column names, delimiters, etc.)
- • Can specify key metrics to focus on
- • Supports generating detailed analysis in Excel format