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 filter a table on a value: a city, a product.
Space: play · ← →: 5 seconds · M: sound · F: full screen
The exact sequence, in order.
Type df[df["city"] == "Lyon"]: two equals signs to compare.
Shift + Enter: 68 rows, the count is written under the table.
Same move for a product: df[df["product"] == "Atlas Refill"].
Shift + Enter: 77 rows.
The habit to keep
Write the column name and the value exactly as they are in the file.
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.
040:22You add a calculated column, then get the total and the average.
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.