I have a dataframe that looks like:
enter image description here

I would like to have all the rain and temperature data in 2 seperate columns

enter image description here

I have tried to transpose the data, but that made the multiple duplicates of the titles.

Source: Python Questions