Can I create formatted reports with this skill?

Absolutely. The skill provides implementation patterns for applying conditional formatting, bolding headers, and auto-adjusting column widths for professional output.

Does it support older .xls file formats?

Yes, by utilizing the xlrd engine, this skill can read and process legacy Excel formats in addition to modern .xlsx files.

Can this skill handle large Excel files?

Yes, it includes performance-optimized patterns such as using chunksize and selecting specific columns to efficiently process large datasets.

Which Python libraries are required for this skill?

This skill primarily utilizes pandas for data manipulation, openpyxl for Excel formatting, and matplotlib for generating charts and visualizations.

Excel Data Analysis

Name: Excel Data Analysis
Author: WalkerVVV

byWalkerVVV

•

データサイエンスとML

Automates the analysis, manipulation, and visualization of Excel spreadsheets using Python-based data science libraries.

The Excel Analysis skill empowers Claude to perform complex data operations on .xlsx and .xls files, bridging the gap between raw spreadsheet data and actionable insights. By leveraging powerful libraries like pandas and openpyxl, this skill enables automated data cleaning, the creation of dynamic pivot tables, sophisticated multi-sheet processing, and the generation of visual charts directly from workbook data. It is an essential tool for developers and analysts who need to programmatically manage large datasets, merge disparate spreadsheets, or generate professional reports with custom formatting and conditional styling.

主な機能

01Read and process multi-sheet Excel workbooks with pandas

02Perform advanced data cleaning, deduplication, and type conversion

031 GitHub stars

04Create visual charts and graphs directly from spreadsheet data

05Apply custom cell formatting and conditional styling using openpyxl

06Generate programmatically controlled pivot tables and aggregations

ユースケース

01Automating weekly sales report generation from raw CSV or Excel exports

02Merging multiple regional data sheets into a single consolidated master workbook

03Cleaning and normalizing messy client-provided data for database ingestion

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add walkervvv/firstmile-deals-pipeline excel-analysis

For use in Claude.ai and ChatGPT

Download Skill