from pandas import read_csv, DataFrame
teaching = read_csv("../data/teaching.csv", sep="\t")
teaching["Total"] = teaching["Sections"] * teaching["Hours"]
teaching["Total"].sum()
201.8
df = teaching[["Format", "Total"]].groupby("Format").sum().sort_values(by="Total", ascending=False)
df.plot(kind="bar")
<AxesSubplot:xlabel='Format'>
df = teaching[["School", "Total"]].groupby("School").sum().sort_values(by="Total", ascending=False)
df.plot(kind="bar")
<AxesSubplot:xlabel='School'>
levels = ["Undergraduate", "Graduate", "Workforce Training", "Grades 6-8", "Grades 9-12", "Grades 4-6", "Grades 7-10"]
totals = [teaching[teaching["Level"].str.contains(level)]["Total"].sum() for level in levels]
DataFrame({"Total": totals}, index=levels).sort_values(by="Total", ascending=False)
Total | |
---|---|
Undergraduate | 200.0 |
Graduate | 3.0 |
Workforce Training | 0.8 |
Grades 6-8 | 0.0 |
Grades 9-12 | 0.0 |
Grades 4-6 | 0.0 |
Grades 7-10 | 0.0 |
topics = ["Ethics", "Writing", "Programming", "Networking", "Web", "Database", "Office", "Security", "Data Science", "Research and Data Analysis"]
totals = [teaching[teaching["Topic"].str.contains(topic)]["Total"].sum() for topic in topics]
df = DataFrame({"Total": totals}, index=topics).sort_values(by="Total", ascending=False)
df.plot(kind="bar")
<AxesSubplot:>
My students:
Clarify:
Provide these answers in a way that's: