How do I select the pandas rows with certain conditions?

Question

I have a pandas frame called df, I wish to select only the rows which have some conditions.

I have one column called 'Country' and one called 'Type'.

I want to select all the rows in which the 'Country' says "South Korea" and the 'Type' is not empty.

I tried the following code df = df[df['Country'] == 'South Korea' & ~df['Type'].empty()]

But I get the following error, TypeError: 'bool' object is not callable. How do I select the rows with the conditions I want?

Does this answer your question? [How to select rows from a DataFrame based on column values?](https://stackoverflow.com/questions/17071871/how-to-select-rows-from-a-dataframe-based-on-column-values) — mechanical_meat, Apr 24 '20 at 21:55

Scott Boston · Accepted Answer · 2020-04-24T22:03:15.400

1

Try using paranthesis and notna:

df = df.loc[(df['Country'] == 'South Korea') & (df['Type'].notna())]

edited Apr 24 '20 at 22:03

answered Apr 24 '20 at 21:53

Scott Boston

now it says TypeError: cannot compare a dtyped [bool] array with a scalar of type [bool] – anarchy Apr 24 '20 at 21:54
That is a strange error. What does type(df) return? – Scott Boston Apr 24 '20 at 21:56
when i separate the commands, it works, but when I try to combine them it doesnt, ive never had this happen before – anarchy Apr 24 '20 at 22:01
Are you using the word "and' Or the "&" ampersand symbol? And the paranthesis are necessary. – Scott Boston Apr 24 '20 at 22:02
im using & if I use 'and' i get this error ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all(). – anarchy Apr 24 '20 at 22:03
if i add .loc i get TypeError: cannot compare a dtyped [bool] array with a scalar of type [bool] – anarchy Apr 24 '20 at 22:04
This error is happening on a different line of code. – Scott Boston Apr 24 '20 at 22:05
You have to have df.loc[(Condition1) & (condition2)]... You must use paranthesis and the & symbol. – Scott Boston Apr 24 '20 at 22:06
1

haha that solved it, i was missing the parenthesis on the first condition, thanks!, I totally didnt notice it. – anarchy Apr 24 '20 at 22:11

1 Answers1