010:28Open 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.
Catalogue · First steps in Python and SQL, with AI
You add a calculated column, then get the total and the average.
Space: play · ← →: 5 seconds · M: sound · F: full screen
The exact sequence, in order.
Type df["amount"] = df["quantity"] * df["unit_price"].
Type print(df["amount"].sum()): 14976.0.
Type print(df["amount"].mean()): 48.0, the average basket.
Note these two numbers: you’ll use them to check.
The habit to keep
Keep a known number to check the next calculations.
You might also like
010:28You open a Python notebook in your browser, with no account and nothing to install, and run your first cell.
020:24You load a sales export with pandas and see its first rows and its size.
030:26You filter a table on a value: a city, a product.
Newsletter
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.