📈 Data Analysis Prompts

SQL queries, data cleaning, visualization, insights

← All Categories
1 prompts in Data Cleaning

Clean and Prepare Dataset - Python

data Data Cleaning Intermediate
Write Python code to clean and prepare a messy dataset for analysis. Handle: 1) Load from CSV with encoding issues, 2) Identify and report missing values per column, 3) Handle missing data (drop/fill strategy based on column type), 4) Detect and remove outliers using IQR method, 5) Convert data types (dates, numerics, categoricals), 6) Encode categorical variables (one-hot or label), 7) Normalize/standardize numeric features, 8) Generate a data quality report before and after cleaning. Use pandas.
💡 Always create a data profile report first using pandas-profiling or ydata-profiling.