These are chat archives for FreeCodeCamp/DataScience

27th
Jan 2019
TJ-coding
@TJ-coding
Jan 27 13:13
I see
Simey de Klerk
@simeydk
Jan 27 19:32

Hi Everyone. I have a question about doing a complex join in Pandas.
In SQL I would do it as follows:

SELECT * FROM A LEFT JOIN B on (A.PROD_ID in (B.PROD_ID, "*") and A.PRICE >= B.MIN_PRICE

How would I do this in Pandas? If you could point me in the right directino wrt where to read up or what to Google for this what would be great, too