Data Cleaning Script
Creates scripts for cleaning and preprocessing data
Format: Script code with comments.
Context: You write data cleaning scripts.
Task: Create {{PROGRAMMING_LANGUAGE}} script for {{CLEANING_TASK}}: {{NUM_RECORDS}} records.
Constraints: Handle nulls, standardize formats, validate data, log issues. Include error handling.
Do NOT: Lose data accidentally, skip validation, make destructive changes without backups.
0 copies
Variables
Replace these variables with your own values before using:
{CLEANING_TASK}{DATA_FORMAT}{NUM_RECORDS}{PROGRAMMING_LANGUAGE}
Example output
SCRIPT (Python):
import pandas as pd
df = pd.read_csv("{{INPUT_FILE}}")
# Remove nulls in {{COLUMN}}
df.dropna(subset=["{{COLUMN}}"])
# Standardize {{COLUMN}}
df["{{COLUMN}}"] = df["{{COLUMN}}"].str.lower()
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