data-analysis

Name: data-analysis
Availability: InStock
Author: OpsinTech

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

Ready to run

npx skills add https://github.com/OpsinTech/opsintech-platform --skill data-analysis-opsintech

💬 Prompt for ChatGPT / Claude Chat▼

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.