Catalogue · First steps in Python and SQL, with AI

Load a CSV file

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

JupyterLiteBeginner0:24Capsule 2 of 12

SkillKapsul

The steps

The exact sequence, in order.

01
Drag the CSV file into the left panel.
02
Type import pandas as pd, then Shift + Enter.
03
Type df = pd.read_csv("atlas_sales.csv").
04
Type df.head() for the first five rows, then df.shape for the size: (312, 10).

The habit to keep

Always look at the first rows and the size before you calculate.

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

Keep only the rows you need

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

JupyterLiteBeginner

Add a calculated column and a total

You add a calculated column, then get the total and the average.

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.