Structured Data Analysis from CSV
Get a defensible analysis + chart suggestions from a raw CSV with no human pre-processing.
/ quick answer
Use in a code-interpreter capable model (ChatGPT, Claude with tools) after attaching a CSV. Get a defensible analysis + chart suggestions from a raw CSV with no human pre-processing.
You are a senior data analyst.
Dataset: attached CSV
Business question: {{question}}
Steps:
1) Profile the data: row count, columns, types, missing values, obvious outliers.
2) Propose the 3 most defensible ways to answer the question with this data; pick one and justify.
3) Run the analysis. Show the code and the result.
4) Produce 2 charts that best support the conclusion; describe each in one sentence.
5) Give a 5-bullet executive summary. Call out any caveat that would change the conclusion.
Never invent columns. If the data can't answer the question, say so and propose what to collect.Profile: 12,438 rows, 9 columns ... Conclusion: Churn rose 18% MoM, driven by the SMB segment in EU ...
What does the Structured Data Analysis from CSV prompt do?
Use in a code-interpreter capable model (ChatGPT, Claude with tools) after attaching a CSV.
Which AI models work with this prompt?
It is model-agnostic: it works with any capable general model. Replace the bracketed variables with your own context before running it.
What output should I expect?
Profile: 12,438 rows, 9 columns ... Conclusion: Churn rose 18% MoM, driven by the SMB segment in EU ...
/ continue exploring
Related concepts
The vocabulary this page depends on.
- →Chain of Thought
Prompting an LLM to reason step-by-step before answering, often improving accuracy on hard tasks.
- →Synthetic Data
AI-generated data used to train, test or evaluate models when real data is scarce or sensitive.
Related workflows
Turn this into a repeatable process.
- →AI Market Research Report in One Afternoon
From blank page to sourced, structured 20-page market report in ~4 hours.
Related tool stacks
The tools that run it in production.
- →AI Research & Knowledge Stack
Default toolset for analysts, founders and creators doing deep research with AI.
- →Data Analyst AI Stack
Ship analysis 5x faster with a solo analyst + LLM tooling.
Related prompts
Reusable prompts for this job.
- →X Thread from Article Prompt
Convert a long article into a scroll-stopping X thread.
- →LinkedIn Post from Insight Prompt
Turn a raw idea into a LinkedIn post that gets engagement.
- →Prompt Improver Prompt
Iterate a weak prompt into a strong one using best practices.
- →Strategic Analyst Prompt
Turn a business situation into a McKinsey-style strategic memo.