excel-analysis
CommunityAnalyze Excel spreadsheets with Python.
AuthorCrumbgrabber
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill automates the complex and time-consuming tasks associated with analyzing data in Excel spreadsheets, enabling users to derive insights and create reports more efficiently.
Core Features & Use Cases
- Data Reading & Manipulation: Load, clean, and transform data from
.xlsxfiles using pandas. - Analysis & Reporting: Generate pivot tables, create charts, and perform statistical analysis.
- File Creation: Write processed data back to Excel with advanced formatting.
- Use Case: A marketing analyst needs to understand sales performance across different regions and products. This Skill can read sales data from an Excel file, create a pivot table summarizing sales by region and product, and generate a bar chart visualizing the top-selling products.
Quick Start
Use the excel-analysis skill to read the attached file 'sales_data.xlsx' and print the first five rows.
Dependency Matrix
Required Modules
pandasopenpyxlxlrdxlsxwritermatplotlib
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: excel-analysis Download link: https://github.com/Crumbgrabber/llm_system_template_agents_skills_patterns_tools_prompts/archive/main.zip#excel-analysis Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.