Please help me write the code using PYTHON

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Please help me write the code using PYTHON

 

 
**PROBLEM 1: Calculate Sales**

**Function Name:** `calculateSales()`

**Parameters:**

- `item` – a string representing the name of the item for which you want to calculate the total sales

**Return Value:** `str`

**Description:** Given a file, `grocery_sales.csv` (found on canvas and shown in the image below), find the given item and calculate the total sales for that item (i.e., `quantitySold * pricePerItem`). If the item does not exist in the file, the function should return 'Item not found'.

**grocery_sales.csv:**

```
itemName,quantitySold,pricePerItem
Apples,25,0.5
Bread,30,2
Oranges,50,0.6
Milk,40,1.5
Eggs,60,0.2
Cheese,20,3
Tomatoes,35,0.75
Lettuce,45,1
Chicken,10,5
Beef,15,6
Cereals,28,3.5
Rice,50,0.9
Pasta,40,1.25
Chocolate,55,1
Coffee,30,4
```

**Test Cases:**

```python
>>> print(calculateSales("Apples"))
Sales Total: $12.50

>>> print(calculateSales("Bread"))
Sales Total: $60.00

>>> print(calculateSales("Onions"))
Item not found.
```
Transcribed Image Text:**PROBLEM 1: Calculate Sales** **Function Name:** `calculateSales()` **Parameters:** - `item` – a string representing the name of the item for which you want to calculate the total sales **Return Value:** `str` **Description:** Given a file, `grocery_sales.csv` (found on canvas and shown in the image below), find the given item and calculate the total sales for that item (i.e., `quantitySold * pricePerItem`). If the item does not exist in the file, the function should return 'Item not found'. **grocery_sales.csv:** ``` itemName,quantitySold,pricePerItem Apples,25,0.5 Bread,30,2 Oranges,50,0.6 Milk,40,1.5 Eggs,60,0.2 Cheese,20,3 Tomatoes,35,0.75 Lettuce,45,1 Chicken,10,5 Beef,15,6 Cereals,28,3.5 Rice,50,0.9 Pasta,40,1.25 Chocolate,55,1 Coffee,30,4 ``` **Test Cases:** ```python >>> print(calculateSales("Apples")) Sales Total: $12.50 >>> print(calculateSales("Bread")) Sales Total: $60.00 >>> print(calculateSales("Onions")) Item not found. ```
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
ASCII Codes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education