Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions 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. ```]
expand button
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
Check Mark
Knowledge Booster
Background pattern image
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
    Recommended textbooks for you
    Text book image
    Database System Concepts
    Computer Science
    ISBN:9780078022159
    Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
    Publisher:McGraw-Hill Education
    Text book image
    Starting Out with Python (4th Edition)
    Computer Science
    ISBN:9780134444321
    Author:Tony Gaddis
    Publisher:PEARSON
    Text book image
    Digital Fundamentals (11th Edition)
    Computer Science
    ISBN:9780132737968
    Author:Thomas L. Floyd
    Publisher:PEARSON
    Text book image
    C How to Program (8th Edition)
    Computer Science
    ISBN:9780133976892
    Author:Paul J. Deitel, Harvey Deitel
    Publisher:PEARSON
    Text book image
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781337627900
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Text book image
    Programmable Logic Controllers
    Computer Science
    ISBN:9780073373843
    Author:Frank D. Petruzella
    Publisher:McGraw-Hill Education