data2 = data
.select(0, 2, 3, 4)
.rename({
"El Masnou": "El_Masnou",
"Premià de Mar": "Premia_Mar",
"Vilassar de Mar": "Vilassarde_Mar"
})
.derive({
YEAR: aq.escape((d) => parsedate(d.ANY))
})
.fold(["El_Masnou", "Premia_Mar", "Vilassarde_Mar"], {
as: ["CITY", "values"]
})
.objects()