Skip to content

Instantly share code, notes, and snippets.

@breeko
Created March 24, 2018 02:02
Show Gist options
  • Select an option

  • Save breeko/83820e891b74de2f38d15eeeb753990f to your computer and use it in GitHub Desktop.

Select an option

Save breeko/83820e891b74de2f38d15eeeb753990f to your computer and use it in GitHub Desktop.
gb_all = df.groupby("GRADE").GRADE.agg(["count"])
gb_all["perc"] = gb_all / gb_all.sum() * 100
gb_recent = df.drop_duplicates("KEY").groupby("GRADE").GRADE.agg(["count"])
gb_recent["perc"] = gb_recent / gb_recent.sum() * 100
gb_all = gb_all.join(gb_recent,lsuffix=" all", rsuffix=" most recent")#
gb_all[["perc all", "perc most recent"]].plot(kind="bar")
gb_all.style.format("{:,.2f}")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment