Catalogue · First steps in Python and SQL, with AI

Ask AI for the code, then check it

You get a line of code from Copilot Chat by giving only the columns, then check it against a number you know.

Copilot ChatIntermediate0:33Capsule 11 of 12

SkillKapsul

The steps

The exact sequence, in order.

01
In Copilot Chat, describe the table’s columns, not the data.
02
Read the suggested line before you copy it.
03
Paste it into the notebook under a name: by_product = …
04
Check: print(by_product.sum()) must give 14976.0 again.

The prompt to copy

Word for word, exactly as shown in the video.

I have a pandas DataFrame df with the columns store, product, quantity, unit_price and amount. Write one line of Python that gives the total amount per product as a Series, sorted from smallest to largest.

The habit to keep

Never put data in the prompt, and always keep a check number.

Worth knowing

What the video does not hide from you.

AI can suggest code that runs but calculates something else: the check number shows it.

Related capsules

You might also like

Copilot ChatIntermediate

Understand an error message with AI

You read the last line of an error, have Copilot Chat explain it, and fix it.

Copilot ChatAdvanced

Copilot in Outlook: prepare a leadership committee briefing

You arrive at the meeting with a structured note: agenda, key figures, documents to review, open questions.

Copilot ChatBeginner

What actually needs you this morning

One question gives you the list of what matters today, sorted by deadline.

Newsletter

Monday's capsule

One skill a week, straight to your inbox. The easiest way to keep learning without thinking about it.

Your data stays in the EU. Never sold.