How to Clean and Prepare Data for Analysis

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1	Original header rows and formatting
2
3								Playing Time				Performance							Per 90 Minutes					Expected				Per 90 Minutes
4	Rk	Player	Nation	Pos	Squad	Age	Born	MP	Starts	Min	90s	Gls	Ast	G-PK	PK	PKatt	CrdY	CrdR	Gls	Ast	G+A	G-PK	G+A-PK	xG	npxG	xA	npxG+xA	xG	xA	xG+xA	npxG	npxG+xA	Matches
5	1	Patrick van Aanholt	nl NED	DF	Crystal Palace	29	1990	22	20	1,777	19.7	0	1	0	0	0	2	0	0	0.05	0.05	0	0.05	1.2	1.2	0.8	2	0.06	0.04	0.1	0.06	0.1	Matches
6	2	Tammy Abraham	eng ENG	FW	Chelsea	22	1997	22	12	1,040	11.6	6	1	6	0	0	0	0	0.52	0.09	0.61	0.52	0.61	6.4	6.4	0.9	7.3	0.56	0.07	0.63	0.56	0.63	Matches
7	3	Che Adams	sco SCO	FW	Southampton	24	1996	36	30	2,667	29.6	9	5	9	0	0	1	0	0.3	0.17	0.47	0.3	0.47	8.8	8.8	5.8	14.5	0.3	0.19	0.49	0.3	0.49	Matches
8	4	Tosin Adarabioyo	eng ENG	DF	Fulham	22	1997	33	33	2,953	32.8	0	0	0	0	0	1	0	0	0	0	0	0	1.1	1.1	0.4	1.5	0.03	0.01	0.04	0.03	0.04	Matches
9	5	Adrián	es ESP	GK	Liverpool	33	1987	3	3	270	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Matches
10	6	Sergio Agüero	ar ARG	FW,MF	Manchester City	32	1988	12	7	559	6.2	4	1	3	1	2	0	0	0.64	0.16	0.81	0.48	0.64	3.4	1.8	1.3	3.1	0.54	0.21	0.75	0.3	0.51	Matches
11	7	Ola Aina	ng NGA	DF	Fulham	23	1996	31	31	2,664	29.6	2	1	2	0	0	3	0	0.07	0.03	0.1	0.07	0.1	1	1	1.4	2.3	0.03	0.05	0.08	0.03	0.08	Matches
12	8	Rayan Aït Nouri	fr FRA	DF	Wolves	19	2001	21	16	1,404	15.6	1	1	1	0	0	1	0	0.06	0.06	0.13	0.06	0.13	0.6	0.6	1	1.6	0.04	0.06	0.1	0.04	0.1	Matches
13	9	Semi Ajayi	ng NGA	DF	West Brom	26	1993	33	31	2,780	30.9	2	0	2	0	0	3	1	0.06	0	0.06	0.06	0.06	1.3	1.3	0.3	1.5	0.04	0.01	0.05	0.04	0.05	Matches
14	10	Nathan Aké	nl NED	DF	Manchester City	25	1995	10	9	797	8.9	1	0	1	0	0	4	0	0.11	0	0.11	0.11	0.11	0.1	0.1	0	0.1	0.01	0	0.02	0.01	0.02	Matches
15
16
17	Changes for cleaning the header
18	1. Consolidate column names into a single header row
19	2. Adjust labels for clarity
20	3. Remove text colors
21	4. Remove cell borders
22
23
24	Rank	Player	Nation	Position	Squad	Age	Born	MP	Starts	Min	90s	Goals	Assists	Goals+Assists	PK	PK attempts	Yellow Cards	Red Cards	Goals/90m	Assists	Goals+Assists/90m	Goals-PK/90m	Goals+Assists-PKs/90m	xGoals	npxGoals	xAssists	npxGoals+xAssists	xGoals/90m	xAssists/90m	xGoals+xAssists/90m	npxGoals/90m	npxGoals+xAssists/90m	Matches
25	1	Patrick van Aanholt	nl NED	DF	Crystal Palace	29	1990	22	20	1,777	19.7	0	1	0	0	0	2	0	0	0.05	0.05	0	0.05	1.2	1.2	0.8	2	0.06	0.04	0.1	0.06	0.1	Matches
26	2	Tammy Abraham	eng ENG	FW	Chelsea	22	1997	22	12	1,040	11.6	6	1	6	0	0	0	0	0.52	0.09	0.61	0.52	0.61	6.4	6.4	0.9	7.3	0.56	0.07	0.63	0.56	0.63	Matches
27	3	Che Adams	sco SCO	FW	Southampton	24	1996	36	30	2,667	29.6	9	5	9	0	0	1	0	0.3	0.17	0.47	0.3	0.47	8.8	8.8	5.8	14.5	0.3	0.19	0.49	0.3	0.49	Matches
28	4	Tosin Adarabioyo	eng ENG	DF	Fulham	22	1997	33	33	2,953	32.8	0	0	0	0	0	1	0	0	0	0	0	0	1.1	1.1	0.4	1.5	0.03	0.01	0.04	0.03	0.04	Matches
29	5	Adrián	es ESP	GK	Liverpool	33	1987	3	3	270	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Matches
30	6	Sergio Agüero	ar ARG	FW,MF	Manchester City	32	1988	12	7	559	6.2	4	1	3	1	2	0	0	0.64	0.16	0.81	0.48	0.64	3.4	1.8	1.3	3.1	0.54	0.21	0.75	0.3	0.51	Matches
31	7	Ola Aina	ng NGA	DF	Fulham	23	1996	31	31	2,664	29.6	2	1	2	0	0	3	0	0.07	0.03	0.1	0.07	0.1	1	1	1.4	2.3	0.03	0.05	0.08	0.03	0.08	Matches
32	8	Rayan Aït Nouri	fr FRA	DF	Wolves	19	2001	21	16	1,404	15.6	1	1	1	0	0	1	0	0.06	0.06	0.13	0.06	0.13	0.6	0.6	1	1.6	0.04	0.06	0.1	0.04	0.1	Matches
33	9	Semi Ajayi	ng NGA	DF	West Brom	26	1993	33	31	2,780	30.9	2	0	2	0	0	3	1	0.06	0	0.06	0.06	0.06	1.3	1.3	0.3	1.5	0.04	0.01	0.05	0.04	0.05	Matches
34	10	Nathan Aké	nl NED	DF	Manchester City	25	1995	10	9	797	8.9	1	0	1	0	0	4	0	0.11	0	0.11	0.11	0.11	0.1	0.1	0	0.1	0.01	0	0.02	0.01	0.02	Matches
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100