skills.rest
kyirexy
kyirexyCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Updated Mar 5, 2026
Search Tags:#data analysis#sql#statistics#excel#csv#duckdb
One-click install
npx skills add https://github.com/kyirexy/dearclaw --skill data-analysis-kyirexy
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analysis
Source: https://github.com/kyirexy/dearclaw/tree/main/skills/public/data-analysis
Command: npx skills add https://github.com/kyirexy/dearclaw --skill data-analysis-kyirexy

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the process of analyzing data from Excel (.xlsx/.xls) and CSV files, allowing users to gain insights without manual data manipulation or complex BI tools.

Core Features & Use Cases

  • Data Inspection: Understand the structure, columns, and data types of your files.
  • SQL Querying: Execute custom SQL queries against your data for targeted analysis.
  • Statistical Summaries: Quickly generate key statistics for numeric and categorical columns.
  • Data Export: Save query results in CSV, JSON, or Markdown formats.
  • Use Case: Upload a sales spreadsheet, ask the skill to calculate the total revenue per region, and export the results to a CSV file for further reporting.

Quick Start

Use the data-analysis skill to inspect the structure of the uploaded file 'sales_data.xlsx'.

Frequently Asked Questions about data-analysis

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

FAQPage Schema
How do I analyze Excel and CSV files using SQL queries?▼

To analyze Excel and CSV files using SQL, you can use an in-process SQL engine like DuckDB to inspect schemas, execute arbitrary SQL queries, and generate statistical summaries directly on your uploaded data.

Can I join data across multiple Excel sheets and CSV files?▼

Yes, you can join data across multiple uploaded files. The analysis engine handles multi-sheet Excel files and allows you to write SQL queries to join data across different CSV and Excel sources.

How do I export SQL query results into different data formats?▼

You can export SQL query results into CSV, JSON, or Markdown formats. After running your custom SQL queries against the Excel or CSV data, the skill allows you to save the output in these formats for reporting.

Do I need to install additional BI tools to get statistical summaries from my CSV data?▼

No, you do not need additional BI tools. You can generate key statistical summaries for numeric and categorical columns directly from CSV and Excel files using the built-in SQL engine without manual data manipulation.

What is the best way to inspect the schema of a multi-sheet Excel file before querying it?▼

The best way to inspect a multi-sheet Excel file is to use the data inspection feature, which allows you to understand the structure, columns, and data types of your files before executing custom SQL queries.

Does this SQL data analysis approach work with both .xlsx and .xls Excel formats?▼

Yes, this SQL data analysis approach works with both .xlsx and .xls Excel formats. It uses an in-process SQL engine to process these files directly, enabling schema inspection and arbitrary querying.

Related Skills

Explore More Data & Analytics Skills→
aifredoaiaifredoai

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Official
Intermediate
bytedancebytedance
79.6k

data-analysis

Analyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.

Official
Intermediate
OpsinTechOpsinTech
91

data-analysis

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

Official
Intermediate
valkryhxvalkryhx
6

数据分析专家

Analyze CSV data with Pandas and Matplotlib for statistics and charts.

Community
Intermediate