Question: Please code in python. As the system administrator of your organization, your security team has informed you that the total number of login attempts by

Please code 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, 250 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 of the suspicious employee accounts.

Make sure you:

Comment code appropriately Method to read data from file Determine employees with suspicious login attempts Method to create a file for suspicious employee login information

Below is an employee login script.

Firstname Lastname Total Logins ip_address

Codie;Junifer;244;218.57.222.107

Dale;Cullingford;177;199.21.64.239

Dasie;Rodolf;171;45.235.38.213

Noach;Maydway;197;50.42.18.134

Franzen;Osgood;247;1.240.128.146

Tailor;Godbert;236;158.209.83.51

Avictor;Bibby;393;129.8.83.247

Constantine;Dawe;309;230.253.173.140

Michaeline;Petraitis;289;89.86.60.249

Nat;Jobin;303;227.6.83.117

Elene;Passby;384;17.120.34.217

Gardy;Speere;224;200.52.159.209

Bea;VanEeden;174;31.129.57.71

Beth;Favey;162;216.65.100.191

Zahara;Edis;304;86.228.227.122

Abner;Cordelle;361;40.96.143.227

Hyatt;Franzotto;166;86.225.116.42

Jacintha;Vittore;111;146.198.141.158

Beilul;DeBiaggi;168;134.227.97.105

Meagan;Eckhard;390;195.17.79.179

Camille;Lowles;225;169.226.183.221

Bjorn;Martinets;162;70.228.166.161

Dagmar;Godmar;226;236.62.236.67

Jackie;Edon;208;127.2.93.232

Garfield;Kidson;214;169.141.80.195

Kitty;Pomphrett;236;158.124.160.53

Anatola;Carlo;103;78.74.23.26

Odette;Bodemeaid;346;119.10.161.54

Jolyn;Joddins;192;183.98.163.232

Thomasin;Greenall;173;17.228.59.90

Nanni;Pala;196;230.164.199.65

Cheston;Askaw;230;225.141.23.175

Nelly;Clawson;262;158.17.103.255

Kakalina;Mitton;131;98.116.200.206

Boot;Sudran;195;13.80.128.13

Bibbie;Caldwell;210;94.91.228.88

Jethro;Lisciandro;223;36.179.167.234

Rennie;Steffan;390;102.210.153.227

Aurthur;Paradine;137;190.73.63.178

Cornelius;Cicci;167;30.48.189.78

Marena;Benoiton;349;117.206.122.85

Oliviero;Dennington;296;4.77.108.204

Tandie;Broadbear;254;126.116.254.85

Sunny;Stuck;247;187.166.190.252

Humfried;Cornilleau;389;245.84.188.184

Othilie;Cowherd;249;239.232.72.212

Gran;Hinnerk;120;131.240.148.163

Goldy;Fishleigh;346;117.166.168.207

Annette;Lanceter;228;152.232.218.28

Austine;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!