Trending today

1

Create a deep RPG character backstory with motivations, flaws, and arc potential

11.8K views
2

Anomaly detection with rolling z-score windows in SQL

11.8K views
3

30-day social media content calendar with post templates

11.6K views
4

Structured logging with correlation IDs across microservices

11.4K views
5

Legacy JavaScript to modern ES2023 refactor

10.9K views

Creators to follow

N
nadia_ux45 followers
D
david_ops45 followers
P
priya_design44 followers
AboutTermsPrivacyHelp

© 2026 teliprompt

SU
sunita_etl
2 days ago•
Data & Analytics

Messy CSV data cleaning pipeline with validation rules

Claude Sonnet 4.6
code output
#data-cleaning
#python
#pandas
#etl
#csv
Views
10.9K
Copies
2.6K
Likes
1.3K
Comments
0
Copy rate
24.0%

Prompt

You are a data engineer. Build a [language] data cleaning pipeline for a messy CSV file containing [data_description]. The data has these common issues:

- Inconsistent date formats
- Missing values in critical fields
- Duplicate rows
- Inconsistent casing and whitespace
- Invalid email/phone formats
- Outlier values

Create a pipeline that:
1. Loads and profiles the data (show distribution of issues)
2. Applies cleaning transformations with logging
3. Validates cleaned data against business rules
4. Exports clean data + a rejected records report
5. Generates a data quality summary

Customise this prompt

Fill in 2 variables to personalise this prompt

Preview
You are a data engineer. Build a [language] data cleaning pipeline for a messy CSV file containing [data_description]. The data has these common issues: - Inconsistent date formats - Missing values in critical fields - Duplicate rows - Inconsistent casing and whitespace - Invalid email/phone formats - Outlier values Create a pipeline that: 1. Loads and profiles the data (show distribution of issues) 2. Applies cleaning transformations with logging 3. Validates cleaned data against business rules 4. Exports clean data + a rejected records report 5. Generates a data quality summary

Example output

Related prompts

SQL query builder from plain English questionsby @rachel_data
Data & Analytics
Dashboard KPI designer for any business typeby @amara_viz
Data & Analytics
GDPR data privacy audit checklist with implementation guideby @rachel_data
Data & Analytics
A/B test significance calculator with practical interpretationby @neil_stats
Data & Analytics