Python EDA Missing Values

You are provided with a CSV file named sales$\_$data$\_$missing.csv containing detailed sales information. Your task is to:

Replace missing values in the promotion$\_$id column with $"$No Promotion string.

Calculate the total sales for a specific product$\_$id in a given month. Add a column for each month's total sales to the dataset. There are only two months present in the dataiorder

column for each month's total sales to the dataset. There are only two months present in the data; order these columns in ascending order by month number. If there were no sales, fill the column with $\text{'}0\mathrm{.}0\text{'}.$

Ensure the final dataset contains only order$\_$id$,$ product$\_$id$,$ promotion$\_$id$,$ and the monthly total sales columns.

Return the cleaned dataset as a NumPy array.

Example Input:

Example Input:order$\_$id$,$ product$\_$id$,$ promotiom$\_$id$,$ currency, order$\_$value, ordedate,origin, order$\_$value$\_$coumn$1,100,,$ USD, $278\mathrm{.}77,2021-01-01,0$ffline, $2124\mathrm{.}862,200,$ PROMO$\_2,,130\mathrm{.}73,2021-01-02,$ Online, $4283\mathrm{.}223,200,,112.01,112.01,2021-02-4,$ Direct, $1055\mathrm{.}084,200,,112\mathrm{.}01,112\mathrm{.}1,2021-02-03,$ Direct, $1055\mathrm{.}08$

Example Output:

$\text{'}$No Promotion'

$2124\mathrm{.}860\mathrm{.}0][2200$ 'PROMO$\_2\text{'}$

$4283\mathrm{.}222110\mathrm{.}16][3200\text{'}$No

Promotion' $4283\mathrm{.}222110\mathrm{.}16]$

$[4200\text{'}$No Promotion' $4283\mathrm{.}22$

$2110\mathrm{.}16$