Question: Please answer the following in python script! As the system administrator of your organization, your security team has informed you that the total number of

Please answer the following in python script!

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, 210 login attempts or more within a month is an anomaly. The file attached (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. Please comment each and every line of code. Also print the new script created to show the results.

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!