skills.rest
OpsinTech
OpsinTechOFFICIAL
Explore all skills by this author →
GitHub

data-analysis

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

91|16|Updated May 11, 2026
Search Tags:#SQL#data analysis#Excel#CSV#statistical summary
One-click install
npx skills add https://github.com/OpsinTech/opsintech-platform --skill data-analysis-opsintech
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analysis
Source: https://github.com/OpsinTech/opsintech-platform/tree/main/skills/public/data-analysis
Command: npx skills add https://github.com/OpsinTech/opsintech-platform --skill data-analysis-opsintech

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the process of analyzing Excel and CSV files, allowing users to perform SQL-based queries, generate statistical summaries, and export results without manual data processing.

Core Features & Use Cases

  • Data Analysis: Perform SQL queries on uploaded Excel/CSV files.
  • Statistical Summaries: Generate statistics for numeric and string columns.
  • File Support: Works with Excel (.xlsx/.xls) and CSV files.
  • Use Case: A user can upload a sales data file and quickly generate a summary of the total revenue by category, along with a breakdown by month.

Quick Start

Use the data-analysis skill to generate a summary of the sales data in 'sales.xlsx'.

Frequently Asked Questions about data-analysis

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

FAQPage Schema
How do I run SQL queries on Excel files without importing them into a database?▼

You can run SQL queries directly on Excel files using an in-process SQL engine, avoiding manual database imports. This Skill uses DuckDB to perform schema inspection and SQL-based querying on Excel and CSV files.

What is the best way to get a statistical summary of a CSV file?▼

Generating a statistical summary of a CSV file involves analyzing numeric and string columns directly. This Skill automates that process, calculating statistics for your data without requiring manual processing scripts.

Can I analyze both CSV and Excel files using the same tool?▼

Yes, you can analyze both CSV and Excel files using the same tool. This Skill supports Excel formats like .xlsx and .xls alongside CSV files, processing them through an SQL engine to generate summaries and query results.

Do I need pandas and openpyxl to query Excel data with SQL?▼

Yes, you need pandas and openpyxl to query Excel data with SQL in this workflow. The Skill requires these dependencies to process file data and execute queries via DuckDB within your environment.

What are the limitations of using an in-process SQL engine for data analysis?▼

Using an in-process SQL engine for data analysis limits you to the memory and processing capacity of your local environment rather than a distributed database. This approach is ideal for administrative workflows involving data exploration and reporting.

Related Skills

Explore More Data & Analytics Skills→
xukrutdonutxukrutdonut

duckdb-en

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

Community
Advanced
borgheiborghei
467

data-analyst

Query SQL databases, create visualizations, and generate insights reports.

Community
Intermediate
syusamasyusama
4

data-analysis

Analyze Excel and CSV files with SQL queries via DuckDB.

Community
Intermediate
HwFeeHwFee

data-analyst

Analyze CSV, Excel, JSON, and SQL datasets to generate visual insights and reports.

Community
Intermediate