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
reshown by
1,322 questions
1,341 answers
11,889 users

©Dataiku 2012-2018 - Privacy Policy