I have a two pandas dataframes (df1,df2) with id as primary key and number as column, i need to inner join them and using a condition as well. Below is the SQL Version of the code which we required in pandas.
Select * from table_1 a Join table_2 b On a.id=b.id And a.number < b.number
Can someone help me in getting the above sql version in pandas code?