Catalogue · First steps in Python and SQL, with AI

Totals by store

You total sales by store and rank them from largest to smallest.

JupyterLiteIntermediate0:16Capsule 5 of 12

SkillKapsul

The steps

The exact sequence, in order.

01
Type by_store = df.groupby("store")["amount"].sum().
02
Type by_store.sort_values(ascending=False).
03
Shift + Enter: Lyon Croix-Rousse on top with 2016.0.
04
Nantes Talensac brings up the rear with 637.0.

The habit to keep

groupby groups, sum adds up, sort_values ranks.

Related capsules

You might also like

JupyterLiteBeginner

Open JupyterLite and run your first line

You open a Python notebook in your browser, with no account and nothing to install, and run your first cell.

JupyterLiteBeginner

Load a CSV file

You load a sales export with pandas and see its first rows and its size.

JupyterLiteBeginner

Keep only the rows you need

You filter a table on a value: a city, a product.

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.