Intro to R:Data dive 3
Data set-English Premier league
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.2 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.0
## ✔ ggplot2 3.4.3 ✔ tibble 3.2.1
## ✔ lubridate 1.9.2 ✔ tidyr 1.3.0
## ✔ purrr 1.0.2
## ── 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
importing data set
data <-read.csv('C:/Downloads/final_dataset.csv')
colnames(data)
## [1] "X" "Date" "HomeTeam" "AwayTeam"
## [5] "FTHG" "FTAG" "FTR" "HTGS"
## [9] "ATGS" "HTGC" "ATGC" "HTP"
## [13] "ATP" "HM1" "HM2" "HM3"
## [17] "HM4" "HM5" "AM1" "AM2"
## [21] "AM3" "AM4" "AM5" "MW"
## [25] "HTFormPtsStr" "ATFormPtsStr" "HTFormPts" "ATFormPts"
## [29] "HTWinStreak3" "HTWinStreak5" "HTLossStreak3" "HTLossStreak5"
## [33] "ATWinStreak3" "ATWinStreak5" "ATLossStreak3" "ATLossStreak5"
## [37] "HTGD" "ATGD" "DiffPts" "DiffFormPts"
# create random samples
set.seed(123)
creating sample datasets from the main dataset
sample_1 <- data[sample(nrow(data), nrow(data) * 0.5), ]
sample_2 <- data[sample(nrow(data), nrow(data) * 0.5), ]
sample_3 <- data[sample(nrow(data), nrow(data) * 0.5), ]
sample_4 <- data[sample(nrow(data), nrow(data) * 0.5), ]
sample_5 <- data[sample(nrow(data), nrow(data) * 0.5), ]
sample_6 <- data[sample(nrow(data), nrow(data) * 0.5), ]
colnames(sample_1)
## [1] "X" "Date" "HomeTeam" "AwayTeam"
## [5] "FTHG" "FTAG" "FTR" "HTGS"
## [9] "ATGS" "HTGC" "ATGC" "HTP"
## [13] "ATP" "HM1" "HM2" "HM3"
## [17] "HM4" "HM5" "AM1" "AM2"
## [21] "AM3" "AM4" "AM5" "MW"
## [25] "HTFormPtsStr" "ATFormPtsStr" "HTFormPts" "ATFormPts"
## [29] "HTWinStreak3" "HTWinStreak5" "HTLossStreak3" "HTLossStreak5"
## [33] "ATWinStreak3" "ATWinStreak5" "ATLossStreak3" "ATLossStreak5"
## [37] "HTGD" "ATGD" "DiffPts" "DiffFormPts"
Finding outliers in sample1
data <- sample_1
column_name <- "ATGS"
# IQR for ATGS column
Q1 <- quantile(data[["ATGS"]], 0.25)
Q3 <- quantile(data[["ATGS"]], 0.75)
IQR <- Q3 - Q1
#threshold to identify outliers
threshold <- 1
#outliers
outliers <- data[data[["ATGS"]] < (Q1 - threshold * IQR) | data[["ATGS"]] > (Q3 + threshold * IQR), ]
(outliers)
## X Date HomeTeam AwayTeam FTHG FTAG FTR HTGS ATGS HTGC
## 3004 3003 19/04/08 Fulham Liverpool 0 2 NH 32 60 56
## 1134 1133 11/05/2003 Chelsea Liverpool 2 1 H 66 60 37
## 6387 6386 08/04/17 Stoke Liverpool 1 2 NH 33 64 44
## 2244 2243 17/04/06 Tottenham Man United 1 2 NH 49 66 33
## 712 711 06/04/02 Leicester Man United 0 1 NH 24 82 58
## 6056 6055 02/05/16 Chelsea Tottenham 2 2 NH 55 65 48
## 4927 4926 12/05/13 Stoke Tottenham 1 2 NH 32 63 42
## 3799 3798 09/05/10 West Ham Man City 1 1 NH 46 72 65
## 2211 2210 01/04/06 Bolton Man United 1 2 NH 43 62 35
## 4903 4902 27/04/13 Wigan Tottenham 2 2 NH 39 60 62
## 3786 3785 02/05/10 Sunderland Man United 0 1 NH 47 81 53
## 4489 4488 02/04/12 Blackburn Man United 0 2 NH 43 74 62
## 3696 3695 06/03/10 Wolves Man United 0 1 NH 21 63 45
## 758 757 11/05/02 Southampton Newcastle 3 1 H 43 73 53
## 6460 6459 21/05/17 Watford Man City 0 5 NH 40 75 63
## 379 378 19/05/01 Southampton Arsenal 3 2 H 37 61 46
## 2269 2268 04/05/06 Man City Arsenal 1 3 NH 42 61 43
## 4546 4545 06/05/12 Newcastle Man City 0 2 NH 55 88 46
## 3769 3768 24/04/10 Arsenal Man City 0 0 NH 76 69 36
## 4559 4558 13/05/12 West Brom Arsenal 2 3 NH 43 71 49
## 6836 6835 13/05/18 Newcastle Chelsea 3 0 H 36 62 47
## 6431 6430 06/05/17 Swansea Everton 1 0 H 40 60 69
## 6767 6766 31/03/18 Everton Man City 1 3 NH 35 85 49
## 3727 3726 24/03/10 Portsmouth Chelsea 0 5 NH 28 70 53
## 4910 4909 04/05/13 QPR Arsenal 0 1 NH 29 65 56
## 4105 4104 02/04/11 West Ham Man United 2 4 NH 36 64 49
## 6827 6826 09/05/18 Leicester Arsenal 3 1 H 49 72 54
## 1458 1457 11/04/04 Newcastle Arsenal 0 0 NH 45 62 33
## 4173 4172 22/05/11 Everton Chelsea 1 0 H 50 69 45
## 2647 2646 06/05/07 Arsenal Chelsea 1 1 NH 62 63 34
## 4085 4084 06/03/11 Liverpool Man United 3 1 H 36 62 35
## 2278 2277 07/05/06 Newcastle Chelsea 1 0 H 46 72 42
## 5265 5264 06/04/14 West Ham Liverpool 1 2 NH 36 88 42
## 5656 5655 26/04/15 Arsenal Chelsea 0 0 NH 63 65 32
## 5669 5668 04/05/15 Hull Arsenal 1 3 NH 32 66 45
## 6668 6667 31/12/17 Crystal Palace Man City 0 0 NH 18 61 32
## 5317 5316 11/05/14 Southampton Man United 1 1 NH 53 63 45
## 1792 1791 26/02/05 Southampton Arsenal 1 1 NH 28 63 43
## 6796 6795 18/04/18 Bournemouth Man United 0 2 NH 41 63 53
## 6052 6051 30/04/16 West Brom West Ham 0 3 NH 32 60 43
## 1119 1118 27/04/2003 Tottenham Man United 0 2 NH 50 66 51
## 2989 2988 06/04/08 Middlesbrough Man United 2 2 NH 28 68 45
## 2265 2264 01/05/06 Sunderland Arsenal 0 3 NH 23 61 66
## 4861 4860 30/03/13 Sunderland Man United 0 1 NH 33 70 42
## 4895 4894 21/04/13 Liverpool Chelsea 2 2 NH 59 66 40
## 5696 5695 24/05/15 Hull Man United 0 0 NH 33 62 51
## 678 677 16/03/02 West Ham Man United 3 5 NH 32 69 44
## 721 720 13/04/02 Derby Newcastle 2 3 NH 30 65 56
## 1499 1498 04/05/04 Portsmouth Arsenal 1 1 NH 40 69 49
## 6813 6812 29/04/18 West Ham Man City 1 4 NH 43 102 67
## 3690 3689 27/02/10 Stoke Arsenal 1 3 NH 26 61 29
## 5629 5628 06/04/15 Crystal Palace Man City 2 1 H 36 62 41
## 6451 6450 21/05/17 Arsenal Everton 3 1 H 74 61 43
## 5307 5306 05/05/14 Crystal Palace Liverpool 3 3 NH 28 96 43
## 6384 6383 08/04/17 Bournemouth Chelsea 1 3 NH 42 62 54
## 6401 6400 16/04/17 Man United Chelsea 2 0 H 50 65 24
## 4136 4135 24/04/11 Bolton Arsenal 2 1 H 48 66 44
## 748 747 29/04/02 Bolton Arsenal 0 2 NH 43 74 58
## 6714 6713 03/02/18 Burnley Man City 1 1 NH 20 73 22
## 3756 3755 14/04/10 Tottenham Arsenal 2 1 H 60 75 33
## 5659 5658 29/04/15 Leicester Chelsea 1 3 NH 35 65 51
## 6412 6411 26/04/17 Crystal Palace Tottenham 0 1 NH 46 69 53
## 5232 5231 22/03/14 Cardiff Liverpool 3 6 NH 22 76 50
## 705 704 01/04/02 Ipswich Chelsea 0 0 NH 39 60 52
## 743 742 27/04/02 Ipswich Man United 0 1 NH 41 87 58
## 1140 1139 11/05/2003 West Brom Newcastle 2 2 NH 27 61 63
## 3373 3372 25/04/09 Hull Liverpool 1 3 NH 36 63 56
## 1111 1110 26/04/2003 Bolton Arsenal 2 2 NH 37 73 48
## 369 368 13/05/01 Southampton Man United 2 1 H 35 77 45
## 2631 2630 28/04/07 Everton Man United 2 4 NH 46 82 31
## 6777 6776 07/04/18 Everton Liverpool 0 0 NH 37 73 50
## 6837 6836 13/05/18 Southampton Man City 0 1 NH 37 105 55
## 1128 1127 03/05/2003 West Ham Chelsea 1 0 H 39 66 57
## 6795 6794 17/04/18 Brighton Tottenham 1 1 NH 31 65 46
## 6754 6753 10/03/18 Man United Liverpool 2 1 H 56 67 22
## 3012 3011 26/04/08 Chelsea Man United 2 1 H 60 73 24
## 1850 1849 20/04/05 Chelsea Arsenal 0 0 NH 62 73 12
## 3785 3784 02/05/10 Liverpool Chelsea 0 2 NH 61 93 33
## 701 700 01/04/02 Charlton Arsenal 0 3 NH 35 66 38
## 4072 4071 26/02/11 Wigan Man United 0 4 NH 27 61 45
## 2618 2617 18/04/07 West Ham Chelsea 1 4 NH 26 60 54
## 6830 6829 10/05/18 West Ham Man United 0 0 NH 45 67 67
## 4174 4173 22/05/11 Fulham Arsenal 2 2 NH 47 70 41
## 2596 2595 07/04/07 Portsmouth Man United 2 1 H 37 74 32
## 3787 3786 03/05/10 Blackburn Arsenal 2 1 H 38 78 54
## 6422 6421 30/04/17 Middlesbrough Man City 2 2 NH 24 65 43
## 3797 3796 09/05/10 Hull Liverpool 0 0 NH 34 61 75
## 639 638 10/02/02 Charlton Man United 0 2 NH 30 60 30
## 3007 3006 19/04/08 Wigan Tottenham 1 1 NH 31 63 48
## 6760 6759 12/03/18 Stoke Man City 0 2 NH 28 83 54
## 350 349 28/04/01 Middlesbrough Man United 0 2 NH 38 75 40
## 735 734 23/04/02 Blackburn Newcastle 2 2 NH 47 68 46
## 718 717 10/04/02 Blackburn Chelsea 0 0 NH 42 60 43
## 1869 1868 30/04/05 Bolton Chelsea 0 2 NH 44 65 38
## 6072 6071 15/05/16 Chelsea Leicester 1 1 NH 58 67 52
## 6450 6449 18/05/17 Leicester Tottenham 1 6 NH 46 73 56
## 2232 2231 15/04/06 Bolton Chelsea 0 2 NH 43 64 38
## 5316 5315 11/05/14 Norwich Arsenal 0 2 NH 28 66 60
## 5668 5667 03/05/15 Tottenham Man City 0 1 NH 55 70 49
## 5295 5294 27/04/14 Liverpool Chelsea 0 2 NH 96 67 44
## 2657 2656 13/05/07 Portsmouth Arsenal 0 0 NH 45 63 42
## 694 693 30/03/02 Leeds Man United 3 4 NH 44 78 30
## 4401 4400 31/01/12 Everton Man City 1 0 H 22 60 26
## 370 369 15/05/01 Newcastle Arsenal 0 0 NH 41 61 50
## 371 370 19/05/01 Charlton Liverpool 0 4 NH 50 67 53
## 3003 3002 19/04/08 Blackburn Man United 1 1 NH 44 72 42
## 4888 4887 20/04/13 Fulham Arsenal 0 1 NH 44 64 48
## 6077 6076 15/05/16 Swansea Man City 1 1 NH 41 70 51
## 4542 4541 06/05/12 Aston Villa Tottenham 1 1 NH 36 63 50
## 6424 6423 01/05/17 Watford Liverpool 0 1 NH 37 70 55
## 4157 4156 08/05/11 Stoke Arsenal 3 1 H 43 68 43
## 5170 5169 29/01/14 Tottenham Man City 1 5 NH 29 63 26
## 4146 4145 01/05/11 Arsenal Man United 1 0 H 67 71 36
## 3038 3037 11/05/08 Tottenham Liverpool 0 2 NH 66 65 59
## 4930 4929 14/05/13 Reading Man City 0 2 NH 41 62 67
## 1490 1489 01/05/04 Blackburn Man United 1 0 H 48 61 57
## 3040 3039 11/05/08 Wigan Man United 0 2 NH 34 78 49
## 5311 5310 11/05/14 Cardiff Chelsea 1 2 NH 31 69 72
## 1834 1833 09/04/05 Middlesbrough Arsenal 0 1 NH 45 72 42
## 1488 1487 25/04/04 Tottenham Arsenal 2 2 NH 42 69 54
## 4508 4507 11/04/12 Wigan Man United 1 0 H 30 78 57
## 6425 6424 05/05/17 West Ham Tottenham 1 0 H 44 71 59
## 5631 5630 11/04/15 Burnley Arsenal 0 1 NH 26 62 49
## 3018 3017 27/04/08 Everton Aston Villa 2 2 NH 50 67 29
## ATGC HTP ATP HM1 HM2 HM3 HM4 HM5 AM1 AM2 AM3 AM4 AM5 MW
## 3004 26 0.7714286 1.885714 W L D L W W D W L W 35
## 1134 39 1.6842105 1.684211 L D W L W L W W W W 38
## 6387 37 1.1612903 1.903226 L L D W L W D W W L 31
## 2244 30 1.7428571 2.171429 W W L W W D W W W W 35
## 712 44 0.6470588 1.970588 L W L D D W L W W D 34
## 6056 26 1.3333333 1.916667 D W L L W D W W D W 36
## 4927 45 1.1081081 1.783784 D W W L L D W D W D 37
## 3799 44 0.8947368 1.736842 L W L W D L W D L W 38
## 2211 29 1.5000000 2.156250 L L L W W W W W W W 32
## 4903 43 0.9142857 1.771429 D L L D W D W D W L 35
## 3786 28 1.1891892 2.135135 W W L W L W W D L W 37
## 4489 27 0.9032258 2.354839 L W W D L W W W W W 31
## 3696 24 0.8571429 2.035714 L L W L D L D W W W 28
## 758 49 1.1052632 1.868421 L L D W L W D W W D 38
## 6460 39 1.0526316 1.973684 L L L L L W W W D D 38
## 379 35 1.2894737 1.842105 W L D L D D W W W L 38
## 2269 28 1.1621622 1.648649 L W L L L W D W D L 37
## 4546 27 1.7567568 2.243243 W L W W W W W W W L 37
## 3769 42 2.0285714 1.771429 L W D W W L W W W L 35
## 4559 47 1.2368421 1.763158 D D W W L D D D L W 38
## 6836 35 1.0789474 1.842105 L L L L W D W W W W 38
## 6431 40 0.8888889 1.611111 D W L L L L D W W D 36
## 6767 20 1.1935484 2.612903 W L L W L W W W W D 31
## 3727 28 0.7096774 2.096774 W L L W L D W L W L 31
## 4910 35 0.6857143 1.800000 L L D L L W D W W W 35
## 4105 30 1.0322581 2.032258 D W W D L W L L W W 31
## 6827 48 1.1891892 1.621622 L L D L L W L W L W 37
## 1458 22 1.5000000 2.406250 W L W L D W D W W W 32
## 4173 32 1.3421053 1.868421 L W D L W D L W W W 38
## 2647 23 1.7837838 2.189189 W D W W D D D D W W 37
## 4085 27 1.3448276 2.068966 L D W W W L W W L W 29
## 2278 21 1.4473684 2.394737 D W W W W L W W W W 38
## 5265 39 1.1212121 2.151515 W W L L L W W W W W 33
## 5656 26 1.9705882 2.264706 D W W W W D W W W W 34
## 5669 33 0.9714286 2.000000 W W L L L W D W W W 35
## 6668 12 0.8571429 2.761905 L D W W D W W W W W 21
## 5317 42 1.4473684 1.657895 W W D L L W L W L W 38
## 1792 31 0.7142857 2.035714 D D L W L W W L W L 28
## 6796 26 1.1176471 2.088235 D D W L D L W W W W 34
## 6052 43 1.1388889 1.638889 D L L L D W W D D D 36
## 1119 32 1.3888889 2.055556 W L D W L W D W W W 36
## 2989 15 1.0303030 2.303030 L W D D L W W W W W 33
## 2265 28 0.3243243 1.648649 L L L D D W D W D L 37
## 4861 31 1.0000000 2.483871 D L D L L W W W W W 31
## 4895 35 1.4705882 1.823529 D D W L W D W W L W 34
## 5696 37 0.8947368 1.815789 L L L W W D W L L L 38
## 678 37 1.2333333 1.933333 W L W L W D W W W W 30
## 721 46 0.8285714 1.828571 L L L L W W D D W D 35
## 1499 24 1.1388889 2.305556 D W W W D D D W D W 36
## 6813 26 0.9722222 2.583333 L L D D W W W W L W 36
## 3690 30 1.2592593 1.925926 W D D W D W L L D W 27
## 5629 28 1.1612903 1.967742 W W L W L W L W L W 31
## 6451 41 1.8947368 1.605263 W W W W L W L L D W 38
## 5307 46 1.1621622 2.162162 L W W W W L W W W W 37
## 6384 24 1.0967742 2.322581 D W W D L W L W W W 31
## 6401 27 1.9090909 2.272727 W W W D D L W W L W 33
## 4136 34 1.3529412 1.882353 W W L L W D D W D D 34
## 748 33 1.0810811 2.189189 L D W L W W W W W W 37
## 6714 18 1.3461538 2.615385 D L L L D W W L W D 26
## 3756 34 1.7941176 2.088235 W L W W W W D W W W 34
## 5659 26 0.9117647 2.264706 W W W W L D W W W W 34
## 6412 22 1.1176471 2.176471 W D W L W W W W W W 34
## 5232 35 0.8333333 2.066667 W L L D L W W W W W 30
## 705 32 0.9696970 1.696970 L D D L L W L W W W 33
## 743 44 0.9729730 2.054054 W L L D L W W W W L 37
## 1140 46 0.6578947 1.789474 D L L W L W W D L L 38
## 3373 25 1.0000000 2.088235 L L D L D D W W W W 34
## 1111 38 1.0833333 2.000000 D W L W W D W D D W 36
## 369 26 1.2432432 2.162162 L D L D L L W D W W 37
## 2631 26 1.5000000 2.361111 L W D W D W D W L W 36
## 6777 34 1.2500000 1.968750 W W L L W W L W W W 32
## 6837 27 0.9473684 2.552632 W D W D L W D W W W 38
## 1128 36 1.0270270 1.729730 W W L D D D W L W W 37
## 6795 30 1.0294118 1.970588 L D L L W L W W W W 34
## 6754 32 2.0666667 2.000000 W W L W L W W W D W 30
## 3012 19 2.1666667 2.250000 W D W W W D W D W W 36
## 1850 33 2.4545455 2.121212 D W W W W W W W W D 33
## 3785 32 1.6756757 2.162162 W W D D W W L W W W 37
## 701 32 1.2424242 2.090909 L L W D W W W W W W 33
## 4072 25 0.9642857 2.142857 D W D L L W W L W W 28
## 2618 20 0.8529412 2.294118 L W W W L W W W W W 34
## 6830 28 1.0270270 2.081081 W L L D D L W W L W 37
## 4174 41 1.2631579 1.763158 W L W W D L L W L D 38
## 2596 21 1.3437500 2.437500 D D L L W W W W W W 32
## 3787 39 1.1891892 1.945946 D L D D W D L L W D 37
## 6422 37 0.7714286 1.885714 W L L D L D D W W L 35
## 3797 35 0.7631579 1.631579 D L L D L L W W D D 38
## 639 34 1.2692308 1.846154 D W L L W W L W W W 26
## 3007 57 1.0000000 1.171429 D W L L W D D L W D 35
## 6760 20 0.9000000 2.600000 D D D L D W W W D W 30
## 350 25 1.0000000 2.200000 L W D L W D W W L W 35
## 735 46 1.1111111 1.861111 D W D W L W W D D W 36
## 718 32 1.0588235 1.676471 D W L L W D W L W W 34
## 1869 13 1.5142857 2.428571 D W W L W W D D W W 35
## 6072 35 1.2894737 2.105263 D L D W L W D W D W 38
## 6450 24 1.1621622 2.162162 L W W L D W L W W W 37
## 2232 20 1.4117647 2.411765 L L L L L W D W L W 34
## 5316 41 0.8684211 2.000000 D L L L L W W W W L 38
## 5668 36 1.6571429 1.914286 D W L D W W W L L W 35
## 5295 26 2.2222222 2.083333 W W W W W L W W L W 36
## 2657 35 1.3947368 1.763158 L W D W L D W D W W 38
## 694 40 1.6875000 2.000000 W W W D D W W D W W 32
## 4401 18 1.1304348 2.347826 D D L L W W W W L D 23
## 370 35 1.2702703 1.864865 L D W D W W W W L W 37
## 371 39 1.3684211 1.736842 L W W D L D W W W W 38
## 3003 18 1.4571429 2.285714 L D D W L W D W W W 35
## 4888 35 1.2121212 1.787879 D L W W D W W W W L 33
## 6077 40 1.2105263 1.710526 W W L L W D L W D W 38
## 4542 40 1.0000000 1.756757 D L D L D W W L L D 37
## 6424 42 1.1428571 1.885714 L L W L W L W W D W 35
## 4157 36 1.1944444 1.861111 D W D L D W L D D W 36
## 5170 25 1.8695652 2.173913 W W W W D W W W W W 23
## 4146 32 1.8285714 2.085714 L D D W D W D W W W 35
## 3038 28 1.2105263 1.921053 W D D D D W D W W D 38
## 4930 31 0.7567568 2.027027 W D L D L W D W L W 37
## 1490 32 1.0571429 2.028571 W W L L L W L W W D 35
## 3040 22 1.0526316 2.210526 W D D D W W L D W D 38
## 5311 26 0.7894737 2.078947 L L D W L D W L W W 38
## 1834 33 1.4062500 2.093750 W L L D D W W W D W 32
## 1488 24 1.0857143 2.342857 L D L L L D W D W D 35
## 4508 27 0.8484848 2.393939 L W W D D W W W W W 33
## 6425 22 1.0857143 2.200000 D D W L L W W W W W 35
## 5631 32 0.8125000 1.968750 D L W L L W W W W W 32
## 3018 45 1.6944444 1.611111 L D W L D W W W L L 36
## HTFormPtsStr ATFormPtsStr HTFormPts ATFormPts HTWinStreak3 HTWinStreak5
## 3004 WLDLW WDWLW 7 10 0 0
## 1134 LDWLW LWWWW 7 12 0 0
## 6387 LLDWL WDWWL 4 10 0 0
## 2244 WWLWW DWWWW 12 13 0 0
## 712 LWLDD WLWWD 5 10 0 0
## 6056 DWLLW DWWDW 7 11 0 0
## 4927 DWWLL DWDWD 7 9 0 0
## 3799 LWLWD LWDLW 7 7 0 0
## 2211 LLLWW WWWWW 6 15 0 0
## 4903 DLLDW DWDWL 5 8 0 0
## 3786 WWLWL WWDLW 9 10 0 0
## 4489 LWWDL WWWWW 7 15 0 0
## 3696 LLWLD LDWWW 4 10 0 0
## 758 LLDWL WDWWD 4 11 0 0
## 6460 LLLLL WWWDD 0 11 0 0
## 379 WLDLD DWWWL 5 10 0 0
## 2269 LWLLL WDWDL 3 8 0 0
## 4546 WLWWW WWWWL 12 12 1 0
## 3769 LWDWW LWWWL 10 9 0 0
## 4559 DDWWL DDDLW 8 6 0 0
## 6836 LLLLW DWWWW 3 13 0 0
## 6431 DWLLL LDWWD 4 8 0 0
## 6767 WLLWL WWWWD 6 13 0 0
## 3727 WLLWL DWLWL 6 7 0 0
## 4910 LLDLL WDWWW 1 13 0 0
## 4105 DWWDL WLLWW 8 9 0 0
## 6827 LLDLL WLWLW 1 9 0 0
## 1458 WLWLD WDWWW 7 13 0 0
## 4173 LWDLW DLWWW 7 10 0 0
## 2647 WDWWD DDDWW 11 9 0 0
## 4085 LDWWW LWWLW 10 9 1 0
## 2278 DWWWW LWWWW 13 12 1 0
## 5265 WWLLL WWWWW 6 15 0 0
## 5656 DWWWW DWWWW 13 13 1 0
## 5669 WWLLL WDWWW 6 13 0 0
## 6668 LDWWD WWWWW 8 15 0 0
## 5317 WWDLL WLWLW 7 9 0 0
## 1792 DDLWL WWLWL 5 9 0 0
## 6796 DDWLD LWWWW 6 12 0 0
## 6052 DLLLD WWDDD 2 9 0 0
## 1119 WLDWL WDWWW 7 13 0 0
## 2989 LWDDL WWWWW 5 15 0 0
## 2265 LLLDD WDWDL 2 8 0 0
## 4861 DLDLL WWWWW 2 15 0 0
## 4895 DDWLW DWWLW 8 10 0 0
## 5696 LLLWW DWLLL 6 4 0 0
## 678 WLWLW DWWWW 9 13 0 0
## 721 LLLLW WDDWD 3 9 0 0
## 1499 DWWWD DDWDW 11 9 0 0
## 6813 LLDDW WWWLW 5 12 0 0
## 3690 WDDWD WLLDW 9 7 0 0
## 5629 WWLWL WLWLW 9 9 0 0
## 6451 WWWWL WLLDW 12 7 0 0
## 5307 LWWWW LWWWW 12 12 1 0
## 6384 DWWDL WLWWW 8 12 0 0
## 6401 WWWDD LWWLW 11 9 0 0
## 4136 WWLLW DDWDD 9 7 0 0
## 748 LDWLW WWWWW 7 15 0 0
## 6714 DLLLD WWLWD 2 10 0 0
## 3756 WLWWW WDWWW 12 13 1 0
## 5659 WWWWL DWWWW 12 13 0 0
## 6412 WDWLW WWWWW 10 15 0 0
## 5232 WLLDL WWWWW 4 15 0 0
## 705 LDDLL WLWWW 2 12 0 0
## 743 WLLDL WWWWL 4 12 0 0
## 1140 DLLWL WWDLL 4 7 0 0
## 3373 LLDLD DWWWW 2 13 0 0
## 1111 DWLWW DWDDW 10 9 0 0
## 369 LDLDL LWDWW 2 10 0 0
## 2631 LWDWD WDWLW 8 10 0 0
## 6777 WWLLW WLWWW 9 12 0 0
## 6837 WDWDL WDWWW 8 13 0 0
## 1128 WWLDD DWLWW 8 10 0 0
## 6795 LDLLW LWWWW 4 12 0 0
## 6754 WWLWL WWWDW 9 13 0 0
## 3012 WDWWW DWDWW 13 11 1 0
## 1850 DWWWW WWWWD 13 13 1 0
## 3785 WWDDW WLWWW 11 12 0 0
## 701 LLWDW WWWWW 7 15 0 0
## 4072 DWDLL WWLWW 5 12 0 0
## 2618 LWWWL WWWWW 9 15 0 0
## 6830 WLLDD LWWLW 5 9 0 0
## 4174 WLWWD LLWLD 10 4 0 0
## 2596 DDLLW WWWWW 5 15 0 0
## 3787 DLDDW DLLWD 6 5 0 0
## 6422 WLLDL DDWWL 4 8 0 0
## 3797 DLLDL LWWDD 2 8 0 0
## 639 DWLLW WLWWW 7 12 0 0
## 3007 DWLLW DDLWD 7 6 0 0
## 6760 DDDLD WWWDW 4 13 0 0
## 350 LWDLW DWWLW 7 10 0 0
## 735 DWDWL WWDDW 8 11 0 0
## 718 DWLLW DWLWW 7 10 0 0
## 1869 DWWLW WDDWW 10 11 0 0
## 6072 DLDWL WDWDW 5 11 0 0
## 6450 LWWLD WLWWW 7 12 0 0
## 2232 LLLLL WDWLW 0 10 0 0
## 5316 DLLLL WWWWL 1 12 0 0
## 5668 DWLDW WWLLW 8 9 0 0
## 5295 WWWWW LWWLW 15 9 1 1
## 2657 LWDWL DWDWW 7 11 0 0
## 694 WWWDD WWDWW 11 13 0 0
## 4401 DDLLW WWWLD 5 10 0 0
## 370 LDWDW WWWLW 8 12 0 0
## 371 LWWDL DWWWW 7 13 0 0
## 3003 LDDWL WDWWW 5 13 0 0
## 4888 DLWWD WWWWL 8 12 0 0
## 6077 WWLLW DLWDW 9 8 0 0
## 4542 DLDLD WWLLD 3 7 0 0
## 6424 LLWLW LWWDW 6 10 0 0
## 4157 DWDLD WLDDW 6 8 0 0
## 5170 WWWWD WWWWW 13 15 0 0
## 4146 LDDWD WDWWW 6 13 0 0
## 3038 WDDDD WDWWD 7 11 0 0
## 4930 WDLDL WDWLW 5 10 0 0
## 1490 WWLLL WLWWD 6 10 0 0
## 3040 WDDDW WLDWD 9 8 0 0
## 5311 LLDWL DWLWW 4 10 0 0
## 1834 WLLDD WWWDW 5 13 0 0
## 1488 LDLLL DWDWD 1 9 0 0
## 4508 LWWDD WWWWW 8 15 0 0
## 6425 DDWLL WWWWW 5 15 0 0
## 5631 DLWLL WWWWW 4 15 0 0
## 3018 LDWLD WWWLL 5 9 0 0
## HTLossStreak3 HTLossStreak5 ATWinStreak3 ATWinStreak5 ATLossStreak3
## 3004 0 0 0 0 0
## 1134 0 0 1 0 0
## 6387 0 0 0 0 0
## 2244 0 0 1 0 0
## 712 0 0 0 0 0
## 6056 0 0 0 0 0
## 4927 0 0 0 0 0
## 3799 0 0 0 0 0
## 2211 0 0 1 1 0
## 4903 0 0 0 0 0
## 3786 0 0 0 0 0
## 4489 0 0 1 1 0
## 3696 0 0 1 0 0
## 758 0 0 0 0 0
## 6460 1 1 0 0 0
## 379 0 0 0 0 0
## 2269 1 0 0 0 0
## 4546 0 0 0 0 0
## 3769 0 0 0 0 0
## 4559 0 0 0 0 0
## 6836 0 0 1 0 0
## 6431 1 0 0 0 0
## 6767 0 0 0 0 0
## 3727 0 0 0 0 0
## 4910 0 0 1 0 0
## 4105 0 0 0 0 0
## 6827 0 0 0 0 0
## 1458 0 0 1 0 0
## 4173 0 0 1 0 0
## 2647 0 0 0 0 0
## 4085 0 0 0 0 0
## 2278 0 0 1 0 0
## 5265 1 0 1 1 0
## 5656 0 0 1 0 0
## 5669 1 0 1 0 0
## 6668 0 0 1 1 0
## 5317 0 0 0 0 0
## 1792 0 0 0 0 0
## 6796 0 0 1 0 0
## 6052 0 0 0 0 0
## 1119 0 0 1 0 0
## 2989 0 0 1 1 0
## 2265 0 0 0 0 0
## 4861 0 0 1 1 0
## 4895 0 0 0 0 0
## 5696 0 0 0 0 1
## 678 0 0 1 0 0
## 721 0 0 0 0 0
## 1499 0 0 0 0 0
## 6813 0 0 0 0 0
## 3690 0 0 0 0 0
## 5629 0 0 0 0 0
## 6451 0 0 0 0 0
## 5307 0 0 1 0 0
## 6384 0 0 1 0 0
## 6401 0 0 0 0 0
## 4136 0 0 0 0 0
## 748 0 0 1 1 0
## 6714 0 0 0 0 0
## 3756 0 0 1 0 0
## 5659 0 0 1 0 0
## 6412 0 0 1 1 0
## 5232 0 0 1 1 0
## 705 0 0 1 0 0
## 743 0 0 0 0 0
## 1140 0 0 0 0 0
## 3373 0 0 1 0 0
## 1111 0 0 0 0 0
## 369 0 0 0 0 0
## 2631 0 0 0 0 0
## 6777 0 0 1 0 0
## 6837 0 0 1 0 0
## 1128 0 0 0 0 0
## 6795 0 0 1 0 0
## 6754 0 0 0 0 0
## 3012 0 0 0 0 0
## 1850 0 0 0 0 0
## 3785 0 0 1 0 0
## 701 0 0 1 1 0
## 4072 0 0 0 0 0
## 2618 0 0 1 1 0
## 6830 0 0 0 0 0
## 4174 0 0 0 0 0
## 2596 0 0 1 1 0
## 3787 0 0 0 0 0
## 6422 0 0 0 0 0
## 3797 0 0 0 0 0
## 639 0 0 1 0 0
## 3007 0 0 0 0 0
## 6760 0 0 0 0 0
## 350 0 0 0 0 0
## 735 0 0 0 0 0
## 718 0 0 0 0 0
## 1869 0 0 0 0 0
## 6072 0 0 0 0 0
## 6450 0 0 1 0 0
## 2232 1 1 0 0 0
## 5316 1 0 0 0 0
## 5668 0 0 0 0 0
## 5295 0 0 0 0 0
## 2657 0 0 0 0 0
## 694 0 0 0 0 0
## 4401 0 0 0 0 0
## 370 0 0 0 0 0
## 371 0 0 1 0 0
## 3003 0 0 1 0 0
## 4888 0 0 0 0 0
## 6077 0 0 0 0 0
## 4542 0 0 0 0 0
## 6424 0 0 0 0 0
## 4157 0 0 0 0 0
## 5170 0 0 1 1 0
## 4146 0 0 1 0 0
## 3038 0 0 0 0 0
## 4930 0 0 0 0 0
## 1490 1 0 0 0 0
## 3040 0 0 0 0 0
## 5311 0 0 0 0 0
## 1834 0 0 0 0 0
## 1488 1 0 0 0 0
## 4508 0 0 1 1 0
## 6425 0 0 1 1 0
## 5631 0 0 1 1 0
## 3018 0 0 0 0 0
## ATLossStreak5 HTGD ATGD DiffPts DiffFormPts
## 3004 0 -0.68571429 0.9714286 -1.11428571 -0.08571429
## 1134 0 0.76315789 0.5526316 0.00000000 -0.13157895
## 6387 0 -0.35483871 0.8709677 -0.74193548 -0.19354839
## 2244 0 0.45714286 1.0285714 -0.42857143 -0.02857143
## 712 0 -1.00000000 1.1176471 -1.32352941 -0.14705882
## 6056 0 0.19444444 1.0833333 -0.58333333 -0.11111111
## 4927 0 -0.27027027 0.4864865 -0.67567568 -0.05405405
## 3799 0 -0.50000000 0.7368421 -0.84210526 0.00000000
## 2211 0 0.25000000 1.0312500 -0.65625000 -0.28125000
## 4903 0 -0.65714286 0.4857143 -0.85714286 -0.08571429
## 3786 0 -0.16216216 1.4324324 -0.94594595 -0.02702703
## 4489 0 -0.61290323 1.5161290 -1.45161290 -0.25806452
## 3696 0 -0.85714286 1.3928571 -1.17857143 -0.21428571
## 758 0 -0.26315789 0.6315789 -0.76315789 -0.18421053
## 6460 0 -0.60526316 0.9473684 -0.92105263 -0.28947368
## 379 0 -0.23684211 0.6842105 -0.55263158 -0.13157895
## 2269 0 -0.02702703 0.8918919 -0.48648649 -0.13513514
## 4546 0 0.24324324 1.6486486 -0.48648649 0.00000000
## 3769 0 1.14285714 0.7714286 0.25714286 0.02857143
## 4559 0 -0.15789474 0.6315789 -0.52631579 0.05263158
## 6836 0 -0.28947368 0.7105263 -0.76315789 -0.26315789
## 6431 0 -0.80555556 0.5555556 -0.72222222 -0.11111111
## 6767 0 -0.45161290 2.0967742 -1.41935484 -0.22580645
## 3727 0 -0.80645161 1.3548387 -1.38709677 -0.03225806
## 4910 0 -0.77142857 0.8571429 -1.11428571 -0.34285714
## 4105 0 -0.41935484 1.0967742 -1.00000000 -0.03225806
## 6827 0 -0.13513514 0.6486486 -0.43243243 -0.21621622
## 1458 0 0.37500000 1.2500000 -0.90625000 -0.18750000
## 4173 0 0.13157895 0.9736842 -0.52631579 -0.07894737
## 2647 0 0.75675676 1.0810811 -0.40540541 0.05405405
## 4085 0 0.03448276 1.2068966 -0.72413793 0.03448276
## 2278 0 0.10526316 1.3421053 -0.94736842 0.02631579
## 5265 0 -0.18181818 1.4848485 -1.03030303 -0.27272727
## 5656 0 0.91176471 1.1470588 -0.29411765 0.00000000
## 5669 0 -0.37142857 0.9428571 -1.02857143 -0.20000000
## 6668 0 -0.66666667 2.3333333 -1.90476190 -0.33333333
## 5317 0 0.21052632 0.5526316 -0.21052632 -0.05263158
## 1792 0 -0.53571429 1.1428571 -1.32142857 -0.14285714
## 6796 0 -0.35294118 1.0882353 -0.97058824 -0.17647059
## 6052 0 -0.30555556 0.4722222 -0.50000000 -0.19444444
## 1119 0 -0.02777778 0.9444444 -0.66666667 -0.16666667
## 2989 0 -0.51515152 1.6060606 -1.27272727 -0.30303030
## 2265 0 -1.16216216 0.8918919 -1.32432432 -0.16216216
## 4861 0 -0.29032258 1.2580645 -1.48387097 -0.41935484
## 4895 0 0.55882353 0.9117647 -0.35294118 -0.05882353
## 5696 0 -0.47368421 0.6578947 -0.92105263 0.05263158
## 678 0 -0.40000000 1.0666667 -0.70000000 -0.13333333
## 721 0 -0.74285714 0.5428571 -1.00000000 -0.17142857
## 1499 0 -0.25000000 1.2500000 -1.16666667 0.05555556
## 6813 0 -0.66666667 2.1111111 -1.61111111 -0.19444444
## 3690 0 -0.11111111 1.1481481 -0.66666667 0.07407407
## 5629 0 -0.16129032 1.0967742 -0.80645161 0.00000000
## 6451 0 0.81578947 0.5263158 0.28947368 0.13157895
## 5307 0 -0.40540541 1.3513514 -1.00000000 0.00000000
## 6384 0 -0.38709677 1.2258065 -1.22580645 -0.12903226
## 6401 0 0.78787879 1.1515152 -0.36363636 0.06060606
## 4136 0 0.11764706 0.9411765 -0.52941176 0.05882353
## 748 0 -0.40540541 1.1081081 -1.10810811 -0.21621622
## 6714 0 -0.07692308 2.1153846 -1.26923077 -0.30769231
## 3756 0 0.79411765 1.2058824 -0.29411765 -0.02941176
## 5659 0 -0.47058824 1.1470588 -1.35294118 -0.02941176
## 6412 0 -0.20588235 1.3823529 -1.05882353 -0.14705882
## 5232 0 -0.93333333 1.3666667 -1.23333333 -0.36666667
## 705 0 -0.39393939 0.8484848 -0.72727273 -0.30303030
## 743 0 -0.45945946 1.1621622 -1.08108108 -0.21621622
## 1140 0 -0.94736842 0.3947368 -1.13157895 -0.07894737
## 3373 0 -0.58823529 1.1176471 -1.08823529 -0.32352941
## 1111 0 -0.30555556 0.9722222 -0.91666667 0.02777778
## 369 0 -0.27027027 1.3783784 -0.91891892 -0.21621622
## 2631 0 0.41666667 1.5555556 -0.86111111 -0.05555556
## 6777 0 -0.40625000 1.2187500 -0.71875000 -0.09375000
## 6837 0 -0.47368421 2.0526316 -1.60526316 -0.13157895
## 1128 0 -0.48648649 0.8108108 -0.70270270 -0.05405405
## 6795 0 -0.44117647 1.0294118 -0.94117647 -0.23529412
## 6754 0 1.13333333 1.1666667 0.06666667 -0.13333333
## 3012 0 1.00000000 1.5000000 -0.08333333 0.05555556
## 1850 0 1.51515152 1.2121212 0.33333333 0.00000000
## 3785 0 0.75675676 1.6486486 -0.48648649 -0.02702703
## 701 0 -0.09090909 1.0303030 -0.84848485 -0.24242424
## 4072 0 -0.64285714 1.2857143 -1.17857143 -0.25000000
## 2618 0 -0.82352941 1.1764706 -1.44117647 -0.17647059
## 6830 0 -0.59459459 1.0540541 -1.05405405 -0.10810811
## 4174 0 0.15789474 0.7631579 -0.50000000 0.15789474
## 2596 0 0.15625000 1.6562500 -1.09375000 -0.31250000
## 3787 0 -0.43243243 1.0540541 -0.75675676 0.02702703
## 6422 0 -0.54285714 0.8000000 -1.11428571 -0.11428571
## 3797 0 -1.07894737 0.6842105 -0.86842105 -0.15789474
## 639 0 0.00000000 1.0000000 -0.57692308 -0.19230769
## 3007 0 -0.48571429 0.1714286 -0.17142857 0.02857143
## 6760 0 -0.86666667 2.1000000 -1.70000000 -0.30000000
## 350 0 -0.05714286 1.4285714 -1.20000000 -0.08571429
## 735 0 0.02777778 0.6111111 -0.75000000 -0.08333333
## 718 0 -0.02941176 0.8235294 -0.61764706 -0.08823529
## 1869 0 0.17142857 1.4857143 -0.91428571 -0.02857143
## 6072 0 0.15789474 0.8421053 -0.81578947 -0.15789474
## 6450 0 -0.27027027 1.3243243 -1.00000000 -0.13513514
## 2232 0 0.14705882 1.2941176 -1.00000000 -0.29411765
## 5316 0 -0.84210526 0.6578947 -1.13157895 -0.28947368
## 5668 0 0.17142857 0.9714286 -0.25714286 -0.02857143
## 5295 0 1.44444444 1.1388889 0.13888889 0.16666667
## 2657 0 0.07894737 0.7368421 -0.36842105 -0.10526316
## 694 0 0.43750000 1.1875000 -0.31250000 -0.06250000
## 4401 0 -0.17391304 1.8260870 -1.21739130 -0.21739130
## 370 0 -0.24324324 0.7027027 -0.59459459 -0.10810811
## 371 0 -0.07894737 0.7368421 -0.36842105 -0.15789474
## 3003 0 0.05714286 1.5428571 -0.82857143 -0.22857143
## 4888 0 -0.12121212 0.8787879 -0.57575758 -0.12121212
## 6077 0 -0.26315789 0.7894737 -0.50000000 0.02631579
## 4542 0 -0.37837838 0.6216216 -0.75675676 -0.10810811
## 6424 0 -0.51428571 0.8000000 -0.74285714 -0.11428571
## 4157 0 0.00000000 0.8888889 -0.66666667 -0.05555556
## 5170 0 0.13043478 1.6521739 -0.30434783 -0.08695652
## 4146 0 0.88571429 1.1142857 -0.25714286 -0.20000000
## 3038 0 0.18421053 0.9736842 -0.71052632 -0.10526316
## 4930 0 -0.70270270 0.8378378 -1.27027027 -0.13513514
## 1490 0 -0.25714286 0.8285714 -0.97142857 -0.11428571
## 3040 0 -0.39473684 1.4736842 -1.15789474 0.02631579
## 5311 0 -1.07894737 1.1315789 -1.28947368 -0.15789474
## 1834 0 0.09375000 1.2187500 -0.68750000 -0.25000000
## 1488 0 -0.34285714 1.2857143 -1.25714286 -0.22857143
## 4508 0 -0.81818182 1.5454545 -1.54545455 -0.21212121
## 6425 0 -0.42857143 1.4000000 -1.11428571 -0.28571429
## 5631 0 -0.71875000 0.9375000 -1.15625000 -0.34375000
## 3018 0 0.58333333 0.6111111 0.08333333 -0.11111111
Visualization for sample set1
library(ggplot2)
# barplot of the "ATGS" column with outliers highlighted
ggplot(sample_1, aes(y = ATGS)) +
geom_bar() +
geom_point(data = outliers, aes(x=1 ,y = ATGS), color = "blue", size = 4) +
labs(
title = "Barplot of ATGS with Outliers Highlighted",
y = "ATGS"
) +
theme_minimal()
finding outliers in sample 2
data <- sample_2
column_name <- "ATGS"
# IQR for the ATGS column
Q1 <- quantile(data[["ATGS"]], 0.25)
Q3 <- quantile(data[["ATGS"]], 0.75)
IQR <- Q3 - Q1
#threshold to identify outliers
threshold <- 1
#Find outliers
outliers <- data[data[["ATGS"]] < (Q1 - threshold * IQR) | data[["ATGS"]] > (Q3 + threshold * IQR), ]
(outliers)
## X Date HomeTeam AwayTeam FTHG FTAG FTR HTGS ATGS HTGC
## 678 677 16/03/02 West Ham Man United 3 5 NH 32 69 44
## 5689 5688 18/05/15 West Brom Chelsea 3 0 H 34 70 47
## 6420 6419 30/04/17 Everton Chelsea 0 3 NH 60 69 37
## 350 349 28/04/01 Middlesbrough Man United 0 2 NH 38 75 40
## 4883 4882 14/04/13 Stoke Man United 0 2 NH 28 73 39
## 6402 6401 16/04/17 West Brom Liverpool 0 1 NH 39 68 41
## 1869 1868 30/04/05 Bolton Chelsea 0 2 NH 44 65 38
## 6740 6739 01/03/18 Arsenal Man City 0 3 NH 51 79 36
## 3409 3408 17/05/09 West Brom Liverpool 0 2 NH 36 72 65
## 750 749 08/05/02 Man United Arsenal 0 1 NH 87 74 44
## 6384 6383 08/04/17 Bournemouth Chelsea 1 3 NH 42 62 54
## 5230 5229 16/03/14 Man United Liverpool 0 3 NH 46 73 31
## 5294 5293 27/04/14 Crystal Palace Man City 0 2 NH 28 93 41
## 3003 3002 19/04/08 Blackburn Man United 1 1 NH 44 72 42
## 5225 5224 15/03/14 Hull Man City 0 2 NH 30 76 35
## 6791 6790 14/04/18 Tottenham Man City 1 3 NH 65 93 30
## 6450 6449 18/05/17 Leicester Tottenham 1 6 NH 46 73 56
## 4861 4860 30/03/13 Sunderland Man United 0 1 NH 33 70 42
## 1512 1511 15/05/04 Aston Villa Man United 0 2 NH 48 62 42
## 2267 2266 02/05/06 Blackburn Chelsea 1 0 H 48 72 42
## 4429 4428 12/02/12 Aston Villa Man City 0 1 NH 29 63 33
## 3018 3017 27/04/08 Everton Aston Villa 2 2 NH 50 67 29
## 4885 4884 17/04/13 Fulham Chelsea 0 3 NH 44 64 48
## 6766 6765 31/03/18 Crystal Palace Liverpool 1 2 NH 28 68 48
## 3400 3399 13/05/09 Wigan Man United 1 2 NH 32 65 41
## 1834 1833 09/04/05 Middlesbrough Arsenal 0 1 NH 45 72 42
## 3696 3695 06/03/10 Wolves Man United 0 1 NH 21 63 45
## 5295 5294 27/04/14 Liverpool Chelsea 0 2 NH 96 67 44
## 1119 1118 27/04/2003 Tottenham Man United 0 2 NH 50 66 51
## 6412 6411 26/04/17 Crystal Palace Tottenham 0 1 NH 46 69 53
## 4556 4555 13/05/12 Sunderland Man United 0 1 NH 45 88 45
## 3012 3011 26/04/08 Chelsea Man United 2 1 H 60 73 24
## 5696 5695 24/05/15 Hull Man United 0 0 NH 33 62 51
## 3720 3719 21/03/10 Blackburn Chelsea 1 1 NH 31 69 48
## 1071 1070 05/04/2003 Aston Villa Arsenal 1 1 NH 33 66 37
## 735 734 23/04/02 Blackburn Newcastle 2 2 NH 47 68 46
## 4173 4172 22/05/11 Everton Chelsea 1 0 H 50 69 45
## 4934 4933 19/05/13 Newcastle Arsenal 0 1 NH 45 71 67
## 1850 1849 20/04/05 Chelsea Arsenal 0 0 NH 62 73 12
## 6833 6832 13/05/18 Huddersfield Arsenal 0 1 NH 28 73 57
## 5170 5169 29/01/14 Tottenham Man City 1 5 NH 29 63 26
## 3785 3784 02/05/10 Liverpool Chelsea 0 2 NH 61 93 33
## 3786 3785 02/05/10 Sunderland Man United 0 1 NH 47 81 53
## 2657 2656 13/05/07 Portsmouth Arsenal 0 0 NH 45 63 42
## 4927 4926 12/05/13 Stoke Tottenham 1 2 NH 32 63 42
## 4536 4535 30/04/12 Man City Man United 1 0 H 87 86 27
## 5286 5285 20/04/14 Norwich Liverpool 2 3 NH 26 93 53
## 367 366 08/05/01 Liverpool Chelsea 2 2 NH 65 64 37
## 6815 6814 04/05/18 Brighton Man United 1 0 H 32 67 47
## 4938 4937 19/05/13 West Brom Man United 5 5 NH 48 81 52
## 2649 2648 09/05/07 Chelsea Man United 0 0 NH 63 83 23
## 1891 1890 15/05/05 Birmingham Arsenal 2 1 H 38 86 45
## 6437 6436 12/05/17 West Brom Chelsea 0 1 NH 41 75 45
## 355 354 01/05/01 Bradford Liverpool 0 2 NH 28 62 63
## 4105 4104 02/04/11 West Ham Man United 2 4 NH 36 64 49
## 6813 6812 29/04/18 West Ham Man City 1 4 NH 43 102 67
## 6793 6792 15/04/18 Newcastle Arsenal 2 1 H 35 62 42
## 2631 2630 28/04/07 Everton Man United 2 4 NH 46 82 31
## 2232 2231 15/04/06 Bolton Chelsea 0 2 NH 43 64 38
## 6714 6713 03/02/18 Burnley Man City 1 1 NH 20 73 22
## 5687 5686 17/05/15 Man United Arsenal 1 1 NH 61 67 36
## 4508 4507 11/04/12 Wigan Man United 1 0 H 30 78 57
## 4930 4929 14/05/13 Reading Man City 0 2 NH 41 62 67
## 6830 6829 10/05/18 West Ham Man United 0 0 NH 45 67 67
## 721 720 13/04/02 Derby Newcastle 2 3 NH 30 65 56
## 6754 6753 10/03/18 Man United Liverpool 2 1 H 56 67 22
## 6837 6836 13/05/18 Southampton Man City 0 1 NH 37 105 55
## 5185 5184 08/02/14 Norwich Man City 0 0 NH 19 68 37
## 3756 3755 14/04/10 Tottenham Arsenal 2 1 H 60 75 33
## 3007 3006 19/04/08 Wigan Tottenham 1 1 NH 31 63 48
## 3396 3395 09/05/09 West Ham Liverpool 0 3 NH 39 69 38
## 694 693 30/03/02 Leeds Man United 3 4 NH 44 78 30
## 4559 4558 13/05/12 West Brom Arsenal 2 3 NH 43 71 49
## 1504 1503 08/05/04 Man United Chelsea 1 1 NH 61 65 34
## 4174 4173 22/05/11 Fulham Arsenal 2 2 NH 47 70 41
## 1877 1876 02/05/05 West Brom Arsenal 0 2 NH 33 76 58
## 6074 6073 15/05/16 Newcastle Tottenham 5 1 H 39 68 64
## 3787 3786 03/05/10 Blackburn Arsenal 2 1 H 38 78 54
## 6422 6421 30/04/17 Middlesbrough Man City 2 2 NH 24 65 43
## 6056 6055 02/05/16 Chelsea Tottenham 2 2 NH 55 65 48
## 4489 4488 02/04/12 Blackburn Man United 0 2 NH 43 74 62
## 1098 1097 19/04/2003 Middlesboro Arsenal 0 2 NH 42 69 35
## 3790 3789 05/05/10 Man City Tottenham 0 1 NH 72 64 43
## 369 368 13/05/01 Southampton Man United 2 1 H 35 77 45
## 3761 3760 17/04/10 Man City Man United 0 1 NH 69 77 42
## 3039 3038 11/05/08 West Ham Aston Villa 2 2 NH 40 69 48
## 1135 1134 11/05/2003 Everton Man United 1 2 NH 47 72 47
## 6435 6434 10/05/17 Southampton Arsenal 0 2 NH 39 68 46
## 3794 3793 09/05/10 Burnley Tottenham 4 2 H 38 65 80
## 5316 5315 11/05/14 Norwich Arsenal 0 2 NH 28 66 60
## 4542 4541 06/05/12 Aston Villa Tottenham 1 1 NH 36 63 50
## 744 743 27/04/02 Middlesbrough Chelsea 0 2 NH 35 63 44
## 6760 6759 12/03/18 Stoke Man City 0 2 NH 28 83 54
## 6423 6422 30/04/17 Tottenham Arsenal 2 0 H 71 66 22
## 4529 4528 28/04/12 Stoke Arsenal 1 1 NH 32 67 48
## 4127 4126 20/04/11 Tottenham Arsenal 3 3 NH 47 63 39
## 4157 4156 08/05/11 Stoke Arsenal 3 1 H 43 68 43
## 701 700 01/04/02 Charlton Arsenal 0 3 NH 35 66 38
## 3727 3726 24/03/10 Portsmouth Chelsea 0 5 NH 28 70 53
## 380 379 19/05/01 Tottenham Man United 3 1 H 44 78 53
## 4498 4497 08/04/12 Arsenal Man City 1 0 H 62 75 41
## 371 370 19/05/01 Charlton Liverpool 0 4 NH 50 67 53
## 6460 6459 21/05/17 Watford Man City 0 5 NH 40 75 63
## 4156 4155 08/05/11 Man United Chelsea 2 1 H 71 66 33
## 3040 3039 11/05/08 Wigan Man United 0 2 NH 34 78 49
## 4546 4545 06/05/12 Newcastle Man City 0 2 NH 55 88 46
## 4910 4909 04/05/13 QPR Arsenal 0 1 NH 29 65 56
## 5304 5303 03/05/14 Everton Man City 2 3 NH 57 96 36
## 1138 1137 11/05/2003 Sunderland Arsenal 0 4 NH 21 81 61
## 5639 5638 12/04/15 QPR Chelsea 0 1 NH 35 64 55
## 3769 3768 24/04/10 Arsenal Man City 0 0 NH 76 69 36
## 3799 3798 09/05/10 West Ham Man City 1 1 NH 46 72 65
## 334 333 17/04/01 Tottenham Chelsea 0 3 NH 41 62 43
## 5669 5668 04/05/15 Hull Arsenal 1 3 NH 32 66 45
## 2647 2646 06/05/07 Arsenal Chelsea 1 1 NH 62 63 34
## 6053 6052 01/05/16 Man United Leicester 1 1 NH 43 63 31
## 6774 6773 01/04/18 Chelsea Tottenham 1 3 NH 53 62 30
## 6441 6440 13/05/17 Stoke Arsenal 1 4 NH 39 72 52
## 658 657 03/03/02 Derby Man United 2 2 NH 21 66 43
## 748 747 29/04/02 Bolton Arsenal 0 2 NH 43 74 58
## 3020 3019 28/04/08 Derby Arsenal 2 6 NH 17 66 76
## 1499 1498 04/05/04 Portsmouth Arsenal 1 1 NH 40 69 49
## 1897 1896 15/05/05 Newcastle Chelsea 1 1 NH 46 71 56
## ATGC HTP ATP HM1 HM2 HM3 HM4 HM5 AM1 AM2 AM3 AM4 AM5 MW
## 678 37 1.2333333 1.933333 W L W L W D W W W W 30
## 5689 28 1.1081081 2.270270 D W D W L D W W D W 37
## 6420 29 1.6764706 2.294118 W W D L W W L W W L 34
## 350 25 1.0000000 2.200000 L W D L W D W W L W 35
## 4883 33 1.0303030 2.424242 L L D L L W L W W W 33
## 6402 40 1.3333333 1.909091 L L D W L W D W D W 33
## 1869 13 1.5142857 2.428571 D W W L W W D D W W 35
## 6740 20 1.6071429 2.571429 L W L W L W D W W L 28
## 3409 26 0.8378378 2.162162 W L W L D W W W D W 37
## 750 33 2.0540541 2.189189 W W W W L W W W W W 37
## 6384 24 1.0967742 2.322581 D W W D L W L W W W 31
## 5230 35 1.6551724 2.034483 W W D D L W W W W D 29
## 5294 35 1.1944444 2.138889 W W W W W W W D L W 36
## 3003 18 1.4571429 2.285714 L D D W L W D W W W 35
## 5225 27 1.0344828 2.172414 L W L W D W W W D L 29
## 6791 25 1.9705882 2.558824 L W W W W W L W W W 34
## 6450 24 1.1621622 2.162162 L W W L D W L W W W 37
## 4861 31 1.0000000 2.483871 D L D L L W W W W W 31
## 1512 35 1.4736842 1.894737 D W W D W D L L W L 38
## 2267 20 1.5405405 2.459459 W L L D D W W W W D 37
## 4429 19 1.1200000 2.280000 L D W D L W L W W W 25
## 3018 45 1.6944444 1.611111 L D W L D W W W L L 36
## 4885 33 1.2121212 1.848485 D L W W D W W L W W 33
## 6766 34 0.8709677 1.935484 L L L L D L W W W D 31
## 3400 23 1.1666667 2.305556 L D L L L W W W W W 36
## 1834 33 1.4062500 2.093750 W L L D D W W W D W 32
## 3696 24 0.8571429 2.035714 L L W L D L D W W W 28
## 5295 26 2.2222222 2.083333 W W W W W L W W L W 36
## 1119 32 1.3888889 2.055556 W L D W L W D W W W 36
## 6412 22 1.1176471 2.176471 W D W L W W W W W W 34
## 4556 33 1.1842105 2.263158 L D D D L W L D W L 38
## 3012 19 2.1666667 2.250000 W D W W W D W D W W 36
## 5696 37 0.8947368 1.815789 L L L W W D W L L L 38
## 3720 27 1.1333333 2.133333 L L W W L W L W L W 30
## 1071 33 1.1250000 2.062500 D L L L L W L W W D 32
## 735 46 1.1111111 1.861111 D W D W L W W D D W 36
## 4173 32 1.3421053 1.868421 L W D L W D L W W W 38
## 4934 37 1.0789474 1.842105 W D L D L W W D W D 38
## 1850 33 2.4545455 2.121212 D W W W W W W W W D 33
## 6833 51 0.9736842 1.578947 D D L W D L W L W L 38
## 5170 25 1.8695652 2.173913 W W W W D W W W W W 23
## 3785 32 1.6756757 2.162162 W W D D W W L W W W 37
## 3786 28 1.1891892 2.135135 W W L W L W W D L W 37
## 2657 35 1.3947368 1.763158 L W D W L D W D W W 38
## 4927 45 1.1081081 1.783784 D W W L L D W D W D 37
## 4536 32 2.2222222 2.305556 W W W L D D W L W W 36
## 5286 42 0.9142857 2.200000 L L L W L W W W W W 35
## 367 42 1.7567568 1.540541 W W W W W W L L W W 37
## 6815 27 1.0277778 2.138889 D D L D L W W L W W 36
## 4938 38 1.2631579 2.315789 L L L W D W L D W D 38
## 2649 26 2.1891892 2.378378 D D D W W W W D W L 37
## 1891 34 1.1052632 2.184211 L W D L D W W W W D 38
## 6437 29 1.2500000 2.333333 D L L L L W W W L W 36
## 355 37 0.6666667 1.722222 L L W W L W W W W L 36
## 4105 30 1.0322581 2.032258 D W W D L W L L W W 31
## 6813 26 0.9722222 2.583333 L L D D W W W W L W 36
## 6793 45 1.2058824 1.588235 W W W W L L W W W L 34
## 2631 26 1.5000000 2.361111 L W D W D W D W L W 36
## 2232 20 1.4117647 2.411765 L L L L L W D W L W 34
## 6714 18 1.3461538 2.615385 D L L L D W W L W D 26
## 5687 35 1.8378378 1.918919 W L L L W D L W D W 37
## 4508 27 0.8484848 2.393939 L W W D D W W W W W 33
## 4930 31 0.7567568 2.027027 W D L D L W D W L W 37
## 6830 28 1.0270270 2.081081 W L L D D L W W L W 37
## 721 46 0.8285714 1.828571 L L L L W W D D W D 35
## 6754 32 2.0666667 2.000000 W W L W L W W W D W 30
## 6837 27 0.9473684 2.552632 W D W D L W D W W W 38
## 5185 27 0.9600000 2.120000 L D W L D L W W W W 25
## 3756 34 1.7941176 2.088235 W L W W W W D W W W 34
## 3007 57 1.0000000 1.171429 D W L L W D D L W D 35
## 3396 26 1.3333333 2.138889 W L D L W W W D W W 36
## 694 40 1.6875000 2.000000 W W W D D W W D W W 32
## 4559 47 1.2368421 1.763158 D D W W L D D D L W 38
## 1504 29 1.9189189 2.027027 L L W L W W L D L D 37
## 4174 41 1.2631579 1.763158 W L W W D L L W L D 38
## 1877 33 0.8333333 2.138889 D L D D W W W D W W 36
## 6074 30 0.8947368 1.842105 D W D D W L D D W W 38
## 3787 39 1.1891892 1.945946 D L D D W D L L W D 37
## 6422 37 0.7714286 1.885714 W L L D L D D W W L 35
## 6056 26 1.3333333 1.916667 D W L L W D W W D W 36
## 4489 27 0.9032258 2.354839 L W W D L W W W W W 31
## 1098 36 1.3529412 2.000000 D W D W W D D W L W 34
## 3790 37 1.7837838 1.810811 W D L W W W L W W L 37
## 369 26 1.2432432 2.162162 L D L D L L W D W W 37
## 3761 27 1.7714286 2.085714 L W W W L D L W W W 35
## 3039 49 1.2631579 1.552632 L D W L L L D W W W 38
## 1135 33 1.5526316 2.105263 L W L L W W W W D W 38
## 6435 42 1.1666667 1.833333 L D D L L W W L W W 36
## 3794 37 0.7105263 1.842105 L L L W L W W L W W 38
## 5316 41 0.8684211 2.000000 D L L L L W W W W L 38
## 4542 40 1.0000000 1.756757 D L D L D W W L L D 37
## 744 35 1.2162162 1.648649 L L W W D L D W D W 37
## 6760 20 0.9000000 2.600000 D D D L D W W W D W 30
## 6423 42 2.2000000 1.800000 W W W W W W L W W L 35
## 4529 43 1.2000000 1.828571 L D W L D L W W L W 35
## 4127 31 1.6363636 1.909091 D W D D D D W D D D 33
## 4157 36 1.1944444 1.861111 D W D L D W L D D W 36
## 701 32 1.2424242 2.090909 L L W D W W W W W W 33
## 3727 28 0.7096774 2.096774 W L L W L D W L W L 31
## 380 28 1.2105263 2.105263 L D L L W L L W D W 38
## 4498 25 1.8125000 2.218750 L W W W W D D W L W 32
## 371 39 1.3684211 1.736842 L W W D L D W W W W 38
## 6460 39 1.0526316 1.973684 L L L L L W W W D D 38
## 4156 28 2.0277778 1.944444 L W D W W W W W W W 36
## 3040 22 1.0526316 2.210526 W D D D W W L D W D 38
## 4546 27 1.7567568 2.243243 W L W W W W W W W L 37
## 4910 35 0.6857143 1.800000 L L D L L W D W W W 35
## 5304 37 1.8648649 2.162162 L W L W W W W W D L 37
## 1138 42 0.5000000 1.973684 L L L L L W L D W D 38
## 5639 26 0.7812500 2.281250 W L L L L W W W D W 32
## 3769 42 2.0285714 1.771429 L W D W W L W W W L 35
## 3799 44 0.8947368 1.736842 L W L W D L W D L W 38
## 334 38 1.3235294 1.588235 W W L W L W W W W L 34
## 5669 33 0.9714286 2.000000 W W L L L W D W W W 35
## 2647 23 1.7837838 2.189189 W D W W D D D D W W 37
## 6053 33 1.6666667 2.111111 D W W L W W D W W W 36
## 6774 26 1.7500000 2.000000 L W L L W W W W W W 32
## 6441 43 1.1081081 1.864865 D D L W L W W W L W 37
## 658 35 0.8928571 1.928571 W L W L L W W W L W 28
## 748 33 1.0810811 2.189189 L D W L W W W W W W 37
## 3020 29 0.3055556 2.055556 L L L D L W L D W L 36
## 1499 24 1.1388889 2.305556 D W W W D D D W D W 36
## 1897 14 1.1315789 2.473684 L W D D L W W W W D 38
## HTFormPtsStr ATFormPtsStr HTFormPts ATFormPts HTWinStreak3 HTWinStreak5
## 678 WLWLW DWWWW 9 13 0 0
## 5689 DWDWL DWWDW 8 11 0 0
## 6420 WWDLW WLWWL 10 9 0 0
## 350 LWDLW DWWLW 7 10 0 0
## 4883 LLDLL WLWWW 1 12 0 0
## 6402 LLDWL WDWDW 4 11 0 0
## 1869 DWWLW WDDWW 10 11 0 0
## 6740 LWLWL WDWWL 6 10 0 0
## 3409 WLWLD WWWDW 7 13 0 0
## 750 WWWWL WWWWW 12 15 0 0
## 6384 DWWDL WLWWW 8 12 0 0
## 5230 WWDDL WWWWD 8 13 0 0
## 5294 WWWWW WWDLW 15 10 1 1
## 3003 LDDWL WDWWW 5 13 0 0
## 5225 LWLWD WWWDL 7 10 0 0
## 6791 LWWWW WLWWW 12 12 1 0
## 6450 LWWLD WLWWW 7 12 0 0
## 4861 DLDLL WWWWW 2 15 0 0
## 1512 DWWDW DLLWL 11 4 0 0
## 2267 WLLDD WWWWD 5 13 0 0
## 4429 LDWDL WLWWW 5 12 0 0
## 3018 LDWLD WWWLL 5 9 0 0
## 4885 DLWWD WWLWW 8 12 0 0
## 6766 LLLLD LWWWD 1 10 0 0
## 3400 LDLLL WWWWW 1 15 0 0
## 1834 WLLDD WWWDW 5 13 0 0
## 3696 LLWLD LDWWW 4 10 0 0
## 5295 WWWWW LWWLW 15 9 1 1
## 1119 WLDWL WDWWW 7 13 0 0
## 6412 WDWLW WWWWW 10 15 0 0
## 4556 LDDDL WLDWL 3 7 0 0
## 3012 WDWWW DWDWW 13 11 1 0
## 5696 LLLWW DWLLL 6 4 0 0
## 3720 LLWWL WLWLW 6 9 0 0
## 1071 DLLLL WLWWD 1 10 0 0
## 735 DWDWL WWDDW 8 11 0 0
## 4173 LWDLW DLWWW 7 10 0 0
## 4934 WDLDL WWDWD 5 11 0 0
## 1850 DWWWW WWWWD 13 13 1 0
## 6833 DDLWD LWLWL 6 6 0 0
## 5170 WWWWD WWWWW 13 15 0 0
## 3785 WWDDW WLWWW 11 12 0 0
## 3786 WWLWL WWDLW 9 10 0 0
## 2657 LWDWL DWDWW 7 11 0 0
## 4927 DWWLL DWDWD 7 9 0 0
## 4536 WWWLD DWLWW 10 10 0 0
## 5286 LLLWL WWWWW 3 15 0 0
## 367 WWWWW WLLWW 15 9 1 1
## 6815 DDLDL WWLWW 3 12 0 0
## 4938 LLLWD WLDWD 4 8 0 0
## 2649 DDDWW WWDWL 9 10 0 0
## 1891 LWDLD WWWWD 5 13 0 0
## 6437 DLLLL WWWLW 1 12 0 0
## 355 LLWWL WWWWL 6 12 0 0
## 4105 DWWDL WLLWW 8 9 0 0
## 6813 LLDDW WWWLW 5 12 0 0
## 6793 WWWWL LWWWL 12 9 0 0
## 2631 LWDWD WDWLW 8 10 0 0
## 2232 LLLLL WDWLW 0 10 0 0
## 6714 DLLLD WWLWD 2 10 0 0
## 5687 WLLLW DLWDW 6 8 0 0
## 4508 LWWDD WWWWW 8 15 0 0
## 4930 WDLDL WDWLW 5 10 0 0
## 6830 WLLDD LWWLW 5 9 0 0
## 721 LLLLW WDDWD 3 9 0 0
## 6754 WWLWL WWWDW 9 13 0 0
## 6837 WDWDL WDWWW 8 13 0 0
## 5185 LDWLD LWWWW 5 12 0 0
## 3756 WLWWW WDWWW 12 13 1 0
## 3007 DWLLW DDLWD 7 6 0 0
## 3396 WLDLW WWDWW 7 13 0 0
## 694 WWWDD WWDWW 11 13 0 0
## 4559 DDWWL DDDLW 8 6 0 0
## 1504 LLWLW WLDLD 6 5 0 0
## 4174 WLWWD LLWLD 10 4 0 0
## 1877 DLDDW WWDWW 6 13 0 0
## 6074 DWDDW LDDWW 9 8 0 0
## 3787 DLDDW DLLWD 6 5 0 0
## 6422 WLLDL DDWWL 4 8 0 0
## 6056 DWLLW DWWDW 7 11 0 0
## 4489 LWWDL WWWWW 7 15 0 0
## 1098 DWDWW DDWLW 11 8 0 0
## 3790 WDLWW WLWWL 10 9 0 0
## 369 LDLDL LWDWW 2 10 0 0
## 3761 LWWWL DLWWW 9 10 0 0
## 3039 LDWLL LDWWW 4 10 0 0
## 1135 LWLLW WWWDW 6 13 0 0
## 6435 LDDLL WWLWW 2 12 0 0
## 3794 LLLWL WWLWW 3 12 0 0
## 5316 DLLLL WWWWL 1 12 0 0
## 4542 DLDLD WWLLD 3 7 0 0
## 744 LLWWD LDWDW 7 8 0 0
## 6760 DDDLD WWWDW 4 13 0 0
## 6423 WWWWW WLWWL 15 9 1 1
## 4529 LDWLD LWWLW 5 9 0 0
## 4127 DWDDD DWDDD 7 7 0 0
## 4157 DWDLD WLDDW 6 8 0 0
## 701 LLWDW WWWWW 7 15 0 0
## 3727 WLLWL DWLWL 6 7 0 0
## 380 LDLLW LLWDW 4 7 0 0
## 4498 LWWWW DDWLW 12 8 1 0
## 371 LWWDL DWWWW 7 13 0 0
## 6460 LLLLL WWWDD 0 11 0 0
## 4156 LWDWW WWWWW 10 15 0 0
## 3040 WDDDW WLDWD 9 8 0 0
## 4546 WLWWW WWWWL 12 12 1 0
## 4910 LLDLL WDWWW 1 13 0 0
## 5304 LWLWW WWWDL 9 10 0 0
## 1138 LLLLL WLDWD 0 8 0 0
## 5639 WLLLL WWWDW 3 13 0 0
## 3769 LWDWW LWWWL 10 9 0 0
## 3799 LWLWD LWDLW 7 7 0 0
## 334 WWLWL WWWWL 9 12 0 0
## 5669 WWLLL WDWWW 6 13 0 0
## 2647 WDWWD DDDWW 11 9 0 0
## 6053 DWWLW WDWWW 10 13 0 0
## 6774 LWLLW WWWWW 6 15 0 0
## 6441 DDLWL WWWLW 5 12 0 0
## 658 WLWLL WWWLW 6 12 0 0
## 748 LDWLW WWWWW 7 15 0 0
## 3020 LLLDL WLDWL 1 7 0 0
## 1499 DWWWD DDWDW 11 9 0 0
## 1897 LWDDL WWWWD 5 13 0 0
## HTLossStreak3 HTLossStreak5 ATWinStreak3 ATWinStreak5 ATLossStreak3
## 678 0 0 1 0 0
## 5689 0 0 0 0 0
## 6420 0 0 0 0 0
## 350 0 0 0 0 0
## 4883 0 0 1 0 0
## 6402 0 0 0 0 0
## 1869 0 0 0 0 0
## 6740 0 0 0 0 0
## 3409 0 0 0 0 0
## 750 0 0 1 1 0
## 6384 0 0 1 0 0
## 5230 0 0 0 0 0
## 5294 0 0 0 0 0
## 3003 0 0 1 0 0
## 5225 0 0 0 0 0
## 6791 0 0 1 0 0
## 6450 0 0 1 0 0
## 4861 0 0 1 1 0
## 1512 0 0 0 0 0
## 2267 0 0 0 0 0
## 4429 0 0 1 0 0
## 3018 0 0 0 0 0
## 4885 0 0 0 0 0
## 6766 0 0 0 0 0
## 3400 1 0 1 1 0
## 1834 0 0 0 0 0
## 3696 0 0 1 0 0
## 5295 0 0 0 0 0
## 1119 0 0 1 0 0
## 6412 0 0 1 1 0
## 4556 0 0 0 0 0
## 3012 0 0 0 0 0
## 5696 0 0 0 0 1
## 3720 0 0 0 0 0
## 1071 1 0 0 0 0
## 735 0 0 0 0 0
## 4173 0 0 1 0 0
## 4934 0 0 0 0 0
## 1850 0 0 0 0 0
## 6833 0 0 0 0 0
## 5170 0 0 1 1 0
## 3785 0 0 1 0 0
## 3786 0 0 0 0 0
## 2657 0 0 0 0 0
## 4927 0 0 0 0 0
## 4536 0 0 0 0 0
## 5286 0 0 1 1 0
## 367 0 0 0 0 0
## 6815 0 0 0 0 0
## 4938 0 0 0 0 0
## 2649 0 0 0 0 0
## 1891 0 0 0 0 0
## 6437 1 0 0 0 0
## 355 0 0 0 0 0
## 4105 0 0 0 0 0
## 6813 0 0 0 0 0
## 6793 0 0 0 0 0
## 2631 0 0 0 0 0
## 2232 1 1 0 0 0
## 6714 0 0 0 0 0
## 5687 0 0 0 0 0
## 4508 0 0 1 1 0
## 4930 0 0 0 0 0
## 6830 0 0 0 0 0
## 721 0 0 0 0 0
## 6754 0 0 0 0 0
## 6837 0 0 1 0 0
## 5185 0 0 1 0 0
## 3756 0 0 1 0 0
## 3007 0 0 0 0 0
## 3396 0 0 0 0 0
## 694 0 0 0 0 0
## 4559 0 0 0 0 0
## 1504 0 0 0 0 0
## 4174 0 0 0 0 0
## 1877 0 0 0 0 0
## 6074 0 0 0 0 0
## 3787 0 0 0 0 0
## 6422 0 0 0 0 0
## 6056 0 0 0 0 0
## 4489 0 0 1 1 0
## 1098 0 0 0 0 0
## 3790 0 0 0 0 0
## 369 0 0 0 0 0
## 3761 0 0 1 0 0
## 3039 0 0 1 0 0
## 1135 0 0 0 0 0
## 6435 0 0 0 0 0
## 3794 0 0 0 0 0
## 5316 1 0 0 0 0
## 4542 0 0 0 0 0
## 744 0 0 0 0 0
## 6760 0 0 0 0 0
## 6423 0 0 0 0 0
## 4529 0 0 0 0 0
## 4127 0 0 0 0 0
## 4157 0 0 0 0 0
## 701 0 0 1 1 0
## 3727 0 0 0 0 0
## 380 0 0 0 0 0
## 4498 0 0 0 0 0
## 371 0 0 1 0 0
## 6460 1 1 0 0 0
## 4156 0 0 1 1 0
## 3040 0 0 0 0 0
## 4546 0 0 0 0 0
## 4910 0 0 1 0 0
## 5304 0 0 0 0 0
## 1138 1 1 0 0 0
## 5639 1 0 0 0 0
## 3769 0 0 0 0 0
## 3799 0 0 0 0 0
## 334 0 0 0 0 0
## 5669 1 0 1 0 0
## 2647 0 0 0 0 0
## 6053 0 0 1 0 0
## 6774 0 0 1 1 0
## 6441 0 0 0 0 0
## 658 0 0 0 0 0
## 748 0 0 1 1 0
## 3020 0 0 0 0 0
## 1499 0 0 0 0 0
## 1897 0 0 0 0 0
## ATLossStreak5 HTGD ATGD DiffPts DiffFormPts
## 678 0 -0.40000000 1.0666667 -0.70000000 -0.13333333
## 5689 0 -0.35135135 1.1351351 -1.16216216 -0.08108108
## 6420 0 0.67647059 1.1764706 -0.61764706 0.02941176
## 350 0 -0.05714286 1.4285714 -1.20000000 -0.08571429
## 4883 0 -0.33333333 1.2121212 -1.39393939 -0.33333333
## 6402 0 -0.06060606 0.8484848 -0.57575758 -0.21212121
## 1869 0 0.17142857 1.4857143 -0.91428571 -0.02857143
## 6740 0 0.53571429 2.1071429 -0.96428571 -0.14285714
## 3409 0 -0.78378378 1.2432432 -1.32432432 -0.16216216
## 750 0 1.16216216 1.1081081 -0.13513514 -0.08108108
## 6384 0 -0.38709677 1.2258065 -1.22580645 -0.12903226
## 5230 0 0.51724138 1.3103448 -0.37931034 -0.17241379
## 5294 0 -0.36111111 1.6111111 -0.94444444 0.13888889
## 3003 0 0.05714286 1.5428571 -0.82857143 -0.22857143
## 5225 0 -0.17241379 1.6896552 -1.13793103 -0.10344828
## 6791 0 1.02941176 2.0000000 -0.58823529 0.00000000
## 6450 0 -0.27027027 1.3243243 -1.00000000 -0.13513514
## 4861 0 -0.29032258 1.2580645 -1.48387097 -0.41935484
## 1512 0 0.15789474 0.7105263 -0.42105263 0.18421053
## 2267 0 0.16216216 1.4054054 -0.91891892 -0.21621622
## 4429 0 -0.16000000 1.7600000 -1.16000000 -0.28000000
## 3018 0 0.58333333 0.6111111 0.08333333 -0.11111111
## 4885 0 -0.12121212 0.9393939 -0.63636364 -0.12121212
## 6766 0 -0.64516129 1.0967742 -1.06451613 -0.29032258
## 3400 0 -0.25000000 1.1666667 -1.13888889 -0.38888889
## 1834 0 0.09375000 1.2187500 -0.68750000 -0.25000000
## 3696 0 -0.85714286 1.3928571 -1.17857143 -0.21428571
## 5295 0 1.44444444 1.1388889 0.13888889 0.16666667
## 1119 0 -0.02777778 0.9444444 -0.66666667 -0.16666667
## 6412 0 -0.20588235 1.3823529 -1.05882353 -0.14705882
## 4556 0 0.00000000 1.4473684 -1.07894737 -0.10526316
## 3012 0 1.00000000 1.5000000 -0.08333333 0.05555556
## 5696 0 -0.47368421 0.6578947 -0.92105263 0.05263158
## 3720 0 -0.56666667 1.4000000 -1.00000000 -0.10000000
## 1071 0 -0.12500000 1.0312500 -0.93750000 -0.28125000
## 735 0 0.02777778 0.6111111 -0.75000000 -0.08333333
## 4173 0 0.13157895 0.9736842 -0.52631579 -0.07894737
## 4934 0 -0.57894737 0.8947368 -0.76315789 -0.15789474
## 1850 0 1.51515152 1.2121212 0.33333333 0.00000000
## 6833 0 -0.76315789 0.5789474 -0.60526316 0.00000000
## 5170 0 0.13043478 1.6521739 -0.30434783 -0.08695652
## 3785 0 0.75675676 1.6486486 -0.48648649 -0.02702703
## 3786 0 -0.16216216 1.4324324 -0.94594595 -0.02702703
## 2657 0 0.07894737 0.7368421 -0.36842105 -0.10526316
## 4927 0 -0.27027027 0.4864865 -0.67567568 -0.05405405
## 4536 0 1.66666667 1.5000000 -0.08333333 0.00000000
## 5286 0 -0.77142857 1.4571429 -1.28571429 -0.34285714
## 367 0 0.75675676 0.5945946 0.21621622 0.16216216
## 6815 0 -0.41666667 1.1111111 -1.11111111 -0.25000000
## 4938 0 -0.10526316 1.1315789 -1.05263158 -0.10526316
## 2649 0 1.08108108 1.5405405 -0.18918919 -0.02702703
## 1891 0 -0.18421053 1.3684211 -1.07894737 -0.21052632
## 6437 0 -0.11111111 1.2777778 -1.08333333 -0.30555556
## 355 0 -0.97222222 0.6944444 -1.05555556 -0.16666667
## 4105 0 -0.41935484 1.0967742 -1.00000000 -0.03225806
## 6813 0 -0.66666667 2.1111111 -1.61111111 -0.19444444
## 6793 0 -0.20588235 0.5000000 -0.38235294 0.08823529
## 2631 0 0.41666667 1.5555556 -0.86111111 -0.05555556
## 2232 0 0.14705882 1.2941176 -1.00000000 -0.29411765
## 6714 0 -0.07692308 2.1153846 -1.26923077 -0.30769231
## 5687 0 0.67567568 0.8648649 -0.08108108 -0.05405405
## 4508 0 -0.81818182 1.5454545 -1.54545455 -0.21212121
## 4930 0 -0.70270270 0.8378378 -1.27027027 -0.13513514
## 6830 0 -0.59459459 1.0540541 -1.05405405 -0.10810811
## 721 0 -0.74285714 0.5428571 -1.00000000 -0.17142857
## 6754 0 1.13333333 1.1666667 0.06666667 -0.13333333
## 6837 0 -0.47368421 2.0526316 -1.60526316 -0.13157895
## 5185 0 -0.72000000 1.6400000 -1.16000000 -0.28000000
## 3756 0 0.79411765 1.2058824 -0.29411765 -0.02941176
## 3007 0 -0.48571429 0.1714286 -0.17142857 0.02857143
## 3396 0 0.02777778 1.1944444 -0.80555556 -0.16666667
## 694 0 0.43750000 1.1875000 -0.31250000 -0.06250000
## 4559 0 -0.15789474 0.6315789 -0.52631579 0.05263158
## 1504 0 0.72972973 0.9729730 -0.10810811 0.02702703
## 4174 0 0.15789474 0.7631579 -0.50000000 0.15789474
## 1877 0 -0.69444444 1.1944444 -1.30555556 -0.19444444
## 6074 0 -0.65789474 1.0000000 -0.94736842 0.02631579
## 3787 0 -0.43243243 1.0540541 -0.75675676 0.02702703
## 6422 0 -0.54285714 0.8000000 -1.11428571 -0.11428571
## 6056 0 0.19444444 1.0833333 -0.58333333 -0.11111111
## 4489 0 -0.61290323 1.5161290 -1.45161290 -0.25806452
## 1098 0 0.20588235 0.9705882 -0.64705882 0.08823529
## 3790 0 0.78378378 0.7297297 -0.02702703 0.02702703
## 369 0 -0.27027027 1.3783784 -0.91891892 -0.21621622
## 3761 0 0.77142857 1.4285714 -0.31428571 -0.02857143
## 3039 0 -0.21052632 0.5263158 -0.28947368 -0.15789474
## 1135 0 0.00000000 1.0263158 -0.55263158 -0.18421053
## 6435 0 -0.19444444 0.7222222 -0.66666667 -0.27777778
## 3794 0 -1.10526316 0.7368421 -1.13157895 -0.23684211
## 5316 0 -0.84210526 0.6578947 -1.13157895 -0.28947368
## 4542 0 -0.37837838 0.6216216 -0.75675676 -0.10810811
## 744 0 -0.24324324 0.7567568 -0.43243243 -0.02702703
## 6760 0 -0.86666667 2.1000000 -1.70000000 -0.30000000
## 6423 0 1.40000000 0.6857143 0.40000000 0.17142857
## 4529 0 -0.45714286 0.6857143 -0.62857143 -0.11428571
## 4127 0 0.24242424 0.9696970 -0.27272727 0.00000000
## 4157 0 0.00000000 0.8888889 -0.66666667 -0.05555556
## 701 0 -0.09090909 1.0303030 -0.84848485 -0.24242424
## 3727 0 -0.80645161 1.3548387 -1.38709677 -0.03225806
## 380 0 -0.23684211 1.3157895 -0.89473684 -0.07894737
## 4498 0 0.65625000 1.5625000 -0.40625000 0.12500000
## 371 0 -0.07894737 0.7368421 -0.36842105 -0.15789474
## 6460 0 -0.60526316 0.9473684 -0.92105263 -0.28947368
## 4156 0 1.05555556 1.0555556 0.08333333 -0.13888889
## 3040 0 -0.39473684 1.4736842 -1.15789474 0.02631579
## 4546 0 0.24324324 1.6486486 -0.48648649 0.00000000
## 4910 0 -0.77142857 0.8571429 -1.11428571 -0.34285714
## 5304 0 0.56756757 1.5945946 -0.29729730 -0.02702703
## 1138 0 -1.05263158 1.0263158 -1.47368421 -0.21052632
## 5639 0 -0.62500000 1.1875000 -1.50000000 -0.31250000
## 3769 0 1.14285714 0.7714286 0.25714286 0.02857143
## 3799 0 -0.50000000 0.7368421 -0.84210526 0.00000000
## 334 0 -0.05882353 0.7058824 -0.26470588 -0.08823529
## 5669 0 -0.37142857 0.9428571 -1.02857143 -0.20000000
## 2647 0 0.75675676 1.0810811 -0.40540541 0.05405405
## 6053 0 0.33333333 0.8333333 -0.44444444 -0.08333333
## 6774 0 0.71875000 1.1250000 -0.25000000 -0.28125000
## 6441 0 -0.35135135 0.7837838 -0.75675676 -0.18918919
## 658 0 -0.78571429 1.1071429 -1.03571429 -0.21428571
## 748 0 -0.40540541 1.1081081 -1.10810811 -0.21621622
## 3020 0 -1.63888889 1.0277778 -1.75000000 -0.16666667
## 1499 0 -0.25000000 1.2500000 -1.16666667 0.05555556
## 1897 0 -0.26315789 1.5000000 -1.34210526 -0.21052632
Visualization for sample 2
library(ggplot2)
# barplot of the "ATGS" column
ggplot(sample_2, aes(y = ATGS)) +
geom_bar() +
geom_point(data = outliers, aes(x=1 ,y = ATGS), color = "blue", size = 4) +
labs(
title = "Barplot of ATGS with Outliers Highlighted",
y = "ATGS"
) +
theme_minimal()
Analysis: By observing the barplots of both the sample set we can
see the that the outliers range in both the sample set for the ATGS
column is the same .
Normal distribution of full time result column in sample 3
data <- sample_3
ggplot(sample_3, aes(x=FTR)) +
geom_bar() +
labs(title = "Distribution of Teams", x = "Team", y = "Frequency") +
theme(axis.text.x = element_text(angle = 90, hjust = 1))
normal distribution of team in sample 4
data <- sample_4
ggplot(sample_4, aes(x=FTR)) +
geom_bar() +
labs(title = "Distribution of Full time result of Teams", x = "Team", y = "Frequency") +
theme(axis.text.x = element_text(angle = 90, hjust = 1))
analysis :We can see the distribution of full time results of teams
in sample 3 and 4 is almost same.