Question: Please code in python. The file attached (empdata.csv(below)) contains records of employees. Upon reviewing your log files as a system administrator, you realized some employees

Please code in python.

  1. The file attached (empdata.csv(below)) contains records of employees. Upon reviewing your log files as a system administrator, you realized some employees computers have been compromised. The compromised computers are in the 200.10.15.0/24 subnet. Implement a function that would print the names, department, and email address of employees using such machines to a file called compromised.csv .Please note that, certain IP addresses in the given address range cannot be assigned to end-user computers.

  1. Following up on 1 above, you also realized that the function to enforce password complexity did not work properly. Given that the password policy has the requirements below, implement a function to print out the names of all employees with weak passwords.
  • At least 8 characters in length
  • Must have a combination of upper- and lower-case characters
  • Must have at least 1 digit

  1. Management of your organization has informed you that the name of the Accounting department has been changed to Finance. Write a function to create a new file (empdata-new.csv) containing information of all employees with the updated department names. Your program should display the names of employees from the Finance Department.
  2. Using the functions implemented above, implement a menu system that allows any of the functions above to be select by users and the corresponding tasks performed.

EMPDATA.CSV file: (table scrolls to the right)

first_name last_name email ip_address department username Password
Aaron Stevens astevens1c@dailymotion.com 144.246.48.229 Product Management astevens1c IW8JT2R8
Amy King akingm@barnesandnoble.com 37.103.166.158 Human Resources akingm yH2gyDQZfjp
Andrew Bowman abowmane@bbb.org 194.147.141.95 Marketing abowmane dZfErQSdKFi
Beverly Perez bperez7@dailymotion.com 5.25.161.180 Product Management bperez7 lBSdzIds6QZ4
Billy Ramirez bramirez12@ameblo.jp 59.199.83.184 Engineering bramirez12 9cLR8rgBR1vM
Brandon Cook bcook4@umn.edu 234.228.150.168 Marketing bcook4 AN1xnOoEa
Brenda Brown bbrowng@squidoo.com 152.51.251.169 Human Resources bbrowng nobbp57gdbyr

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!