How does this skill handle very large datasets?

It includes performance optimization tips such as using 'usecols' to limit memory intake and 'chunksize' for processing large workbooks efficiently.

Which Excel file formats are supported?

The skill supports modern .xlsx files via openpyxl and legacy .xls files using the xlrd engine within the pandas framework.

Does it support advanced formatting like conditional styling?

Absolutely. The skill provides implementation patterns for applying cell fills, font styles, and conditional formatting rules using the openpyxl library.

Can I generate visual charts with this skill?

Yes, it includes patterns for generating bar charts, pie charts, and other visualizations using matplotlib that can be saved as image files.

Excel Analysis

Name: Excel Analysis
Author: pur3v4d3r

bypur3v4d3r

•

データサイエンスとML

Analyzes Excel spreadsheets, generates pivot tables, and automates complex data visualization workflows.

概要

The Excel Analysis skill empowers Claude to perform professional-grade data manipulation and reporting directly on .xlsx and .xls files. By leveraging industry-standard Python libraries like pandas and openpyxl, it enables users to automate the extraction of insights from multi-sheet workbooks, perform advanced data cleaning, and generate programmatic pivot tables. Whether you are merging quarterly financial records or creating dynamic charts for business intelligence, this skill streamlines repetitive spreadsheet tasks and ensures data integrity through code-driven analysis.

主な機能

Custom Excel formatting, auto-adjusting columns, and conditional styling
Advanced data cleaning, type conversion, and duplicate removal
Dynamic chart generation including bar, pie, and line visualizations
1 GitHub stars
Programmatic pivot table creation with custom aggregation functions
Automated multi-sheet data extraction and vertical/horizontal merging

ユースケース

Merging multiple regional workbooks into a single master financial file
Automating monthly sales reports with integrated charts and summaries
Cleaning and normalizing messy tabular data from legacy business systems

概要

主な機能

Custom Excel formatting, auto-adjusting columns, and conditional styling
Advanced data cleaning, type conversion, and duplicate removal
Dynamic chart generation including bar, pie, and line visualizations
1 GitHub stars
Programmatic pivot table creation with custom aggregation functions
Automated multi-sheet data extraction and vertical/horizontal merging

ユースケース

Merging multiple regional workbooks into a single master financial file
Automating monthly sales reports with integrated charts and summaries
Cleaning and normalizing messy tabular data from legacy business systems