Homework $7$

This homework$/$notebook demonstrates the use of aggregate functions in Pandas data frames

$($similar to GROUP BY clause in SQL$).$ The objective of this homework is for you to be able to

write aggregate functions and create a simple bar chart.

Homework Instructions

Start Jupyter Notebook and upload Homework$-7.$ ipunb notebook. Read, understand, and rum the

code in each cell. Besides many other examples, this notebook shows top five occupations $($by

percentage$)$ for men in the total worlforce. The output shows a listing in tabular form as well as

a bar chart for the top five male occupations.

Your task is to add additional cells at the end of this notebook where you should write necessary

code to do the following two things: $(1)$ Generate a tabular output that shows top seven

occupations for females, and $(2)$ Generate a bar chart that shows the same information

graphically. Please notice the labels for the chart and its two axes $-$ your chart's title and sub$-$title

should be modified appropriately and include your own name.

What to Submit

Make two screenshots as below, paste them in a Word document, and submit the Word

document containing your full name at the top of the document.

$(1)$ A screenshot of the code, together with its tabular output for top $7$ female occupation

percentages $($see an example below, though it's for males and shows top five occupations$).$Ra$\}$e ogeupet Lons $=$ E$.$sort walves$\backslash$secendLng $=$ ralse$),$ hesdC$)$

deeter $\backslash 6\%$ $$00000$

engLneer $\backslash 7,814925$

teahniedan $36.$a$$6206$

ret$\backslash$red $\backslash 2\mathrm{.}85\%148$

progranrex $30\mathrm{.}365052$

dtyper $\{$loats$4(2)$ A screenshot of the code and its chart output for top $7$ female occupation percentages in the

workforce $($see an example below, though it's for males and shows top five occupations$).$of olker tale past

YoL.alur$-1$