How to convert a pandas GroupBy to a DataFrame

By -



# Create a new DataFrameGroupBy object that groups the data by registration year
group_by_years = df.groupby(df["month"].dt.year)
# Let's count how many rows are there in each year
group_by_years_count = group_by_years.count()
# We have too many columns to display, let's reduce the number of columns to just one
group_by_years_count = group_by_years_count[["month"]]
# rename the column so it looks more proper on the barplot later
group_by_years_count.rename(columns={'month':'count'},inplace=True)
group_by_years_count.reset_index(inplace=True)
df_new = group_by_years_count.apply(list).apply(pd.Series)
df_new.columns = ['month', 'count']

Comments

Post a Comment

Popular posts from this blog

How to create an organizational chart in your webpage using Google Organization Chart Tools

By Dora -
Image
https://developers.google.com/chart/interactive/docs/gallery/orgchart While googling for some information on organizational charts of various companies, I came across this cool visualization tool on Google Developers. If you are comfortable with JavaScript and want a quick and easy way to churn out a simple organizational chart that displays on a webpage, this tool is quite useful. Organizational chart churned out using Google's Visualization OrgChart object To use it, follow these few steps Step 1: Include this tag in your <head> tag in your HTML file <script type = 'text/javascript' src = 'https://www.google.com/jsapi' ></script> Step 2: Load visualization package and set callback method when page loads In this case, the callback method is "drawChart". <script type = 'text/javascript' >       google . load ( 'visualization' , '1' , { packages :[ 'orgchart' ]});     ...
Read more

How to remove “Git” from Windows 7 context menu

By Dora -
Image
Click “Start->Run->cmd” to open up a command prompt window Type the following commands in the command prompt Technorati Tags: Git , Windows 7 , context menu You should see the above "success" message to inform you that the DLL has been unregistered and you should no longer see the "Git" menu items on your context menu
Read more

How to add Diggit, Technorati, Del.icio.us, Stumbleupon, Reddit and pInterest buttons to your Blogger posts

By Dora -
Image
Here's how you can add a row of social media sharing buttons all at one go :) Step 1 Locate the <data:post.body/> code in the HTML template. Step 2 Copy and paste the code below just after the  <data:post.body/> tag. <!--Digg--> <a expr:href='"http://digg.com/submit?phase=2&amp;url=" + data:post.url + "&amp;title=" + data:post.title' target='_blank'><img src="https://sites.google.com/site/mydesiowfamily/Home/diggit.png" border="0"/></a> <!--Technorati--> <a expr:href='"http://technorati.com/faves?add=" + data:post.url' target='_blank'><img src="https://sites.google.com/site/mydesiowfamily/Home/technorati.png" border="0"/></a> <!--Del.icio.us--> <a expr:href='"http://del.icio.us/post?url=" + data:post.url + "&amp;title=" + data:post.title' target='_blank'...
Read more