https://lowcostwallchargeripod.blogspot.com/2023/05/transpose-dataframe-pandas-and-add-new.html