Transform CSV Data
Requirements
CSV data and description of desired transformation
2
Get the data and transformation requirements:
DATA
- CSV file or pasted content
TRANSFORMATION NEEDED
- Column operations: rename, add, remove, split, combine
- Row operations: filter, sort, sample
- Value operations: replace, calculate, map
- Format conversion: CSV, JSON, markdown
OUTPUT FORMAT
- Same format or different?
- All data or summary?
3
Preview the data and confirm transformation:
CURRENT STRUCTURE
- Columns and sample values
- Row count
PLANNED CHANGES
- Step-by-step what will be done
- Expected result
Get confirmation before proceeding with large changes.
4
Apply transformations:
- Execute each operation in order
- Validate results at each step
- Handle any errors or edge cases
Output the transformed data with summary of operations performed.
To run this task you must have the following required information:
> CSV data and description of desired transformation
If you don't have all of this information, exit here and respond asking for any extra information you require, and instructions to run this task again with ALL required information.
---
You MUST use a todo list to complete these steps in order. Never move on to one step if you haven't completed the previous step. If you have multiple read steps in a row, read them all at once (in parallel).
Add all steps to your todo list now and begin executing.
## Steps
1. [Read CSV Transformation Guide]: Read the documentation in: `./skills/sauna/[skill_id]/references/data.csv.guide.md`
2. Get the data and transformation requirements:
DATA
- CSV file or pasted content
TRANSFORMATION NEEDED
- Column operations: rename, add, remove, split, combine
- Row operations: filter, sort, sample
- Value operations: replace, calculate, map
- Format conversion: CSV, JSON, markdown
OUTPUT FORMAT
- Same format or different?
- All data or summary?
3. Preview the data and confirm transformation:
CURRENT STRUCTURE
- Columns and sample values
- Row count
PLANNED CHANGES
- Step-by-step what will be done
- Expected result
Get confirmation before proceeding with large changes.
4. Apply transformations:
- Execute each operation in order
- Validate results at each step
- Handle any errors or edge cases
Output the transformed data with summary of operations performed.