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
| USC00242347 | 2000-01-01 | TMAX | 61 |
| USC00242347 | 2000-01-01 | TMIN | -72 |
| USC00242347 | 2000-01-01 | PRCP | 0 |
| USC00242347 | 2000-01-01 | SNOW | 0 |
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?