Assignment Problem Statement
Assignment 3:
Part 1 - Online Grocery
An online grocery is a grocery store that allows the customers to order grocery items online and
then the order can be either collected by the customer or delivered to the customer address.
You are going to create a program that simulates the ordering system from an online grocery.
Questions for Part 1:
Q1- Create the items data structure:
Create the (Grocery) data structure with at least 20 items. Each item is a separate data structure
with its details: item number(id), item name, item price,** quantity** in stock.
For example:
[{"Milk":["001139801",10,20]}, {}, {}]
OR
[[001139802,"Milk”, 10,20], [ ], [ ]]
(Note: the selection off the data structures is up to you, the above are just examples)
Q2-Ordering:
1. ** Display**
y** all items, each item with its price, to allow the customer to decide what to buy. 2.
The customer has to enter the item name and the quantity of each item he/she wants to buy.
And your code must validate that the item name is in the (Grocery) data structure and
also validate the quantity. 3. The customer can continue ordering by typing the item
name and quantity until he/she types pay. 4. If the customer orders an item; the quantity in the
(Grocery) data structure must be reduced according to the user ordered quantity. 5. If the customer tries to order an item that is out of stock, display a message that the item is out of stock
and DON'T add the item to the (Order) data structure. 6. If the item name entered and
quantity entered by the customer are ok after all validations, then the item name,
** unit** price,
entered** quantity and the calculated price** according to the entered quantity will be saved
in the (Order) data structure.
Q3 - Payment and Invoice:
1. The program must calculate the total bill amount.
2. The program will ask the customer to enter his/her name and **credit card **number
(must be a number of 16 digit length).
3. The total bill amount will be updated according to the below delivery,** discount**
and VAT options: Delivery:
•
If the customer needs delivery, then ask the customer to enter the emirate and **check if
it is
correct emirate **then charge **5 for Abu Dhabi**,** 10 for Al Ain
**and** 20 for other emirates.**
Discount:
Only one discount can be applied to any total bill amount, confirm which one
the customer wants to apply:
ly 10% discount.
1. If the customer buys **more than 5 items**, app
pply 20% discount.
2. If the total amount is **more than 200 AED** a
3. If the customer uses Fazza, apply 15% discount
VAT: Apply a VAT of 5% to the total bill amount.
1. The (Payment) data structure must include the customer name,
number**** total** bill amount.
** credit card
2. A new data structure (Invoice) must be created to include the (Payment) and the
(Order).
For example: Invoice = { order: [ ], payment: [ ] } (Note: the selection off the data structures is
up to you, this is just an example)
6. Invoice:** Print the invoice with the order details and payment details.**
Requirements for Part 1:
1. Your program should use appropriate user defined functions for all the processes like:
ordering, updating the grocery items quantities, payment, discounts, delivery and printing
the invoice. 2. Use two-dimensional data structure. Choose appropriate data structures such as a list,
tuple, set or a dictionary to store data.
3. Print the invoice for the user, along with adding a VAT of 5% to the total bill amount.
Part 2: Data analysis and Visualization:
You are tasked to analyze and visualize data using python code and libraries. Choose one dataset
from the datasets provided in this link, which also includes additional information on the
datasets, and then write and comment on the code to answer the below question.
1. Write a code to Import a dataset selected from the link above into a pandas dataframe and
provide a brief description of the dataset.
2. Write a code that will select a random sample of 100 from the original data set and save it
as a new dataset.** (Use this sample to answer the remaining questions)**
3. Write a code to display the first 20 and last 20 rows of the dataset and display the number
of columns and rows in the dataset. From what you can observe, report any insights
revealed about the dataset.
4. Using the random sample dataframe from question 2, write a code that will select a
column of interest from your dataset with string data type and arrange the data in
alphabetical order, take note of the first value of the current sorting. Then rearrange
the data in reverse alphabetical order and take note of the first value of the new
sorting.
1. Using the same column generated by question 4, write a code that will summarize
its content with a frequency table and create percentages. Observe the data and
explain your findings.
5. Write a code to choose a specific numerical column and calculate the average of that
column. Then write a code to find the maximum and minimum for that column. Observe
the data and explain your findings.
6. Write a code that would create 2 new columns from a selected numerical column: The
first new column is the result of multiplying by 3. The second new column should be**
half the value of the original column**.
7. Using a column in your dataset with repeated values. Apply a dataframe function by
writing a code to calculate the distribution of this column and create a bar chart to
visualize the data. Customize the colors in the bar chart, ensure that x and y labels have
appropriate titles, and a main title. Describe what you can observe from the created
chart briefly.
8. Identify 2 numerical columns. Write a code that will create a line chart to visualize the
data, customize the colors of each line, make sure to show x and y labels, provide a title
and describe the shape of the chart.
9. Develop a specific question related to data filtering and analysis in your selected dataset.
Write a code to answer your question and include a brief explanation of the results
obtained.
You may use **matplotlib library **for data visualisation, provided that you explain the
functions used for this module, if it is not explained then it will negatively impact your grade.
Instructions for Students:
1. You will be working on this assignment in a group. 2. Algorithm and Flowchart are required only for part 1.
3. You can not use AI tools (such as ChatGPT or Bard) to help answer the questions. You
must only utilize the tools and programming structures that have been instructed in class
thus far to receive complete credit. Code with advanced tools or programming structures
not covered in the course will get a score of 0. In addition, you must understand every
single line of code submitted. You must attend a technical interview on your assignment
explaining your approach to coding if needed.
4. Make sure that you submit your original work. Suspected plagiarism cases will be treated
as possible academic misconduct and will be reported to the College Academic Integrity
Committee for formal investigation. As part of this procedure, your instructor may
require you to meet with them for an oral exam on the assignment.
5. Failure to comply with the instructions will result in a 0 grade on the relevant portions of
the assignment. Your instructor will grade your submission based on what you submitted
on Forum within the allowed deadlines. Do not submit your assignment via email. Failure
to submit an assignment or submitting an assignment for another student from the same
class or another class will result in a 0 grade without the opportunity to resubmit.
Submission:
Primary Resource: A single PDF file of your ipynb workbook which includes separate cells
for part 1 (online grocery) and part 2 (Data analysis and Visualization). A neat, clearly
presented, and easy-to-read file should be submitted. The file should be submitted with the
filename "student_name.pdf".
The PDF file of your ipynb workbook should include the following as part of the solution to
the problem given below.
1.**
Algorithm**, which clearly describes all steps and sub-steps required to arrive at the
solution, with clearly defined step numbers.
2.** Flowchart**, which is a picture that uses the standard notations of a flowchart and depicts
the flow of control.
3.** Python code for part 1 and part 2**, which must NOT be a picture. The error-free code with
all the proper documentation and indentations must be included.
4. **Test cases ** for part 1: include and explain at least 3 test cases to demonstrate that the
program works correctly. One test case has to be a failure case.
5. A paragraph mentioning the individual contribution of each group member.
6.** References** (list any references used in APA format)
Secondary Resource: A Zip folder. The folder should be submitted with the name
"student_name.zip". The ZIP folder should include all additional files below to support your solution to the
problem.
1. The .ipynb** file**
2. 2.** Flowchart (if not included in the workbook)**
Note:
If the PDF is not submitted as a primary resource, i.e., if the PDF as is submitted as a
secondary resource, the final grade will be no more than 2.
If the ipynb file is not submitted (as secondary resource), the final grade will be no more
than 2.
Assignment Guidelines:
As you solve each part of the problem, follow the steps of algorithmic thinking as outlined
below.
Step 1:** Algorithm Description**. Use an algorithm and a flow chart to develop and express
your algorithm that accomplishes the given task. Remember, you must be very explicit and clear
to ensure one can achieve the required solution following the steps of your algorithm. Describe
the input(s), output(s), and the process of the algorithm. Follow the flowchart shape conventions
reading, available here.
Step 2:** Python Code.**
You can use Anaconda or Colab to work on the Jupyter Notebook you will submit as your final
project on Forum.
1 – You may download this Jupyter Notebook to your local machine.
2 - Open a tab in your browser and type https://colab.research.google.com/.
3 - This will open a small window. Choose the last option, Show notebooks in Drive on the
upper menu, "Upload". Then, choose the Jupyter Notebook you have saved.
4 - You can start working on your assignment by answering the questions in the corresponding
cells.
5 - If you have any questions, please get in touch with your instructors or the CIS tutors.
Implementation: Implement the algorithm in Python using the basic concepts and structures we
covered in class (IMPORTANT: ONLY USE CONCEPTS COVERED IN CLASS).
•
User input
• Variables
•
· Logical, Relational and Arithmetic Operators
