import pandas as pd

import matplotlib.pyplot as plt

import seaborn as sns

# Data

df $=$ pd$.$read$\_$csv$(\text{'}$transactions$-$pet$\_$store.csv$\text{'})$

df$\_$orig $=$ df$.$copy$()$

Question $2$

Find any clearly "incorrect" values in the Price column and "clean" the DataFrame to address those values.

Ensure you make the changes to the DataFrame assigned to the variable df$.$

Question $3$

After you've done the cleaning above, remove any column that has more than $500$ missing values.

Ensure you make the changes to the DataFrame assigned to the variable df$.\text{'}$

Question $4$

Address the other missing values. You can replace the values or remvove them, but whatever method you decide to clean the DataFrame, you should no longer have any missing values.

Ensure you make the changes to the DataFrame assigned to the variable df$.$

Question $6$

Determine most common category $($Product$\_$Category$)$ purchases $($number of total items$)$ for both Product$\_$Line categories. Assign the $($string$)$ name of these categories to their respective variables common$\_$category$\_$cat & common$\_$category$\_$dog.

Question $7$

Determine which categories $($Product$\_$Category$),$ by Product$\_$Line have the median highest Price. Assign the $($string$)$ name of these categories to their respective variables priciest$\_$category$\_$cat & priciest$\_$category$\_$dog.

Question $8$

You want to emphasize to your stakeholders that the total number of product categories sold differ between the two Product$\_$Line categories $(\text{'}$cat$\text{'}$ & 'dog'$).$

Create a horizontal bar plot that has Product$\_$Category on the y$-$axis and the total number of that category sold $($using the Quantity$)$ by each Product$\_$Line category. Also change the axis labels to something meaningful and add a title.

You will likely want to use Seaborn. Make sure you set the result to the variable ax like the following:

ax $=$ # code to create a bar plot

Question $9$

Based on the plot from Question $8,$ what would you conclude for your stakeholders about what products they should sell? What would be the considerations and$/$or caveats you'd communicate to your stakeholders?

Write at least a couple sentences of your thoughts in a string assigned to the variable answer$\_$to$\_9.$

The cell below should look something like this:

answer$\_$to$\_9=\text{'}\text{'}\text{'}$

I think that based on the visualization that $****.$

Therefore I would communicate with the stakeholders that $****$

$\text{'}\text{'}\text{'}$

Question $10$

The plot you created for Question $8$ is good but could be modified to emphasize which products are important for the business.

Create an explanatory visualization that emphasizes the insight you about the product category. This would be a visualization you'd share with the business stakeholders.

Make sure you set the result to the variable ax like the following:

ax $=$ # code to create explanatory visualization