I have a public dataset from a data center and would like to flatten the data.
For example here's a sample:
Station date type value
I would like the data to look like:
USC00342347 2000-01-01 TMAX 61 TMIN -72 PRCP 0 SNOW 0
Essentially I want to aggregate the type and value variables based on the station and date.
How should I do this process?