Subsetting by row/column number
The most common ways to subset rows are the ways we've previously discussed: using a Boolean condition or by index labels. However, it is also occasionally useful to pass row numbers.
This is done using .iloc[]
, and like .loc[]
, it can take two arguments to let you subset by rows and columns.
pandas
is loaded as pd
. temperatures
(without an index) is available.
This exercise is part of the course
Data Manipulation with pandas
Exercise instructions
Use .iloc[]
on temperatures
to take subsets.
- Get the 23rd row, 2nd column (index positions 22 and 1).
- Get the first 5 rows (index positions 0 to 5).
- Get all rows, columns 3 and 4 (index positions 2 to 4).
- Get the first 5 rows, columns 3 and 4.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Get 23rd row, 2nd column (index 22, 1)
print(____)
# Use slicing to get the first 5 rows
print(____)
# Use slicing to get columns 3 to 4
print(____)
# Use slicing in both directions at once
print(____)