Check out example codes for "SQL joins in python". It will help you in understanding the concepts better.

Code Example 1

This was What I intended
 ID Case NxtCase
 1    A        
 2    C        
 3    E      

This is my desired result

 ID Case NxtCase
 1    A        B
 2    C        D
 3    E        F

Learn ReactJs, React Native from akashmittal.com