Clean a Messy CSV

Overview

Produce steps and transformed headers to clean a messy CSV.

Use cases

Prompt

Copied 0

Clean this messy CSV sample.

Tasks:
- Normalize column names (snake_case)
- Detect types
- Flag duplicate rows / likely bad values
- Propose a cleaned header + 10 example cleaned rows
- List transformation rules so I can apply them in pandas/Sheets

CSV:
<<<paste>>>

Can AI?

Clean a messy CSV and fix column namesPaste into a general LLM and produce steps and transformed headers to clean a messy CSV

Alternatives

API Documentation to curl ExamplesConvert JSON API documentation into example curl commands.Coding agent
Audit and fix bugs in an entire repoThis prompt tells a coding agent to map an entire repository, find bugs and security issues, and rank them by severity. It then fixes them with tests and writes up each fix. It works with any language or stack.Coding agent
Better Variable and Function NamesSuggest clearer variable and function names for a code snippet.Coding agent
Code Review Checklist and RubricReview a diff against a scored rubric for correctness, security, and clarity.Coding agent
Code to Structured PseudocodeTranslate code into pseudocode organized by ALGORITHM, INPUT, and OUTPUT sections.Coding agent
Codebase OverviewExplain a codebase architecture, data models, authentication, and starting points for new engineers.Coding agent