Problem: Haggling Electronics

Haggling Electronics is a new store that just opened where customers can haggle to get the best deal possible for each item they buy.

The owner of the store, which just opened this year, heard you are taking a course on foundations in computing, and asks you to assist with some inquiries they have.

separated by a comma. The first line of this file is the header of the three columns mentioned above respectively. Here is a sample from the file:

transactions$\_$Products.csv

Product$\_$ID$,$ Product$\_$Nane, Price

P$1,2-$in$-1$ Laptop, $1500$

P$2,$ Game Laptop, $2000$

P$3,$Titan Laptop, $2100$

Each time a customer comes to the store they can haggle and obtain a special discount.

percentage of discount after haggling, all separated by a comma. The first line of this file is the header of these five columns. Here is a sample from the file:

transactions$\_$Sales.csv

transaction$\_$id$,$ date, product$\_$id$,$ quantity, discount

$1,\frac{1}{2}\frac{?}{2024},P10,1,0\mathrm{.}03$

$2,\frac{1}{2}\frac{?}{2024},P1,2,0\mathrm{.}13$

$3,\frac{1}{2}\frac{?}{2024},P15,2,0\mathrm{.}13$

of these two columns. Here is a sample of the file:

transactions$\_$Returns.csV

transaction$\_1$d$,$ date

$12,\frac{1}{3}\frac{?}{2024}$

$23,\frac{1}{3}\frac{?}{2024}$

$55,\frac{1}{3}\frac{?}{2024}$

$1-$What is the product that led to the larger number of sales in units?

forget to account for the returns.

Here is a template for the output:

XXXXXXXXXXXXXXXXXXXXXX $999$

$2-$What is the product that led to the larger number of sales in dollars?

$$123,345\mathrm{.}78.$ Obviously, don't forget to account for the returns.

Here is a template for the output:

$3.$What is the turnover for all sales?

the decimal point$),$ sorted by the total discounted amount. All dollar amounts should be prefixed by the $ sign. The comma should be used for thousand separators like in $$98,765\mathrm{.}43.$

Do not forget to account for the returns.

The table should be framed with $"","*$ and $"+",$ Here is a sample output:

$|$P$18|$Universal Smart Remo$|33|$$$16,500\mathrm{.}34|09\mathrm{.}67\frac{}{\text{\$}}1,543\mathrm{.}50|$

$4-$What are the number of transactions per weekday?

Print the number of sales transactions per weekday. The weekday should be on $9$ positions followed by the character $"$:$",$ followed by the count on $3$ positions.

Here is a template for the output:

XXXXXXXXXX:$999$

What are the returned products?

was returned $(3$ positions, right aligned$),$ all separated by a space.

Here is a template for the output:

XXX XXXXXXXXXXXXXXXXXXXXXX $999$

$6-$What is the performance of each product?

Create a text file named "transactions$\_$units.txt$"$ to record each line with the product ID and corresponding total units sold, separated by a comma.

When the alignment $($left$,$ right or other$)$ is not specified in any of the questions above, use the default alignment.

just examples to indicate the format of all of the files. DO NOT hard code your output. The TAs will evaluate your assignment with different input files.

Stick to the required output format. Do not try to make it "nicer" or "more practical", or anything else. This is what the customer wants.writewwr