$\{$

"cells": $[$

$\{$

"cell$\_$type": "code",

"execution$\_$count": $2,$

$"$id$"$: $"$c$1$f$833$e$6",$

"metadata": $\{\},$

"outputs": $[],$

"source": $[$

$"$#Assignment $3-05/10/2024$ CIS $2300$

$",$

$"$

$",$

$"$#Name:

$",$

$"$

$",$

$"$#Due Date: $05/17/202311$:$59$ PM

$",$

$"$#All data are found in Course Documents$/$ Class Presentations

$",$

$"$#Please Answer below each question:"

$]$

$\},$

$\{$

"cell$\_$type": "code",

"execution$\_$count": null,

$"$id$"$: $"7$c$32$e$755",$

"metadata": $\{\},$

"outputs": $[],$

"source": $[]$

$\},$

$\{$

"cell$\_$type": "code",

"execution$\_$count": null,

$"$id$"$: $"4$aeed$37$a$",$

"metadata": $\{\},$

"outputs": $[],$

"source": $[$

$"$#Question $1$:

$",$

$"$# Using the employee and dept$\_$id files, write a code that gives the average salary $($mean$())$ for each department$($dept$\_$name should be one of the columns$)$:

$",$

$"$# $(1\mathrm{.}5$ points$)$

$"$

$]$

$\},$

$\{$

"cell$\_$type": "code",

"execution$\_$count": null,

$"$id$"$: $"97465601",$

"metadata": $\{\},$

"outputs": $[],$

"source": $[$

$"$#Question $2$:

$",$

$"$#Using the Titanic data, get the women who were survived.

$",$

$"$#Show the plot for number of the survived women in each Pclass.

$",$

$"$# $(2$ points$)"$

$]$

$\},$

$\{$

"cell$\_$type": "code",

"execution$\_$count": $1,$

$"$id$"$: $"542$e$17$f$9",$

"metadata": $\{\},$

"outputs": $[],$

"source": $[$

$"$# Question $3$:

$",$

$"$# Using the world population data, find the median population on year $2021$ of all countries.

$",$

$"$#which country has this population. $(2$ points$)$ # If the number of rows are even, please drop the row with min population.

$",$

$"$

$",$

$"$#Find the average population of all countries in $2021-$ exclude the countries with more than one billion and less than one million in $2021.(2$ points$)$

$"$

$]$

$\},$

$\{$

"cell$\_$type": "code",

"execution$\_$count": null,

$"$id$"$: $"10$dccfb$7",$

"metadata": $\{\},$

"outputs": $[],$

"source": $[$

$"$#Question $4$:

$",$

$"$#In world population data, add the column 'Percentage', to calculate the percentage of each country's population in $2021.($compare to whole population of the world$)$

$",$

$"$#Name the file wrd$\_$pop$\_$prcg$\_2021$ and save it into a csv file.

$",$

$"$#$(2\mathrm{.}5$ points$)$

$"$

$]$

$\}$

$],$

"metadata": $\{$

"kernelspec": $\{$

"display$\_$name": "Python $3($ipykernel$)",$

"language": "python",

"name": "python$3"$

$\},$

"language$\_$info": $\{$

"codemirror$\_$mode": $\{$

"name": "ipython",

"version": $3$

$\},$

"file$\_$extension": $".$py$",$

"mimetype": "text$/$x$-$python",

"name": "python",

"nbconvert$\_$exporter": "python",

"pygments$\_$lexer": "ipython$3",$

"version": $"3\mathrm{.}11\mathrm{.}5"$

$\}$

$\},$

"nbformat": $4,$

"nbformat$\_$minor": $5$

$\}$