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). import pandas as pd file_name = input()

Answer 1

To complete the program, read the input file as a pandas dataframe, sort the dataframe by the 'finals scores' column in descending order, find the max score, median, average, and standard deviation of each assignment's scores, and output the results.

Step-by-step explanation:

To complete the program tasks, you can follow these steps:

1. Read the input file using pandas and store it as a dataframe.
2. Sort the dataframe by the 'finals scores' column in descending order.
3. Find the max score for each assignment using the 'max()' function.
4. Calculate the median and average of each assignment's scores using the 'median()' and 'mean()' functions respectively.
5. Calculate the standard deviation of each assignment's scores using the 'std()' function.
6. Output the results for each of the above calculations using the 'to_string()' function.

Remember to pass numeric_only=True as a parameter to the functions used in steps 3 through 5 to specify that only numbers will be calculated.

Here's an example code snippet to help you:

import pandas as pd

file_name = input()
df = pd.read_csv(file_name, sep=' ')
df.sort_values('finals scores', ascending=False, inplace=True)

max_scores = df.max(numeric_only=True).to_string()
median_scores = df.median(numeric_only=True).to_string()
average_scores = df.mean(numeric_only=True).to_string()
std_deviation_scores = df.std(numeric_only=True).to_string()

print('Max scores:', max_scores)
print('Median scores:', median_scores)
print('Average scores:', average_scores)
print('Standard deviation scores:', std_deviation_scores)