CYSE/SYST 230 Exercise 7 Instructions: Submit only one python file (.py or .ipynb) and it shall be named using your first and last name with an underscore separating the names. Ex: The submission file...

Questions are uploaded


CYSE/SYST 230 Exercise 7 Instructions: Submit only one python file (.py or .ipynb) and it shall be named using your first and last name with an underscore separating the names. Ex: The submission file for a student with name- 'Matt Amissah', shall be 'Matt_Amissah.py'. Write codes that implements the following: 1) Question 1: a. Read the data in the attached submission and set the “Order ID” column to be the row index. b. Show all information of all orders on the date “8/26/2021”. c. Determine the order id which had the lowest purchase of “Item Total”. d. Among those who purchased with an amount greater than $100, determine the order ids belonging to either of the following two groups: “Computer & Electronics”, “Kitchen”. e. Determine the count of occurrences of “Amazon.com” in the “Seller” column. f. Show the “Description” of the SOFA sold on “8/29/2021”. 2) Question 2: a. Change the row index to be the “Order Date” and store the new data frame in a new variable. b. Show all information of all orders on the date “9/1/2021”. c. Among those being sold on “8/26/2021”, determine the order id which had the highest purchase.