Filtering data using Pandas .loc function

Question

I have a df of car miles per gallon data, which are int (as far as I can tell).

Using Pandas, I'm filtering with df.loc[(df['Horsepower'] >90)] which is giving me the results I expect - cars with >90 horsepower. But when I try adding a second filter, I get the below error.

>> df.loc[(df['Horsepower'] >90)] & (df['Weight']< 4500)

TypeError: unsupported operand type(s) for &: 'float' and 'bool'

Is it a syntax issue or am i missing something bigger??

Jaroslav Bezděk · Accepted Answer · 2021-05-24 10:45:18Z

5

You have got typo in your code. The brancket ] has to be at the end of the filter:

df.loc[(df['Horsepower'] >90) & (df['Weight']< 4500)]

answered May 24, 2021 at 10:45

Jaroslav Bezděk

7,7156 gold badges34 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Filtering data using Pandas .loc function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related