csv-transform

Name: csv-transform
Availability: InStock
Author: andregusman-raiz

Cleans, validates, and transforms messy CSV/TSV data into structured datasets.

19|4|Updated Mar 7, 2026

Search Tags:#validation #pandas #transformation #csv #encoding #data-cleaning

Ready to run

npx skills add https://github.com/andregusman-raiz/a-gusman-claude --skill csv-transform

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: csv-transform
Source: https://github.com/andregusman-raiz/a-gusman-claude/tree/main/skills/csv-transform
Command: npx skills add https://github.com/andregusman-raiz/a-gusman-claude --skill csv-transform

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, chardet, pandera, csvkit.

What problem does it solve?

Este Skill resolve o problema de limpar, validar e transformar CSV/TSV com headers inconsistentes, encoding quebrado, duplicatas e dados divergentes, tornando os dados prontos para análises.

Core Features & Use Cases

Limpeza de headers: normaliza nomes de colunas, remove espaços e transforma em snake_case.
Encoding e qualidade: detecta encoding, corrige separadores e tipos, remove duplicatas.
Mesclagem e exportação: concatena múltiplos CSVs e exporta para CSV/TSV/Excel/JSON.
Use Case: conjuntos de clientes com dados heterogêneos, padronize e valide rapidamente para dashboards.

Quick Start

Passe o caminho de um CSV sujo e peça para limpar, validar e transformar em um conjunto de dados pronto para uso.

Frequently Asked Questions about csv-transform

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I clean messy CSV data with encoding issues and header mismatches?▼

To clean messy CSV data, this Skill normalizes headers into snake_case, detects encoding using chardet, fixes separators, removes duplicates, and corrects data types using pandas. It processes files with inconsistent structures and transforms them into structured, analysis-ready datasets.

Can I validate data types and schemas in a CSV using pandas and pandera?▼

Yes, you can validate CSV schemas using pandera. This Skill applies schema validation to ensure consistent data types across your dataset, checking for divergent data and structural issues while leveraging pandas for the underlying data manipulation.

What is the best way to merge and convert multiple CSV files into JSON or Excel?▼

The best way to merge multiple CSV files is using this Skill's concatenation feature, which combines heterogeneous datasets and exports the cleaned data into CSV, TSV, Excel, or JSON formats for downstream analysis and dashboards.

Does this tool support automatic encoding detection for broken CSV files?▼

Yes, automatic encoding detection is supported. The Skill uses the chardet library to detect and correct broken encoding in CSV and TSV files, ensuring accurate data reading and preventing decode errors during the transformation process.

How do I standardize inconsistent CSV column headers for dashboard reporting?▼

To standardize inconsistent CSV column headers, the Skill automatically normalizes column names, removes extra spaces, and converts them to snake_case format. This creates uniform headers suitable for dashboard integration and data analysis.