Question: Question 2 - - Cleaning the data ( 5 marks ) In this dataset there are two types of maps, escort and control. On control

Question 2-- Cleaning the data (5 marks) In this dataset there are two types of maps, escort and control. On control maps, the teams try to control an objective until the meter reaches 100. On escort maps, the attacker tries to escort a payload to the end of the map, while the defender tries to stop it. Control maps can be found in the dataset by rows where the control_perecent is not 0 for at least one team. That is, control_perecent will be Nan or 0 for both teams when the map is not a control map. 2a)(1 marks) Create a variable for map type called map_type, which has two possible values "control" and "escort". 2b)(2 marks) For rows which correspond to control maps, set the time_banked and payload distance values to NaN. 2c)(2 marks) Ensure that round_start_time and round_end_time time variables are in the date_time format (print out the type) and create a variable called year which contains the year the match took place

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 Programming Questions!