Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data Cleaning: There are 7 , 3 6 1 rows in this dataset. I expect you to clean the data following the steps below using
Data Cleaning: There are rows in this dataset. I expect you to clean the data following the steps below using code in some programming language.a You need to figure out how to convert this dataset where there are two rows for each game to one row for each game.b I want you to remove all games that are played on a neutral field. This means there is no home team and no away team. You can idenfy these games based off the value N in the th column.c In your cleaned dataset, the first three variables need to be Date, Home, Away containing the date of the game, name of the home team, and name of the away team for each individual game.d In your cleaned dataset, the fourth variable should be called HomeWins and this variable should be binary with a indicang the home team won and a indicang the home team lost.e In the original dataset, PassCmp to TotalTO are all team stascs In the cleaned dataset, there should be two variables for each team stasc I want to create a variable starng with H for the home team, and a variable starng with A for the away team. For example, in your cleaned dataset, I want the fih variable to be HPassCmp Passing compleons for the home team and the sixth variable to be APassCmp Passing compleons for the away team Following this patern, the next variable in your cleaned dataset should be HPassAtt, then APassAtt, then HPassPct, then APassPct then you should get the point.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started