Skip to content
data-storyteller logo

Data Storyteller

data-storyteller

Transform CSV/Excel data into narrative reports with auto-generated insights, visualizations, and PDF export. Auto-detects patterns and creates plain-English summaries.

SKILL.md

Full skill instructions

Data Storyteller

Automatically transform raw data into compelling, insight-rich reports. Upload any CSV or Excel file and get back a complete analysis with visualizations, statistical summaries, and narrative explanations - all without writing code.

Core Workflow

1. Load and Analyze Data

from scripts.data_storyteller import DataStoryteller

# Initialize with your data file
storyteller = DataStoryteller("your_data.csv")

# Or from a pandas DataFrame
import pandas as pd
df = pd.read_csv("your_data.csv")
storyteller = DataStoryteller(df)

2. Generate Full Report

# Generate comprehensive report
report = storyteller.generate_report()

# Access components
print(report['summary'])           # Executive summary
print(report['insights'])          # Key findings
print(report['statistics'])        # Statistical analysis
print(report['visualizations'])    # Generated chart info

3. Export Options

# Export to PDF
storyteller.export_pdf("analysis_report.pdf")

# Export to HTML (interactive charts)
storyteller.export_html("analysis_report.html")

# Export charts only
storyteller.export_charts("charts/", format="png")

Quick Start Examples

Basic Analysis

from scripts.data_storyteller import DataStoryteller

# One-liner full analysis
DataStoryteller("sales_data.csv").generate_report().export_pdf("report.pdf")

Custom Analysis

storyteller = DataStoryteller("data.csv")

# Focus on specific columns
storyteller.analyze_columns(['revenue', 'customers', 'date'])

# Set analysis parameters
report = storyteller.generate_report(
    include_correlations=True,
    include_outliers=True,
    include_trends=True,
    time_column='date',
    chart_style='business'
)

Features

Auto-Detection

  • Column Types: Numeric, categorical, datetime, text, boolean
  • Data Quality: Missing values, duplicates, outliers
  • Relationships: Correlations, dependencies, groupings
  • Time Series: Trends, seasonality, anomalies

Generated Visualizations

Data TypeCharts Generated
NumericHistogram, box plot, trend line
CategoricalBar chart, pie chart, frequency table
Time SeriesLine chart, decomposition, forecast
CorrelationsHeatmap, scatter matrix
ComparisonsGrouped bar, stacked area

Narrative Insights

The storyteller generates plain-English insights including:

  • Executive summary of key findings
  • Notable patterns and anomalies
  • Statistical significance notes
  • Actionable recommendations
  • Data quality warnings

Output Sections

1. Executive Summary

High-level overview of the dataset and key findings in 2-3 paragraphs.

2. Data Profile

  • Row/​column counts
  • Memory usage
  • Missing value analysis
  • Duplicate detection
  • Data type distribution

3. Statistical Analysis

For each numeric column:

  • Central tendency (mean, median, mode)
  • Dispersion (std dev, IQR, range)
  • Distribution shape (skewness, kurtosis)
  • Outlier count

4. Categorical Analysis

For each categorical column:

  • Unique values count
  • Top/​bottom categories
  • Frequency distribution
  • Category balance assessment

5. Correlation Analysis

  • Correlation matrix with significance
  • Strongest relationships highlighted
  • Multicollinearity warnings

6. Time-Based Analysis

If datetime column detected:

  • Trend direction and strength
  • Seasonality patterns
  • Year-over-year comparisons
  • Growth rate calculations

7. Visualizations

Auto-generated charts saved to report:

  • Distribution plots
  • Trend charts
  • Comparison charts
  • Correlation heatmaps

8. Recommendations

Data-driven suggestions:

  • Columns needing attention
  • Potential data quality fixes
  • Analysis suggestions
  • Business implications

Chart Styles

# Available styles
styles = ['business', 'scientific', 'minimal', 'dark', 'colorful']

storyteller.generate_report(chart_style='business')

Configuration

storyteller = DataStoryteller(df)

# Configure analysis
storyteller.config.update({
    'max_categories': 20,       # Max categories to show
    'outlier_method': 'iqr',    # 'iqr', 'zscore', 'isolation'
    'correlation_threshold': 0.5,
    'significance_level': 0.05,
    'date_format': 'auto',      # Or specify like '%Y-%m-%d'
    'language': 'en',           # Narrative language
})

Supported File Formats

FormatExtensionNotes
CSV.csvAuto-detect delimiter
Excel.xlsx, .xlsMulti-sheet support
JSON.jsonRecords or columnar
Parquet.parquetFor large datasets
TSV.tsvTab-separated

Example Output

Sample Executive Summary

"This dataset contains 10,847 records across 15 columns, covering sales transactions from January 2023 to December 2024. Revenue shows a strong upward trend (+23% YoY) with clear seasonal peaks in Q4. The top 3 product categories account for 67% of total revenue. Notable finding: Customer acquisition cost has increased 15% while retention rate dropped 8%, suggesting potential profitability concerns worth investigating."

Sample Insight

"Strong correlation detected between marketing_spend and new_customers (r=0.78, p<0.001). However, this relationship weakens significantly after $50K monthly spend, suggesting diminishing returns beyond this threshold."

Best Practices

  1. Clean data first: Remove obvious errors before analysis
  2. Name columns clearly: Helps auto-detection and narratives
  3. Include dates: Enables time-series analysis
  4. Provide context: Tell the storyteller what the data represents

Limitations

  • Maximum recommended: 1M rows, 100 columns
  • Complex nested data may need flattening
  • Images/​binary data not supported
  • PDF export requires reportlab package

Dependencies

pandas>=2.0.0
numpy>=1.24.0
matplotlib>=3.7.0
seaborn>=0.12.0
scipy>=1.10.0
reportlab>=4.0.0
openpyxl>=3.1.0

More skills from majiayu000

xiaohongshu logo
majiayu000/claude-arsenal

xiaohongshu

xiaohongshu

286 148
View
agent-task-conductor logo
majiayu000/claude-skill-registry

agent-task-conductor

Conduct multi-agent task orchestration and workflow coordination.

663 1
View
conductor-setup logo
majiayu000/claude-skill-registry

conductor-setup

Initialize project with Conductor artifacts (product definition,

663 1
View
animation-designer logo
majiayu000/claude-skill-registry

animation-designer

Expert in web animations, transitions, and motion design using Framer Motion and CSS

663 1
View
diagramming logo
majiayu000/claude-skill-registry

diagramming

Creates Mermaid and ASCII diagrams for flowcharts, architecture, ERDs, state machines, mindmaps, and more. Use when user mentions diagram, flowchart, mermaid, ASCII diagram, text diagram, terminal diagram, visualize, C4, mindmap, architecture diagram, sequence diagram, ERD, or needs visual docume...

663 1
View
h3-pg logo
majiayu000/claude-skill-registry-data

h3-pg

PostgreSQL bindings for H3 hexagonal grid system. Use when working with H3 cells in Postgres, including spatial indexing, geometry/geography integration, and raster analysis.

23 1
View
conductor-development logo
majiayu000/claude-skill-registry

conductor-development

Context-Driven Development skill for projects using Conductor. Use this skill when you detect a `conductor/` directory in the project, when working on tasks defined in a `plan.md` file, or when the user asks about tracks, specs, or plans. Automatically applies TDD workflow, tracks task completion...

663 1
View
conductor-status logo
majiayu000/claude-skill-registry

conductor-status

Display project status, active tracks, and next actions

663 1
View
dockerization logo
majiayu000/claude-skill-registry

dockerization

Official Stakpak application containerization standard operating procedure, a step-by-step guidline to properly dockerize applications. This is a rule book curated by the Stakpak Team.

663 1
View

Popular AI tools

Kaiber logo
Video

Kaiber

Generate, edit, and beat-sync AI video with leading models in one workspace.

Paid
View
Vimcal logo
Productivity

Vimcal

The world's fastest calendar for remote work

Free
View

Transform Your Design with AI Designer by ImgCreator.ai

Freemium
View
Akool AI logo
Content & writing

Akool AI

Revolutionizing Video Production with AI-Powered Creativity

Paid
View

Extend an image past the frame and let AI fill the new aspect ratio.

Freemium
View
StarByFace logo
Security

StarByFace

Discover your celebrity doppelgänger with StarByFace!

Free
View
C

ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.

Freemium
View
Opus Clip logo
Coding & apps

Opus Clip

Opus.ai: Revolutionize Your Web Experience

Free
View