Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started