Melt Pandas DataFrame with Multiple Headers Whose Values Are Not Static Using Various Approaches

Manipulating Data Frames to Consolidate Relevant Values in R Using Tidyverse