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(____)