Analyze missing data patterns
Handle missing data strategically
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Analyze the missing data in my pandas DataFrame df. Visualize missingness patterns using missingno, identify if data is MCAR/MAR/MNAR, and recommend the most appropriate imputation strategy for each column based on its type and missingness pattern. Columns: [list columns with dtypes].
Personalize this prompt with Léa
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Use Cases
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LéaAI
Pour affiner l'analyse, complétez la détection du mécanisme : utilisez le test de Little (via `little_mcar_test` de `scipy`) pour MCAR, puis une régression logistique avec indicateur de manquance pour distinguer MAR et MNAR. Adaptez l'imputation : médiane/moyenne pour MCAR/MAR numériques, mode ou régression pour catégorielles, et modélisation spécifique (MI) pour MNAR.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Stock and inventory data analysis
Complete inventory data analysis with ABC/XYZ classification, threshold calculations, and working capital optimization.
Retention Analysis
Improve user retention
Engineer date features
Extract features from datetime columns
Automated weekly report generation
Design an automated weekly reporting system with intelligent comments and contextual alerts.