For this assignment, we look into a restaurant$$s tipping dataset, that consists of the following fields:

Obs: id# of a restaurant$$s bills incidents

totbill: total amount of the bill

tip: tip amount

sex: M$/$F

smoker: Yes$/$No

day: Mon thru Sun

time: Day$/$Night

size: party number

$1.$ To load the data using read$\_$csv for the data files attached $($tips$.$txt or tips.csv$),$ save the files and

path of your own, to include the directory path of the loaded files, like below example of the

saved path:

In: tips$=$ pd$.$read$\_$csv$(\text{'}$c:$/$Users$/$mowaf$/$Data$/$tips$.$txt$\text{'},$ sep$=\text{'},\text{'})$

In: tips$=$ pd$.$read$\_$csv$(\text{'}$c:$/$Users$/$mowaf$/$Data$/$tips$.$csv$\text{'})$

$2.$ To view the file dataset $($first $5$ rows$)$:

In: tips.head$()$

obs totbill tip sex smoker day time size

$0116\mathrm{.}991\mathrm{.}01$ F No Sun Night $2$

$1210\mathrm{.}341\mathrm{.}66$ M No Sun Night $3$

$2321\mathrm{.}013\mathrm{.}50$ M No Sun Night $3$

$3423\mathrm{.}683\mathrm{.}31$ M No Sun Night $2$

$4524\mathrm{.}593\mathrm{.}61$ F No Sun Night $4$

$3.$ To make a stacked bar plot showing the percentage of data points for each party size on each

day, make a cross$-$tabulation by day and party size and sh:

In$[]$: party$\_$count$=$pd$.$crosstab$($tips$[\text{'}$day$\text{'}],$tips$[\text{'}$size$\text{'}])$

In $[]$: party$\_$count

Out:

size $123456$

day

Fri $1161100$

Sat $253181310$

Sun $039151831$

Thu $1484513$

$4.$ To normalize the data, so that each row sums to $1$ and make the plot:

In: party$\_$counts $=$ party$\_$count.loc$[$:$,2$:$5]$

In: party$\_$counts

size $2345$

day

Fri $16110$

Sat $5318131$

Sun $3915183$

Thu $48451$

$5.$ Normalize so that each row sums to $1$ to make a bar plot of the party size $($counts$)$ over the

weekdays:

# Normalize to sum to $1$

In: party$\_$pcts $=$ party$\_$counts.div$($party$\_$counts.sum$(1),$ axis$=0)$

In: party$\_$pcts

size $2345$

day

Fri $0\mathrm{.}8888890\mathrm{.}0555560\mathrm{.}0555560\mathrm{.}000000$

Sat $0\mathrm{.}6235290\mathrm{.}2117650\mathrm{.}1529410\mathrm{.}011765$

Sun $0\mathrm{.}5200000\mathrm{.}2000000\mathrm{.}2400000\mathrm{.}040000$

Thu $0\mathrm{.}8275860\mathrm{.}0689660\mathrm{.}0862070\mathrm{.}017241$

$6.$ Draw plot$($kind$=$'bar'$)$ of the party$\_$pcts from step $5.$

Show your plot output.

$7.$ To find the percentage of the tip for each bill, create a column $$tip$\_$pct$$:

In: tips$[\text{'}$tip$\_$pct$\text{'}]=$ tips$[\text{'}$tip$\text{'}]/$ tips$[\text{'}$totbill$\text{'}]$

tips.head$(5)$

Similarly, to list the first five rows of the dataset:

tips$[$:$6]$

Show your output.

$8.$ Draw a histogram plot $($frequency of the data points split into discrete, evenly spaced bins, with

the number of data points in each bin$),$ using the tip percentages of the total bill, tips$[$tip$\_$pct$],$

of step $7$:

tips$[\text{'}$tip$\_$pct$\text{'}].$plot.hist$($bins$=50)$

Show your output.

$9.$ To show a summary statistics of the percentag of tips $$tip$\_$pct$$ for day, smoker, sex, and time

columns, we can call the describe on a groupby object:

tips.groupby$(\text{'}$smoker$\text{'})[\text{'}$tip$\_$pct$\text{'}].$describe$()$

Show your output.

Similarly, show the $$tip$\_$pct$$ aggregated on $$sex$,$day$$ and $$time$$

Show your output.

$10.$ Aggregating a Series or all of the columns of a DataFrame is a matter of using aggregate with the

desired function or calling a method like mean or std$.$ However, we may want to aggregate using

a different function depending on the column, or multiple functions at once.

To group the tips by day and smoker:

grouped $=$ tips.groupby$([\text{'}$day$\text{'},$ 'smoker'$])$

grouped

Out$[130]$: