import pandas as pd df = pd.read_csv("input.csv", sep='\s+') dfdf.melt(id_vars=["location", "name"], var_name="date", value_name="value")