Data Wrangler

Manipulate tabular data (CSV, Excel, JSON, Parquet, TSV) w/ pandas-powered scripts. Two scripts cover all operations: data_wrangler.py for data ops, excel_toolkit.py for Excel-specific features.

When to Use

• User asks to read, edit, filter, sort, or transform CSV/Excel/JSON/Parquet/TSV files
• User asks to merge/join datasets, deduplicate, fill missing values, or validate data
• User asks to create Excel workbooks w/ formatting, dropdowns, freeze panes, or multi-sheet
• User asks to pivot, unpivot, group-by, aggregate, sample, or split datasets
• User asks to add computed columns, rename columns, cast types, or apply formulas
• User asks to convert between data formats (CSV -> Excel, JSON -> Parquet, etc.)
• User asks to inspect/profile data structure, types, nulls, stats

Prerequisites

# Required
pip install pandas openpyxl