Data Transformation & Cleaning
Transforms and cleans data with step-by-step processing
Help me transform and clean data.
Source data format: {format} (CSV / Excel / JSON)
Data description: {description}
Data issues: {issues} (missing values / duplicates / inconsistent date formats / unstructured)
Desired result: {result}
I need:
1. **Diagnosis**: what problems exist in the data and how to fix them
2. **Python code (pandas)** for:
- Loading the data
- Removing/filling missing values (strategy)
- Removing duplicates
- Casting data types
- Normalization (dates, numbers, text)
- Creating new columns (if needed)
- Exporting to the desired format
3. **No-code alternative**: how to do the same in Excel/Google Sheets
4. **Quality check**: how to verify the data is clean
5. **Report**: how many rows before/after, what was removed and why
0 copies
Variables
Replace these variables with your own values before using:
{формат}{описание}{проблемы}{результат}
Prompt info
📊
Category
Data
AI model
Any model
Application
Подготовка и очистка данных перед анализом
очистка данныхETLтрансформацияpandasCSV
Similar prompts
RegEx Data Extractor
Extracts data using regular expressions with match explanations
Format: Regex pattern with examples and explanation. Context: You create regex p...
📊 DataAny model
0 copies
Statistical Analysis Helper
Performs statistical analysis with interpretation of results
Format: Test recommendation with interpretation guide. Context: You recommend st...
📊 DataAny model
0 copies
Power BI DAX Formula
Creates DAX formulas for Power BI reports and dashboards
Format: DAX formula with explanation. Context: You write Power BI DAX formulas. ...
📊 DataAny model
0 copies