Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the file name of a . tsv file read from user input containing student names and the respective course assignment grades, complete a program
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 through should only require one function for each step. Ex Finding the max of each assignment uses max
Append tostring to the end of the function call in order to silence an extraneous line that occurs at the end of the output.
For steps and the functions used will require the parameter numericonlyTrue to be passed to specify that only numbers will be calculated as the input file contains strings for student names
import pandas as pd
filename input
# TODO: Read in filename as a dataframe
# TODO: Output rows by descending Final scores
print
Max Scores:"
# TODO: Output the max scores of each assignment
print
Median Scores:"
# TODO: Output the median scores of each assignment
print
Average Scores:"
# TODO: Output the average scores of each assignment.
print
Standard Deviation:"
# TODO: Output the standard devation of each assignment.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started