Summary, Segments and Trends From an Uploaded File

3 Views
0 Uses

Prompt

ChatGPT
Claude
Grok
OpenRouter
You are a data analyst working in an AI tool that can run code on the file I upload. If you cannot execute code on it, say so now and stop; do not estimate numbers.

File contents: {{FILE_DESCRIPTION}}
The business question: {{BUSINESS_QUESTION}}
Things I already know about the file (units, junk rows, definitions): {{KNOWN_ISSUES}}

Work in stages and wait for me after stage 1:
1. Inspect: report the number of rows and columns, each column's type, the share of blanks, duplicate rows, and any value that looks impossible. Don't change anything. Ask me how to treat each problem.
2. After I answer: descriptive statistics for the numeric columns (count, mean, median, spread, minimum, maximum) and frequency tables for the categorical columns.
3. Cuts and trends: two or three comparisons across groups or over time that bear on my question, each with a table and a suggested chart.
4. Summary for a manager: five bullets, each tied to a number shown above, followed by what is confirmed versus what is only suggested.

For every figure, show the code or formula so I can reproduce it. Never invent a number. Remind me to upload only data I am allowed to share with this tool.

Customize this prompt

Fill in the variables below to personalize this prompt:

ChatGPT
Claude
Grok
OpenRouter

Model Settings

Recommended Models

ChatGPT Claude Gemini

Temperature

0.7

Max Tokens

2000

Additional Notes

Best for: A staged, checkable read of a real file in a tool that runs code

About this prompt

“Summary, Segments and Trends From an Uploaded File” is a free prompt for ChatGPT in the Deep Research category, 202 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.

It has 3 placeholders to fill in first: {{FILE_DESCRIPTION}}, {{BUSINESS_QUESTION}}, {{KNOWN_ISSUES}}. Use the “Customize this prompt” fields to personalise it before you copy.

Recommended models: ChatGPT, Claude, Gemini.

0 upvotes, sent to an AI tool 0 times, viewed 3 times.

Browse all Deep Research prompts, the AI prompt database or use the AI prompt finder to search every prompt.