Fifa World Cup 2022 Dataset

Author

Guibril Ramde

Approach

In this project, I selected the FIFA World Cup 2022 Matches dataset from Discussion 5A. The dataset is not organized according to tidy data principles because many variables are separated into different columns for each team (for example, statistics recorded for team1 and team2).

The first step of the analysis is to clean and restructure the dataset using tidy data principles. Using functions from the tidyverse, particularly pivot_longer(), the dataset will be transformed into a tidy format where each variable has its own column and each observation corresponds to a single row.

After tidying the dataset, exploratory analysis will be performed to evaluate how each country performs in terms of match statistics such as total attempts, passes, and goals scored. Finally, visualizations will be created using ggplot2 to highlight patterns and comparisons between teams in the FIFA World Cup 2022.

library(tidyverse)
Warning: package 'ggplot2' was built under R version 4.5.2
Warning: package 'tibble' was built under R version 4.5.2
Warning: package 'tidyr' was built under R version 4.5.2
Warning: package 'readr' was built under R version 4.5.2
Warning: package 'purrr' was built under R version 4.5.2
Warning: package 'dplyr' was built under R version 4.5.2
── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
✔ dplyr     1.2.0     ✔ readr     2.1.6
✔ forcats   1.0.1     ✔ stringr   1.6.0
✔ ggplot2   4.0.2     ✔ tibble    3.3.1
✔ lubridate 1.9.4     ✔ tidyr     1.3.2
✔ purrr     1.2.1     
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()
ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
get_info <- "https://raw.githubusercontent.com/japhet125/Project2-Data-Science/refs/heads/main/Fifa_world_cup_matches.csv"

load_info <- read.csv(get_info)
load_info
            team1          team2 possession.team1 possession.team2
1           QATAR        ECUADOR              42%              50%
2         ENGLAND           IRAN              72%              19%
3         SENEGAL    NETHERLANDS              44%              45%
4   UNITED STATES          WALES              51%              39%
5       ARGENTINA   SAUDI ARABIA              64%              24%
6         DENMARK        TUNISIA              55%              33%
7          MEXICO         POLAND              54%              31%
8          FRANCE      AUSTRALIA              56%              35%
9         MOROCCO        CROATIA              32%              57%
10        GERMANY          JAPAN              65%              22%
11          SPAIN     COSTA RICA              74%              17%
12        BELGIUM         CANADA              46%              43%
13    SWITZERLAND       CAMEROON              43%              46%
14        URUGUAY KOREA REPUBLIC              49%              38%
15       PORTUGAL          GHANA              55%              35%
16         BRAZIL         SERBIA              53%              34%
17          WALES           IRAN              51%              33%
18          QATAR        SENEGAL              42%              48%
19    NETHERLANDS        ECUADOR              48%              39%
20        ENGLAND  UNITED STATES              51%              40%
21        TUNISIA      AUSTRALIA              50%              31%
22         POLAND   SAUDI ARABIA              30%              57%
23         FRANCE        DENMARK              44%              44%
24      ARGENTINA         MEXICO              50%              36%
25          JAPAN     COSTA RICA              48%              39%
26        BELGIUM        MOROCCO              56%              32%
27        CROATIA         CANADA              41%              46%
28          SPAIN        GERMANY              56%              33%
29       CAMEROON         SERBIA              38%              49%
30 KOREA REPUBLIC          GHANA              53%              32%
31         BRAZIL    SWITZERLAND              51%              40%
32       PORTUGAL        URUGUAY              53%              35%
33    NETHERLANDS          QATAR              54%              38%
34        ECUADOR        SENEGAL              51%              32%
35          WALES        ENGLAND              33%              58%
36           IRAN  UNITED STATES              42%              45%
37      AUSTRALIA        DENMARK              24%              60%
38        TUNISIA         FRANCE              30%              56%
39         POLAND      ARGENTINA              24%              67%
40   SAUDI ARABIA         MEXICO              29%              55%
41        CROATIA        BELGIUM              43%              47%
42         CANADA        MOROCCO              52%              36%
43          JAPAN          SPAIN              14%              78%
44     COSTA RICA        GERMANY              27%              60%
45          GHANA        URUGUAY              46%              39%
46 KOREA REPUBLIC       PORTUGAL              34%              55%
47         SERBIA    SWITZERLAND              45%              41%
48       CAMEROON         BRAZIL              31%              56%
49    NETHERLANDS  UNITED STATES              33%              54%
50      ARGENTINA      AUSTRALIA              53%              35%
51         FRANCE         POLAND              48%              42%
52        ENGLAND        SENEGAL              54%              35%
53          JAPAN        CROATIA              35%              51%
54         BRAZIL KOREA REPUBLIC              47%              44%
55        MOROCCO          SPAIN              22%              68%
56       PORTUGAL    SWITZERLAND              43%              48%
57        CROATIA         BRAZIL              45%              45%
58    NETHERLANDS      ARGENTINA              45%              44%
59        MOROCCO       PORTUGAL              22%              65%
60        ENGLAND         FRANCE              54%              36%
61      ARGENTINA        CROATIA              34%              54%
62         FRANCE        MOROCCO              34%              55%
63        CROATIA        MOROCCO              45%              45%
64      ARGENTINA         FRANCE              46%              40%
   possession.in.contest number.of.goals.team1 number.of.goals.team2
1                     8%                     0                     2
2                     9%                     6                     2
3                    11%                     0                     2
4                    10%                     1                     1
5                    12%                     1                     2
6                    12%                     0                     0
7                    15%                     0                     0
8                     9%                     4                     1
9                    12%                     0                     0
10                   13%                     1                     2
11                    9%                     7                     0
12                   11%                     1                     0
13                   11%                     1                     0
14                   13%                     0                     0
15                   10%                     3                     2
16                   13%                     2                     0
17                   16%                     0                     2
18                   10%                     1                     3
19                   13%                     1                     1
20                    9%                     0                     0
21                   19%                     0                     1
22                   14%                     2                     0
23                   12%                     2                     1
24                   14%                     2                     0
25                   13%                     0                     1
26                   12%                     0                     2
27                   13%                     4                     1
28                   11%                     1                     1
29                   13%                     3                     3
30                   15%                     2                     3
31                    9%                     1                     0
32                   12%                     2                     0
33                    8%                     2                     0
34                   17%                     1                     2
35                   10%                     0                     3
36                   13%                     0                     1
37                   16%                     1                     0
38                   14%                     1                     0
39                    9%                     0                     2
40                   17%                     1                     2
41                   10%                     0                     0
42                   12%                     1                     2
43                    8%                     2                     1
44                   13%                     2                     4
45                   15%                     0                     2
46                   11%                     2                     1
47                   14%                     2                     3
48                   13%                     1                     0
49                   13%                     3                     1
50                   12%                     2                     1
51                   10%                     3                     1
52                   11%                     3                     0
53                   14%                     1                     1
54                    9%                     4                     1
55                   10%                     0                     0
56                    9%                     6                     1
57                   10%                     1                     1
58                   11%                     2                     2
59                   13%                     1                     0
60                   10%                     1                     2
61                   12%                     3                     0
62                   11%                     2                     0
63                   10%                     2                     1
64                   14%                     3                     3
          date    hour                 category total.attempts.team1
1  20 NOV 2022 17 : 00                  Group A                    5
2  21 NOV 2022 14 : 00                  Group B                   13
3  21 NOV 2022 17 : 00                  Group A                   14
4  21 NOV 2022 20 : 00                  Group B                    6
5  22 NOV 2022 11 : 00                  Group C                   14
6  22 NOV 2022 14 : 00                  Group D                   11
7  22 NOV 2022 17 : 00                  Group C                   13
8  22 NOV 2022 20 : 00                  Group D                   22
9  23 NOV 2022 11 : 00                  Group F                    8
10 23 NOV 2022 14 : 00                  Group E                   25
11 23 NOV 2022 17 : 00                  Group E                   17
12 23 NOV 2022 20 : 00                  Group F                    9
13 24 NOV 2022 11 : 00                  Group G                    8
14 24 NOV 2022 14 : 00                  Group H                   10
15 24 NOV 2022 17 : 00                  Group H                   11
16 24 NOV 2022 20 : 00                  Group G                   24
17 25 NOV 2022 11 : 00                  Group B                   10
18 25 NOV 2022 14 : 00                  Group A                   10
19 25 NOV 2022 17 : 00                  Group A                    2
20 25 NOV 2022 20 : 00                  Group B                    8
21 26 NOV 2022 11 : 00                  Group D                   13
22 26 NOV 2022 14 : 00                  Group C                    8
23 26 NOV 2022 17 : 00                  Group D                   21
24 26 NOV 2022 20 : 00                  Group C                    5
25 27 NOV 2022 11 : 00                  Group E                   14
26 27 NOV 2022 14 : 00                  Group F                   10
27 27 NOV 2022 17 : 00                  Group F                   13
28 27 NOV 2022 20 : 00                  Group E                    7
29 28 NOV 2022 11 : 00                  Group G                   13
30 28 NOV 2022 14 : 00                  Group H                   21
31 28 NOV 2022 17 : 00                  Group G                    9
32 28 NOV 2022 20 : 00                  Group H                   14
33 29 NOV 2022 16 : 00                  Group A                   13
34 29 NOV 2022 16 : 00                  Group A                    8
35 29 NOV 2022 20 : 00                  Group B                    7
36 29 NOV 2022 20 : 00                  Group B                    6
37 30 NOV 2022 16 : 00                  Group D                    8
38 30 NOV 2022 16 : 00                  Group D                    5
39 30 NOV 2022 20 : 00                  Group C                    4
40 30 NOV 2022 20 : 00                  Group C                   10
41 01 DEC 2022 16 : 00                  Group F                   11
42 01 DEC 2022 16 : 00                  Group F                    5
43 01 DEC 2022 20 : 00                  Group E                    6
44 01 DEC 2022 20 : 00                  Group E                    8
45 02 DEC 2022 16 : 00                  Group H                    9
46 02 DEC 2022 16 : 00                  Group H                   12
47 02 DEC 2022 20 : 00                  Group G                   11
48 02 DEC 2022 20 : 00                  Group G                    7
49 03 DEC 2022 16 : 00              Round of 16                   11
50 03 DEC 2022 20 : 00              Round of 16                   14
51 04 DEC 2022 16 : 00              Round of 16                   16
52 04 DEC 2022 20 : 00              Round of 16                    8
53 05 DEC 2022 16 : 00              Round of 16                   12
54 05 DEC 2022 20 : 00              Round of 16                   18
55 06 DEC 2022 16 : 00              Round of 16                    6
56 06 DEC 2022 20 : 00              Round of 16                   14
57 09 DEC 2022 16 : 00            Quarter-final                    9
58 09 DEC 2022 20 : 00            Quarter-final                    5
59 10 DEC 2022 16 : 00            Quarter-final                    9
60 10 DEC 2022 20 : 00            Quarter-final                   14
61 13 DEC 2022 20 : 00               Semi-final                   10
62 14 DEC 2022 20 : 00               Semi-final                   14
63 17 DEC 2022 16 : 00 Play-off for third place                   14
64 18 DEC 2022 16 : 00                    Final                   21
   total.attempts.team2 conceded.team1 conceded.team2
1                     6              2              0
2                     8              2              6
3                     9              2              0
4                     7              1              1
5                     3              2              1
6                    11              0              0
7                     8              0              0
8                     4              1              4
9                     6              0              0
10                   10              2              1
11                    0              0              7
12                   21              0              1
13                    7              0              1
14                    6              0              0
15                    8              2              3
16                    4              0              2
17                   21              2              0
18                   12              3              1
19                   13              1              1
20                   10              0              0
21                    8              1              0
22                   16              0              2
23                   10              1              2
24                    4              0              2
25                    4              1              0
26                   11              2              0
27                    9              1              4
28                   10              1              1
29                   16              3              3
30                    8              3              2
31                    4              0              1
32                   10              0              2
33                    6              0              2
34                   15              2              1
35                   17              3              0
36                   12              1              0
37                   14              0              1
38                    9              0              1
39                   25              2              0
40                   25              2              1
41                   15              0              0
42                    7              2              1
43                   14              1              2
44                   32              4              2
45                   12              2              0
46                   12              1              2
47                   14              3              2
48                   19              0              1
49                   18              1              3
50                    5              1              2
51                   11              1              3
52                   10              0              3
53                   16              1              1
54                   10              1              4
55                   13              0              0
56                   10              1              6
57                   20              1              1
58                   15              2              2
59                   11              0              1
60                    9              2              1
61                   12              0              3
62                   13              0              2
63                    7              1              2
64                   10              3              3
   goal.inside.the.penalty.area.team1 goal.inside.the.penalty.area.team2
1                                   0                                  2
2                                   6                                  2
3                                   0                                  2
4                                   1                                  1
5                                   1                                  2
6                                   0                                  0
7                                   0                                  0
8                                   4                                  1
9                                   0                                  0
10                                  1                                  2
11                                  7                                  0
12                                  1                                  0
13                                  1                                  0
14                                  0                                  0
15                                  3                                  2
16                                  2                                  0
17                                  0                                  1
18                                  1                                  3
19                                  0                                  1
20                                  0                                  0
21                                  0                                  1
22                                  2                                  0
23                                  2                                  1
24                                  1                                  0
25                                  0                                  1
26                                  0                                  2
27                                  3                                  1
28                                  1                                  1
29                                  3                                  2
30                                  2                                  3
31                                  1                                  0
32                                  1                                  0
33                                  2                                  0
34                                  1                                  2
35                                  0                                  2
36                                  0                                  1
37                                  1                                  0
38                                  0                                  0
39                                  0                                  2
40                                  1                                  1
41                                  0                                  0
42                                  0                                  1
43                                  1                                  1
44                                  2                                  4
45                                  0                                  2
46                                  2                                  1
47                                  2                                  3
48                                  1                                  0
49                                  3                                  1
50                                  2                                  0
51                                  3                                  1
52                                  3                                  0
53                                  1                                  1
54                                  4                                  0
55                                  0                                  0
56                                  6                                  1
57                                  1                                  1
58                                  2                                  2
59                                  1                                  0
60                                  1                                  1
61                                  3                                  0
62                                  2                                  0
63                                  2                                  1
64                                  3                                  3
   goal.outside.the.penalty.area.team1 goal.outside.the.penalty.area.team2
1                                    0                                   0
2                                    0                                   0
3                                    0                                   0
4                                    0                                   0
5                                    0                                   0
6                                    0                                   0
7                                    0                                   0
8                                    0                                   0
9                                    0                                   0
10                                   0                                   0
11                                   0                                   0
12                                   0                                   0
13                                   0                                   0
14                                   0                                   0
15                                   0                                   0
16                                   0                                   0
17                                   0                                   1
18                                   0                                   0
19                                   1                                   0
20                                   0                                   0
21                                   0                                   0
22                                   0                                   0
23                                   0                                   0
24                                   1                                   0
25                                   0                                   0
26                                   0                                   0
27                                   1                                   0
28                                   0                                   0
29                                   0                                   1
30                                   0                                   0
31                                   0                                   0
32                                   1                                   0
33                                   0                                   0
34                                   0                                   0
35                                   0                                   1
36                                   0                                   0
37                                   0                                   0
38                                   1                                   0
39                                   0                                   0
40                                   0                                   1
41                                   0                                   0
42                                   0                                   1
43                                   1                                   0
44                                   0                                   0
45                                   0                                   0
46                                   0                                   0
47                                   0                                   0
48                                   0                                   0
49                                   0                                   0
50                                   0                                   0
51                                   0                                   0
52                                   0                                   0
53                                   0                                   0
54                                   0                                   1
55                                   0                                   0
56                                   0                                   0
57                                   0                                   0
58                                   0                                   0
59                                   0                                   0
60                                   0                                   1
61                                   0                                   0
62                                   0                                   0
63                                   0                                   0
64                                   0                                   0
   assists.team1 assists.team2 on.target.attempts.team1
1              0             1                        0
2              6             1                        7
3              0             1                        3
4              1             0                        1
5              0             1                        6
6              0             0                        4
7              0             0                        4
8              4             1                        7
9              0             0                        2
10             0             1                        9
11             4             0                        7
12             1             0                        3
13             1             0                        3
14             0             0                        0
15             2             2                        5
16             1             0                       10
17             0             1                        3
18             1             2                        2
19             1             0                        1
20             0             0                        3
21             0             1                        4
22             1             0                        3
23             2             1                        6
24             2             0                        2
25             0             1                        3
26             0             2                        4
27             4             1                       10
28             1             1                        3
29             3             3                        8
30             2             2                        6
31             1             0                        5
32             0             0                        4
33             1             0                        4
34             1             0                        4
35             0             2                        1
36             0             1                        2
37             1             0                        4
38             1             0                        3
39             0             2                        0
40             1             1                        2
41             0             0                        4
42             0             1                        0
43             2             1                        3
44             0             4                        6
45             0             1                        4
46             1             1                        6
47             1             3                        4
48             1             0                        3
49             3             1                        6
50             1             0                        5
51             3             0                        7
52             3             0                        4
53             1             1                        4
54             3             0                        9
55             0             0                        3
56             5             0                        9
57             1             1                        1
58             2             1                        2
59             1             0                        3
60             0             2                        6
61             1             0                        7
62             0             0                        2
63             2             0                        4
64             1             1                        9
   on.target.attempts.team2 off.target.attempts.team1 off.target.attempts.team2
1                         3                         5                         3
2                         3                         3                         4
3                         3                         8                         5
4                         3                         4                         3
5                         2                         5                         0
6                         1                         4                         7
7                         1                         5                         4
8                         1                         9                         3
9                         2                         0                         2
10                        3                        11                         6
11                        0                         8                         0
12                        4                         6                        12
13                        3                         4                         2
14                        0                         6                         5
15                        3                         3                         5
16                        0                         9                         3
17                        6                         4                         6
18                        4                         7                         6
19                        5                         1                         3
20                        2                         4                         7
21                        2                         5                         3
22                        5                         3                         9
23                        2                         8                         6
24                        1                         3                         2
25                        1                         4                         1
26                        4                         6                         6
27                        2                         2                         3
28                        4                         4                         5
29                        6                         3                         8
30                        3                         8                         3
31                        0                         2                         1
32                        3                         7                         6
33                        4                         5                         2
34                        5                         3                         8
35                        7                         3                         6
36                        5                         4                         4
37                        3                         2                         7
38                        3                         2                         4
39                       13                         2                         8
40                       10                         8                         8
41                        4                         5                         7
42                        2                         4                         2
43                        5                         2                         3
44                       11                         1                        17
45                        7                         4                         5
46                        4                         4                         6
47                        7                         6                         3
48                        6                         3                        11
49                        7                         4                         4
50                        2                         7                         2
51                        3                         7                         5
52                        2                         4                         6
53                        4                         4                         8
54                        6                         8                         2
55                        1                         3                         6
56                        1                         2                         7
57                       11                         4                         4
58                        6                         2                         8
59                        3                         6                         6
60                        5                         4                         3
61                        3                         2                         7
62                        1                         8                         6
63                        2                         8                         5
64                        5                         9                         3
   attempts.inside.the.penalty.area.team1
1                                       2
2                                      10
3                                       7
4                                       4
5                                      10
6                                       7
7                                      10
8                                      18
9                                       3
10                                     15
11                                     12
12                                      6
13                                      6
14                                      7
15                                      7
16                                     11
17                                      5
18                                      4
19                                      0
20                                      6
21                                      9
22                                      8
23                                     16
24                                      2
25                                      7
26                                      5
27                                      9
28                                      3
29                                      9
30                                     15
31                                      6
32                                      4
33                                     10
34                                      5
35                                      1
36                                      5
37                                      3
38                                      2
39                                      2
40                                      6
41                                      7
42                                      4
43                                      4
44                                      6
45                                      4
46                                      6
47                                     10
48                                      5
49                                      7
50                                     11
51                                     10
52                                      7
53                                      5
54                                     14
55                                      3
56                                      9
57                                      5
58                                      3
59                                      5
60                                      6
61                                      7
62                                     12
63                                      7
64                                     10
   attempts.inside.the.penalty.area..team2
1                                        4
2                                        6
3                                        5
4                                        5
5                                        3
6                                        6
7                                        7
8                                        2
9                                        4
10                                      10
11                                       0
12                                      16
13                                       6
14                                       1
15                                       2
16                                       1
17                                       7
18                                      10
19                                       8
20                                       6
21                                       5
22                                       9
23                                       5
24                                       1
25                                       1
26                                       6
27                                       2
28                                       7
29                                      11
30                                       7
31                                       2
32                                       6
33                                       2
34                                      11
35                                      13
36                                       8
37                                      11
38                                       4
39                                      21
40                                      10
41                                      12
42                                       4
43                                       7
44                                      24
45                                       7
46                                       5
47                                      10
48                                      14
49                                      11
50                                       3
51                                       8
52                                       4
53                                       9
54                                       6
55                                       9
56                                       5
57                                      12
58                                       5
59                                       7
60                                       6
61                                       6
62                                       8
63                                       5
64                                       7
   attempts.outside.the.penalty.area..team1
1                                         3
2                                         3
3                                         7
4                                         2
5                                         4
6                                         4
7                                         3
8                                         4
9                                         5
10                                       10
11                                        5
12                                        3
13                                        2
14                                        3
15                                        4
16                                       13
17                                        5
18                                        6
19                                        2
20                                        2
21                                        4
22                                        0
23                                        5
24                                        3
25                                        7
26                                        5
27                                        4
28                                        4
29                                        4
30                                        6
31                                        3
32                                       10
33                                        3
34                                        3
35                                        6
36                                        1
37                                        5
38                                        3
39                                        2
40                                        4
41                                        4
42                                        1
43                                        2
44                                        2
45                                        5
46                                        6
47                                        1
48                                        2
49                                        4
50                                        3
51                                        6
52                                        1
53                                        7
54                                        4
55                                        3
56                                        5
57                                        4
58                                        2
59                                        4
60                                        8
61                                        3
62                                        2
63                                        7
64                                       11
   attempts.outside.the.penalty.area..team2 left.channel.team1
1                                         2                 15
2                                         2                 11
3                                         4                 12
4                                         2                 14
5                                         0                 12
6                                         5                 17
7                                         1                 20
8                                         2                 30
9                                         2                  8
10                                        0                 24
11                                        0                 30
12                                        5                  6
13                                        1                 19
14                                        5                 13
15                                        6                 24
16                                        3                 14
17                                       14                 18
18                                        2                  7
19                                        5                  8
20                                        4                 11
21                                        3                 12
22                                        7                  7
23                                        5                 15
24                                        3                 10
25                                        3                 28
26                                        5                 12
27                                        7                  7
28                                        3                 12
29                                        5                  5
30                                        1                 22
31                                        2                 19
32                                        4                 17
33                                        4                 25
34                                        4                 13
35                                        4                  7
36                                        4                 12
37                                        3                  9
38                                        5                 11
39                                        4                  6
40                                       15                  5
41                                        3                 23
42                                        3                 22
43                                        7                  2
44                                        8                  7
45                                        5                 12
46                                        7                  9
47                                        4                 17
48                                        5                  8
49                                        7                  4
50                                        2                 15
51                                        3                 15
52                                        6                 17
53                                        7                 14
54                                        4                 20
55                                        4                 11
56                                        5                  8
57                                        8                 19
58                                       10                 11
59                                        4                  4
60                                        3                 17
61                                        6                  8
62                                        5                  9
63                                        2                 20
64                                        3                 13
   left.channel.team2 left.inside.channel.team1 left.inside.channel.team2
1                   8                         0                         7
2                   3                         5                         0
3                  11                         4                         2
4                   7                         5                         2
5                   3                         4                         2
6                   9                         4                         2
7                   8                         6                         6
8                  11                         6                         2
9                  12                         1                         3
10                  5                         9                         0
11                  5                         4                         0
12                 17                         3                         6
13                  9                         2                        12
14                 15                         4                         0
15                  7                         6                         9
16                 10                         9                         3
17                  7                         3                         3
18                 26                         5                         4
19                 10                         8                         5
20                 12                         2                         0
21                 11                         8                         3
22                 21                         2                         6
23                 13                         7                         5
24                  8                         6                         1
25                  8                         6                         0
26                 10                         8                         3
27                  8                         3                         4
28                  3                         3                         3
29                 20                         3                         4
30                  8                         5                         3
31                  7                        12                         3
32                 13                         9                         8
33                 10                         9                         7
34                 14                         3                         0
35                 10                         1                         4
36                 11                         2                         7
37                 27                         2                         5
38                 14                         3                         6
39                 25                         2                         8
40                 16                         3                         5
41                 18                         7                         5
42                  6                         4                         0
43                 30                         3                         9
44                 29                         5                        13
45                  7                         5                         2
46                 23                         7                         7
47                 14                         6                         7
48                 20                         8                         5
49                 13                         2                         8
50                  8                         6                         1
51                 15                         7                         2
52                  8                         6                         1
53                 18                         6                         7
54                 19                         5                         4
55                 36                         1                        10
56                 18                         3                         2
57                 25                         4                        10
58                  7                         7                         7
59                 27                         1                        10
60                 15                         6                         2
61                 18                         9                         6
62                 10                         6                         4
63                 13                         8                         1
64                 15                         6                         7
   central.channel.team1 central.channel.team2 right.inside.channel.team1
1                      3                     6                          1
2                      2                     3                          3
3                      2                     2                          4
4                      4                     5                          4
5                      5                     3                          8
6                      7                     2                          6
7                      1                     6                          3
8                      3                     5                          8
9                      6                     6                          0
10                    14                     3                          5
11                     8                     1                          6
12                     5                     8                          2
13                    11                     3                          6
14                     4                     4                          6
15                     7                     6                          4
16                    10                     4                          7
17                     8                     7                         11
18                     2                     6                          5
19                     2                     2                          4
20                     7                     1                          5
21                     7                     4                          6
22                     4                     5                          8
23                     4                     3                          1
24                     2                     1                          4
25                     9                     3                          3
26                     3                     2                          4
27                     3                     3                          3
28                     2                     4                          1
29                     5                    16                          4
30                     6                     4                          8
31                     5                     4                          5
32                     4                     4                          9
33                     8                     5                         11
34                     1                     2                          6
35                     2                     7                          0
36                     5                     7                          3
37                     2                     4                          1
38                     4                     5                          0
39                     1                     7                          2
40                     4                     3                          3
41                     3                     7                          2
42                     2                     3                          6
43                     1                     6                          2
44                     3                    13                          1
45                     8                    13                          4
46                     5                     5                          2
47                     4                     3                          4
48                     4                     6                          4
49                     4                     4                          7
50                    11                     2                          2
51                     2                     2                          9
52                     2                     0                          2
53                     6                     9                          6
54                     5                     3                          7
55                     0                     8                          2
56                     6                     6                          6
57                     2                    15                          5
58                     9                    13                          3
59                     4                     8                          1
60                     4                     7                          2
61                     7                     7                          3
62                     3                     6                          2
63                     3                     3                          2
64                     8                     5                          9
   right.inside.channel.team2 right.channel.team1 right.channel.team2
1                           4                   9                   6
2                           1                  11                   0
3                           7                  13                  20
4                           2                  11                   7
5                           3                  18                   8
6                           3                  18                   6
7                           4                  27                  13
8                           1                  19                   9
9                           5                  11                   7
10                          3                  21                  11
11                          0                  12                   1
12                          5                   6                  20
13                          5                  16                  18
14                          4                  14                  19
15                          3                  10                   3
16                          3                  20                   7
17                          4                  13                   7
18                          4                  11                  18
19                          5                  11                   4
20                          6                  11                   8
21                          7                  11                  19
22                          7                  13                  15
23                          4                  13                  25
24                          2                  12                  11
25                          1                  10                   4
26                          1                   9                  11
27                          4                   3                  13
28                          3                   5                   8
29                          5                  15                  12
30                          3                  27                   7
31                          6                  11                  10
32                          5                  11                   9
33                          4                  21                   6
34                          7                   6                  10
35                         12                   4                   9
36                          5                   4                  17
37                          6                  11                  19
38                          3                  10                  21
39                         10                   3                  26
40                          7                  11                  16
41                          4                  12                   9
42                          4                  11                   5
43                         11                   5                  22
44                         12                   1                  15
45                          3                  12                  17
46                          8                   7                  12
47                          1                  10                  12
48                          7                   9                  13
49                          9                  10                  15
50                          6                  17                   9
51                          3                  19                  10
52                          4                  13                   9
53                          6                  18                  28
54                          5                  15                  21
55                         19                   8                  29
56                          2                   8                   8
57                          8                  27                  20
58                          6                  15                  17
59                          7                   3                  20
60                          2                  10                  13
61                          4                   2                   8
62                          6                   6                  19
63                          7                   7                  16
64                          4                   9                  12
   total.offers.to.receive.team1 total.offers.to.receive.team2
1                            520                           532
2                           1061                           212
3                            502                           506
4                            725                           436
5                            650                           268
6                            681                           477
7                            547                           296
8                            691                           521
9                            498                           626
10                           865                           346
11                          1085                           250
12                           618                           582
13                           609                           561
14                           566                           551
15                           762                           459
16                           727                           414
17                           722                           343
18                           511                           553
19                           632                           541
20                           676                           539
21                           710                           342
22                           428                           661
23                           630                           615
24                           569                           373
25                           699                           429
26                           732                           441
27                           573                           592
28                           633                           440
29                           419                           583
30                           695                           389
31                           659                           568
32                           752                           413
33                           785                           574
34                           453                           268
35                           388                           777
36                           492                           697
37                           302                           640
38                           381                           630
39                           328                           907
40                           337                           492
41                           650                           581
42                           703                           493
43                           315                          1138
44                           344                           747
45                           597                           424
46                           470                           740
47                           577                           456
48                           397                           643
49                           404                           820
50                           869                           538
51                           568                           501
52                           794                           489
53                           692                           717
54                           666                           547
55                           438                           896
56                           614                           617
57                           674                           737
58                           722                           644
59                           339                           780
60                           661                           401
61                           349                           643
62                           330                           702
63                           519                           609
64                           607                           507
   inbehind.offers.to.receive.team1 inbehind.offers.to.receive.team2
1                               116                              127
2                               207                               53
3                               123                              117
4                               149                              100
5                               157                               69
6                               152                               89
7                               128                               72
8                               150                               95
9                               106                               99
10                              199                              102
11                              180                               52
12                              115                              140
13                              153                              109
14                              157                              136
15                              168                               87
16                              144                               67
17                              135                              109
18                              109                              136
19                              129                               86
20                              116                              129
21                              166                              108
22                              140                              156
23                              111                              171
24                              103                               78
25                              176                               77
26                              144                              109
27                              113                              121
28                               90                              108
29                              103                              124
30                              175                               72
31                              154                              128
32                              142                              115
33                              157                              100
34                               83                               76
35                               71                              140
36                               94                              133
37                               88                              146
38                               99                               96
39                               62                              175
40                              100                              194
41                              124                              123
42                              189                               78
43                               77                              174
44                              100                              217
45                              154                              117
46                               93                              159
47                               92                              108
48                               88                              145
49                               73                              179
50                              131                              105
51                              118                              124
52                              140                               95
53                              157                              175
54                              149                              116
55                              103                              182
56                              134                              115
57                              156                              153
58                              117                               97
59                               68                              205
60                              127                               84
61                               89                              136
62                               82                              136
63                              117                              127
64                              146                              105
   inbetween.offers.to.receive.team1 inbetween.offers.to.receive.team2
1                                235                               187
2                                386                                86
3                                230                               191
4                                336                               172
5                                177                               131
6                                276                               204
7                                202                               101
8                                182                               208
9                                193                               197
10                               366                               146
11                               418                               104
12                               268                               279
13                               256                               248
14                               155                               228
15                               308                               187
16                               275                               185
17                               286                               149
18                               199                               190
19                               267                               276
20                               290                               238
21                               291                               120
22                               164                               264
23                               226                               268
24                               244                               151
25                               255                               177
26                               211                               173
27                               256                               247
28                               270                               177
29                               149                               261
30                               234                               157
31                               218                               212
32                               327                               155
33                               322                               245
34                               174                               115
35                               138                               310
36                               223                               262
37                               114                               259
38                               175                               212
39                               126                               282
40                               162                               158
41                               338                               181
42                               211                               227
43                               106                               286
44                               156                               272
45                               247                               157
46                               186                               195
47                               214                               193
48                               144                               328
49                               200                               360
50                               337                               184
51                               207                               224
52                               276                               193
53                               270                               247
54                               257                               270
55                               176                               279
56                               241                               240
57                               250                               239
58                               278                               278
59                               150                               208
60                               312                               136
61                               122                               291
62                                99                               314
63                               198                               202
64                               257                               207
   infront.offers.to.receive.team1 infront.offers.to.receive.team2
1                              169                             218
2                              468                              73
3                              149                             198
4                              240                             164
5                              316                              68
6                              253                             184
7                              217                             123
8                              359                             218
9                              199                             330
10                             300                              98
11                             487                              94
12                             235                             163
13                             200                             204
14                             254                             187
15                             286                             185
16                             308                             162
17                             301                              85
18                             203                             227
19                             236                             179
20                             270                             172
21                             253                             114
22                             124                             241
23                             293                             176
24                             222                             144
25                             268                             175
26                             377                             159
27                             204                             224
28                             273                             155
29                             167                             198
30                             286                             160
31                             287                             228
32                             283                             143
33                             306                             229
34                             196                              77
35                             179                             327
36                             175                             302
37                             100                             235
38                             107                             322
39                             140                             450
40                              75                             140
41                             188                             277
42                             303                             188
43                             132                             678
44                              88                             258
45                             196                             150
46                             191                             386
47                             271                             155
48                             165                             170
49                             131                             281
50                             401                             249
51                             243                             153
52                             378                             201
53                             265                             295
54                             260                             161
55                             159                             435
56                             239                             262
57                             268                             345
58                             327                             269
59                             121                             367
60                             222                             181
61                             138                             216
62                             149                             252
63                             204                             280
64                             204                             195
   receptions.between.midfield.and.defensive.lines.team1
1                                                      5
2                                                     16
3                                                     15
4                                                     12
5                                                     26
6                                                     14
7                                                     20
8                                                     26
9                                                      4
10                                                    19
11                                                    23
12                                                     8
13                                                    13
14                                                     4
15                                                    20
16                                                    11
17                                                    13
18                                                     9
19                                                     4
20                                                    10
21                                                    13
22                                                    14
23                                                    11
24                                                     2
25                                                     5
26                                                     4
27                                                    15
28                                                    16
29                                                    15
30                                                    19
31                                                    16
32                                                    11
33                                                    16
34                                                     2
35                                                     1
36                                                     9
37                                                     8
38                                                     9
39                                                     2
40                                                     6
41                                                    17
42                                                     8
43                                                    10
44                                                    10
45                                                     8
46                                                     8
47                                                     7
48                                                     9
49                                                     8
50                                                     8
51                                                    14
52                                                    11
53                                                     8
54                                                    17
55                                                    10
56                                                     9
57                                                    10
58                                                     5
59                                                     6
60                                                     8
61                                                     7
62                                                     8
63                                                    15
64                                                    43
   receptions.between.midfield.and.defensive.lines.team2
1                                                      8
2                                                      4
3                                                     14
4                                                      9
5                                                      9
6                                                      7
7                                                      3
8                                                      7
9                                                      9
10                                                    10
11                                                     1
12                                                    15
13                                                     5
14                                                     8
15                                                     5
16                                                     4
17                                                     9
18                                                    12
19                                                    12
20                                                     6
21                                                     8
22                                                    22
23                                                    17
24                                                     5
25                                                     1
26                                                     7
27                                                     6
28                                                     9
29                                                    11
30                                                     5
31                                                     4
32                                                     6
33                                                    11
34                                                    12
35                                                     9
36                                                    17
37                                                    17
38                                                    11
39                                                    21
40                                                    17
41                                                    12
42                                                     8
43                                                    17
44                                                    28
45                                                    14
46                                                    12
47                                                    10
48                                                     9
49                                                    17
50                                                     8
51                                                    11
52                                                     7
53                                                    14
54                                                    15
55                                                    27
56                                                     8
57                                                    11
58                                                     7
59                                                    19
60                                                     7
61                                                     3
62                                                    15
63                                                    10
64                                                    10
   attempted.line.breaks.team1 attempted.line.breaks.team2
1                          136                         155
2                          238                         101
3                          151                         162
4                          199                         174
5                          191                         137
6                          190                         174
7                          170                         150
8                          173                         133
9                          142                         169
10                         241                         113
11                         276                         119
12                         175                         176
13                         178                         182
14                         146                         185
15                         198                         150
16                         184                         140
17                         208                         185
18                         174                         184
19                         168                         155
20                         208                         143
21                         200                         171
22                         150                         205
23                         155                         173
24                         150                         127
25                         158                         154
26                         149                         125
27                         193                         201
28                         186                         143
29                         173                         184
30                         201                         122
31                         164                         173
32                         170                         150
33                         185                         161
34                         146                         153
35                         104                         167
36                         195                         185
37                         166                         241
38                         153                         138
39                         117                         214
40                         178                         198
41                         204                         177
42                         153                         147
43                         104                         190
44                         154                         193
45                         188                         186
46                         139                         178
47                         157                         157
48                         144                         181
49                         161                         187
50                         181                         146
51                         174                         156
52                         184                         159
53                         229                         232
54                         193                         188
55                         164                         219
56                         165                         167
57                         240                         185
58                         194                         203
59                         128                         167
60                         147                         136
61                         147                         182
62                         126                         141
63                         164                         150
64                         223                         163
   completed.line.breaksteam1 completed.line.breaks.team2
1                          86                          99
2                         178                          45
3                          89                          96
4                         146                         103
5                         127                          68
6                         136                          85
7                         117                          82
8                         135                          84
9                          81                         116
10                        185                          70
11                        233                          58
12                        118                         123
13                        123                         103
14                         88                          96
15                        149                          88
16                        134                          91
17                        129                          92
18                        117                         113
19                        115                          84
20                        147                          88
21                        109                          91
22                         84                         153
23                        105                         132
24                        100                          66
25                         95                          85
26                        104                          89
27                        124                         134
28                        146                          83
29                         78                         122
30                        148                          66
31                        114                         100
32                        112                          86
33                        165                         107
34                         77                          84
35                         55                         131
36                        102                         133
37                         81                         172
38                         96                          99
39                         66                         188
40                         86                         121
41                        159                         115
42                         91                          85
43                         57                         140
44                        103                         159
45                        111                         124
46                         87                         123
47                         95                          95
48                         92                         145
49                         95                         126
50                        135                          92
51                        111                          97
52                        129                          86
53                        116                         132
54                        145                         137
55                         86                         158
56                         98                         107
57                        180                         121
58                        130                         122
59                         63                         118
60                        108                          87
61                         91                         129
62                         85                          95
63                        114                          97
64                        151                          99
   attempted.defensive.line.breaks.team1 attempted.defensive.line.breaks.team2
1                                      9                                    13
2                                     25                                     7
3                                     22                                    22
4                                     23                                    17
5                                     39                                    15
6                                     21                                    17
7                                     32                                    12
8                                     32                                    15
9                                     10                                    18
10                                    23                                    17
11                                    34                                    11
12                                    13                                    23
13                                    21                                    16
14                                    16                                    17
15                                    26                                    12
16                                    16                                    15
17                                    17                                    24
18                                    13                                    19
19                                     9                                    22
20                                    23                                    15
21                                    23                                    19
22                                    22                                    27
23                                    16                                    23
24                                    10                                    13
25                                    22                                     4
26                                    13                                    11
27                                    24                                    15
28                                    19                                    17
29                                    22                                    22
30                                    24                                    12
31                                    20                                    17
32                                    11                                    17
33                                    13                                    15
34                                    10                                    20
35                                     4                                    13
36                                    23                                    27
37                                    17                                    21
38                                    21                                    10
39                                     5                                    25
40                                    17                                    33
41                                    23                                    26
42                                    21                                    16
43                                    14                                    21
44                                    13                                    34
45                                    13                                    24
46                                    11                                    21
47                                    10                                    20
48                                    16                                    15
49                                    17                                    28
50                                    16                                    12
51                                    26                                    20
52                                    16                                    15
53                                    21                                    20
54                                    21                                    20
55                                    22                                    37
56                                    16                                    17
57                                    16                                    19
58                                    15                                    24
59                                    13                                    23
60                                    13                                    14
61                                    17                                     9
62                                    12                                    18
63                                    23                                    14
64                                    38                                    14
   completed.defensive.line.breaksteam1 completed.defensive.line.breaks.team2
1                                     4                                     7
2                                    16                                     4
3                                    15                                    10
4                                    15                                     8
5                                    25                                     7
6                                    12                                     6
7                                    19                                     2
8                                    27                                     7
9                                     4                                     9
10                                   20                                    11
11                                   22                                     1
12                                    6                                    13
13                                   13                                     4
14                                    7                                     8
15                                   18                                     4
16                                   10                                     6
17                                    8                                    10
18                                    7                                     9
19                                    4                                    10
20                                   10                                     5
21                                   11                                    10
22                                   12                                    19
23                                   12                                    15
24                                    5                                     5
25                                    7                                     0
26                                    3                                     8
27                                   10                                     6
28                                   13                                     7
29                                   12                                    12
30                                   19                                     5
31                                   11                                     4
32                                    7                                    11
33                                   10                                    10
34                                    2                                    12
35                                    1                                     8
36                                    8                                    16
37                                    7                                    17
38                                    7                                     4
39                                    1                                    19
40                                    5                                    16
41                                   17                                    14
42                                    8                                     7
43                                    8                                    15
44                                    7                                    25
45                                    5                                    14
46                                    6                                    12
47                                    5                                     8
48                                    7                                     9
49                                    7                                    17
50                                    8                                     7
51                                   14                                    12
52                                   12                                     7
53                                    8                                    11
54                                   17                                    14
55                                    9                                    25
56                                    8                                     7
57                                   10                                    10
58                                    6                                     8
59                                    3                                    18
60                                   10                                     8
61                                    7                                     1
62                                    8                                    11
63                                   12                                     8
64                                   23                                     9
   yellow.cards.team1 yellow.cards.team2 red.cards.team1 red.cards.team2
1                   4                  2               0               0
2                   0                  2               0               0
3                   2                  1               0               0
4                   4                  2               0               0
5                   0                  6               0               0
6                   2                  1               0               0
7                   2                  1               0               0
8                   0                  3               0               0
9                   1                  0               0               0
10                  0                  0               0               0
11                  0                  2               0               0
12                  3                  2               0               0
13                  2                  1               0               0
14                  1                  1               0               0
15                  2                  4               0               0
16                  0                  3               0               0
17                  1                  2               1               0
18                  3                  3               0               0
19                  0                  1               0               0
20                  0                  0               0               0
21                  3                  0               0               0
22                  3                  2               0               0
23                  1                  2               0               0
24                  1                  4               0               0
25                  3                  3               0               0
26                  1                  1               0               0
27                  2                  2               0               0
28                  1                  3               0               0
29                  2                  2               0               0
30                  2                  2               0               0
31                  1                  1               0               0
32                  3                  2               0               0
33                  1                  0               0               0
34                  0                  1               0               0
35                  2                  0               0               0
36                  3                  1               0               0
37                  2                  1               0               0
38                  1                  0               0               0
39                  1                  1               0               0
40                  6                  1               0               0
41                  0                  1               0               0
42                  4                  0               0               0
43                  3                  0               0               0
44                  1                  0               0               0
45                  2                  5               0               0
46                  2                  0               0               0
47                  7                  4               0               0
48                  5                  2               1               0
49                  2                  0               0               0
50                  0                  2               0               0
51                  1                  2               0               0
52                  0                  1               0               0
53                  0                  2               0               0
54                  0                  1               0               0
55                  1                  1               0               0
56                  0                  2               0               0
57                  2                  3               0               0
58                  8                  8               1               0
59                  3                  1               1               0
60                  1                  3               0               0
61                  2                  2               0               0
62                  0                  1               0               0
63                  0                  2               0               0
64                  4                  3               0               0
   fouls.against.team1 fouls.against.team2 offsides.team1 offsides.team2
1                   15                  15              3              4
2                    9                  14              2              2
3                   13                  13              2              1
4                   15                  10              1              1
5                    7                  21             10              1
6                    9                  10              1              1
7                   14                  16              3              0
8                    5                  11              0              0
9                   17                  11              0              1
10                   6                  14              4              4
11                   8                  12              3              7
12                  11                  14              0              1
13                  12                  10              2              2
14                   7                  10              1              0
15                  14                  19              1              1
16                   7                  12              1              0
17                   9                  10              2              2
18                   7                  12              4              3
19                  15                  12              1              4
20                   9                  15              1              0
21                  16                  15              3              0
22                  18                  15              0              0
23                   4                   9              1              1
24                  15                  19              2              4
25                  22                   9              0              2
26                  10                  14              3              3
27                  13                   5              1              3
28                  13                  11              2              5
29                   8                  13              0              4
30                  13                   9              1              1
31                  10                  17              3              1
32                  10                  16              2              0
33                  19                   9              4              0
34                  23                  11              0              3
35                  16                   9              1              1
36                  13                  10              2              1
37                  11                  10              1              3
38                  14                   6              3              2
39                   6                  11              0              0
40                  20                  18              2              6
41                   7                   9              4              0
42                  14                  14              4              4
43                   9                   6              2              2
44                   3                   9              4              3
45                  18                  11              2              2
46                   9                  11              1              5
47                  18                  13              0              0
48                  14                  14              0              1
49                  10                   5              0              3
50                   8                  15              4              0
51                  10                   8              3              1
52                  16                  12              0              0
53                  13                  16              3              0
54                   8                  13              0              5
55                  15                  14              5              4
56                  12                  10              3              3
57                  22                  24              3              3
58                  30                  18              1              2
59                  15                   9              2              2
60                  10                  14              1              2
61                  15                   8              1              0
62                  11                  11              4              3
63                  13                  11              2              2
64                  26                  19              4              4
   passes.team1 passes.team2 passes.completed.team1 passes.completed.team2
1           450          480                    381                    409
2           809          224                    730                    154
3           383          438                    313                    374
4           569          409                    509                    321
5           610          267                    529                    190
6           594          387                    523                    302
7           485          322                    422                    241
8           734          466                    672                    399
9           360          667                    290                    592
10          820          261                    743                    207
11         1061          231                   1003                    170
12          512          448                    439                    382
13          497          500                    437                    424
14          528          419                    459                    340
15          636          394                    573                    326
16          585          403                    526                    341
17          508          295                    413                    202
18          424          511                    353                    445
19          524          425                    451                    345
20          550          427                    488                    368
21          501          334                    396                    239
22          303          560                    236                    494
23          503          537                    437                    473
24          533          356                    464                    287
25          575          444                    510                    371
26          671          317                    598                    275
27          462          511                    391                    434
28          647          352                    565                    281
29          364          513                    271                    433
30          540          319                    477                    260
31          565          488                    498                    415
32          596          390                    517                    306
33          795          459                    740                    394
34          432          269                    353                    198
35          325          588                    261                    529
36          463          470                    379                    413
37          286          650                    187                    567
38          328          636                    266                    566
39          321          862                    261                    814
40          297          412                    197                    336
41          578          596                    504                    531
42          539          384                    472                    308
43          225         1070                    167                    992
44          347          727                    269                    661
45          460          446                    377                    361
46          359          606                    304                    541
47          476          403                    390                    325
48          295          548                    239                    491
49          396          567                    320                    487
50          711          450                    635                    381
51          540          466                    481                    391
52          597          393                    523                    320
53          532          735                    414                    624
54          616          548                    556                    486
55          323         1041                    229                    967
56          461          512                    392                    436
57          715          695                    632                    625
58          651          603                    557                    511
59          229          678                    171                    592
60          508          369                    453                    310
61          408          624                    344                    551
62          358          583                    307                    518
63          491          494                    430                    428
64          648          516                    544                    419
   crosses.team1 crosses.team2 crosses.completed.team1 crosses.completed.team2
1              9            14                       4                       4
2             23             8                       7                       1
3             19            25                       7                       8
4             31            15                       4                       6
5             29             9                      12                       2
6             27            13                      10                       3
7             33            10                       8                       2
8             34             9                      17                       2
9             10            19                       1                       4
10            28            16                       9                       3
11            17             5                       2                       0
12             8            19                       5                       6
13            28            20                       6                       4
14            16            19                       4                       3
15            17            12                       4                       3
16            19            13                       3                       3
17            20            26                       5                       4
18            18            20                       5                       6
19             8            22                       0                       4
20            13            16                       4                       2
21            23            23                       5                       4
22            19            24                       8                       4
23            23            18                      12                       4
24            14            17                       2                       4
25            17             5                       1                       0
26            19             9                       3                       4
27            22            15                       5                       5
28             9            13                       2                       1
29            20            23                       1                       4
30            46            13                      16                       4
31            26            11                       3                       3
32            16            18                       4                       5
33            11            16                       1                       4
34            19            20                       6                       5
35             4            17                       1                       7
36            18            22                       3                       2
37            11            32                       2                       5
38            27            20                       4                       5
39             5            22                       2                       5
40             9            34                       2                       6
41            24            24                       6                       8
42            20             7                       4                       1
43             6            20                       3                       2
44            12            38                       3                      12
45            20            15                       2                       4
46            13            22                       3                       6
47            23            13                       6                       4
48            12            28                       3                       8
49            13            27                       4                       2
50             6            15                       1                       2
51            27            18                       4                       7
52            19            13                       7                       3
53            28            35                       6                       9
54            18            14                       4                       1
55            10            27                       4                       4
56            14            15                       6                       1
57            22            25                       5                       6
58            22            16                       4                       4
59             8            33                       3                       7
60            22            13                       5                       6
61             8            20                       2                       4
62             5            22                       2                       1
63            21            20                       3                       5
64            20            24                       4                       3
   switches.of.play.completed.team1 switches.of.play.completed.team2
1                                 9                                9
2                                12                                3
3                                 9                                6
4                                 5                                8
5                                 5                                7
6                                11                                1
7                                 9                                1
8                                 6                                5
9                                 6                                7
10                                4                                2
11                                8                                1
12                                4                                6
13                                4                                8
14                               10                                9
15                               13                                2
16                                6                                6
17                               13                                5
18                               12                                9
19                                6                                2
20                                9                                2
21                                6                                2
22                                5                               13
23                                7                               14
24                                3                                2
25                                2                                7
26                                6                               10
27                                6                                7
28                                9                                2
29                                5                                5
30                               16                                3
31                                6                                2
32                                9                                2
33                                1                               10
34                                1                                6
35                                1                                6
36                               11                                8
37                                1                                9
38                                4                                3
39                                8                               11
40                                1                                4
41                               18                                4
42                                3                               14
43                                2                                9
44                                4                                5
45                                3                                6
46                                9                               11
47                                7                                9
48                                4                                3
49                                4                                5
50                                5                                8
51                                4                                5
52                               11                                7
53                                5                                7
54                                9                               13
55                                4                                8
56                                7                                3
57                               13                                4
58                                5                                4
59                                4                                9
60                                5                                2
61                                4                                8
62                                1                                8
63                                7                               12
64                                6                                5
   corners.team1 corners.team2 free.kicks.team1 free.kicks.team2
1              1             3               19               17
2              8             0               16               10
3              6             7               14               14
4              5             3               11               15
5              9             2               22               16
6             11             9               11               10
7              6             5               16               16
8              8             1               11                5
9              0             5               12               17
10             6             6               17               10
11             5             0               18               11
12             4             4               15               10
13            11             5               11               14
14             4             3               10                8
15             3             3               19               15
16             6             4               12                8
17             2             7               12               11
18             6             7               15               11
19             2             5               16               16
20             3             7               15               10
21             5             2               15               19
22             4             5               15               17
23             6             4               10                5
24             4             2               23               17
25             5             0               11               22
26             9             1               17               13
27             5             2                8               14
28             6             5               16               15
29             4             3               17                8
30            12             5               10               14
31             8             3               18               13
32             6             2               15               13
33             4             2                9               24
34             3             6               14               22
35             1             6               10               17
36             1             5               11               15
37             2             6               13               12
38             7             8                8               17
39             1             9               12                5
40             1             8               23               22
41             2             4                9               11
42             6             2               18               18
43             0             2                8               11
44             1            14               12                7
45             5             2               12               20
46             5             4               15               10
47             2             0               14               18
48             3            11               15               14
49             4             5                8               10
50             1             3               15               11
51             7             1                8               11
52             3             3               12               16
53             8             5               16               16
54             5             4               16                8
55             0             8               18               20
56             6             6               13               15
57             3             7               27               25
58             2             8               20               30
59             3             9               11               17
60             5             2               14               11
61             2             4                6               16
62             2             3               13               15
63             6             3               13               15
64             6             5               22               28
   penalties.scored.team1 penalties.scored.team2 goal.preventions.team1
1                       0                      1                      6
2                       0                      1                      8
3                       0                      0                      9
4                       0                      1                      7
5                       1                      0                      4
6                       0                      0                     11
7                       0                      0                      8
8                       0                      0                      4
9                       0                      0                      7
10                      1                      0                     12
11                      1                      0                      0
12                      0                      0                     21
13                      0                      0                      7
14                      0                      0                      6
15                      1                      0                      8
16                      0                      0                      4
17                      0                      0                     21
18                      0                      0                     12
19                      0                      0                     14
20                      0                      0                     10
21                      0                      0                      9
22                      0                      0                     16
23                      0                      0                     10
24                      0                      0                      4
25                      0                      0                      4
26                      0                      0                     11
27                      0                      0                      9
28                      0                      0                     11
29                      0                      0                     16
30                      0                      0                      8
31                      0                      0                      4
32                      1                      0                     11
33                      0                      0                      5
34                      0                      1                     15
35                      0                      0                     17
36                      0                      0                     13
37                      0                      0                     14
38                      0                      0                     11
39                      0                      0                     25
40                      0                      0                     26
41                      0                      0                     16
42                      0                      0                      7
43                      0                      0                     14
44                      0                      0                     32
45                      0                      0                     12
46                      0                      0                     14
47                      0                      0                     14
48                      0                      0                     20
49                      0                      0                     18
50                      0                      0                      5
51                      0                      1                     11
52                      0                      0                     10
53                      0                      0                     18
54                      1                      0                     10
55                      0                      0                     14
56                      0                      0                     10
57                      0                      0                     21
58                      0                      1                     15
59                      0                      0                     11
60                      1                      0                      9
61                      1                      0                     12
62                      0                      0                     13
63                      0                      0                      7
64                      1                      2                     11
   goal.preventions.team2 own.goals.team1 own.goals.team2
1                       5               0               0
2                      13               0               0
3                      15               0               0
4                       7               0               0
5                      14               0               0
6                      11               0               0
7                      15               0               0
8                      22               0               0
9                       8               0               0
10                     26               0               0
11                     17               0               0
12                      9               0               0
13                      8               0               0
14                     10               0               0
15                     11               0               0
16                     24               0               0
17                      9               0               0
18                     11               0               0
19                      2               0               0
20                      8               0               0
21                     13               0               0
22                      9               0               0
23                     21               0               0
24                      5               0               0
25                     14               0               0
26                     10               0               0
27                     13               0               0
28                      7               0               0
29                     13               0               0
30                     21               0               0
31                      9               0               0
32                     14               0               0
33                     14               0               0
34                      8               0               0
35                      8               0               0
36                      6               0               0
37                      8               0               0
38                      6               0               0
39                      4               0               0
40                     10               0               0
41                     11               0               0
42                      7               0               1
43                      6               0               0
44                      8               0               0
45                      9               0               0
46                     12               0               0
47                     10               0               0
48                      7               0               0
49                     13               0               0
50                     14               1               0
51                     16               0               0
52                      8               0               0
53                     11               0               0
54                     18               0               0
55                      6               0               0
56                     15               0               0
57                      9               0               0
58                      5               0               0
59                     10               0               0
60                     15               0               0
61                     10               0               0
62                     14               0               0
63                     14               0               0
64                     21               0               0
   forced.turnovers.team1 forced.turnovers.team2
1                      52                     72
2                      63                     72
3                      63                     73
4                      81                     72
5                      65                     80
6                      76                     73
7                      61                     70
8                      64                     56
9                      87                     58
10                     55                     87
11                     46                     76
12                     74                     47
13                     64                     79
14                     65                     54
15                     70                     82
16                     72                     71
17                     89                     84
18                     67                     67
19                     85                     52
20                     52                     61
21                     81                     88
22                     69                     53
23                     79                     61
24                     63                     79
25                     47                     66
26                     38                     78
27                     87                     72
28                     79                    101
29                     83                     81
30                     53                     75
31                     85                     80
32                     68                     81
33                     62                     52
34                     59                     62
35                     49                     56
36                     63                     74
37                     90                     74
38                     68                     80
39                     67                     48
40                     82                     76
41                     70                     68
42                     66                     72
43                     85                     49
44                     79                     77
45                     92                     84
46                     54                     50
47                     74                     82
48                     78                     54
49                    101                     77
50                     67                     73
51                     71                     64
52                     60                     74
53                    100                    100
54                     73                     81
55                    100                     66
56                     71                     54
57                     95                     77
58                     91                     79
59                     88                     44
60                     49                     54
61                     85                     63
62                     72                     47
63                     75                     72
64                     87                    104
   defensive.pressures.applied.team1 defensive.pressures.applied.team2
1                                256                               279
2                                139                               416
3                                263                               251
4                                242                               292
5                                163                               361
6                                226                               287
7                                193                               290
8                                250                               316
9                                391                               217
10                               164                               487
11                               185                               585
12                               284                               320
13                               313                               316
14                               240                               231
15                               286                               326
16                               236                               338
17                               161                               276
18                               308                               232
19                               254                               279
20                               266                               350
21                               217                               273
22                               329                               173
23                               269                               282
24                               220                               327
25                               300                               294
26                               194                               360
27                               347                               316
28                               275                               387
29                               285                               234
30                               220                               324
31                               282                               344
32                               226                               362
33                               319                               322
34                               190                               243
35                               328                               167
36                               295                               302
37                               341                               161
38                               400                               202
39                               438                               141
40                               269                               229
41                               328                               346
42                               224                               324
43                               637                               150
44                               378                               230
45                               248                               293
46                               359                               233
47                               276                               253
48                               321                               226
49                               325                               256
50                               240                               453
51                               220                               297
52                               230                               339
53                               405                               308
54                               310                               329
55                               573                               217
56                               357                               240
57                               365                               423
58                               401                               323
59                               373                               165
60                               193                               308
61                               321                               260
62                               328                               218
63                               288                               277
64                               280                               409
colnames(load_info)
 [1] "team1"                                                
 [2] "team2"                                                
 [3] "possession.team1"                                     
 [4] "possession.team2"                                     
 [5] "possession.in.contest"                                
 [6] "number.of.goals.team1"                                
 [7] "number.of.goals.team2"                                
 [8] "date"                                                 
 [9] "hour"                                                 
[10] "category"                                             
[11] "total.attempts.team1"                                 
[12] "total.attempts.team2"                                 
[13] "conceded.team1"                                       
[14] "conceded.team2"                                       
[15] "goal.inside.the.penalty.area.team1"                   
[16] "goal.inside.the.penalty.area.team2"                   
[17] "goal.outside.the.penalty.area.team1"                  
[18] "goal.outside.the.penalty.area.team2"                  
[19] "assists.team1"                                        
[20] "assists.team2"                                        
[21] "on.target.attempts.team1"                             
[22] "on.target.attempts.team2"                             
[23] "off.target.attempts.team1"                            
[24] "off.target.attempts.team2"                            
[25] "attempts.inside.the.penalty.area.team1"               
[26] "attempts.inside.the.penalty.area..team2"              
[27] "attempts.outside.the.penalty.area..team1"             
[28] "attempts.outside.the.penalty.area..team2"             
[29] "left.channel.team1"                                   
[30] "left.channel.team2"                                   
[31] "left.inside.channel.team1"                            
[32] "left.inside.channel.team2"                            
[33] "central.channel.team1"                                
[34] "central.channel.team2"                                
[35] "right.inside.channel.team1"                           
[36] "right.inside.channel.team2"                           
[37] "right.channel.team1"                                  
[38] "right.channel.team2"                                  
[39] "total.offers.to.receive.team1"                        
[40] "total.offers.to.receive.team2"                        
[41] "inbehind.offers.to.receive.team1"                     
[42] "inbehind.offers.to.receive.team2"                     
[43] "inbetween.offers.to.receive.team1"                    
[44] "inbetween.offers.to.receive.team2"                    
[45] "infront.offers.to.receive.team1"                      
[46] "infront.offers.to.receive.team2"                      
[47] "receptions.between.midfield.and.defensive.lines.team1"
[48] "receptions.between.midfield.and.defensive.lines.team2"
[49] "attempted.line.breaks.team1"                          
[50] "attempted.line.breaks.team2"                          
[51] "completed.line.breaksteam1"                           
[52] "completed.line.breaks.team2"                          
[53] "attempted.defensive.line.breaks.team1"                
[54] "attempted.defensive.line.breaks.team2"                
[55] "completed.defensive.line.breaksteam1"                 
[56] "completed.defensive.line.breaks.team2"                
[57] "yellow.cards.team1"                                   
[58] "yellow.cards.team2"                                   
[59] "red.cards.team1"                                      
[60] "red.cards.team2"                                      
[61] "fouls.against.team1"                                  
[62] "fouls.against.team2"                                  
[63] "offsides.team1"                                       
[64] "offsides.team2"                                       
[65] "passes.team1"                                         
[66] "passes.team2"                                         
[67] "passes.completed.team1"                               
[68] "passes.completed.team2"                               
[69] "crosses.team1"                                        
[70] "crosses.team2"                                        
[71] "crosses.completed.team1"                              
[72] "crosses.completed.team2"                              
[73] "switches.of.play.completed.team1"                     
[74] "switches.of.play.completed.team2"                     
[75] "corners.team1"                                        
[76] "corners.team2"                                        
[77] "free.kicks.team1"                                     
[78] "free.kicks.team2"                                     
[79] "penalties.scored.team1"                               
[80] "penalties.scored.team2"                               
[81] "goal.preventions.team1"                               
[82] "goal.preventions.team2"                               
[83] "own.goals.team1"                                      
[84] "own.goals.team2"                                      
[85] "forced.turnovers.team1"                               
[86] "forced.turnovers.team2"                               
[87] "defensive.pressures.applied.team1"                    
[88] "defensive.pressures.applied.team2"                    

Data Source

The dataset originates from the FIFA World Cup 2022 and was obtained from Kaggle. It contains match statistics for teams that participated in the 2022 tournament held in Qatar. The dataset includes information such as passes, goals scored, and total attempts for each team. The dataset is stored locally as Fifa_world_cup_matches.csv. Showing raw structure

glimpse(load_info)
Rows: 64
Columns: 88
$ team1                                                 <chr> "QATAR", "ENGLAN…
$ team2                                                 <chr> "ECUADOR", "IRAN…
$ possession.team1                                      <chr> "42%", "72%", "4…
$ possession.team2                                      <chr> "50%", "19%", "4…
$ possession.in.contest                                 <chr> "8%", "9%", "11%…
$ number.of.goals.team1                                 <int> 0, 6, 0, 1, 1, 0…
$ number.of.goals.team2                                 <int> 2, 2, 2, 1, 2, 0…
$ date                                                  <chr> "20 NOV 2022", "…
$ hour                                                  <chr> "17 : 00", "14 :…
$ category                                              <chr> "Group A", "Grou…
$ total.attempts.team1                                  <int> 5, 13, 14, 6, 14…
$ total.attempts.team2                                  <int> 6, 8, 9, 7, 3, 1…
$ conceded.team1                                        <int> 2, 2, 2, 1, 2, 0…
$ conceded.team2                                        <int> 0, 6, 0, 1, 1, 0…
$ goal.inside.the.penalty.area.team1                    <int> 0, 6, 0, 1, 1, 0…
$ goal.inside.the.penalty.area.team2                    <int> 2, 2, 2, 1, 2, 0…
$ goal.outside.the.penalty.area.team1                   <int> 0, 0, 0, 0, 0, 0…
$ goal.outside.the.penalty.area.team2                   <int> 0, 0, 0, 0, 0, 0…
$ assists.team1                                         <int> 0, 6, 0, 1, 0, 0…
$ assists.team2                                         <int> 1, 1, 1, 0, 1, 0…
$ on.target.attempts.team1                              <int> 0, 7, 3, 1, 6, 4…
$ on.target.attempts.team2                              <int> 3, 3, 3, 3, 2, 1…
$ off.target.attempts.team1                             <int> 5, 3, 8, 4, 5, 4…
$ off.target.attempts.team2                             <int> 3, 4, 5, 3, 0, 7…
$ attempts.inside.the.penalty.area.team1                <int> 2, 10, 7, 4, 10,…
$ attempts.inside.the.penalty.area..team2               <int> 4, 6, 5, 5, 3, 6…
$ attempts.outside.the.penalty.area..team1              <int> 3, 3, 7, 2, 4, 4…
$ attempts.outside.the.penalty.area..team2              <int> 2, 2, 4, 2, 0, 5…
$ left.channel.team1                                    <int> 15, 11, 12, 14, …
$ left.channel.team2                                    <int> 8, 3, 11, 7, 3, …
$ left.inside.channel.team1                             <int> 0, 5, 4, 5, 4, 4…
$ left.inside.channel.team2                             <int> 7, 0, 2, 2, 2, 2…
$ central.channel.team1                                 <int> 3, 2, 2, 4, 5, 7…
$ central.channel.team2                                 <int> 6, 3, 2, 5, 3, 2…
$ right.inside.channel.team1                            <int> 1, 3, 4, 4, 8, 6…
$ right.inside.channel.team2                            <int> 4, 1, 7, 2, 3, 3…
$ right.channel.team1                                   <int> 9, 11, 13, 11, 1…
$ right.channel.team2                                   <int> 6, 0, 20, 7, 8, …
$ total.offers.to.receive.team1                         <int> 520, 1061, 502, …
$ total.offers.to.receive.team2                         <int> 532, 212, 506, 4…
$ inbehind.offers.to.receive.team1                      <int> 116, 207, 123, 1…
$ inbehind.offers.to.receive.team2                      <int> 127, 53, 117, 10…
$ inbetween.offers.to.receive.team1                     <int> 235, 386, 230, 3…
$ inbetween.offers.to.receive.team2                     <int> 187, 86, 191, 17…
$ infront.offers.to.receive.team1                       <int> 169, 468, 149, 2…
$ infront.offers.to.receive.team2                       <int> 218, 73, 198, 16…
$ receptions.between.midfield.and.defensive.lines.team1 <int> 5, 16, 15, 12, 2…
$ receptions.between.midfield.and.defensive.lines.team2 <int> 8, 4, 14, 9, 9, …
$ attempted.line.breaks.team1                           <int> 136, 238, 151, 1…
$ attempted.line.breaks.team2                           <int> 155, 101, 162, 1…
$ completed.line.breaksteam1                            <int> 86, 178, 89, 146…
$ completed.line.breaks.team2                           <int> 99, 45, 96, 103,…
$ attempted.defensive.line.breaks.team1                 <int> 9, 25, 22, 23, 3…
$ attempted.defensive.line.breaks.team2                 <int> 13, 7, 22, 17, 1…
$ completed.defensive.line.breaksteam1                  <int> 4, 16, 15, 15, 2…
$ completed.defensive.line.breaks.team2                 <int> 7, 4, 10, 8, 7, …
$ yellow.cards.team1                                    <int> 4, 0, 2, 4, 0, 2…
$ yellow.cards.team2                                    <int> 2, 2, 1, 2, 6, 1…
$ red.cards.team1                                       <int> 0, 0, 0, 0, 0, 0…
$ red.cards.team2                                       <int> 0, 0, 0, 0, 0, 0…
$ fouls.against.team1                                   <int> 15, 9, 13, 15, 7…
$ fouls.against.team2                                   <int> 15, 14, 13, 10, …
$ offsides.team1                                        <int> 3, 2, 2, 1, 10, …
$ offsides.team2                                        <int> 4, 2, 1, 1, 1, 1…
$ passes.team1                                          <int> 450, 809, 383, 5…
$ passes.team2                                          <int> 480, 224, 438, 4…
$ passes.completed.team1                                <int> 381, 730, 313, 5…
$ passes.completed.team2                                <int> 409, 154, 374, 3…
$ crosses.team1                                         <int> 9, 23, 19, 31, 2…
$ crosses.team2                                         <int> 14, 8, 25, 15, 9…
$ crosses.completed.team1                               <int> 4, 7, 7, 4, 12, …
$ crosses.completed.team2                               <int> 4, 1, 8, 6, 2, 3…
$ switches.of.play.completed.team1                      <int> 9, 12, 9, 5, 5, …
$ switches.of.play.completed.team2                      <int> 9, 3, 6, 8, 7, 1…
$ corners.team1                                         <int> 1, 8, 6, 5, 9, 1…
$ corners.team2                                         <int> 3, 0, 7, 3, 2, 9…
$ free.kicks.team1                                      <int> 19, 16, 14, 11, …
$ free.kicks.team2                                      <int> 17, 10, 14, 15, …
$ penalties.scored.team1                                <int> 0, 0, 0, 0, 1, 0…
$ penalties.scored.team2                                <int> 1, 1, 0, 1, 0, 0…
$ goal.preventions.team1                                <int> 6, 8, 9, 7, 4, 1…
$ goal.preventions.team2                                <int> 5, 13, 15, 7, 14…
$ own.goals.team1                                       <int> 0, 0, 0, 0, 0, 0…
$ own.goals.team2                                       <int> 0, 0, 0, 0, 0, 0…
$ forced.turnovers.team1                                <int> 52, 63, 63, 81, …
$ forced.turnovers.team2                                <int> 72, 72, 73, 72, …
$ defensive.pressures.applied.team1                     <int> 256, 139, 263, 2…
$ defensive.pressures.applied.team2                     <int> 279, 416, 251, 2…
dim(load_info)
[1] 64 88

Interpretation of the data:

The dataset contains 64 rows and 88 columns. Each match includes separate statistics for both teams (team1 and team2), resulting in a wide data format. This structure makes the dataset difficult to analyze directly. Therefore, the dataset will be transformed into a long tidy format to facilitate analysis and visualization.

We will use ggplot to visualize and analyze the dataset

Cleaning and filtering data

3.2 Data import and tidying

clean_load <- load_info %>%
  mutate(match_id = row_number()) %>%
  pivot_longer(
    cols = matches("\\.team1$|\\.team2$"),
    names_to = c("stat", "team_id"),
    names_sep = "\\.team",
    values_to = "value",
    values_transform = list(value = as.character)
  ) %>%
  mutate(
    team = ifelse(team_id == "1", team1, team2)
    
  ) %>%
  select(match_id, date, category, team, stat, value)
clean_load
# A tibble: 5,120 × 6
   match_id date        category team    stat                         value
      <int> <chr>       <chr>    <chr>   <chr>                        <chr>
 1        1 20 NOV 2022 Group A  QATAR   possession                   42%  
 2        1 20 NOV 2022 Group A  ECUADOR possession                   50%  
 3        1 20 NOV 2022 Group A  QATAR   number.of.goals              0    
 4        1 20 NOV 2022 Group A  ECUADOR number.of.goals              2    
 5        1 20 NOV 2022 Group A  QATAR   total.attempts               5    
 6        1 20 NOV 2022 Group A  ECUADOR total.attempts               6    
 7        1 20 NOV 2022 Group A  QATAR   conceded                     2    
 8        1 20 NOV 2022 Group A  ECUADOR conceded                     0    
 9        1 20 NOV 2022 Group A  QATAR   goal.inside.the.penalty.area 0    
10        1 20 NOV 2022 Group A  ECUADOR goal.inside.the.penalty.area 2    
# ℹ 5,110 more rows

Normalizing variables structure and Rename and Handling missing data

tidy_clean_load <- clean_load %>%
  mutate(value = as.numeric(value)) %>%
  filter(!is.na(value))
Warning: There was 1 warning in `mutate()`.
ℹ In argument: `value = as.numeric(value)`.
Caused by warning:
! NAs introduced by coercion

3.3 Analysis

To evaluate team performance, summary statistics were calculated for selected variables including:

  • Total attempts

  • Passes

  • Goals scored

  • For each statistic, the mean value per team was calculated using group_by() and summarise(). This approach allows comparison of average team performance across matches during the tournament.

The top teams were then identified using slice_max() and visualized using bar charts created with ggplot2

Analyzing the average total.attempts of each country

tidy_clean_load %>%
  filter(stat == "total.attempts") %>%
  mutate(value = as.numeric(value)) %>%
  group_by(team) %>%
  summarise(avg_team_attempts = mean(value, na.rm = TRUE), .groups = "drop") %>%
  arrange(desc(avg_team_attempts))
# A tibble: 32 × 2
   team           avg_team_attempts
   <chr>                      <dbl>
 1 GERMANY                     22.3
 2 BRAZIL                      18  
 3 ARGENTINA                   14.9
 4 FRANCE                      14.4
 5 MEXICO                      14  
 6 SENEGAL                     12.8
 7 SPAIN                       12.8
 8 PORTUGAL                    12.4
 9 KOREA REPUBLIC              12.2
10 ENGLAND                     12  
# ℹ 22 more rows

Visualize

tidy_clean_load %>%
  filter(stat == "total.attempts") %>%
  mutate(value = as.numeric(value)) %>%
  group_by(team) %>%
  summarise(avg_team_attempts = mean(value, na.rm = TRUE), .groups = "drop") %>%
  slice_max(avg_team_attempts, n = 10) %>%
  ggplot(aes(x = reorder(team, avg_team_attempts), y = avg_team_attempts)) +
  geom_col(fill = "darkgreen") +
  coord_flip() +
  labs(
    title = "Top 10 Countries With Highest Attempts",
    x = "Country",
    y = "Average Attempts"
  ) +
  theme_minimal()

Analyzing the average passes of each country

tidy_clean_load %>%
  filter(stat == "passes") %>%
  mutate(value = as.numeric(value)) %>%
  group_by(team) %>%
  summarise(avg_team_passes = mean(value, na.rm = TRUE)) %>%
  arrange(desc(avg_team_passes))
# A tibble: 32 × 2
   team        avg_team_passes
   <chr>                 <dbl>
 1 SPAIN                  955.
 2 GERMANY                633 
 3 ARGENTINA              625 
 4 ENGLAND                610.
 5 CROATIA                610.
 6 BRAZIL                 602.
 7 PORTUGAL               595.
 8 DENMARK                594.
 9 BELGIUM                593 
10 NETHERLANDS            561.
# ℹ 22 more rows

Visualizing the dataset of average team passes

tidy_clean_load %>%
  filter(stat == "passes") %>%
  mutate(value = as.numeric(value)) %>%
  group_by(team) %>%
  summarise(avg_team_passes = mean(value, na.rm = TRUE), .groups = "drop") %>%
  slice_max(avg_team_passes, n = 10) %>%
  ggplot(aes(x = reorder(team, avg_team_passes), y = avg_team_passes)) +
  geom_col(fill = "darkgreen") +
  coord_flip() +
  labs(
    title = "Top 10 Countries With Highest Passes",
    x = "Country",
    y = "Average Passes"
  ) +
  theme_minimal()

Visualizing the top 10 countries with the highest goal scored

tidy_clean_load %>%
  filter(stat == "number.of.goals") %>%
  mutate(value = as.numeric(value)) %>%
  group_by(team) %>%
  summarise(avg_team_score = mean(value, na.rm = TRUE), .groups = "drop") %>%
  slice_max(avg_team_score, n = 10) %>%
  ggplot(aes(x = reorder(team, avg_team_score), y = avg_team_score)) +
  geom_col(fill = "darkgreen") +
  coord_flip() +
  labs(
    title = "Top 10 Countries With Highest Score",
    x = "Country",
    y = "Average Score"
  ) +
  theme_minimal()

While there a Hugh number of stat to visualize i have chosen a few stat such as total attempts and passes and number of goals to analyze which country have the most total average attempts and passes, base on the plot the number one country with the highest total attempts in 2022 FIFA World Cup was Germany and the country with the highest total average passes is Spain and England scored the most goals.

Conclusion

This project analyzed match statistics from the FIFA World Cup 2022 dataset. Initially, the dataset was stored in a wide format where statistics for team1 and team2 were stored in separate columns. Using tidy data principles and functions from the tidyverse, the dataset was transformed into a long format that is more suitable for analysis.

The exploratory analysis focused on three key statistics: total attempts, passes, and goals scored. The results show that Germany had the highest average number of attempts, Spain had the highest average number of passes, and England scored the highest number of goals among the teams analyzed.

Overall, this analysis demonstrates how tidy data techniques can simplify complex datasets and enable effective visualization and interpretation of sports performance statistics