Excel Analysis

SKILL.md

Read, analyze, and transform Excel spreadsheets with pandas, pivot tables, charts, and data cleaning.

Supports reading single or multiple sheets, filtering, grouping, aggregating, and calculating derived metrics on tabular data

Create pivot tables programmatically and generate bar, pie, and other chart visualizations using matplotlib

Write formatted Excel files with auto-adjusted column widths, conditional formatting, bold headers, and color fills using openpyxl

Merge and concatenate multiple Excel files, handle missing values, remove duplicates, and convert data types for data preparation

Includes performance optimization options like column selection, chunked reading for large files, and engine selection for different file formats

Excel Analysis

Quick start

Read Excel files with pandas:

import pandas as pd

# Read Excel file
df = pd.read_excel("data.xlsx", sheet_name="Sheet1")

# Display first few rows
print(df.head())

# Basic statistics
print(df.describe())