Analyze Excel and CSV files with DuckDB SQL queries and statistical summaries.
npx skills add https://github.com/ainlper/dra-drb2 --skill data-analysis-ainlper
Please help me install this Agent Skill. Skill: data-analysis Source: https://github.com/ainlper/dra-drb2/tree/main/deer-flow/skills/public/data-analysis Command: npx skills add https://github.com/ainlper/dra-drb2 --skill data-analysis-ainlper
This Skill streamlines the process of analyzing Excel and CSV files, allowing users to perform complex data analysis tasks like schema inspection, SQL queries, statistical summaries, and exporting results.
Use the data-analysis skill to generate a statistical summary for the 'sales.xlsx' file.
High-intent search queries and answers about installing and using this skill.
To analyze Excel and CSV files using SQL queries, this Skill loads your data into DuckDB, an in-memory columnar database, allowing you to execute arbitrary SQL statements directly against the file contents.
You can generate a statistical summary for numeric and string columns in a CSV file by loading it into the DuckDB engine, which automatically calculates and returns the descriptive statistics for your dataset.
Yes, this data analysis tool requires both Python and DuckDB installed in your environment, as it relies on DuckDB's columnar in-memory SQL database engine to automate the querying and statistical analysis process.
The best way to inspect an Excel file's schema is using the schema inspection feature, which displays the file structure including sheet names, column names, data types, and row counts before you execute SQL queries.
You can export SQL query results to CSV, JSON, or Markdown formats by running your queries through the DuckDB engine, which provides built-in export functionality to output your analyzed data in your chosen format.
DuckDB is suitable for financial reporting and administrative data analysis because its in-memory columnar SQL engine efficiently handles Excel and CSV files, providing fast schema inspection and statistical summaries for reporting tasks.
MichaelYang-lyxNormalize numeric columns in Excel workbooks and verify totals against a Summary sheet.
bytedanceAnalyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.
hackeshackesAnalyze Excel and CSV files with SQL queries and statistical summaries.
bettercallfanAnalyze Excel and CSV files with SQL queries via DuckDB.
