0 votes
I have a dataset with minute pricing data, I want to take the average of these rows and create 1 single new row. So instead of 60 rows  (with minute interval) per hour I want an aggregated 1 row per hour. What is the best way to do this?

edit: found the answer, made a column for day, month and hour based on timestamp and used the group feature to group them.
closed with the note: resolved
by
reshown by
1,169 questions
1,204 answers
1,349 comments
11,694 users

┬ęDataiku 2012-2018 - Privacy Policy