🏠 Home
Benchmark Hub
📊 All Benchmarks 🦖 Dinosaur v1 🦖 Dinosaur v2 ✅ To-Do List Applications 🎨 Creative Free Pages 🎯 FSACB - Ultimate Showcase 🌍 Translation Benchmark
Models
🏆 Top 10 Models 🆓 Free Models 📋 All Models ⚙️ Kilo Code
Resources
💬 Prompts Library 📖 AI Glossary 🔗 Useful Links
hard

Data Cleaning Strategy Synthesizer

#data-science #preprocessing #python #pandas

Generates a step-by-step data cleaning and preprocessing strategy for messy datasets.

I have a dataset that contains the following issues: [LIST ISSUES e.g., 20% missing values in column X, inconsistent date formats, categorical data with high cardinality, and several outliers in column Y]. Act as a Senior Data Scientist and outline a comprehensive, step-by-step strategy to clean and preprocess this data for a regression model. Provide code snippets using Python and Pandas to illustrate the most complex steps, specifically focusing on handling missing data without dropping rows and encoding high-cardinality categorical variables.