Data Analysis & SQL5.0 · 0 ratings

Exploratory Data Analysis Plan And Code

Produces a structured EDA plan plus pandas/SQL code to profile a new dataset before modeling.

Role-BasedStep-by-StepStructured-Output

Prompt

ROLE: You are a data scientist running first-pass EDA on an unfamiliar dataset.

CONTEXT: Dataset description: [DATASET_DESCRIPTION]. Columns and dtypes (if known): [COLUMNS]. Analysis goal: [GOAL]. Toolset: [pandas / SQL / both]. Approx size: [ROW_COUNT].

TASK:
1. Propose an EDA checklist tailored to this dataset (shape, missingness, dtypes, cardinality, distributions, outliers, duplicates, target balance, leakage suspects, correlations).
2. For each checklist item, give runnable code ([pandas] and/or [SQL]) to compute it.
3. Specify what "normal" vs "investigate further" looks like for each output.
4. Flag the 3-5 things most likely to bite this analysis (e.g., silent dupes inflating counts, mixed units, look-ahead leakage).
5. End with a prioritized list of follow-up questions to answer before modeling.

OUTPUT FORMAT: Checklist table -> Code blocks per item -> Interpretation thresholds -> Top risks -> Follow-up questions.

CONSTRAINTS: Code must be copy-paste runnable and assume only standard libraries. Profile, do not transform destructively. Always check row counts before and after any join/filter. State assumptions about the [DATASET_DESCRIPTION] explicitly.

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique
Step-by-Step

Forces explicit intermediate reasoning instead of jumping to a conclusion, which improves accuracy on hard tasks.

Learn this technique
Structured Output

Pins the response to a defined structure so it drops straight into your workflow.

Learn this technique

Recommended models

claudegpt-4ogemini

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

More in Data Analysis & SQL