Sheetsmith

**Judgement:** Sheetsmith is a solid, general‑purpose spreadsheet helper for CSV/TSV/Excel files, well-suited for most tabular data tasks where you’d normally reach for a quick pandas script. It offers a good balance of exploratory tools (summary/describe/preview) and editing operations (filter/transform/convert) through a single, coherent CLI. **Recommended scenarios:** - You need to quickly inspect or sanity-check new CSV/Excel files (shapes, dtypes, missingness, head/tail) before heavier analysis. - You want to filter or transform tabular data using pandas-style queries/expressions and save results, without opening a notebook or writing boilerplate. - You frequently convert between CSV/TSV/Excel formats and prefer a simple, repeatable command-line workflow. **Key risks / limitations:** - Relies on pandas query/express syntax, which may be error-prone for users unfamiliar with pandas or boolean indexing rules. - In-memory pandas operations may struggle with very large files (memory and performance constraints). - Destructive edits are possible with `--inplace` if used carelessly, though the design requires explicit opt-in for overwriting. - Behavior and feature set are ultimately bounded by pandas and the installed Excel backends (e.g., openpyxl/xlrd) on the system.