Download the following transaction data https://www.dropbox.com/s/wex65hytsyevyh5/supermarket.csv?dl=0. This data has the information for each purchased item with its “Date, Transaction Number, UPC Number, Product Name, Customer Account, Qty, Regular Price, Sale Price, and Discount”.
1. Please write the python code to (Don’t achieve this task by using the pandas package. It is intended to train your logic thinking of how to use if statement and for statement.)
(1) Show the product name of all the items purchased in the transaction number T005. (Hint: you should have the following 2 items: “EGGPLANT, and MILK”)
(2) Maintain a list of all the customer account id. (Hint: you should have [‘C001’, ‘C002’, ‘C003’])