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.
C++ for Engineers and Scientists
4th Edition
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Bronson, Gary J.
Chapter8: I/o Streams And Data Files
Section: Chapter Questions
Problem 2PP: (Data processing) a. Store the following data in a file, or use the numbers.dat file provided on...
Related questions
Question
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.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![C++ for Engineers and Scientists](https://www.bartleby.com/isbn_cover_images/9781133187844/9781133187844_smallCoverImage.gif)
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
![EBK JAVA PROGRAMMING](https://www.bartleby.com/isbn_cover_images/9781337671385/9781337671385_smallCoverImage.jpg)
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
![Microsoft Visual C#](https://www.bartleby.com/isbn_cover_images/9781337102100/9781337102100_smallCoverImage.gif)
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,
![C++ for Engineers and Scientists](https://www.bartleby.com/isbn_cover_images/9781133187844/9781133187844_smallCoverImage.gif)
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
![EBK JAVA PROGRAMMING](https://www.bartleby.com/isbn_cover_images/9781337671385/9781337671385_smallCoverImage.jpg)
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
![Microsoft Visual C#](https://www.bartleby.com/isbn_cover_images/9781337102100/9781337102100_smallCoverImage.gif)
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,