loc for label-based selection in Pandas - Step-by-Step Execution

Concept Flow - loc for label-based selection

Start with DataFrame

↓

Use .loc with row labels

↓

Use .loc with column labels

↓

Extract subset DataFrame

↓

Use result for analysis or display

The flow shows selecting rows and columns by their labels using .loc, then extracting the subset for use.

Execution Sample

Pandas

import pandas as pd

df = pd.DataFrame({
  'A': [10, 20, 30],
  'B': [40, 50, 60]
}, index=['x', 'y', 'z'])

subset = df.loc['y', 'B']

This code creates a DataFrame with labels and selects the value at row 'y' and column 'B' using .loc.

Execution Table

Step	Action	Input	Output/Result
1	Create DataFrame	{'A':[10,20,30],'B':[40,50,60]}, index=['x','y','z']	DataFrame with rows x,y,z and columns A,B
2	Select with .loc row label 'y'	df.loc['y']	Row with index 'y': A=20, B=50
3	Select with .loc row 'y' and column 'B'	df.loc['y','B']	Value 50
4	Assign to subset	subset = 50	subset holds value 50
5	End	-	Selection complete

💡 Selection stops after retrieving the value at row 'y' and column 'B'

Variable Tracker

Variable	Start	After Step 1	After Step 2	After Step 3	After Step 4	Final
df	undefined	DataFrame with 3 rows and 2 columns	Same	Same	Same	Same
subset	undefined	undefined	undefined	50	50	50

Key Moments - 2 Insights

Why do we use labels like 'y' instead of numbers with .loc?

Because .loc selects by the actual row and column labels, not by position. See execution_table step 2 where 'y' selects the row labeled 'y'.

What happens if we select only one label for row and column with .loc?

It returns a single value, not a DataFrame or Series. See execution_table step 3 where df.loc['y','B'] returns 50.

Visual Quiz - 3 Questions

Look at the execution table, what is the output of df.loc['y'] at step 2?

A Value 50

B Row with A=10, B=40

C Row with A=20, B=50

D Error

💡 Hint

Check execution_table row with Step 2 for the output of df.loc['y']

At which step does subset get assigned the value 50?

A Step 4

B Step 3

C Step 2

D Step 5

💡 Hint

Look at execution_table step 4 where subset is assigned

If we change df.loc['y','B'] to df.loc['z','A'], what value will subset hold?

A 60

B 30

C 20

D 50

💡 Hint

Check the DataFrame values at index 'z' and column 'A' in execution_table step 1

Concept Snapshot

pandas .loc selects data by labels.
Use df.loc[row_label, column_label] to get specific data.
Selecting one row label returns a Series.
Selecting one row and one column label returns a single value.
Labels must match index and column names exactly.

Full Transcript

This visual execution shows how to use pandas .loc for label-based selection. We start with a DataFrame having rows labeled 'x','y','z' and columns 'A','B'. Using df.loc['y'] selects the row labeled 'y' returning a Series with values A=20 and B=50. Using df.loc['y','B'] selects the single value at row 'y' and column 'B', which is 50. This value is assigned to the variable subset. The key point is .loc uses labels, not positions, so the labels must exist in the DataFrame. Selecting one label for row and column returns a scalar value. This method is useful to extract specific data by meaningful labels.