Prompt
Structured Data Analysis from CSV
Get a defensible analysis + chart suggestions from a raw CSV with no human pre-processing.
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