Pandas 3 Filter Observations

Question 1

A Filter is a way to

Answer 1

Pick out a subset of rows

Question 2

Method to find row by specific index value

Answer 2

Loc[] — note the brackets, loc is more like a retrieving a value from a dictionary than calling a method

Pass index value
DF.loc[119]

Or

Multiple rows:
DF.loc[119, 1886, 925]

Question 3

When using loc[] you may also pass which specific columns to include

Answer 3

DF.loc[119, [‘name’, ‘pos’, ‘stdev’]]

Question 4

How is loc[] most commonly used?

Answer 4

By using boolean indexing, which is passing a series of boolean values and the method returns rows which are true

is_a_rb = df[‘position’] == ‘RB’
DF.loc[is_a_rb, [‘name’, ‘position’]