Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

using python 3 Many applications require parsing through and processing csv files to extract information This lab will serve as an introduction for file parsing

using python 3
image text in transcribed
Many applications require parsing through and processing csv files to extract information This lab will serve as an introduction for file parsing and will require you to figure out 2 pieces of information Youre given a csv file employee_info.csv with the following structure Name, Hire-Date, Salary Graham Chapman, 03/15/14, 50000.0 John Cleese, 06701/15, 65000.0 Eric Idle, 05/12/14, 45000.0 Terry Jones, 11/01/13, 70000.0 Terry Gilliam, 08/12/14, 48000.0 Michael Palin, 05/23/13, 66000.0 Write functions calculateAverage Salary(filename) Returns the average salary of all employees rounded down to 2 decimal points highestHireMonth(filename) Returns the month (integer) during which most hires were made over the years .getMonth(date) Helper function to extract and return the month number from a date given as a string input of format MM/DD/YY Return type should be an int LAB ACTIVITY 9.15.1. Breakout Room Activity 2 072 main.py Load default template 1 l tt Cty de calculateAverage salary() Your code here 6 fet Month(date): Takes in input date as a string in format /O/VY Returns son representation of the string 1 11 12 14 of highest ronth(filename) 15 Your code here 10 17 hain 19 Test your functions here 20

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions