Exploratory Data Analysis prompts for Data Analyst
Ready-to-use AI prompts for exploratory data analysis — written for Data Analyst and easy to paste into ChatGPT, Claude or Gemini.
When you need exploratory data analysis done, these data analyst prompts give you a fill-in-the-blanks starting point covering eda, statistics, data quality. Fill in fields like question, decision, data available and paste the result into ChatGPT, Claude, or Gemini.
Plan an analysis before touching the data
You are a senior data analyst. Business question: [question]. Decision it informs: [decision]. Data available: [data available]. Deadline: [deadline].
Design the analysis before any code: the precise metric definition and why that definition and not a neighboring one, the population and exclusions, the comparison or baseline that makes the number meaningful, the cuts worth examining, and the confounders that could make a naive answer wrong.
Then list the data quality checks to run first, and state what result would mean the analysis cannot answer the question honestly. Finish with the one chart or table that would answer the question if everything checks out. Keep it under 400 words.
First-pass EDA script
Act as a data scientist writing [language] for a first look at a new dataset.
Dataset: [dataset]. Context: [context]. Goal: [goal].
Write a script that: profiles missingness and its pattern, checks the grain is what I think it is (duplicate keys), summarizes distributions including outliers, checks date ranges and gaps, cross-tabs the key categorical fields, and flags values that are impossible given the domain.
Keep it readable, no unnecessary libraries. After the code, list the five specific things I should look at in the output and what each would imply about whether this data can answer my question.
Interpret results honestly
You are a statistician reviewing my analysis for overclaiming. Here are my results:
<results>
[results]
</results>
Method used: [method]. Sample: [sample]. Question: [question]. Conclusion I want to draw: [conclusion].
Tell me whether the data supports that conclusion. Check specifically: sample size and whether differences are within noise, selection bias in how the data was collected, confounders that could explain the pattern, whether this is correlation being described as cause, multiple comparisons, and whether the effect size matters practically even if it is statistically detectable.
Give me: the conclusion the data actually supports, the caveats that must accompany it, and the additional data or test that would strengthen it.
How to use this prompt
Fill in the blanks. Type your details into each highlighted field of this exploratory data analysis prompt — fields like question, decision, data available — and it rewrites itself live.
Copy the prompt. Press Copy prompt to put the finished exploratory data analysis prompt on your clipboard.
Paste into your AI model. Paste it into ChatGPT, Claude, Gemini, or any chat LLM to get your exploratory data analysis result.
Review and iterate. Read the response as a data analyst would, then adjust fields like question, decision, data available and re-run to sharpen it.
Fill-in fields explained
question
Your question.
decision
what someone will do differently
data available
describe tables, columns, grain, time range, known quality issues
deadline
Your deadline.
language
Python with pandas / R
dataset
describe columns and types, with 5 sample rows
context
where it comes from and what it measures
goal
what I want to learn
results
paste numbers, tables, or model output
method
Your method.
sample
size and how selected
conclusion
what you want to draw
Frequently asked
Which AI models does the Exploratory Data Analysis prompt work with?
The Exploratory Data Analysis prompts for Data Analyst are plain-text and model-agnostic — paste them into ChatGPT (GPT-4o), Claude, Gemini, Llama, or any other chat model.
How do I customize the Exploratory Data Analysis prompt for my own use?
Fill in the 12 labelled fields (question, decision, data available, …) before copying, or edit the [bracketed] text after you paste.
Are the Exploratory Data Analysis prompts for Data Analyst free to use?
Yes. Every Exploratory Data Analysis prompt here is free to copy and reuse, including for commercial and client work, with no sign-up.