xxxxxxxxxx
df = pd.merge(left=df1, right=df2, on=['var_1', 'var_2'], how='inner']
xxxxxxxxxx
SELECT *
FROM flights
INNER JOIN airports
ON ((airports.code = flights.fairport)
AND (airports.code = flights.tairport))
xxxxxxxxxx
SELECT *
FROM flights
INNER JOIN airports
ON ((airports.code = flights.fairport)
AND (airports.code = flights.tairport))