📈 Data Analysis Prompts
SQL queries, data cleaning, visualization, insights
← All Categories
1 prompts
in Data Cleaning
Clean and Prepare Dataset - Python
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.