Part $3$: Excel Data Manipulation and visualization

Add the table above to excel either by typing it manually or save the dataframe as a CSV using the

code below, and then open it with excel. $($Each answer should be on a new worksheet by either

coping the table to it or by answering the question in such away that the answer is on a new

worksheet.$)$df$.$to$\_$csv$($sales$\_$data.cs$,$ index$=$False$)$ #Set index$=$False to exclude the index df is your

dataframe.

$1.$ At the bottom of the following column, create a sparkline$($line graph$)$ on age and data bars on

the quantity and value column in an Excel sheet.

$2.$ Create a pivot table from the dataset

$3.$ Introduce slicers and demonstrate how they can be used for interactive filtering.

$4.$ Provide an example of creating a pivot chart and customizing it$.$

$5.$ Sort by the name column name

$6.$ Filter all names that do not start with $$k$$ on a new worksheet.