Analyze Excel and CSV files with SQL queries via DuckDB.
npx skills add https://github.com/bettercallfan/deerflow --skill data-analysis-bettercallfan
Please help me install this Agent Skill. Skill: data-analysis Source: https://github.com/bettercallfan/deerflow/tree/main/skills/public/data-analysis Command: npx skills add https://github.com/bettercallfan/deerflow --skill data-analysis-bettercallfan
This Skill simplifies the process of analyzing Excel (.xlsx/.xls) and CSV files, allowing users to execute SQL queries, generate statistics, create summaries, pivot tables, and export results without manual data manipulation.
Use the 'data-analysis' skill to run a SQL query on your Excel/CSV data.
High-intent search queries and answers about installing and using this skill.
You can run SQL queries directly on Excel and CSV files using this Skill. It leverages DuckDB's in-memory SQL engine to analyze your uploaded spreadsheets, allowing you to explore, aggregate, and manipulate data without manual database setup.
Yes, you can generate statistical summaries and pivot tables from a CSV file using DuckDB. The Skill supports built-in functions to analyze specific data patterns and create summaries from your uploaded files, simplifying complex data exploration.
The best way to export analyzed spreadsheet data into JSON or Markdown is using this Skill's data export feature. After executing your SQL queries and generating summaries, you can export the results in multiple formats including CSV, JSON, and Markdown for presentations.
Yes, you need Python installed to analyze Excel data with this Skill. It requires Python for scripting, along with dependencies like openpyxl and pandas for file handling, and DuckDB to perform the in-memory SQL analysis.
Yes, this data analysis approach works with both .xlsx and .xls Excel file formats. The Skill uses the openpyxl library to parse your spreadsheets, enabling schema inspection and SQL querying across these supported file types.
You can inspect the schema of an uploaded CSV file using this Skill's schema inspection feature. It automatically reads your file's structure via pandas, allowing you to understand column names and data types before executing DuckDB SQL queries.
oldmangrizzzAnalyze clean CSV/Excel data to generate statistics, dashboards, and reports.
Datus-aiGenerate JSON, CSV, or markdown reports from SQL query results.
jaydelandDesign, build, and query DuckDB schemas within Python workflows.
apacheWrite DataFusion DataFrame and SQL queries with Apache Arrow integration in Python.
