slice the dataframe into intervals for statistical analysis | python
You have relational data and want to perform aggregations. What about using a relational database with the appropriate model to link everything together and compute the aggregations?
after have found this question and answers for them on StackExchangehttps://softwareengineering.stackexchange.com/questions/235707/using-a-relational-database-vs-json-objects-for-event-activity-data
I realized that staying on dataframes with pandas instead of using json-objects could be the best solution for the type of data I have