Given the file name of a .tsv file read from user input containing student names and the respective course assignment grades, complete a program that performs the following tasks: Read the input file as a pandas dataframe. Output the students' names and grades in descending order of Finals scores. Output each assignment's max score. Output the median and average of each assignment's scores. Output the standard deviation of each assignment's scores. NOTES: Steps 3 through 5 should only require one function for each step. Ex. Finding the max of each assignment uses max() Append .to_string() to the end of the function call in order to silence an extraneous line that occurs at the end of the output. For steps 3, 4, and 5, the functions used will require the parameter numeric_only=True to be passed to specify that only numbers will be calculated (as the input file contains strings for student names). Input and Output Example NOTE: Download StudentInfo.tsv to view the contents of the file.

Given the file name of a .tsv file read from user input containing student names and the respective course assignment grades, complete a program that performs the following tasks: Read the input file as a pandas dataframe. Output the students' names and grades in descending order of Finals scores. Output each assignment's max score. Output the median and average of each assignment's scores. Output the standard deviation of each assignment's scores. NOTES: Steps 3 through 5 should only require one function for each step. Ex. Finding the max of each assignment uses max() Append .to_string() to the end of the function call in order to silence an extraneous line that occurs at the end of the output. For steps 3, 4, and 5, the functions used will require the parameter numeric_only=True to be passed to specify that only numbers will be calculated (as the input file contains strings for student names). Input and Output Example NOTE: Download StudentInfo.tsv to view the contents of the file.

EBK JAVA PROGRAMMING

9th Edition

ISBN:9781337671385

Author:FARRELL

Publisher:FARRELL

Chapter13: File Input And Output

Section: Chapter Questions

Problem 10PE

See similar textbooks

Similar questions

write a program that computes and prints the average of the numbers in a text file. you should make use of two higher-order functions to simplify the design 1. Modify the data in numbers.txt 45.6 66.7 88.8 100.3 22.4 98.1 2. Run the average.py and numbers.txt to get the desired output. Enter the input file name: numbers.txt The average is 70.31666666666666 3. Please explain the algorithm in 3 sentences Please screenshot input ans output window
C++ A company hired 10 temporary workers who are paid hourly and you are given a data file that contains the last name of the employees, the number of hours each employee worked in a week, and the hourly pay rate of each employee. You are asked to write a program that computes each employ- ee’s weekly pay and the average salary of all the workers. The program then outputs the weekly pay of each employee, the average weekly pay, and the names of all the employees whose pay is greater than or equal to the average pay. If the number of hours worked in a week is more than 40, then the pay rate for the hours over 40 is 1.5 times the regular hourly rate. Use two parallel arrays: a one-dimensional array to store the names of all the employees, and a two-dimensional array of 10 rows and 3 columns to store the number of hours an employee worked in a week, the hourly pay rate, and the weekly pay. Your program must contain at least the follow- ing functions—a function to read the data from…
Given a text file containing the availability of food items, write a program that reads the information from the text file and outputs the available food items. The program should first read the name of the text file from the user. The program then should read the text file, line by line. If a food is available, the program should output the available food item in the following format: name (category) -- description Assume the text file contains the category, name, description, and availability of at least one food item, separated by a tab character ('\t'). Hints: Use the find() function to find the index of a tab character in each row of the text file. Use the substr() function to extract the text separated by the tab characters. Ex: If the input of the program is: food.txt and the contents of food.txt are: Sandwiches Ham sandwich Classic ham sandwich Available Sandwiches Chicken salad sandwich Chicken salad sandwich Not available Sandwiches Cheeseburger Classic cheeseburger Not…
Consider a file named transaction.txt which contains unknown number of lines. Each line contains data of one transaction as follows: username (string), amount (float), and membership number (int). Write a C++ program that reads the data from the file, then displays on screen the number of users, the total amount, the average of amounts, the lowest amount and the highest amount. Reading from the file should stop when one or more of the conditions given below becomes true:(a) The end of file has been reached. (b) The “user999” is reached.
Consider a file named transaction.txt which contains unknown number of lines. Each line contains data of one transaction as follows: username (string), amount (float), and membership number (int). Write a C++ program that reads the data from the file, then displays on screen the number of users, the total amount, the average of amounts, the lowest amount and the highest amount. Reading from the file should stop when one or more of the conditions given below becomes true:(a) The end of file has been reached. (b) The “user999” is reached.transaction.txtHassan 12.5 12345 Mariam 5.2 87542 Zahra 33.1 93568 :::: ::Sample Screen OutputNumber of users: 54 Transactions total amount: 2658.7 The average of amounts: 120 The highest amount: 280 The lowest amount: 5.2
Question B. Write a C++ program that reads the marks of a group of students from a text file "grades.txt" and computes the average of all grades. The program must check the file for any opening problems, and then proceeds to do the other tasks. The input file can have 1 or more students. The text file and sample-output are shown as below: O grades - Notepad File Edit Format View Help 60.0 78.6 78.0 98.6 77.7 55.0 73.0 80.7 80.0 85.0 Windows (CF Ln 13, Col 1 100% CAUsers\Imran\Desktop\Lab111\Debug\Lab111.exe Average of 10 students is 77 Press any key to continue... Activa Coto s
Write a program that reads the student information from a tab separated values (tsv) file. The program then creates a text file that records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student. A sample of the student information is provided in StudentInfo.tsv. Assume the number of students is at least 1 and at most 20. Assume also the last names and first names do not contain whitespaces. The program performs the following tasks: Read the file name of the tsv file from the user. Open the tsv file and read the student information. Compute the average exam score of each student. Assign a letter grade to each student based on the average exam score in the following scale: A: 90 =< x B: 80 =< x < 90 C: 70 =< x < 80 D: 60 =< x < 70 F: x < 60 Compute the average of each exam. Output the last names, first names, exam scores, and letter grades of the…
Write a function count_character(filename, character) that takes in a filename and a character, both as strings, and returns the total number of times the given character occurs in the file. Examples: Contents of hello.txt:HelloHELLOHelloHELLO count_character('hello.txt', 'L') returns 4count_character('hello.txt', 'H') returns 4count_character('hello.txt', 'e') returns 2 Requirements: Please use Python Programming only Show screenshot of your work.
C++ A company hired 10 temporary workers who are paid hourly and you are given a data file that contains the last name of the employees, the number of hours each employee worked in a week, and the hourly pay rate of each employee. You are asked to write a program that computes each employee's weekly pay and the average salary of all the workers. The program then outputs the weekly pay of each employee, the average weekly pay, and the names of all the employees whose pay is greater than or equal to the average pay. If the number of hours worked in a week is more than 40 hours, then the pay rate for the hours over 40 is 1.5 times the regular hourly rate. Use two parallel arrays: a one-dimensional array to store the names of all the employees, and a two-dimensional array of 10 rows and 3 columns to store the number of hours an employee worked in a week, the hourly pay rate, and the weekly pay. Your program must contain at least the following functions—a function to read the data from the…
For this program, assume you have an input file with several lines of text. Each line has a student's last name, followed by a space and then 4 numbers which represent his/her grades. Your program should read this input file and produce an output file with the same number of lines, each line showing the last name and the average of the student's scores. "grades.txt" is the file your program should read. "badformat.txt" is an example of a file that your program can't read, so a clear error message should be generated, as shown in the sample output. Your program must catch all exceptions. Your main method must NOT have a "throws" clause - it must catch all exceptions and dea' with them appropriately. Other methods may throw exceptions, as long as the main method catches them. I don't expect you to examine any filenames to make sure they're valid. Instead, you should use the filename the user gives you and try to open a file by that name. That will throw an exception if the filename is…
in python Given a set of text files containing synonyms for different words, complete the main program to output the synonyms for a specific word. Each text file contains synonyms for the word specified in the file’s name, and each row within the file lists the word’s synonyms that begin with the same letter, separated by a space. The program reads a word and a letter from the user and opens the text file associated with the input word. The program then stores the contents of the text file into a dictionary predefined in the program. Finally the program searches the dictionary and outputs all the synonyms that begin with the input letter, one synonym per line, or a message if no synonyms that begin with the input letter are found. Hints: Use the first letter of a synonym as the key when storing the synonym into the dictionary. Assume all letters are in lowercase. Ex: If the input of the program is: educate c the program opens the file educate.txt, which contains: brainwash brief…
in python: Given a set of text files containing synonyms for different words, complete the main program to output the synonyms for a specific word. Each text file contains synonyms for the word specified in the file’s name, and each row within the file lists the word’s synonyms that begin with the same letter, separated by a space. The program reads a word and a letter from the user and opens the text file associated with the input word. The program then stores the contents of the text file into a dictionary predefined in the program. Finally the program searches the dictionary and outputs all the synonyms that begin with the input letter, one synonym per line, or a message if no synonyms that begin with the input letter are found. Ex: If the input of the program is: educate a then the program outputs: No synonyms for educate begin with a.