Amazon Q Prompts for Data Scientists
Data scientists need help writing and debugging pandas or SQL, choosing and checking statistical methods, and explaining results to people who will make decisions from them. These Amazon Q prompts start from that: fill in your situation once and reuse it. The worked example below is a debugging task, one of the most common for data scientists.
I'm a data scientist and need help with [task, e.g. data analysis and visualization]. What I have: - [the material involved: code, draft, notes or data] What a good result looks like: - [the outcome and its format] Ask me one clarifying question if something important is missing, then give the result. About my work - Data shape and types: [e.g. 2M rows, columns: user_id, signup_date, plan, churned (bool)] - Tools and environment: [e.g. Python 3.11, pandas 2, scikit-learn, Jupyter] - Question the analysis must answer: [e.g. which plan features predict churn in the first 90 days] Context - Reference material: [paste it below, or attach the file]
How to use this prompt
- 1
Open Amazon Q
Open Amazon Q in your IDE or the AWS console and paste the prompt.
- 2
Give it context
Name the AWS services, regions and resources involved, and paste the relevant code or configuration.
- 3
Review and iterate
Ask follow-ups in the same chat, and test changes in a non-production account first.
Working in Amazon Q
- •Amazon Q is built for AWS work, so name the services (for example Lambda, S3, IAM) your question involves.
- •Never paste credentials or secret values; describe the IAM setup instead.
- •For infrastructure changes, ask for the change as code (CloudFormation, CDK or Terraform) so you can review it.
Example task: Debugging
What you give it
Symptom: add_tag returns tags from earlier calls. Calling add_tag("a") then add_tag("b") gives ["a", "b"] on the second call instead of ["b"].
Environment: Python 3.11, local script.
def add_tag(tag, tags=[]):
tags.append(tag)
return tags
What changed: nothing, it has always done this.What a good answer looks like (shortened)
1. Mutable default argument (very likely). The list [] is created once, when the function is defined, and every call without a tags argument reuses that same list.
Check: print(id(tags)) inside the function. If the id is the same on every call, this is the cause.
2. A caller is passing the same list in each time (less likely, since the calls you showed pass only one argument).
Check: search for calls to add_tag that pass a second argument.
Run check 1 first. If confirmed, the fix is:
def add_tag(tag, tags=None):
if tags is None:
tags = []
tags.append(tag)
return tagsTips for better results
- •Describe the data with df.dtypes and a few sample rows (with sensitive values removed) instead of words. The AI writes far more accurate code when it sees real column names and types.
- •Name the AWS services, regions and resources involved, and paste the relevant code or configuration.
- •Check this before you use the output: verify that suggested methods fit your data's assumptions, and watch for data leakage between training and test sets in any modeling code.
Check before you use it: Verify that suggested methods fit your data's assumptions, and watch for data leakage between training and test sets in any modeling code.
Get the free prompt pack
Our best coding prompts in one Markdown file, delivered by email. The templates here stay free either way — the pack just saves you the copying.
Variations
Task
Debugging: Replace the first line with: Help me debug a problem. I want to find the cause, not just patch the symptom.
Intermittent bug
Add this line to Symptom: It only happens [e.g. 1 in 20 requests, under load, after midnight UTC]. Focus on timing, concurrency and caching causes.
Second task
Change the task line to: [Building ML models].
Save it as a Retext snippet
Retext is a free text expander for Mac. Save this prompt once, then type ;data-amazon in any app (ChatGPT, Claude, your editor, a browser tab) and the full prompt is pasted in.
- Click Add to Retext. The prompt installs as a snippet with the trigger ;data-amazon.
- Change the trigger in Retext if you prefer a different one.
- Type the trigger wherever you want the prompt, then fill in the brackets.
Frequently asked questions
Can AI choose the right statistical test for my data?
It can suggest options and explain their assumptions, which is a useful check. You still need to confirm the assumptions hold for your data, like independence, sample size and distribution.
Is this prompt only for AWS projects?
Amazon Q is most useful when the work involves AWS services. The prompt still works for general code, but say what stack you use.
What should I leave out of the prompt?
Access keys, secrets and customer data. Describe permissions and resources by name instead.
How do I reuse this prompt without copying it every time?
Click Add to Retext to save it as a snippet. Then type ;data-amazon in any Mac app, including your AI tool, and the full prompt is pasted in.
Related Templates
Get the free prompt pack
Our best coding prompts in one Markdown file, delivered by email. The templates here stay free either way — the pack just saves you the copying.