access rows that are found in two columns

Question

from the image, how do access rows that are expensive and too old?

"dataset[dataset['Price_description']=='Expensive' & dataset['Car_health']=='Too old']"

that was my code but its wrong, please try and correct me

score 0 · Answer 1 · answered Mar 29 '22 at 12:09

0

You need to wrap the two equality statements in parentheses:

dataset[(dataset['Price_description']=='Expensive') & (dataset['Car_health']=='Too old')]

Or use eg:

dataset[dataset['Price_description'].eq('Expensive') & dataset['Car_health'].eq('Too old')]

answered Mar 29 '22 at 12:09

mozway

Can you convert to wiki? – jezrael Mar 29 '22 at 12:10
@jezrael sure if it makes you happy ;) – mozway Mar 29 '22 at 12:11
Only surprise why not closed. – jezrael Mar 29 '22 at 12:11
1

Because it was faster to answer than searching for a potential dupe. I close most of the ones for which I know what to search for – mozway Mar 29 '22 at 12:12
check my profile, there are most repeated dupes. – jezrael Mar 29 '22 at 12:12
@jezrael I know, it's just something I make the effort to search, sometimes not. But I feel that you're doing also the same (example: [yours](https://stackoverflow.com/a/71657581/16343464) and [dupe](https://stackoverflow.com/questions/62721565/split-the-data-frame-based-on-consecutive-row-values-differences), I picked one but there are many others) ;) – mozway Mar 29 '22 at 12:16
yes, please give me know, because I sometimes failed too. – jezrael Mar 29 '22 at 12:17
dupe failed, because non numeric column. – jezrael Mar 29 '22 at 12:20
I am sure there is one, it's so common, just lazy to search – mozway Mar 29 '22 at 12:21
If close like dupe and there is my answer, please let me know it for wiki answer. – jezrael Mar 29 '22 at 12:22
it's not really my way, I don't want to "police" – mozway Mar 29 '22 at 12:23
hmmm, it is up to you. But for me is sad if blatant dupe answers are answered high rep users(sometimes also by me). So I am grateful for closing and feedback. – jezrael Mar 29 '22 at 12:25

1 Answers1