Track 14 · Lesson 5 of 12

Selecting and filtering

Pick rows and columns by label with loc and by position with iloc, filter rows with conditions or query, and sort the result.

You will be able to

• Select rows and columns by label with .loc and by position with .iloc
• Filter rows with boolean conditions, isin and between
• Write the same filter with DataFrame.query
• Sort by one or more columns and take the top rows
• Change values in place with .loc instead of chained indexing