Restructure data frame through aggregation

[andresrcs]

Since you have experience with python I think you are familiar with the concept of a minimal reproducible example, could you please turn this into one?

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

In the meanwhile, you can take a look into tibbletime package for time aggregation and, into tidyr package for gathering your data into a wide format.