ChatGPT Prompt for Exploratory Data Analysis on a New Dataset
This ChatGPT prompt for exploratory data analysis (EDA) is built for analysts, students, and data scientists opening a dataset for the first time and needing a structured first pass before any modeling starts. Instead of asking the model to "analyze this data" and getting a generic paragraph back, the prompt walks it through the same checklist a human analyst would follow: shape and structure, missing values, distributions, outliers, and relationships worth investigating further.
The prompt asks the model to separate observations from recommendations, so you get a clear read on what the data actually shows before any suggestion about what to do next. It also asks for follow-up questions the data raises, which is often the most useful output of an EDA pass, since it tells you where to dig deeper rather than treating the first summary as final.
When the dataset is large, comes from a CSV or PDF export, or is spread across multiple files, pasting the whole thing into a chat window either doesn't fit or buries the model in irrelevant rows; pulling just the relevant slice first with Context Extractor keeps the EDA prompt focused on the columns and records that actually matter.
Prompt template
Want it sharper? Optimize this prompt with Prompt Optimizer, check it with the Prompt Debugger or shorten it with the Token Optimizer.
Example input
When to use it
- Opening a new dataset for the first time and needing a structured overview before modeling
- Onboarding onto a dataset someone else collected, where the quirks and gaps aren't documented
- Preparing a quick data summary to share with a non-technical stakeholder
- Deciding which columns or segments deserve a deeper, more rigorous analysis
Best practices
- Paste the actual column names, data types, and a few sample rows, not just a description of the dataset
- Ask explicitly for missing-value counts and how the model would handle them, rather than letting it assume
- Request the analysis in a fixed structure (summary, distributions, outliers, questions) so results are easy to scan
- For very large or multi-sheet datasets, trim the input to the columns actually relevant to your business question before running the prompt
Common mistakes
- Pasting an entire raw dataset with no context on what each column represents
- Treating the model's summary as a finished analysis instead of a starting point for deeper investigation
- Not asking for missing-value or data-quality issues, which then surface later during modeling
- Accepting statistical claims (correlations, averages) without asking the model to show its reasoning or flag uncertainty
FAQs
How do I write a ChatGPT prompt for exploratory data analysis?
Give the model the actual column names, data types, and several real sample rows rather than a general description, then ask for a fixed structure: overview, data-quality issues, distributions, and follow-up questions. That structure is what turns a vague summary into a usable first pass.
Can ChatGPT do real statistical analysis on a dataset I paste in?
ChatGPT can describe patterns visible in the exact rows you provide and reason about likely relationships, but it cannot compute precise statistics across a full dataset it hasn't seen in full, and it can't verify claims against data outside what's pasted in. Treat its output as a starting hypothesis to verify with actual computation, not a finished statistical result.
What's the difference between EDA and full data analysis?
Exploratory data analysis is the first pass: understanding structure, quality, and obvious patterns before deciding what deeper analysis or modeling is worth doing. It's meant to generate questions and flag issues, not produce final conclusions.
How much sample data should I include in an EDA prompt?
Include enough rows to show the range of values and any quirks (blanks, inconsistent formatting, outliers) — typically 5 to 15 rows plus the full column list and data types. For large datasets, extracting a representative slice is more useful than pasting thousands of rows the model can't fully process anyway.
Which Cuelara tool helps when my dataset is too large to paste directly into a prompt?
Context Extractor — it pulls only the relevant snippets or columns from large CSVs, PDFs, or multi-file exports via RAG, which keeps the EDA prompt focused and cuts down on hallucinated patterns from incomplete context.