Use the Python language **Design a Program to Calculate Average Sales from a File****Objective:**Develop a program that reads a file named `sales.txt`, which contains sales data for employees, and calculates the average sales for each employee.**File Data Structure:**```Jane,215.5,445.5,910.0John,825.0,250.5,675.0Bill,0.0,999.15```Each line in the file represents:- An employee's name followed by their weekly sales totals.- Sales numbers are separated by commas.- Some weeks may have zero sales due to vacations.**Task:**1. Create a function that accepts a list of sales numbers (floats) and returns their average.2. Read the sales data from the file.3. Use a loop to compute the average sales for each employee.4. Display the results in the following format:```Jane, average sales: 523.67John, average sales: 583.50Bill, average sales: 499.56```This program teaches how to handle file input, process numerical data, and implement basic averaging functions in programming.

Input : Given the python file. Output : Produce the output as given.

Design a program that reads a file called sales.txt containing the following data: Jane, 215.5,445.5,910.0 John, 825.0, 250.5,675.0 Bill,0.0,999.15 Each line has a employee's name and their weekly sales totals all separated by commas. Some employees have taken vacation some weeks so no numbers are captured for those weeks. Create a function that takes a list of floats and returns the average value for those numbers. After reading the information from the file, use a for loop to calculate the sales average using your new average function for each employee and display the following output to the screen. Jane, average sales: 523.67 John, average sales: 583.50 Bill, average sales: 499.56

Design a program that reads a file called sales.txt containing the following data: Jane, 215.5,445.5,910.0 John, 825.0, 250.5,675.0 Bill,0.0,999.15 Each line has a employee's name and their weekly sales totals all separated by commas. Some employees have taken vacation some weeks so no numbers are captured for those weeks. Create a function that takes a list of floats and returns the average value for those numbers. After reading the information from the file, use a for loop to calculate the sales average using your new average function for each employee and display the following output to the screen. Jane, average sales: 523.67 John, average sales: 583.50 Bill, average sales: 499.56

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

See similar textbooks

Similar questions

PASCAL is an example of a programming language that uses pseudo-code.
python program please
A few of popular languages for coding include JAVA and Python.
PASCAL is an example of a programming language that uses pseudo-code.
Create a calculator application using python
Python(Exact output)
Hardware is what makes a computer work.
What methods are used in the creation of computer software?
Logical memory is referred to as "false memory."
1- What is the difference between a variable and a value? (Python)
make a barcode reader web application to scan barcode using a Asp.net or C#
Hardware is what makes a computer work.