https://www.somethingsblog.com/2024/10/22/mastering-pandas-dataframe-joins-a-comprehensive-guide/