Hubert-Dudek
Databricks MVP
df.groupBy("date").pivot("Node").agg(first("Temp"))

It is converting to classic crosstable so pivot will help. Example above.


My blog: https://databrickster.medium.com/

View solution in original post