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,221 questions
1,249 answers
1,413 comments
11,783 users

┬ęDataiku 2012-2018 - Privacy Policy