Question

Write a program that, given a file name typed by the user, reads the content of the file and determines the highest salary, lowest salary and average salary. The file contains employee records, and each record consists of the hours worked and the hourly rate. The salary is calculated as the product of the hours worked and the hourly rate.
An example of file containing three records is as follows:
10.5 25.0
40.0 30.0
30.9 26.5

Answer 1

Using the pandas packge in python, the program which performs the required calculation goes thus :

file_name = input()

#user types the filename

df = pd.read_csv(file_name, names=['hours_worked', 'rate']

#file is read into a pandas dataframe

df['salary'] = df['hours_worked'] * df['rate']

#salary column is created using the product of rate and hours worked

highest_salary = df['salary'].max()

#the max method returns the maximum value of a series

print('highest_salary)

lowest_salary = df['salary'].min()

#the min method returns the minimum value of a series

print('lowest_salary)

avg_salary = df['salary'].mean()

#the mean method returns the average value of a series

print('avg_salary)

Learn more : brainly.com/question/25677416