Back to guide/Research & Analysis

CSV Data Analysis

Analyze CSV data — identify quality issues, suggest analyses, and get working code with plain-English explanations.

data-analysiscross-modelpython
Edit View
Prompt
I have a CSV file with these columns: {{columns}}
Sample rows:
{{paste 3-5 sample rows}}

Tasks:
1. Identify data quality issues (missing values, outliers, inconsistent formats)
2. Suggest 3 interesting analyses I could run on this data
3. Write {{language}} code to perform the most impactful analysis
4. Explain what the results would tell me in plain English

Assume I have pandas/numpy available if using Python.

Variables to customize

{{columns}}{{paste 3-5 sample rows}}{{language}}

Why this prompt works

Sample rows give both models concrete data to work with instead of guessing. The plain English explanation step ensures you understand the output.

Save this prompt to your library

Organize, version, and access your best prompts across ChatGPT, Claude, and Cursor.