CODEWITHSUNDEEP
pythonpandasdataframe
King
King

Reputation: 962

Pandas - Selecting multiple dataframe criteria

I have a DataFrame with multiple columns and I need to set the criteria to access specific values from two different columns. I'm able to do it successfully on one column as shown here:

status_filter = df[df['STATUS'] == 'Complete']

But I'm struggling to specify values from two columns. I've tried something like this but get errors:

status_filter = df[df['STATUS'] == 'Complete' and df['READY TO INVOICE'] == 'No']

It may be a simple answer, but any help is appreciated.

Upvotes: 1

Views: 208

Answers (3)

JMat
JMat

Reputation: 737

you can use:

status_filter = df[(df['STATUS'] == 'Complete') &  (df['READY TO INVOICE'] == 'No')]

Upvotes: 0

A.Kot
A.Kot

Reputation: 7893

Your code has two very small errors: 1) need parentheses for two or more criteria and 2) you need to use the ampersand between your criteria:

status_filter = df[(df['STATUS'] == 'Complete') & (df['READY TO INVOICE'] == 'No')]

Upvotes: 3

ℕʘʘḆḽḘ
ℕʘʘḆḽḘ

Reputation: 19375

status_filter = df.ix[(df['STATUS'] == 'Complete') & (df['READY TO INVOICE'] == 'No'),]

ur welcome

Upvotes: 1

Related Questions