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
Data cleaning and preparation
Step-by-step guide to clean and standardize raw data before analysis in Excel or Google Sheets.
Prompt Claude for Analyzing Customer Reviews
Customer review analysis has become an essential strategic lever for any company looking to improve its products, services, and customer experience. Yet manually processing hundreds or thousands of comments remains a time-consuming task prone to interpretation bias. Claude, Anthropic's AI assistant, excels at qualitative analysis of natural language text. With its ability to understand nuances, sarcasm, implicit emotions, and cultural contexts, Claude transforms a corpus of raw reviews into actionable insights. Whether you manage an e-commerce site, a SaaS, or a network of stores, a well-structured prompt allows you to automatically extract dominant sentiments, identify recurring themes, spot weak signals, and prioritize improvement areas. This page offers an optimized main prompt as well as variants tailored to your level of expertise, to fully leverage Claude's potential in analyzing your customer feedback.
Annual HR Report
HR Reporting
Generate interaction features
Discover feature interactions