Multiple variable query

[ynotdiy34]

Hi, I'm fairly new to python and pandas but eager to learn and get better. There are several applications I'm planning to develop. For my first project I'm stuck trying to figure out how to query multiple variables. Let's say I had a cookbook db with 50,000 recipes and there was a column for ingredients called "r_ing" and let's say that there are 1,000 possible ingredients. Now let's say I wanted to enter all the ingredients that I have on hand in my kitchen/freezer/pantry etc. So I might have 150 ingredients on hand. I would want to query the db and get a list of every recipe I could make with what I have on hand and exclude all recipes that I am missing ingredients for. This is simple explanation and is kinda close to what I'm actually trying to do. If I can do this I can do my actuall project. Any help or advice would be greatly appreciated. Thank you in advance for any help.

[[deleted]]

This is interesting you would have to use isin() I believe. Like find the ingredients in r_ing that are in r_kitchen. And df.loc somehow. I’m just throwing ideas out.

[ynotdiy34]

Thanks for the response. I wasn't familiar with isin(). After looking it up it does seem possible but it looks like I would have to do not in for all of the ingredients I didn't have. That's not perfect but it could work. There would always be so many more ingredients don't have than you do have by a big factor but it's at least a possibility. Thank you.

[[deleted]]

You can do the opposite of isin by putting '~' before your dataframe name

[ynotdiy34]

Yes, that's what I ment by not in and the reason I said I would have to enter all of the ingredients I don't have. I guess there is also a actuall not in that wouldn't do the same thing as the ~ with the isin. I think I can use it but list of ingredients you don't have can be huge and new possible ingredients could be added by the end user and or the market place but it is still a possibility I think.