I have one the dataframe that has the following columns:
| Region | ProductName | Quantity | Sales | Discount |
|---|---|---|---|---|
| South | dust filter Hoover MaxExtract PressurePro model 60 | 3 | 114.90 | 0 |
and the other one looks like this
| Region | Person |
|---|---|
| South | Andrea |
SELECT Orders.Region, Orders.ProductName,
FROM Orders
INNER JOIN People ON Orders.Region != People.Region;
My point is that I'd like to perform the join while specifying multiple clauses and using operators like (<,>,<=,>=...) but I don't know how to do that with the pandas methods capable of doing that join, I know that with the clause
ON Orders.Region == People.Region
this piece of code will do the job
df = lista[0].merge(right = lista[1])
but how can I do, for example
ON Orders.Region > People.Person
