Project $15$

Write a Python application which reads data from input file, "ProdData.txt$"$ into three lists:

productList: stores the names of products, as string data.

priceList: stores of the prices of products, as float data.

quantityList: stores the current quantity on hand of a product, as int data.

Each line of the input file stores data about one product. The fields are separated by commas. The data for the first product is: Li Hing Mango, $2\mathrm{.}29,12$

Find the extended value for each product by multiplying its price by its quantity. You may decide to store the extended value of each product in its own list.

Find the grand total of the inventory by adding together the extended values.

Produce the following output by accessing data from your lists:

$\backslash$table$[[$Li Hing Mango,$2\mathrm{.}29,12,27\mathrm{.}48],[$Wet Lemon Peel,$3\mathrm{.}39,18,61\mathrm{.}02],[$Red Iso Peanut,$2\mathrm{.}79,23,64\mathrm{.}17],[$Salty Seed,$2\mathrm{.}89,17,49\mathrm{.}13],[$Mixed Arare,$3\mathrm{.}19,16,51\mathrm{.}04],[$Shredded Ika,$3\mathrm{.}39,17,57\mathrm{.}63],[$Imperial Mix,$2\mathrm{.}79,22,61\mathrm{.}38],[$Mini Mori Maki,$2\mathrm{.}79,19,53\mathrm{.}01],[$Taro Chips,$2\mathrm{.}99,22,65\mathrm{.}78],[$Banana Chips,$3\mathrm{.}19,17,54\mathrm{.}23]]$

Grand Total: $544\mathrm{.}87$