DS $201$X$-$homework $2$

Revisit the HW $1,$ answer the following questions

Instruction:

Import the data from the Lemonade$2016-2.$csv to Pandas DataFrame

Cleanse the Data

Find and resolve any missing values in the data Into any cells where a value is missing:

a$.$ either by interpolating missing values that are in an obvious sequence,

b$.$ or by entering the average value for the column $($rounded to the nearest whole number$).$

Find and remove any duplicate rows in the data.

Add Derived Columns

Add a column named Sales to the table, in which the total sales of lemon and nange is calculated.

Add a column named Revenue to the table, in which the sales revenue is calculated by multiplying the total sales and price.

Create following charts:

Create a scatter$-$plot chart that shows Leaflets on the $x$ axis and Sales on the $Y$ axis.