Hilltop turns multiple values for the "extrema" method: The results are sent as six item data, and the order of the items is min, mean, max, the amount of missing record, and then the times of the minimum and maximum values.
Current whurl behaviour is that the first column (i.e. minimum) gets renamed to the measurement, while the others have generic unhelpful "I2-6" labels.
Recreate:
max_data = client.get_data(
site=site,
measurement=measurement,
from_datetime="2025-01-01T00:00:00",
method="Extrema",
interval="1 day"
)
example current output (as dataframe):
Water Temperature I2 I3 ... I6 Site DataSource
DateTime ...
2025-01-01 15.87 18.665990 19.61 ... 2024-12-31T15:15:00 Manawatu at Teachers College Water Temperature
2025-01-02 15.61 16.0117188 16.47 ... 2025-01-01T16:15:00 Manawatu at Teachers College Water Temperature
2025-01-03 15.70 16.524635 17.68 ... 2025-01-02T23:00:00 Manawatu at Teachers College Water Temperature
2025-01-04 16.69 17.7325 18.96 ... 2025-01-03T17:00:00 Manawatu at Teachers College Water Temperature
Hilltop turns multiple values for the "extrema" method: The results are sent as six item data, and the order of the items is min, mean, max, the amount of missing record, and then the times of the minimum and maximum values.
Current whurl behaviour is that the first column (i.e. minimum) gets renamed to the measurement, while the others have generic unhelpful "I2-6" labels.
Recreate:
example current output (as dataframe):
Water Temperature I2 I3 ... I6 Site DataSource
DateTime ...
2025-01-01 15.87 18.665990 19.61 ... 2024-12-31T15:15:00 Manawatu at Teachers College Water Temperature
2025-01-02 15.61 16.0117188 16.47 ... 2025-01-01T16:15:00 Manawatu at Teachers College Water Temperature
2025-01-03 15.70 16.524635 17.68 ... 2025-01-02T23:00:00 Manawatu at Teachers College Water Temperature
2025-01-04 16.69 17.7325 18.96 ... 2025-01-03T17:00:00 Manawatu at Teachers College Water Temperature