Question: 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
using python 3 Many applications require parsing through and processing csv files

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!