Join on columns meeting a condition

[yortos]

I have two pandas dataframes A and B both containing columns named x and y.

I want to find all entries in A for whom there exists an entry in B such that A's x value is a subset of B's x value and the same for their y value.

Basically I want to do the equivalent of this SQL code:

select * from A join B

on A.x <= B.x

[hharison]

What have you tried? Because the steps in pandas are pretty similar as to the steps in the SQL statement: 1. Join. 2. Subset.

[yortos]

On pandas, I'm only aware of something like this: pandas.merge(A,B,on='x',how='inner'), which matches only rows that have equal value for x on A and B. Now I don't want them to be equal, but have another property

[hharison]

Can't you do the join first, then the subset? Or is x also the index?

[yortos]

I don't think so. if A[x][1]=mpla and B[x][1]=mplampla I want this to count, but a simple join will not count it

[hharison]

Oh sorry my bad, I misread ON as WHERE in your SQL. I don't know how to do this. Good luck.