Unpivot a DataFrame from wide to long format

import pandas as pd df = pd.read_csv("input.csv", sep='\s+') df

df.melt(id_vars=["location", "name"], var_name="date", value_name="value")