These are chat archives for FreeCodeCamp/DataScience
discussion on how we can use statistical methods to measure and improve the efficacy of http://freeCodeCamp.com
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