Excel Processor

Overview

Read, transform, analyze, and generate Excel and CSV files using Python. This skill covers data loading, cleaning, filtering, aggregation, formula generation, and export to multiple formats.

Instructions

When a user asks you to work with spreadsheets, Excel files, or CSV data, follow these steps:

Step 1: Load the data

import pandas as pd

# For .xlsx files (openpyxl engine, the default)
df = pd.read_excel("data.xlsx", sheet_name=0)  # or sheet_name="Sheet1"