User 1129 | 2/9/2016, 10:24:38 AM
Consider two data frames:
I would like to do a left join the two data frames such that their
x columns match AND their
y columns don't. Right now, I perform this in two steps:
tmp = a.join(b, on='x', how='left')
result = tmp[tmp['y'] != tmp['y.1']]
The problem is that in real life situations, the intermediate table is much larger that the desired final result. Is there a way to achieve this effect in one command, without the need to create a temporary object?