456
Prompt

Structured Data Analysis from CSV

Get a defensible analysis + chart suggestions from a raw CSV with no human pre-processing.

1 min readupdated 2026-06-22

/ 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.

Get a defensible analysis + chart suggestions from a raw CSV with no human pre-processing. Use in a code-interpreter capable model (ChatGPT, Claude with tools) after attaching a CSV. Copy the prompt below, swap the bracketed variables for your own context, and run it in any capable model. This prompt node is part of the Onexial knowledge graph and links to related concepts, workflows and tools below.
Context
Use in a code-interpreter capable model (ChatGPT, Claude with tools) after attaching a CSV.
Prompt
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.
Example Output
Profile: 12,438 rows, 9 columns ... Conclusion: Churn rose 18% MoM, driven by the SMB segment in EU ...
Related Tool Stacks
/ 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.

What output should I expect?

Profile: 12,438 rows, 9 columns ... Conclusion: Churn rose 18% MoM, driven by the SMB segment in EU ...

/ topics#data#analysis
↳ connected nodes
Tool Stack↳ linked
AI Research & Knowledge Stack
Default toolset for analysts, founders and creators doing deep research with AI.
Dictionary↳ linked
Chain of Thought
Prompting an LLM to reason step-by-step before answering, often improving accuracy on hard tasks.
Workflow↳ linked
AI Market Research Report in One Afternoon
From blank page to sourced, structured 20-page market report in ~4 hours.
Prompt↳ linked
X Thread from Article Prompt
Convert a long article into a scroll-stopping X thread.
Prompt↳ linked
LinkedIn Post from Insight Prompt
Turn a raw idea into a LinkedIn post that gets engagement.
Prompt↳ linked
Prompt Improver Prompt
Iterate a weak prompt into a strong one using best practices.