Demonstration of how to summarize minute sensor data by average and max, by hour and day, using a pivot table. Caution: check for gaps in your data, which may not be represented clearly in a pivot table. If you have gaps in your data, use an x-y scatterplot.
