Code Interpreter Analysis

Prompt patterns for ChatGPT Code Interpreter data analysis. Upload files and describe analysis in plain language — Code Interpreter runs actual Python and returns exact computed results, charts, and downloads.

Syntax

chatgpt

# Basic analysis:
Analyze this [CSV/Excel/JSON]:
1. Shape, data types
2. Missing values — count and %
3. Basic statistics for numeric columns
4. [Specific analysis]
Export result as [format].

# Chart:
Create [chart type] showing [data].
X: [column] Y: [column]
Title: "[title]"
Export PNG at 300 DPI.

# Precision calculation:
[Describe calculation exactly]
Show formula and intermediate steps.

Example

chatgpt

# Sales retention heatmap:
For this sales CSV:
- customer_id, purchase_date, order_value

Calculate monthly cohort retention:
- Cohort size at month 0
- Retention % at months 1, 3, 6, 12
- Heatmap: cohorts as rows, months as columns
- Green >60%, yellow 30-60%, red <30%
- Export raw table as CSV

# CAGR calculation:
CAGR: Start $50,000 → End $183,700, 13 years
Then: year-by-year projection for 10 more years
at the same rate.