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 ...
/ frequently asked
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.
How do I use this prompt?
1) Copy the prompt with the copy button. 2) Replace every bracketed variable with your real details. 3) Paste it into your AI assistant. 4) Compare the answer with the example output and ask for changes if needed.
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.
- →Automate Competitor Analysis with AI Browser
This workflow uses an AI browser to autonomously collect and analyze data from competitor websites, providing real-time insights into pricing, features, and marketing strategies. It streamlines market intelligence gathering by automating repetitive web interactions.
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.