title: Taking second-by-second data and transforming it into hour-by-hour?
body: <p>So, I have a dataset that contains values sampled every second.</p>
  
  <p>I would like to transform the above dataset that has the second-by-second data, so that it is indexed every hour.  And the value at each hour is the running sum total through the day.</p>
  
  <p>I haven't been able to find anything similar in my searches, so if anyone could point me in the best direction to find out the best method to accomplish this; it would be greatly appreciated!</p>