Analyze Excel and CSV files with DuckDB SQL queries and statistical summaries.
npx skills add https://github.com/9Ashwin/aswin-skills --skill data-analysis-9ashwin
Please help me install this Agent Skill. Skill: data-analysis Source: https://github.com/9Ashwin/aswin-skills/tree/main/skills/data-analysis Command: npx skills add https://github.com/9Ashwin/aswin-skills --skill data-analysis-9ashwin
This Skill streamlines the process of analyzing Excel and CSV files, providing a powerful tool for data exploration, statistical summaries, and result visualization without the need for manual data processing.
Use the data-analysis skill to inspect the structure of your Excel file 'sales_data.xlsx'.
High-intent search queries and answers about installing and using this skill.
You can analyze Excel and CSV files using SQL by loading them into DuckDB's in-process engine, which executes queries directly on local files. This approach allows schema inspection, data manipulation, and statistical summaries without requiring a separate database server setup.
Automating statistical summaries for structured data involves using SQL queries against in-memory datasets to compute metrics for numeric and string columns. This process generates statistical aggregations that can be exported as JSON or Markdown for reporting.
Yes, you can run SQL queries directly on Excel workbooks by utilizing an in-process analytical engine like DuckDB. This allows you to extract, filter, and manipulate workbook data programmatically for rapid data exploration and trend analysis.
To export SQL query results to Markdown or JSON from a CSV file, execute the desired query using an in-process SQL engine and specify the output format. This transforms raw structured data into formatted reports for analysis and visualization.
Yes, DuckDB supports schema inspection for local CSV and Excel files, allowing you to automatically detect column types and structures. This enables immediate SQL querying and statistical analysis without manual schema definition or data preprocessing.
syusamaAnalyze Excel and CSV files with SQL queries via DuckDB.
bytedanceAnalyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.
OpsinTechAnalyze Excel and CSV files with SQL queries and statistical summaries.
tondevrelRun in-process analytical SQL queries on Python DataFrames and files.
