5) What is the difference between the total sales and the total production cost of all albums? In other words, how much profit has been generated from album sales?

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

 

Instructions:

This is an individual exercise that will be submitted directly to the instructor using the assignment link provided on Blackboard.  Use only the standard libraries available through the current Python distribution (in this case, the csv library is likely your best option). Do NOT use libraries that you need to pip install separately such as Pandas for this assignment. Your final submission should consist of a single Python (.py) file. If you have trouble saving or attaching your file, you can submit a txt document of your Python code.

Assignment

In this assignment, you will use Python to perform data analysis on data taken from the Hallux database. The CSV file provided with the assignment includes the following information (and has a header row with column names):

1) Album ID

2) Album Name

3) Band Name

4) Production Cost

5) Album Sales

When executed, your program should print the answers to the questions below. Remember, it is important to give your answers context, as I will not know which outputs are answering which questions. And since you have direct access to the CSV file, you should have an easy way to check your answers. However, be careful if you make changes to the file, as it may not be imported into Python correctly if it saves in a different format. You can always download the file again from Blackboard if you need to do so.

Requirements

1) What is the total production cost of all albums?

2) What is the total sales of all albums?

3) What is the average production cost of all albums?

4) What is the average of all album sales?

5) What is the difference between the total sales and the total production cost of all albums? In other words, how much profit has been generated from album sales?

6) For two extra points, provide answers to questions 1-5 for each band.

 

Attachments:

Expert's Answer

438 Times Downloaded

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of