Pandas Inner Join Outer Left Right Cross Join

[@sketchytv1321]

awesome need more

[@אלכסנחשונוב-פ5ע]

Thank you for the great explanation,
How would you implement a join condition different than equal, like for example ">=" or usign case in the join condition like we do in sql?
Thanks