Question: Hello could you please help me with the question below!! It should be in python! As the system administrator of your organization, your security team

Hello could you please help me with the question below!! It should be in python!

As the system administrator of your organization, your security team has informed you that the total number of login attempts by some employees raises security concerns. The security team indicated to you that, for each employee, 220 login attempts or more within a month is an anomaly. The file attached (employee-logins.csv)details the login attempts by each employee. Write a python script that creates a file that contains the First Name, Last Name and the Count of Login attempts by employees with suspicious logins. Your script should have at least two user-defined methods; one for reading the data from the given file and the other for creating the new file with suspicious login employee information. In addition to creating the files, print to the console the first and last names, and login attempts of the suspicious employee accounts.

The following is the employee-logins.csv file:

First_name;Last_name;Tota_Logins;ip_address

Codie;Junifer;244;218.57.222.107Dale;Cullingford;177;199.21.64.239Dasie;Rodolf;171;45.235.38.213Noach;Maydway;197;50.42.18.134Franzen;Osgood;247;1.240.128.146Tailor;Godbert;236;158.209.83.51Avictor;Bibby;393;129.8.83.247Constantine;Dawe;309;230.253.173.140Michaeline;Petraitis;289;89.86.60.249Nat;Jobin;303;227.6.83.117Elene;Passby;384;17.120.34.217Gardy;Speere;224;200.52.159.209Bea;VanEeden;174;31.129.57.71Beth;Favey;162;216.65.100.191Zahara;Edis;304;86.228.227.122Abner;Cordelle;361;40.96.143.227Hyatt;Franzotto;166;86.225.116.42Jacintha;Vittore;111;146.198.141.158Beilul;DeBiaggi;168;134.227.97.105Meagan;Eckhard;390;195.17.79.179Camille;Lowles;225;169.226.183.221Bjorn;Martinets;162;70.228.166.161Dagmar;Godmar;226;236.62.236.67Jackie;Edon;208;127.2.93.232Garfield;Kidson;214;169.141.80.195Kitty;Pomphrett;236;158.124.160.53Anatola;Carlo;103;78.74.23.26Odette;Bodemeaid;346;119.10.161.54Jolyn;Joddins;192;183.98.163.232Thomasin;Greenall;173;17.228.59.90Nanni;Pala;196;230.164.199.65Cheston;Askaw;230;225.141.23.175Nelly;Clawson;262;158.17.103.255Kakalina;Mitton;131;98.116.200.206Boot;Sudran;195;13.80.128.13Bibbie;Caldwell;210;94.91.228.88Jethro;Lisciandro;223;36.179.167.234Rennie;Steffan;390;102.210.153.227Aurthur;Paradine;137;190.73.63.178Cornelius;Cicci;167;30.48.189.78Marena;Benoiton;349;117.206.122.85Oliviero;Dennington;296;4.77.108.204Tandie;Broadbear;254;126.116.254.85Sunny;Stuck;247;187.166.190.252Humfried;Cornilleau;389;245.84.188.184Othilie;Cowherd;249;239.232.72.212Gran;Hinnerk;120;131.240.148.163Goldy;Fishleigh;346;117.166.168.207Annette;Lanceter;228;152.232.218.28Austine;Falcus;297;222.26.105.190

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!

Hello, can you please help with these questions? Question 3 SQ XS Tanjong PLC is a limited company by share incorporated back in 1926 at Malaysia. The main 2 x 40 nature of business of this company...

Please help me answer this question Background Veronese 81 Tiffany Inc. is a medium-sized business located in Elmira, Ontario. It sells designerjewelry to specialty stores through Canada as well as...

hi expert please help me answer this question How would you justify the need for the proposed change to Jinnah? Suggest some techniques to handle the senior yet problematic employees. At 8:00a.m. on...

hi expert please help me answer this question thank you. How can formal workforce planning benefit Jinnah? At 8:00 am on the first day of 2018, it was still early for the full work of Jinnah...

Hi! Attached is the case study. My questions for this case study is Conceptual (C)C3.3) on page 8. Conceptual (C) C3.3) Do you believe the independence rules are sufficient to ensure that the public...

please help me answer this question will rate your answer right away! Requirements: A summary of the key issues and your thoughts about important aspects of an analysis or recommendation. A...

CAN YOU PLEASE HELP ME SOLVE THE QUESTION REFERENCING THE ANNUAL REPORT OF BILLABOG 2015 AND 2016. THANKS FEDERATION BUSINESS SCHOOL BUACC1508 ACCOUNTING AND FINANCE ASSESSMENT TASK 2: GROUP...

Hello can you please help with this case study, that's an exercice given by the teacher in order for us to get ready for the mid-term, he said he is going to give something like that, so we should...

hello, can you please help me answer the questions attached. Attached is the case merger and sample write-up. Its be in Times New Roman 12-point font, double-spaced and 4 pages. Any supporting...

Hello. Can you please help me fill out this excel master budget sheets (all tabs) using the instructions from the pdf attachment? Thank you! Buns Bakery Basic Information For Year Ended December 31,...

If only one force acts on a particle, must this force necessarily change the particles (a) kinetic energy and (b) velocity? Explain your answers for both parts.

XYZ Inc., a media corporation headquartered in Texas, has its operations across different nations. The activities of the firm are affected by the government policies and the ideologies of the...

EXERCISE 3-12. Costing Units Completed and Ending Work in Process At the start of October, Helbert Pure Extract had Work in Process Inventory consisting of 2,000 units that were 90 percent complete...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Provide examples of KPIs in Human Capital Management.

What would an Internal Compa-Ratio of 118% indicate for an employee?

What are OLAP Cubes?