esign a program that reads a file called sales.txt containing the following data: ane, 215.5, 445.5,910.0 ohn, 825.0,250.5,675.0 ill,0.0,999.15 ach 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 aptured 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 se a for loop to calculate the sales average using your new average function for each employee and display the following output to the screen. ane, average sales: 523.67 ohn, average sales: 583.50 ill, average sales: 499.56

esign a program that reads a file called sales.txt containing the following data: ane, 215.5, 445.5,910.0 ohn, 825.0,250.5,675.0 ill,0.0,999.15 ach 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 aptured 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 se a for loop to calculate the sales average using your new average function for each employee and display the following output to the screen. ane, average sales: 523.67 ohn, average sales: 583.50 ill, 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

● Create a Python file called holiday.py in this folder.● You will need to create four functions:● hotel_cost — This function will take the number of nights a userwill be staying at a hotel as an argument, and return a total cost forthe hotel stay (You can choose the price per night charged at thehotel).● plane_cost — This function will take the city you are flying to as anargument and return a cost for the flight (Hint: use if/else ifstatements in the function to retrieve a price based on the chosencity).
Python - Next Birthdate In this task, we will write a program that reads birthdate data from a given CSV file, and given the current date, determines which person's birthday will be celebrated next. Create a function with the following signature: nextBirthdate(filename, date) filename: parameter, which represents the CSV filename. date: parameter, which represents the current date. The function should open the CSV file, read the birthdate data, and determine which person's birthday will be celebrated next, given the current date. The name of the person should be returned. In other words, given a date, find the person whose birthday is next. Sample Run birthdates.csv Draven Brock, 01/21/1952 Easton Mclean, 09/02/1954 Destiny Pacheco, 10/10/1958 Ariella Wood, 12/20/1961 Keely Sanders, 08/03/1985 Bryan Sloan,04/06/1986 Shannon Brewer, 05/11/1986 Julianne Farrell,01/29/2000 Makhi Weeks, 03/20/2000 Lucian Fields, 08/02/2018 Function Call nextBirthdate("birthdates.csv", "01/01/2022") Output…
Average grades bar chart Write a python program grades.py that reads a file of assignment grades and draws a bar chart of the average grades for each assignment. Save the figure as grades.png in the current working directory. The format of a line in the file is: assignment_type grade Note that there is a single space between the assignment type and the grade. E.g. exam 92.80 Your program must contain the following functions: Function name Function description Function input(s) Function return value(s) get_grades() This function takes a file name as input and populates a dictionary containing the assignment types and grades. Filename string Dictionary of grades main() This function prompts for the grades file name. Next, it calls the functions get_grades(). Next, it draws the bar chart of the average grade for each assignment. Hint: You can use the mean function of the statistics module to calculate the average of a list. None None Use the starter…
1. The file Final.txt contains student grades on a final exam. Write a program that displays the number of grades, the average grade, and the percentage of grades that are above the average grade as shown below. Write a main() function to initialize (kickstart) the application, and a calculate_ percent above_ average() function to calculate the percentage of grades that are above the average grade. Hint: Read in the input file Final.txt using the open() method and assign the grades to a list of integers. Number of grades: 24 Average grade: 83.25 Percentage of grades above average: 54.17% 78 67 56 99 80 83 82 91 94 95 77 88 85 92 91 79 88 82 81 86 94 93 92 45
python!!!!! Create a function, showEmployment. It will have three arguments. 1. Employees: directory of strings with individual employee names EmployeeYears: directory of integers with the year of the employee work for each individual Year: an integer with a year This function shall show a message that displays every employee’s name and years worked based solely on the year with the format: Dylan has worked 5 years in 2021. The input will be: showEmployment ([“Dylan”], [2000], [2021].
Design a C++ program to store AND retrieve grocery information using the following guidelines: (1) Write a function named CreateGroceryList that repeatedly asks the user for grocery item and its cost and stores the information into a text file named grocery.txt (2) Your function must store at least 5 grocery items in grocery.txt (3) Write another function named ReadGroceryList that reads the information from grocery.txt and displays the information on the screen like Item Cost Apple $4.50 $1.20 Banana (4) Your program must include your information and algorithm as specified in class WRITE THIS PROGRAM ON DEV C++
Create a file in your project named employees.txt with the following data (you can simply create the file by hand rather than with Python code): 123 Bob Smith345 Anne Jones256 Carol Lee845 Steve Robert Anderson132 Jill Thompson From your program's main function, give the user the following options: lookup a name based on ID number, lookup an ID number based on name, and quit the program. OPTION 1: The user chooses to lookup a name based on ID number: Use a try/except and ask the user to enter an integer. If they don't enter an integer, print an error message. If they do enter an integer, call a function named lookup_employee which takes the id as a parameter. If an employee with the given id number is found, return the name. Otherwise, return the string “Employee not found” Back in main, print the return result. OPTION 2: The user chooses to lookup an ID based on name: Ask the user to enter the first and last name (don't ask for the middle name). Call a function named…
2. Dog Years File: dog_years.py In Prac 3 you wrote a program to calculate a dog's age in dog years.Rewrite this program using a function for the conversion.Write a main function that repeatedly asks the user for an age in human years, then displays it in dog years until the user enters a negative number.Don't do any error checking on this age. Here's the calculation part already: if human_years <= 2: dog_years = human_years * 10.5 else: dog_years = 21 + 4 * (human_years - 2) 3. Seconds Display File: seconds.py In Prac 2 you wrote a program to calculate and display deep sleep time/percentage.In that program, you displayed seconds as minutes and seconds, example: Total sleep in seconds: 161 Deep sleep in seconds : 62 Deep sleep : 1m 2s Total sleep: 2m 41s Percentage : 38.50931677018634% Note: the original program from prac 2 was about sleep, but this question is not related to that context.The technique for figuring out minutes and seconds from just seconds is the same,…
Design a C++ program to store AND retrieve grocery information using the following guidelines: (1) Write a function named CreateGroceryList that repeatedly asks the user for grocery item and its cost and stores the information into a text file named grocery.txt (2) Your function must store at least 5 grocery items in grocery.txt (3) Write another function named ReadGroceryList that reads the information from grocery.txt and displays the information on the screen like Item Cost Apple $4.50 $1.20 Banana (4) Your program must include your information and algorithm as specified in class (5) You must upload the entire main.cpp as a file
PLEASE COMMENT CODE In a python program, create a new file and call it “ tracking”. Write to it four lines each contains information about an order like this: 1-00654-021 Dell charger Toronto-WEST 99-49-ZAD011-76540-022 ASUS battery Milton-EAST 34-56-CBH561-09239-026 HP HD Scarborough-NORTH 12-98-AZC451-12349-029 Mac FD North York-LAWRENCE 34-49-ZWL01Add the file two more lines: 1-34567-055 Lenovo SSD Milton-ON 34-09-MT04 1-90432-091 Lenovo battery Oakville-ON 78-KL98 Define a function that searches for a brand (e.g. Dell, ASUS, etc.). Test the function in your program.
Program a python program that demonstrates reading and comparing Create a python program that demonstrates reading and comparing multiple files, processes the input files based on the business rules, and produces an output file. Needed Files 1. The timeclock.txt Download timeclock.txtfile contains the hours worked data for every employee as well as the shift they worked. The layout for the file is as follows: EMPLOYEE_NUMBER, HOURS_WORKED, SHIFTTimeclock.txt 22476, 45, 3 24987, 30, 148283, 50, 285437, 25, 3 2. The personnel.txt Download personnel.txtfile contains the names of all employees and their hourly pay rates. The layout for the file is as follows: EMPLOYEE_NUMBER, EMPLOYEE_NAME, PAY_RATEPersonnel.txt 11235, Bob Smith, 10.50 22476, John Roberts, 12.3524987, Mary Johnson, 15.9032743, Brad Carson, 11.2548283, Alice Martin, 14.2085437, Aaron James,15.15 Note: Both the timeclock.txt and payroll.txt files are pre-sorted by EMPLOYEE_NUMBER in ascending order. Business…
A MyPetStore sells many pets and their accessories. As new pets are added to the MyPetStore, theirinformation is entered into a flat text file. Each month, the manager requests a listing of all pets sorted bytheir price. You must write a program to produce a report of MyPetStore and their types sorted by their pricesfrom the data in the flat text file. Below is a description of the information on the text file:• The first entry is the number of animals on the file (numeric) •The fields below repeat for each animal:o Pet name (String)o Birthdate (java.time.LocalDate)o Price (numeric)o Species Type (String)o Special feature (boolean or String)The animals sold by the MyPetStore are of six types: Dogs & Cats, Reptiles, Birds, Rabbits & SmallAnimals.For Dogs & Cats, the special feature field on the flat file is the breed of the animal (String).For Reptiles, the special feature field is the blood type (warm vs cold-blooded, String).For Birds, the special feature field is the…