Sheetsmith

Overview

Sheetsmith is a lightweight pandas wrapper that keeps the focus on working with CSV/Excel files: previewing, describing, filtering, transforming, and converting them in one place. The CLI lives at skills/sheetsmith/scripts/sheetsmith.py, and it automatically loads any CSV/TSV/Excel file, reports structural metadata, runs pandas expressions, and writes the results back safely.

Quick start

Place the spreadsheet (CSV, TSV, or XLS/XLSX) inside the workspace or reference it via a full path.
Run python3 skills/sheetsmith/scripts/sheetsmith.py <command> <path> with the command described below.
When you modify data, either provide --output new-file to save a copy or pass --inplace to overwrite the source file.
Check references/usage.md for extra sample commands and tips.

Commands

summary

Prints row/column counts, dtype breakdowns, columns with missing data, and head/tail previews. Use --rows to control how many rows are shown after the summary and --tail to preview the tail instead of the head.

describe

Runs pandas.DataFrame.describe(include='all') (customizable with --include) so you instantly see numeric statistics, cardinality, and frequency information. Supply --percentiles to add additional percentile lines.