Data Cleaning: There are $7,361$ 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 iden$$fy these games based off the value $$N$$ in the $4$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 $1$ indica$$ng the home team won and a $0$ indica$$ng the home team lost.

e$.$ In the original dataset, PassCmp to TotalTO are all team sta$$s$$cs$.$ In the cleaned dataset, there should be two variables for each team sta$$s$$c$.$ I want to create a variable star$$ng with $$H$$ for the home team, and a variable star$$ng with $$A$$ for the away team. For example, in your cleaned dataset, I want the fi$$h variable to be HPassCmp $($Passing comple$$ons for the home team$)$ and the sixth variable to be APassCmp $($Passing comple$$ons 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.