Analyze Excel and CSV files with DuckDB SQL queries and export results.
npx skills add https://github.com/aifredoai/sdk --skill data-analysis-aifredoai
Please help me install this Agent Skill. Skill: data-analysis Source: https://github.com/aifredoai/sdk/tree/main/deerflow/skills/public/data-analysis Command: npx skills add https://github.com/aifredoai/sdk --skill data-analysis-aifredoai
This Skill automates the process of analyzing data from Excel and CSV files, eliminating the need for manual data manipulation and complex spreadsheet formulas.
Use the data-analysis skill to inspect the structure of the uploaded file 'sales_data.xlsx'.
High-intent search queries and answers about installing and using this skill.
To analyze Excel and CSV data using SQL, you can upload your files and execute arbitrary SQL queries directly against them. This approach bypasses complex spreadsheet formulas by utilizing DuckDB for schema inspection and deep data exploration.
Yes, you can join data across multiple CSV files and Excel worksheets. The Skill supports multi-sheet workbooks and cross-file joins, allowing you to perform comprehensive data exploration and combine datasets using standard SQL queries.
The best way to get statistical summaries for columns in a CSV file is to use a SQL-based analysis tool that generates key statistics automatically. This Skill calculates metrics like mean, median, and counts without requiring manual formula setup.
You can export SQL query results from an Excel file to JSON or Markdown by running your queries and selecting a data export format. The Skill supports exporting analyzed data outputs directly to CSV, JSON, or Markdown formats.
DuckDB works well for analyzing Excel files locally because it is an embedded SQL engine optimized for analytical queries. It efficiently handles schema inspection and statistical summarization on uploaded Excel and CSV datasets.
A limitation of using SQL for Excel data analysis is that it requires understanding SQL syntax rather than visual spreadsheet tools. Additionally, the Skill processes structured data types, so complex formatting or non-tabular Excel layouts may not translate cleanly into queryable schemas.
rocklambrosAudit tabular datasets for data quality issues before modeling.
bytedanceAnalyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.
easyspace-aiLoad Excel and CSV files into DuckDB for SQL queries and statistics.
derob98Translate business questions into SQL, pandas, or spreadsheet formulas.
