skills.rest
darknetopencv-alt
darknetopencv-altCOMMUNITY
Explore all skills by this author →
GitHub

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and statistical summaries.

34|4|Updated Mar 25, 2026
Search Tags:#data analysis#Excel#DuckDB#CSV#statistical summary
One-click install
npx skills add https://github.com/darknetopencv-alt/autodev --skill data-analysis-darknetopencv-alt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analysis
Source: https://github.com/darknetopencv-alt/autodev/tree/main/src/autodev/skills/data-analysis
Command: npx skills add https://github.com/darknetopencv-alt/autodev --skill data-analysis-darknetopencv-alt

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires python, duckdb, openpyxl, pdfplumber, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the process of analyzing and summarizing Excel and CSV files, allowing for efficient data exploration, statistical analysis, and result export.

Core Features & Use Cases

  • Data Analysis: Perform schema inspection, SQL-based querying, and statistical summaries.
  • Supports Excel & CSV: Analyze multi-sheet Excel workbooks and CSV files.
  • File Handling: Efficiently handles large files using DuckDB's columnar engine.
  • Use Case: Imagine you have sales data in an Excel file and you want to analyze monthly trends and top products by revenue. Use this Skill to extract insights and generate statistical summaries.

Quick Start

Use the data-analysis skill to analyze a sales data file. For example, to get a statistical summary of the 'Orders' table:

python /mnt/skills/public/data-analysis/scripts/analyze.py --files /mnt/user-data/uploads/sales.xlsx --action summary --table Orders

Frequently Asked Questions about data-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I get a statistical summary of a CSV file?▼

You can get a statistical summary of a CSV file by running a Python script that leverages DuckDB to inspect schemas and generate statistical summaries. This automates data exploration directly from your CSV files.

Can I analyze multi-sheet Excel workbooks with DuckDB?▼

Yes, you can analyze multi-sheet Excel workbooks using DuckDB. This Skill supports Excel (.xlsx) files, allowing you to perform schema inspection, SQL querying, and statistical summaries across multiple sheets efficiently.

Do I need Python to run SQL queries on Excel files for data analysis?▼

Yes, you need Python to run SQL queries on Excel files for data analysis. This Skill requires Python script execution to automate DuckDB database operations, schema inspection, and statistical summaries for your Excel data.

What's the best way to handle large CSV files for statistical analysis?▼

The best way to handle large CSV files for statistical analysis is using DuckDB's columnar engine. This Skill leverages DuckDB to efficiently process large CSV files, enabling fast schema inspection and SQL-based querying.

Does this data analysis approach support exporting SQL query results?▼

Yes, this data analysis approach supports exporting SQL query results. The Skill automates the analysis and summarization of Excel and CSV files using DuckDB, including schema inspection, SQL querying, statistical summaries, and result export.

Why use DuckDB instead of other tools for Excel data analysis?▼

You should use DuckDB for Excel data analysis because its columnar engine efficiently handles large files. This Skill uses DuckDB to automate schema inspection, SQL-based querying, and statistical summaries, providing fast data exploration for Excel and CSV files.

Related Skills

Explore More Data & Analytics Skills→
syusamasyusama
4

data-analysis

Analyze Excel and CSV files with SQL queries via DuckDB.

Community
Intermediate
Thiago-Cruz-engThiago-Cruz-eng

data-analysis

Analyze datasets to extract insights and produce structured reports.

Community
Intermediate
xukrutdonutxukrutdonut

duckdb-en

Run SQL queries on CSV, Parquet, and JSON files using the DuckDB CLI.

Community
Advanced
bettercallfanbettercallfan

data-analysis

Analyze Excel and CSV files with SQL queries via DuckDB.

Community
Intermediate