0 
0 It is such a small thing. That you can look for in the docs, no Stackoverflow and in many blog articles. After I have used groupby on a Data Frame, instead of getting a Series result, I would like to turn the result into a new Data Frame [to continue my manipulation, querying, visualization etc.]. I feel at home in Data Frames and so do my tools and libraries. It took me a while – and a useful post on StackOverflow – to get things straight.
So here it goes. After my groupby, I use to_frame() to create a new Data Frame based on the result of the groupby operation. I use the parameter name to define the name for the column that holds the result of the aggregation (the mean value in this case)
# resample per quarter, (grouping by) for each weekday grouper = d.groupby([pd.Grouper(freq='1Q'), 'weekday']) # create a new data frame with for each Quarter the average daily death index for each day of the week (again, between 0.9 and 1.1) d2 = grouper['relative30DayCount'].mean().to_frame(name = 'mean').reset_index()
In pictures. First my original data frame:
Just applying the groupby with the grouper – in order to aggregate over each Quarter of data grouped by day of the week – gives me a Series object:
However, by applying to_frame() I get the shiny new Data Frame I was after:
Related posts:
The Full Oracle OpenWorld and CodeOne 2018 Conference Session Catalog as JSON data set (for data science purposes) 
Tour de France Data Analysis using Strava data in Jupyter Notebook with Python, Pandas and Plotly – Step 1: single rider loading, exploration, wrangling, visualization 
Tour de France Data Analysis using Strava data in Jupyter Notebook with Python, Pandas and Plotly – Step 2: combining and aligning multi rider data for analyzing and visualizing the Race 
Downsizing the Data Set – Resampling and Binning of Time Series and other Data Sets 
Dissecting Dutch Death Statistics with Python, Pandas and Plotly in a Jupyter Notebook
Thank you for the post, I have a question. How can I split the data after groupby in a way that each dataframe represents a group. For example, I have a dataframe with data from NYC, DC, CF and I want to turn it into 3 individual dataframes for each state
Hi Ghazal, I am afraid I do not have an immediate answer nor currently time to investigate. kind regards and good luck, Lucas
I’ve been looking for this all day. Thank you for saving me a few hours of hair pulling!
HI Phil, thanks for letting me know. Nice to hear! Lucas
Best Kept Secret on Groupby I have found………
Exactly what I was looking for..
Thanks
Great to hear from you. I am glad my article helped you out. Thanks for letting me know. kind regards, Lucas