I am working on transferring pyspark code to python. In that process i have landed into a challenge wherein i have the below code in spark sql which i need to change to python
select b.id as tno, a.* from dfrno a, dft b where a.v = b.v1 and (a.rno >= b.start_rno and a.rno <= b.end_rno)
Since i am new to python i am not sure how to go about this. And i am eager to understand the methodology since this would be quite interesting. I can use only native python packages. I tried to split this into two steps and complete but the join will effectively do the job only with the >= <= condition. It would be of great help if you can get this resolved. Below is pictorial representation of the tables and the output required. Thanks
