library(stringr)
library(readr)
library(tidyverse)## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.4.1 ✔ purrr 1.0.1
## ✔ tibble 3.2.1 ✔ dplyr 1.1.2
## ✔ tidyr 1.3.0 ✔ forcats 1.0.0
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()library(dplyr)dfTournament = read_csv("tournamentinfo.csv", show_col_types = FALSE)head(dfTournament)## # A tibble: 6 × 1
## ----------------------------------------------------------------------------…¹
## <chr>
## 1 Pair | Player Name |Total|Round|Round|Round|Round|Round|R…
## 2 Num | USCF ID / Rtg (Pre->Post) | Pts | 1 | 2 | 3 | 4 | 5 | …
## 3 -----------------------------------------------------------------------------…
## 4 1 | GARY HUA |6.0 |W 39|W 21|W 18|W 14|W 7|D 1…
## 5 ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B |W |B …
## 6 -----------------------------------------------------------------------------…
## # ℹ abbreviated name:
## # ¹`-----------------------------------------------------------------------------------------`tail(dfTournament)## # A tibble: 6 × 1
## ----------------------------------------------------------------------------…¹
## <chr>
## 1 63 | THOMAS JOSEPH HOSMER |1.0 |L 2|L 48|D 49|L 43|L 45|H …
## 2 MI | 15057092 / R: 1175 ->1125 | |W |B |W |B |B | …
## 3 -----------------------------------------------------------------------------…
## 4 64 | BEN LI |1.0 |L 22|D 30|L 31|D 49|L 46|L …
## 5 MI | 15006561 / R: 1163 ->1112 | |B |W |W |B |W |B …
## 6 -----------------------------------------------------------------------------…
## # ℹ abbreviated name:
## # ¹`-----------------------------------------------------------------------------------------`dfTournament## # A tibble: 195 × 1
## ---------------------------------------------------------------------------…¹
## <chr>
## 1 Pair | Player Name |Total|Round|Round|Round|Round|Round|…
## 2 Num | USCF ID / Rtg (Pre->Post) | Pts | 1 | 2 | 3 | 4 | 5 |…
## 3 ----------------------------------------------------------------------------…
## 4 1 | GARY HUA |6.0 |W 39|W 21|W 18|W 14|W 7|D …
## 5 ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B |W |B …
## 6 ----------------------------------------------------------------------------…
## 7 2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 17|W 16|W …
## 8 MI | 14598900 / R: 1553 ->1663 |N:2 |B |W |B |W |B |W …
## 9 ----------------------------------------------------------------------------…
## 10 3 | ADITYA BAJAJ |6.0 |L 8|W 61|W 25|W 21|W 11|W …
## # ℹ 185 more rows
## # ℹ abbreviated name:
## # ¹`-----------------------------------------------------------------------------------------`dfTournament## # A tibble: 195 × 1
## ---------------------------------------------------------------------------…¹
## <chr>
## 1 Pair | Player Name |Total|Round|Round|Round|Round|Round|…
## 2 Num | USCF ID / Rtg (Pre->Post) | Pts | 1 | 2 | 3 | 4 | 5 |…
## 3 ----------------------------------------------------------------------------…
## 4 1 | GARY HUA |6.0 |W 39|W 21|W 18|W 14|W 7|D …
## 5 ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B |W |B …
## 6 ----------------------------------------------------------------------------…
## 7 2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 17|W 16|W …
## 8 MI | 14598900 / R: 1553 ->1663 |N:2 |B |W |B |W |B |W …
## 9 ----------------------------------------------------------------------------…
## 10 3 | ADITYA BAJAJ |6.0 |L 8|W 61|W 25|W 21|W 11|W …
## # ℹ 185 more rows
## # ℹ abbreviated name:
## # ¹`-----------------------------------------------------------------------------------------`x3 = unname(str_locate_all(pattern = '\\|', dfTournament[1]))## Warning in stri_locate_all_regex(string, pattern, omit_no_match = TRUE, :
## argument is not an atomic vector; coercingx3## [[1]]
## start end
## [1,] 9 9
## [2,] 43 43
## [3,] 49 49
## [4,] 55 55
## [5,] 61 61
## [6,] 67 67
## [7,] 73 73
## [8,] 79 79
## [9,] 85 85
## [10,] 91 91
## [11,] 101 101
## [12,] 135 135
## [13,] 141 141
## [14,] 147 147
## [15,] 153 153
## [16,] 159 159
## [17,] 165 165
## [18,] 171 171
## [19,] 177 177
## [20,] 183 183
## [21,] 283 283
## [22,] 317 317
## [23,] 323 323
## [24,] 329 329
## [25,] 335 335
## [26,] 341 341
## [27,] 347 347
## [28,] 353 353
## [29,] 359 359
## [30,] 365 365
## [31,] 373 373
## [32,] 407 407
## [33,] 413 413
## [34,] 419 419
## [35,] 425 425
## [36,] 431 431
## [37,] 437 437
## [38,] 443 443
## [39,] 449 449
## [40,] 455 455
## [41,] 556 556
## [42,] 590 590
## [43,] 596 596
## [44,] 602 602
## [45,] 608 608
## [46,] 614 614
## [47,] 620 620
## [48,] 626 626
## [49,] 632 632
## [50,] 638 638
## [51,] 646 646
## [52,] 680 680
## [53,] 686 686
## [54,] 692 692
## [55,] 698 698
## [56,] 704 704
## [57,] 710 710
## [58,] 716 716
## [59,] 722 722
## [60,] 728 728
## [61,] 828 828
## [62,] 862 862
## [63,] 868 868
## [64,] 874 874
## [65,] 880 880
## [66,] 886 886
## [67,] 892 892
## [68,] 898 898
## [69,] 904 904
## [70,] 910 910
## [71,] 918 918
## [72,] 952 952
## [73,] 958 958
## [74,] 964 964
## [75,] 970 970
## [76,] 976 976
## [77,] 982 982
## [78,] 988 988
## [79,] 994 994
## [80,] 1000 1000
## [81,] 1101 1101
## [82,] 1135 1135
## [83,] 1141 1141
## [84,] 1147 1147
## [85,] 1153 1153
## [86,] 1159 1159
## [87,] 1165 1165
## [88,] 1171 1171
## [89,] 1177 1177
## [90,] 1183 1183
## [91,] 1191 1191
## [92,] 1225 1225
## [93,] 1231 1231
## [94,] 1237 1237
## [95,] 1243 1243
## [96,] 1249 1249
## [97,] 1255 1255
## [98,] 1261 1261
## [99,] 1267 1267
## [100,] 1273 1273
## [101,] 1373 1373
## [102,] 1407 1407
## [103,] 1413 1413
## [104,] 1419 1419
## [105,] 1425 1425
## [106,] 1431 1431
## [107,] 1437 1437
## [108,] 1443 1443
## [109,] 1449 1449
## [110,] 1455 1455
## [111,] 1463 1463
## [112,] 1497 1497
## [113,] 1503 1503
## [114,] 1509 1509
## [115,] 1515 1515
## [116,] 1521 1521
## [117,] 1527 1527
## [118,] 1533 1533
## [119,] 1539 1539
## [120,] 1545 1545
## [121,] 1646 1646
## [122,] 1680 1680
## [123,] 1686 1686
## [124,] 1692 1692
## [125,] 1698 1698
## [126,] 1704 1704
## [127,] 1710 1710
## [128,] 1716 1716
## [129,] 1722 1722
## [130,] 1728 1728
## [131,] 1736 1736
## [132,] 1770 1770
## [133,] 1776 1776
## [134,] 1782 1782
## [135,] 1788 1788
## [136,] 1794 1794
## [137,] 1800 1800
## [138,] 1806 1806
## [139,] 1812 1812
## [140,] 1818 1818
## [141,] 1918 1918
## [142,] 1952 1952
## [143,] 1958 1958
## [144,] 1964 1964
## [145,] 1970 1970
## [146,] 1976 1976
## [147,] 1982 1982
## [148,] 1988 1988
## [149,] 1994 1994
## [150,] 2000 2000
## [151,] 2008 2008
## [152,] 2042 2042
## [153,] 2048 2048
## [154,] 2054 2054
## [155,] 2060 2060
## [156,] 2066 2066
## [157,] 2072 2072
## [158,] 2078 2078
## [159,] 2084 2084
## [160,] 2090 2090
## [161,] 2191 2191
## [162,] 2225 2225
## [163,] 2231 2231
## [164,] 2237 2237
## [165,] 2243 2243
## [166,] 2249 2249
## [167,] 2255 2255
## [168,] 2261 2261
## [169,] 2267 2267
## [170,] 2273 2273
## [171,] 2281 2281
## [172,] 2315 2315
## [173,] 2321 2321
## [174,] 2327 2327
## [175,] 2333 2333
## [176,] 2339 2339
## [177,] 2345 2345
## [178,] 2351 2351
## [179,] 2357 2357
## [180,] 2363 2363
## [181,] 2463 2463
## [182,] 2497 2497
## [183,] 2503 2503
## [184,] 2509 2509
## [185,] 2515 2515
## [186,] 2521 2521
## [187,] 2527 2527
## [188,] 2533 2533
## [189,] 2539 2539
## [190,] 2545 2545
## [191,] 2553 2553
## [192,] 2587 2587
## [193,] 2593 2593
## [194,] 2599 2599
## [195,] 2605 2605
## [196,] 2611 2611
## [197,] 2617 2617
## [198,] 2623 2623
## [199,] 2629 2629
## [200,] 2635 2635
## [201,] 2737 2737
## [202,] 2771 2771
## [203,] 2777 2777
## [204,] 2783 2783
## [205,] 2789 2789
## [206,] 2795 2795
## [207,] 2801 2801
## [208,] 2807 2807
## [209,] 2813 2813
## [210,] 2819 2819
## [211,] 2827 2827
## [212,] 2861 2861
## [213,] 2867 2867
## [214,] 2873 2873
## [215,] 2879 2879
## [216,] 2885 2885
## [217,] 2891 2891
## [218,] 2897 2897
## [219,] 2903 2903
## [220,] 2909 2909
## [221,] 3010 3010
## [222,] 3044 3044
## [223,] 3050 3050
## [224,] 3056 3056
## [225,] 3062 3062
## [226,] 3068 3068
## [227,] 3074 3074
## [228,] 3080 3080
## [229,] 3086 3086
## [230,] 3092 3092
## [231,] 3100 3100
## [232,] 3134 3134
## [233,] 3140 3140
## [234,] 3146 3146
## [235,] 3152 3152
## [236,] 3158 3158
## [237,] 3164 3164
## [238,] 3170 3170
## [239,] 3176 3176
## [240,] 3182 3182
## [241,] 3284 3284
## [242,] 3318 3318
## [243,] 3324 3324
## [244,] 3330 3330
## [245,] 3336 3336
## [246,] 3342 3342
## [247,] 3348 3348
## [248,] 3354 3354
## [249,] 3360 3360
## [250,] 3366 3366
## [251,] 3374 3374
## [252,] 3408 3408
## [253,] 3414 3414
## [254,] 3420 3420
## [255,] 3426 3426
## [256,] 3432 3432
## [257,] 3438 3438
## [258,] 3444 3444
## [259,] 3450 3450
## [260,] 3456 3456
## [261,] 3557 3557
## [262,] 3591 3591
## [263,] 3597 3597
## [264,] 3603 3603
## [265,] 3609 3609
## [266,] 3615 3615
## [267,] 3621 3621
## [268,] 3627 3627
## [269,] 3633 3633
## [270,] 3639 3639
## [271,] 3647 3647
## [272,] 3681 3681
## [273,] 3687 3687
## [274,] 3693 3693
## [275,] 3699 3699
## [276,] 3705 3705
## [277,] 3711 3711
## [278,] 3717 3717
## [279,] 3723 3723
## [280,] 3729 3729
## [281,] 3831 3831
## [282,] 3865 3865
## [283,] 3871 3871
## [284,] 3877 3877
## [285,] 3883 3883
## [286,] 3889 3889
## [287,] 3895 3895
## [288,] 3901 3901
## [289,] 3907 3907
## [290,] 3913 3913
## [291,] 3921 3921
## [292,] 3955 3955
## [293,] 3961 3961
## [294,] 3967 3967
## [295,] 3973 3973
## [296,] 3979 3979
## [297,] 3985 3985
## [298,] 3991 3991
## [299,] 3997 3997
## [300,] 4003 4003
## [301,] 4104 4104
## [302,] 4138 4138
## [303,] 4144 4144
## [304,] 4150 4150
## [305,] 4156 4156
## [306,] 4162 4162
## [307,] 4168 4168
## [308,] 4174 4174
## [309,] 4180 4180
## [310,] 4186 4186
## [311,] 4194 4194
## [312,] 4228 4228
## [313,] 4234 4234
## [314,] 4240 4240
## [315,] 4246 4246
## [316,] 4252 4252
## [317,] 4258 4258
## [318,] 4264 4264
## [319,] 4270 4270
## [320,] 4276 4276
## [321,] 4378 4378
## [322,] 4412 4412
## [323,] 4418 4418
## [324,] 4424 4424
## [325,] 4430 4430
## [326,] 4436 4436
## [327,] 4442 4442
## [328,] 4448 4448
## [329,] 4454 4454
## [330,] 4460 4460
## [331,] 4468 4468
## [332,] 4502 4502
## [333,] 4508 4508
## [334,] 4514 4514
## [335,] 4520 4520
## [336,] 4526 4526
## [337,] 4532 4532
## [338,] 4538 4538
## [339,] 4544 4544
## [340,] 4550 4550
## [341,] 4651 4651
## [342,] 4685 4685
## [343,] 4691 4691
## [344,] 4697 4697
## [345,] 4703 4703
## [346,] 4709 4709
## [347,] 4715 4715
## [348,] 4721 4721
## [349,] 4727 4727
## [350,] 4733 4733
## [351,] 4741 4741
## [352,] 4775 4775
## [353,] 4781 4781
## [354,] 4787 4787
## [355,] 4793 4793
## [356,] 4799 4799
## [357,] 4805 4805
## [358,] 4811 4811
## [359,] 4817 4817
## [360,] 4823 4823
## [361,] 4925 4925
## [362,] 4959 4959
## [363,] 4965 4965
## [364,] 4971 4971
## [365,] 4977 4977
## [366,] 4983 4983
## [367,] 4989 4989
## [368,] 4995 4995
## [369,] 5001 5001
## [370,] 5007 5007
## [371,] 5015 5015
## [372,] 5049 5049
## [373,] 5055 5055
## [374,] 5061 5061
## [375,] 5067 5067
## [376,] 5073 5073
## [377,] 5079 5079
## [378,] 5085 5085
## [379,] 5091 5091
## [380,] 5097 5097
## [381,] 5198 5198
## [382,] 5232 5232
## [383,] 5238 5238
## [384,] 5244 5244
## [385,] 5250 5250
## [386,] 5256 5256
## [387,] 5262 5262
## [388,] 5268 5268
## [389,] 5274 5274
## [390,] 5280 5280
## [391,] 5288 5288
## [392,] 5322 5322
## [393,] 5328 5328
## [394,] 5334 5334
## [395,] 5340 5340
## [396,] 5346 5346
## [397,] 5352 5352
## [398,] 5358 5358
## [399,] 5364 5364
## [400,] 5370 5370
## [401,] 5472 5472
## [402,] 5506 5506
## [403,] 5512 5512
## [404,] 5518 5518
## [405,] 5524 5524
## [406,] 5530 5530
## [407,] 5536 5536
## [408,] 5542 5542
## [409,] 5548 5548
## [410,] 5554 5554
## [411,] 5562 5562
## [412,] 5596 5596
## [413,] 5602 5602
## [414,] 5608 5608
## [415,] 5614 5614
## [416,] 5620 5620
## [417,] 5626 5626
## [418,] 5632 5632
## [419,] 5638 5638
## [420,] 5644 5644
## [421,] 5745 5745
## [422,] 5779 5779
## [423,] 5785 5785
## [424,] 5791 5791
## [425,] 5797 5797
## [426,] 5803 5803
## [427,] 5809 5809
## [428,] 5815 5815
## [429,] 5821 5821
## [430,] 5827 5827
## [431,] 5835 5835
## [432,] 5869 5869
## [433,] 5875 5875
## [434,] 5881 5881
## [435,] 5887 5887
## [436,] 5893 5893
## [437,] 5899 5899
## [438,] 5905 5905
## [439,] 5911 5911
## [440,] 5917 5917
## [441,] 6019 6019
## [442,] 6053 6053
## [443,] 6059 6059
## [444,] 6065 6065
## [445,] 6071 6071
## [446,] 6077 6077
## [447,] 6083 6083
## [448,] 6089 6089
## [449,] 6095 6095
## [450,] 6101 6101
## [451,] 6109 6109
## [452,] 6143 6143
## [453,] 6149 6149
## [454,] 6155 6155
## [455,] 6161 6161
## [456,] 6167 6167
## [457,] 6173 6173
## [458,] 6179 6179
## [459,] 6185 6185
## [460,] 6191 6191
## [461,] 6292 6292
## [462,] 6326 6326
## [463,] 6332 6332
## [464,] 6338 6338
## [465,] 6344 6344
## [466,] 6350 6350
## [467,] 6356 6356
## [468,] 6362 6362
## [469,] 6368 6368
## [470,] 6374 6374
## [471,] 6382 6382
## [472,] 6416 6416
## [473,] 6422 6422
## [474,] 6428 6428
## [475,] 6434 6434
## [476,] 6440 6440
## [477,] 6446 6446
## [478,] 6452 6452
## [479,] 6458 6458
## [480,] 6464 6464
## [481,] 6566 6566
## [482,] 6600 6600
## [483,] 6606 6606
## [484,] 6612 6612
## [485,] 6618 6618
## [486,] 6624 6624
## [487,] 6630 6630
## [488,] 6636 6636
## [489,] 6642 6642
## [490,] 6648 6648
## [491,] 6656 6656
## [492,] 6690 6690
## [493,] 6696 6696
## [494,] 6702 6702
## [495,] 6708 6708
## [496,] 6714 6714
## [497,] 6720 6720
## [498,] 6726 6726
## [499,] 6732 6732
## [500,] 6738 6738
## [501,] 6839 6839
## [502,] 6873 6873
## [503,] 6879 6879
## [504,] 6885 6885
## [505,] 6891 6891
## [506,] 6897 6897
## [507,] 6903 6903
## [508,] 6909 6909
## [509,] 6915 6915
## [510,] 6921 6921
## [511,] 6929 6929
## [512,] 6963 6963
## [513,] 6969 6969
## [514,] 6975 6975
## [515,] 6981 6981
## [516,] 6987 6987
## [517,] 6993 6993
## [518,] 6999 6999
## [519,] 7005 7005
## [520,] 7011 7011
## [521,] 7113 7113
## [522,] 7147 7147
## [523,] 7153 7153
## [524,] 7159 7159
## [525,] 7165 7165
## [526,] 7171 7171
## [527,] 7177 7177
## [528,] 7183 7183
## [529,] 7189 7189
## [530,] 7195 7195
## [531,] 7203 7203
## [532,] 7237 7237
## [533,] 7243 7243
## [534,] 7249 7249
## [535,] 7255 7255
## [536,] 7261 7261
## [537,] 7267 7267
## [538,] 7273 7273
## [539,] 7279 7279
## [540,] 7285 7285
## [541,] 7386 7386
## [542,] 7420 7420
## [543,] 7426 7426
## [544,] 7432 7432
## [545,] 7438 7438
## [546,] 7444 7444
## [547,] 7450 7450
## [548,] 7456 7456
## [549,] 7462 7462
## [550,] 7468 7468
## [551,] 7476 7476
## [552,] 7510 7510
## [553,] 7516 7516
## [554,] 7522 7522
## [555,] 7528 7528
## [556,] 7534 7534
## [557,] 7540 7540
## [558,] 7546 7546
## [559,] 7552 7552
## [560,] 7558 7558
## [561,] 7660 7660
## [562,] 7694 7694
## [563,] 7700 7700
## [564,] 7706 7706
## [565,] 7712 7712
## [566,] 7718 7718
## [567,] 7724 7724
## [568,] 7730 7730
## [569,] 7736 7736
## [570,] 7742 7742
## [571,] 7750 7750
## [572,] 7784 7784
## [573,] 7790 7790
## [574,] 7796 7796
## [575,] 7802 7802
## [576,] 7808 7808
## [577,] 7814 7814
## [578,] 7820 7820
## [579,] 7826 7826
## [580,] 7832 7832
## [581,] 7933 7933
## [582,] 7967 7967
## [583,] 7973 7973
## [584,] 7979 7979
## [585,] 7985 7985
## [586,] 7991 7991
## [587,] 7997 7997
## [588,] 8003 8003
## [589,] 8009 8009
## [590,] 8015 8015
## [591,] 8023 8023
## [592,] 8057 8057
## [593,] 8063 8063
## [594,] 8069 8069
## [595,] 8075 8075
## [596,] 8081 8081
## [597,] 8087 8087
## [598,] 8093 8093
## [599,] 8099 8099
## [600,] 8105 8105
## [601,] 8207 8207
## [602,] 8241 8241
## [603,] 8247 8247
## [604,] 8253 8253
## [605,] 8259 8259
## [606,] 8265 8265
## [607,] 8271 8271
## [608,] 8277 8277
## [609,] 8283 8283
## [610,] 8289 8289
## [611,] 8297 8297
## [612,] 8331 8331
## [613,] 8337 8337
## [614,] 8343 8343
## [615,] 8349 8349
## [616,] 8355 8355
## [617,] 8361 8361
## [618,] 8367 8367
## [619,] 8373 8373
## [620,] 8379 8379
## [621,] 8480 8480
## [622,] 8514 8514
## [623,] 8520 8520
## [624,] 8526 8526
## [625,] 8532 8532
## [626,] 8538 8538
## [627,] 8544 8544
## [628,] 8550 8550
## [629,] 8556 8556
## [630,] 8562 8562
## [631,] 8570 8570
## [632,] 8604 8604
## [633,] 8610 8610
## [634,] 8616 8616
## [635,] 8622 8622
## [636,] 8628 8628
## [637,] 8634 8634
## [638,] 8640 8640
## [639,] 8646 8646
## [640,] 8652 8652
## [641,] 8754 8754
## [642,] 8788 8788
## [643,] 8794 8794
## [644,] 8800 8800
## [645,] 8806 8806
## [646,] 8812 8812
## [647,] 8818 8818
## [648,] 8824 8824
## [649,] 8830 8830
## [650,] 8836 8836
## [651,] 8844 8844
## [652,] 8878 8878
## [653,] 8884 8884
## [654,] 8890 8890
## [655,] 8896 8896
## [656,] 8902 8902
## [657,] 8908 8908
## [658,] 8914 8914
## [659,] 8920 8920
## [660,] 8926 8926
## [661,] 9027 9027
## [662,] 9061 9061
## [663,] 9067 9067
## [664,] 9073 9073
## [665,] 9079 9079
## [666,] 9085 9085
## [667,] 9091 9091
## [668,] 9097 9097
## [669,] 9103 9103
## [670,] 9109 9109
## [671,] 9117 9117
## [672,] 9151 9151
## [673,] 9157 9157
## [674,] 9163 9163
## [675,] 9169 9169
## [676,] 9175 9175
## [677,] 9181 9181
## [678,] 9187 9187
## [679,] 9193 9193
## [680,] 9199 9199
## [681,] 9301 9301
## [682,] 9335 9335
## [683,] 9341 9341
## [684,] 9347 9347
## [685,] 9353 9353
## [686,] 9359 9359
## [687,] 9365 9365
## [688,] 9371 9371
## [689,] 9377 9377
## [690,] 9383 9383
## [691,] 9391 9391
## [692,] 9425 9425
## [693,] 9431 9431
## [694,] 9437 9437
## [695,] 9443 9443
## [696,] 9449 9449
## [697,] 9455 9455
## [698,] 9461 9461
## [699,] 9467 9467
## [700,] 9473 9473
## [701,] 9574 9574
## [702,] 9608 9608
## [703,] 9614 9614
## [704,] 9620 9620
## [705,] 9626 9626
## [706,] 9632 9632
## [707,] 9638 9638
## [708,] 9644 9644
## [709,] 9650 9650
## [710,] 9656 9656
## [711,] 9664 9664
## [712,] 9698 9698
## [713,] 9704 9704
## [714,] 9710 9710
## [715,] 9716 9716
## [716,] 9722 9722
## [717,] 9728 9728
## [718,] 9734 9734
## [719,] 9740 9740
## [720,] 9746 9746
## [721,] 9848 9848
## [722,] 9882 9882
## [723,] 9888 9888
## [724,] 9894 9894
## [725,] 9900 9900
## [726,] 9906 9906
## [727,] 9912 9912
## [728,] 9918 9918
## [729,] 9924 9924
## [730,] 9930 9930
## [731,] 9938 9938
## [732,] 9972 9972
## [733,] 9978 9978
## [734,] 9984 9984
## [735,] 9990 9990
## [736,] 9996 9996
## [737,] 10002 10002
## [738,] 10008 10008
## [739,] 10014 10014
## [740,] 10020 10020
## [741,] 10121 10121
## [742,] 10155 10155
## [743,] 10161 10161
## [744,] 10167 10167
## [745,] 10173 10173
## [746,] 10179 10179
## [747,] 10185 10185
## [748,] 10191 10191
## [749,] 10197 10197
## [750,] 10203 10203
## [751,] 10211 10211
## [752,] 10245 10245
## [753,] 10251 10251
## [754,] 10257 10257
## [755,] 10263 10263
## [756,] 10269 10269
## [757,] 10275 10275
## [758,] 10281 10281
## [759,] 10287 10287
## [760,] 10293 10293
## [761,] 10395 10395
## [762,] 10429 10429
## [763,] 10435 10435
## [764,] 10441 10441
## [765,] 10447 10447
## [766,] 10453 10453
## [767,] 10459 10459
## [768,] 10465 10465
## [769,] 10471 10471
## [770,] 10477 10477
## [771,] 10485 10485
## [772,] 10519 10519
## [773,] 10525 10525
## [774,] 10531 10531
## [775,] 10537 10537
## [776,] 10543 10543
## [777,] 10549 10549
## [778,] 10555 10555
## [779,] 10561 10561
## [780,] 10567 10567
## [781,] 10668 10668
## [782,] 10702 10702
## [783,] 10708 10708
## [784,] 10714 10714
## [785,] 10720 10720
## [786,] 10726 10726
## [787,] 10732 10732
## [788,] 10738 10738
## [789,] 10744 10744
## [790,] 10750 10750
## [791,] 10758 10758
## [792,] 10792 10792
## [793,] 10798 10798
## [794,] 10804 10804
## [795,] 10810 10810
## [796,] 10816 10816
## [797,] 10822 10822
## [798,] 10828 10828
## [799,] 10834 10834
## [800,] 10840 10840
## [801,] 10942 10942
## [802,] 10976 10976
## [803,] 10982 10982
## [804,] 10988 10988
## [805,] 10994 10994
## [806,] 11000 11000
## [807,] 11006 11006
## [808,] 11012 11012
## [809,] 11018 11018
## [810,] 11024 11024
## [811,] 11032 11032
## [812,] 11066 11066
## [813,] 11072 11072
## [814,] 11078 11078
## [815,] 11084 11084
## [816,] 11090 11090
## [817,] 11096 11096
## [818,] 11102 11102
## [819,] 11108 11108
## [820,] 11114 11114
## [821,] 11215 11215
## [822,] 11249 11249
## [823,] 11255 11255
## [824,] 11261 11261
## [825,] 11267 11267
## [826,] 11273 11273
## [827,] 11279 11279
## [828,] 11285 11285
## [829,] 11291 11291
## [830,] 11297 11297
## [831,] 11305 11305
## [832,] 11339 11339
## [833,] 11345 11345
## [834,] 11351 11351
## [835,] 11357 11357
## [836,] 11363 11363
## [837,] 11369 11369
## [838,] 11375 11375
## [839,] 11381 11381
## [840,] 11387 11387
## [841,] 11489 11489
## [842,] 11523 11523
## [843,] 11529 11529
## [844,] 11535 11535
## [845,] 11541 11541
## [846,] 11547 11547
## [847,] 11553 11553
## [848,] 11559 11559
## [849,] 11565 11565
## [850,] 11571 11571
## [851,] 11579 11579
## [852,] 11613 11613
## [853,] 11619 11619
## [854,] 11625 11625
## [855,] 11631 11631
## [856,] 11637 11637
## [857,] 11643 11643
## [858,] 11649 11649
## [859,] 11655 11655
## [860,] 11661 11661
## [861,] 11762 11762
## [862,] 11796 11796
## [863,] 11802 11802
## [864,] 11808 11808
## [865,] 11814 11814
## [866,] 11820 11820
## [867,] 11826 11826
## [868,] 11832 11832
## [869,] 11838 11838
## [870,] 11844 11844
## [871,] 11852 11852
## [872,] 11886 11886
## [873,] 11892 11892
## [874,] 11898 11898
## [875,] 11904 11904
## [876,] 11910 11910
## [877,] 11916 11916
## [878,] 11922 11922
## [879,] 11928 11928
## [880,] 11934 11934
## [881,] 12036 12036
## [882,] 12070 12070
## [883,] 12076 12076
## [884,] 12082 12082
## [885,] 12088 12088
## [886,] 12094 12094
## [887,] 12100 12100
## [888,] 12106 12106
## [889,] 12112 12112
## [890,] 12118 12118
## [891,] 12126 12126
## [892,] 12160 12160
## [893,] 12166 12166
## [894,] 12172 12172
## [895,] 12178 12178
## [896,] 12184 12184
## [897,] 12190 12190
## [898,] 12196 12196
## [899,] 12202 12202
## [900,] 12208 12208
## [901,] 12309 12309
## [902,] 12343 12343
## [903,] 12349 12349
## [904,] 12355 12355
## [905,] 12361 12361
## [906,] 12367 12367
## [907,] 12373 12373
## [908,] 12379 12379
## [909,] 12385 12385
## [910,] 12391 12391
## [911,] 12399 12399
## [912,] 12433 12433
## [913,] 12439 12439
## [914,] 12445 12445
## [915,] 12451 12451
## [916,] 12457 12457
## [917,] 12463 12463
## [918,] 12469 12469
## [919,] 12475 12475
## [920,] 12481 12481
## [921,] 12583 12583
## [922,] 12617 12617
## [923,] 12623 12623
## [924,] 12629 12629
## [925,] 12635 12635
## [926,] 12641 12641
## [927,] 12647 12647
## [928,] 12653 12653
## [929,] 12659 12659
## [930,] 12665 12665
## [931,] 12673 12673
## [932,] 12707 12707
## [933,] 12713 12713
## [934,] 12719 12719
## [935,] 12725 12725
## [936,] 12731 12731
## [937,] 12737 12737
## [938,] 12743 12743
## [939,] 12749 12749
## [940,] 12755 12755
## [941,] 12856 12856
## [942,] 12890 12890
## [943,] 12896 12896
## [944,] 12902 12902
## [945,] 12908 12908
## [946,] 12914 12914
## [947,] 12920 12920
## [948,] 12926 12926
## [949,] 12932 12932
## [950,] 12938 12938
## [951,] 12946 12946
## [952,] 12980 12980
## [953,] 12986 12986
## [954,] 12992 12992
## [955,] 12998 12998
## [956,] 13004 13004
## [957,] 13010 13010
## [958,] 13016 13016
## [959,] 13022 13022
## [960,] 13028 13028
## [961,] 13130 13130
## [962,] 13164 13164
## [963,] 13170 13170
## [964,] 13176 13176
## [965,] 13182 13182
## [966,] 13188 13188
## [967,] 13194 13194
## [968,] 13200 13200
## [969,] 13206 13206
## [970,] 13212 13212
## [971,] 13220 13220
## [972,] 13254 13254
## [973,] 13260 13260
## [974,] 13266 13266
## [975,] 13272 13272
## [976,] 13278 13278
## [977,] 13284 13284
## [978,] 13290 13290
## [979,] 13296 13296
## [980,] 13302 13302
## [981,] 13403 13403
## [982,] 13437 13437
## [983,] 13443 13443
## [984,] 13449 13449
## [985,] 13455 13455
## [986,] 13461 13461
## [987,] 13467 13467
## [988,] 13473 13473
## [989,] 13479 13479
## [990,] 13485 13485
## [991,] 13493 13493
## [992,] 13527 13527
## [993,] 13533 13533
## [994,] 13539 13539
## [995,] 13545 13545
## [996,] 13551 13551
## [997,] 13557 13557
## [998,] 13563 13563
## [999,] 13569 13569
## [1000,] 13575 13575
## [1001,] 13677 13677
## [1002,] 13711 13711
## [1003,] 13717 13717
## [1004,] 13723 13723
## [1005,] 13729 13729
## [1006,] 13735 13735
## [1007,] 13741 13741
## [1008,] 13747 13747
## [1009,] 13753 13753
## [1010,] 13759 13759
## [1011,] 13767 13767
## [1012,] 13801 13801
## [1013,] 13807 13807
## [1014,] 13813 13813
## [1015,] 13819 13819
## [1016,] 13825 13825
## [1017,] 13831 13831
## [1018,] 13837 13837
## [1019,] 13843 13843
## [1020,] 13849 13849
## [1021,] 13950 13950
## [1022,] 13984 13984
## [1023,] 13990 13990
## [1024,] 13996 13996
## [1025,] 14002 14002
## [1026,] 14008 14008
## [1027,] 14014 14014
## [1028,] 14020 14020
## [1029,] 14026 14026
## [1030,] 14032 14032
## [1031,] 14040 14040
## [1032,] 14074 14074
## [1033,] 14080 14080
## [1034,] 14086 14086
## [1035,] 14092 14092
## [1036,] 14098 14098
## [1037,] 14104 14104
## [1038,] 14110 14110
## [1039,] 14116 14116
## [1040,] 14122 14122
## [1041,] 14224 14224
## [1042,] 14258 14258
## [1043,] 14264 14264
## [1044,] 14270 14270
## [1045,] 14276 14276
## [1046,] 14282 14282
## [1047,] 14288 14288
## [1048,] 14294 14294
## [1049,] 14300 14300
## [1050,] 14306 14306
## [1051,] 14314 14314
## [1052,] 14348 14348
## [1053,] 14354 14354
## [1054,] 14360 14360
## [1055,] 14366 14366
## [1056,] 14372 14372
## [1057,] 14378 14378
## [1058,] 14384 14384
## [1059,] 14390 14390
## [1060,] 14396 14396
## [1061,] 14497 14497
## [1062,] 14531 14531
## [1063,] 14537 14537
## [1064,] 14543 14543
## [1065,] 14549 14549
## [1066,] 14555 14555
## [1067,] 14561 14561
## [1068,] 14567 14567
## [1069,] 14573 14573
## [1070,] 14579 14579
## [1071,] 14587 14587
## [1072,] 14621 14621
## [1073,] 14627 14627
## [1074,] 14633 14633
## [1075,] 14639 14639
## [1076,] 14645 14645
## [1077,] 14651 14651
## [1078,] 14657 14657
## [1079,] 14663 14663
## [1080,] 14669 14669
## [1081,] 14771 14771
## [1082,] 14805 14805
## [1083,] 14811 14811
## [1084,] 14817 14817
## [1085,] 14823 14823
## [1086,] 14829 14829
## [1087,] 14835 14835
## [1088,] 14841 14841
## [1089,] 14847 14847
## [1090,] 14853 14853
## [1091,] 14861 14861
## [1092,] 14895 14895
## [1093,] 14901 14901
## [1094,] 14907 14907
## [1095,] 14913 14913
## [1096,] 14919 14919
## [1097,] 14925 14925
## [1098,] 14931 14931
## [1099,] 14937 14937
## [1100,] 14943 14943
## [1101,] 15044 15044
## [1102,] 15078 15078
## [1103,] 15084 15084
## [1104,] 15090 15090
## [1105,] 15096 15096
## [1106,] 15102 15102
## [1107,] 15108 15108
## [1108,] 15114 15114
## [1109,] 15120 15120
## [1110,] 15126 15126
## [1111,] 15134 15134
## [1112,] 15168 15168
## [1113,] 15174 15174
## [1114,] 15180 15180
## [1115,] 15186 15186
## [1116,] 15192 15192
## [1117,] 15198 15198
## [1118,] 15204 15204
## [1119,] 15210 15210
## [1120,] 15216 15216
## [1121,] 15318 15318
## [1122,] 15352 15352
## [1123,] 15358 15358
## [1124,] 15364 15364
## [1125,] 15370 15370
## [1126,] 15376 15376
## [1127,] 15382 15382
## [1128,] 15388 15388
## [1129,] 15394 15394
## [1130,] 15400 15400
## [1131,] 15408 15408
## [1132,] 15442 15442
## [1133,] 15448 15448
## [1134,] 15454 15454
## [1135,] 15460 15460
## [1136,] 15466 15466
## [1137,] 15472 15472
## [1138,] 15478 15478
## [1139,] 15484 15484
## [1140,] 15490 15490
## [1141,] 15591 15591
## [1142,] 15625 15625
## [1143,] 15631 15631
## [1144,] 15637 15637
## [1145,] 15643 15643
## [1146,] 15649 15649
## [1147,] 15655 15655
## [1148,] 15661 15661
## [1149,] 15667 15667
## [1150,] 15673 15673
## [1151,] 15681 15681
## [1152,] 15715 15715
## [1153,] 15721 15721
## [1154,] 15727 15727
## [1155,] 15733 15733
## [1156,] 15739 15739
## [1157,] 15745 15745
## [1158,] 15751 15751
## [1159,] 15757 15757
## [1160,] 15763 15763
## [1161,] 15865 15865
## [1162,] 15899 15899
## [1163,] 15905 15905
## [1164,] 15911 15911
## [1165,] 15917 15917
## [1166,] 15923 15923
## [1167,] 15929 15929
## [1168,] 15935 15935
## [1169,] 15941 15941
## [1170,] 15947 15947
## [1171,] 15955 15955
## [1172,] 15989 15989
## [1173,] 15995 15995
## [1174,] 16001 16001
## [1175,] 16007 16007
## [1176,] 16013 16013
## [1177,] 16019 16019
## [1178,] 16025 16025
## [1179,] 16031 16031
## [1180,] 16037 16037
## [1181,] 16138 16138
## [1182,] 16172 16172
## [1183,] 16178 16178
## [1184,] 16184 16184
## [1185,] 16190 16190
## [1186,] 16196 16196
## [1187,] 16202 16202
## [1188,] 16208 16208
## [1189,] 16214 16214
## [1190,] 16220 16220
## [1191,] 16228 16228
## [1192,] 16262 16262
## [1193,] 16268 16268
## [1194,] 16274 16274
## [1195,] 16280 16280
## [1196,] 16286 16286
## [1197,] 16292 16292
## [1198,] 16298 16298
## [1199,] 16304 16304
## [1200,] 16310 16310
## [1201,] 16412 16412
## [1202,] 16446 16446
## [1203,] 16452 16452
## [1204,] 16458 16458
## [1205,] 16464 16464
## [1206,] 16470 16470
## [1207,] 16476 16476
## [1208,] 16482 16482
## [1209,] 16488 16488
## [1210,] 16494 16494
## [1211,] 16502 16502
## [1212,] 16536 16536
## [1213,] 16542 16542
## [1214,] 16548 16548
## [1215,] 16554 16554
## [1216,] 16560 16560
## [1217,] 16566 16566
## [1218,] 16572 16572
## [1219,] 16578 16578
## [1220,] 16584 16584
## [1221,] 16685 16685
## [1222,] 16719 16719
## [1223,] 16725 16725
## [1224,] 16731 16731
## [1225,] 16737 16737
## [1226,] 16743 16743
## [1227,] 16749 16749
## [1228,] 16755 16755
## [1229,] 16761 16761
## [1230,] 16767 16767
## [1231,] 16775 16775
## [1232,] 16809 16809
## [1233,] 16815 16815
## [1234,] 16821 16821
## [1235,] 16827 16827
## [1236,] 16833 16833
## [1237,] 16839 16839
## [1238,] 16845 16845
## [1239,] 16851 16851
## [1240,] 16857 16857
## [1241,] 16959 16959
## [1242,] 16993 16993
## [1243,] 16999 16999
## [1244,] 17005 17005
## [1245,] 17011 17011
## [1246,] 17017 17017
## [1247,] 17023 17023
## [1248,] 17029 17029
## [1249,] 17035 17035
## [1250,] 17041 17041
## [1251,] 17049 17049
## [1252,] 17083 17083
## [1253,] 17089 17089
## [1254,] 17095 17095
## [1255,] 17101 17101
## [1256,] 17107 17107
## [1257,] 17113 17113
## [1258,] 17119 17119
## [1259,] 17125 17125
## [1260,] 17131 17131
## [1261,] 17232 17232
## [1262,] 17266 17266
## [1263,] 17272 17272
## [1264,] 17278 17278
## [1265,] 17284 17284
## [1266,] 17290 17290
## [1267,] 17296 17296
## [1268,] 17302 17302
## [1269,] 17308 17308
## [1270,] 17314 17314
## [1271,] 17322 17322
## [1272,] 17356 17356
## [1273,] 17362 17362
## [1274,] 17368 17368
## [1275,] 17374 17374
## [1276,] 17380 17380
## [1277,] 17386 17386
## [1278,] 17392 17392
## [1279,] 17398 17398
## [1280,] 17404 17404
## [1281,] 17506 17506
## [1282,] 17540 17540
## [1283,] 17546 17546
## [1284,] 17552 17552
## [1285,] 17558 17558
## [1286,] 17564 17564
## [1287,] 17570 17570
## [1288,] 17576 17576
## [1289,] 17582 17582
## [1290,] 17588 17588
## [1291,] 17596 17596
## [1292,] 17630 17630
## [1293,] 17636 17636
## [1294,] 17642 17642
## [1295,] 17648 17648
## [1296,] 17654 17654
## [1297,] 17660 17660
## [1298,] 17666 17666
## [1299,] 17672 17672
## [1300,] 17678 17678list_Tournament = matrix(unlist(dfTournament), byrow=TRUE)
matrix2 = list_Tournament[seq(5,length(list_Tournament),3)]
head(matrix2)## [1] "ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B |W |B |W |"
## [2] "MI | 14598900 / R: 1553 ->1663 |N:2 |B |W |B |W |B |W |B |"
## [3] "MI | 14959604 / R: 1384 ->1640 |N:2 |W |B |W |B |W |B |W |"
## [4] "MI | 12616049 / R: 1716 ->1744 |N:2 |W |B |W |B |W |B |B |"
## [5] "MI | 14601533 / R: 1655 ->1690 |N:2 |B |W |B |W |B |W |B |"
## [6] "OH | 15055204 / R: 1686 ->1687 |N:3 |W |B |W |B |B |W |B |"matrix2## [1] "ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B |W |B |W |"
## [2] "MI | 14598900 / R: 1553 ->1663 |N:2 |B |W |B |W |B |W |B |"
## [3] "MI | 14959604 / R: 1384 ->1640 |N:2 |W |B |W |B |W |B |W |"
## [4] "MI | 12616049 / R: 1716 ->1744 |N:2 |W |B |W |B |W |B |B |"
## [5] "MI | 14601533 / R: 1655 ->1690 |N:2 |B |W |B |W |B |W |B |"
## [6] "OH | 15055204 / R: 1686 ->1687 |N:3 |W |B |W |B |B |W |B |"
## [7] "MI | 11146376 / R: 1649 ->1673 |N:3 |W |B |W |B |B |W |W |"
## [8] "MI | 15142253 / R: 1641P17->1657P24 |N:3 |B |W |B |W |B |W |W |"
## [9] "ON | 14954524 / R: 1411 ->1564 |N:2 |W |B |W |B |W |B |B |"
## [10] "MI | 14150362 / R: 1365 ->1544 |N:3 |W |W |B |B |W |B |W |"
## [11] "MI | 12581589 / R: 1712 ->1696 |N:3 |B |W |B |W |B |W |B |"
## [12] "MI | 12681257 / R: 1663 ->1670 |N:3 |W |B |W |B | |W |B |"
## [13] "MI | 15082995 / R: 1666 ->1662 |N:3 |B |W |B |B |W |W |B |"
## [14] "MI | 10131499 / R: 1610 ->1618 |N:3 |W |B |W |W |B |B |W |"
## [15] "MI | 15619130 / R: 1220P13->1416P20 |N:3 |B |B |W |W |B |B |W |"
## [16] "MI | 10295068 / R: 1604 ->1613 |N:3 |B |W | |B |W |B | |"
## [17] "MI | 10297702 / R: 1629 ->1610 |N:3 |W |B |W |B |W |B |W |"
## [18] "MI | 11342094 / R: 1600 ->1600 |N:3 |B |W |B |W |B |W |B |"
## [19] "MI | 14862333 / R: 1564 ->1570 |N:3 |W |B |W |B |W |W |B |"
## [20] "MI | 14529060 / R: 1595 ->1569 |N:4 |W |B |W |B |W |B |W |"
## [21] "ON | 15495066 / R: 1563P22->1562 |N:3 |B |W |B |W |W |B |W |"
## [22] "MI | 12405534 / R: 1555 ->1529 |N:4 |W |B |W |B | |W |B |"
## [23] "ON | 15030142 / R: 1363 ->1371 | |B |W |B |W |B |W |B |"
## [24] "MI | 13469010 / R: 1229 ->1300 |N:4 |B |W |B |B |W |W |B |"
## [25] "MI | 12486656 / R: 1745 ->1681 |N:4 |B |W |B |W |B |W |B |"
## [26] "ON | 15131520 / R: 1579 ->1564 |N:4 |B |W |B |W |B |W |W |"
## [27] "MI | 14476567 / R: 1552 ->1539 |N:4 |W |B |W |B |W |B | |"
## [28] "MI | 14882954 / R: 1507 ->1513 |N:3 |W |W |B |W |B |B |W |"
## [29] "MI | 15323285 / R: 1602P6 ->1508P12 |N:4 |B |W |B |W |W |B | |"
## [30] "ON | 12577178 / R: 1522 ->1444 | |W |B |B |W |W |B |B |"
## [31] "MI | 15131618 / R: 1494 ->1444 | |B |W |B |W |B |W |B |"
## [32] "ON | 14073750 / R: 1441 ->1433 |N:4 |W |B |W |B |W |B |W |"
## [33] "MI | 14691842 / R: 1449 ->1421 | |B |W |B |W |B |W |B |"
## [34] "MI | 15051807 / R: 1399 ->1400 | |B |W |B |B |W |B |W |"
## [35] "MI | 14601397 / R: 1438 ->1392 | |W |W |B |W |B |B |W |"
## [36] "MI | 14773163 / R: 1355 ->1367 |N:4 |W |B |W |B | |W |B |"
## [37] "MI | 15489571 / R: 980P12->1077P17 | | |B |W |W | |B |W |"
## [38] "MI | 15108523 / R: 1423 ->1439 |N:4 |W |B |W |W | |B |B |"
## [39] "MI | 12923035 / R: 1436P23->1413 |N:4 |B |W |B |W |B |W |W |"
## [40] "MI | 14892710 / R: 1348 ->1346 | |B |B |W |W |B |W |W |"
## [41] "MI | 15761443 / R: 1403P5 ->1341P9 | |B |W |B |W | | | |"
## [42] "MI | 14462326 / R: 1332 ->1256 | |B |W |B |B |W |W |B |"
## [43] "MI | 14101068 / R: 1283 ->1244 | |W |B |W |W |B |B |W |"
## [44] "MI | 15323504 / R: 1199 ->1199 | | |W |B |B |W |B |W |"
## [45] "MI | 15372807 / R: 1242 ->1191 | |W |B |W |B |W |B |W |"
## [46] "MI | 15490981 / R: 377P3 ->1076P10 | |B |W |B |W |B |W |W |"
## [47] "MI | 12533115 / R: 1362 ->1341 | |W |B |W |B |W |B |W |"
## [48] "MI | 14369165 / R: 1382 ->1335 | |B |W | |B | |W |B |"
## [49] "MI | 12531685 / R: 1291P12->1259P17 | |W |W |B |W |B | | |"
## [50] "MI | 14773178 / R: 1056 ->1111 | |W |B |W |B | |B |W |"
## [51] "MI | 15205474 / R: 1011 ->1097 | |B |W |B |W |B |W |W |"
## [52] "MI | 14918803 / R: 935 ->1092 |N:4 |B |W |B |W |B |W |B |"
## [53] "MI | 12578849 / R: 1393 ->1359 | | |B | |W | |W | |"
## [54] "MI | 12836773 / R: 1270 ->1200 | |B |B |W | |W |B |W |"
## [55] "MI | 15412571 / R: 1186 ->1163 | |W |B |W |B | |W |B |"
## [56] "MI | 14679887 / R: 1153 ->1140 | | |B |W |W | |B |W |"
## [57] "MI | 15113330 / R: 1092 ->1079 | |B |W |W |B |W |B | |"
## [58] "MI | 14700365 / R: 917 -> 941 | |W |B |W |B |W | |B |"
## [59] "MI | 12841036 / R: 853 -> 878 | |W | |B |B |W |W |B |"
## [60] "MI | 14579262 / R: 967 -> 984 | |W |B |B |W |B | | |"
## [61] "ON | 15771592 / R: 955P11-> 979P18 | |B |W |B |W |B |W |B |"
## [62] "MI | 15219542 / R: 1530 ->1535 | |B | | | | | | |"
## [63] "MI | 15057092 / R: 1175 ->1125 | |W |B |W |B |B | | |"
## [64] "MI | 15006561 / R: 1163 ->1112 | |B |W |W |B |W |B |B |"matrix1 <- list_Tournament[seq(4,length(list_Tournament),3)]
head(matrix1)## [1] "1 | GARY HUA |6.0 |W 39|W 21|W 18|W 14|W 7|D 12|D 4|"
## [2] "2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 17|W 16|W 20|W 7|"
## [3] "3 | ADITYA BAJAJ |6.0 |L 8|W 61|W 25|W 21|W 11|W 13|W 12|"
## [4] "4 | PATRICK H SCHILLING |5.5 |W 23|D 28|W 2|W 26|D 5|W 19|D 1|"
## [5] "5 | HANSHI ZUO |5.5 |W 45|W 37|D 12|D 13|D 4|W 14|W 17|"
## [6] "6 | HANSEN SONG |5.0 |W 34|D 29|L 11|W 35|D 10|W 27|W 21|"matrix1## [1] "1 | GARY HUA |6.0 |W 39|W 21|W 18|W 14|W 7|D 12|D 4|"
## [2] "2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 17|W 16|W 20|W 7|"
## [3] "3 | ADITYA BAJAJ |6.0 |L 8|W 61|W 25|W 21|W 11|W 13|W 12|"
## [4] "4 | PATRICK H SCHILLING |5.5 |W 23|D 28|W 2|W 26|D 5|W 19|D 1|"
## [5] "5 | HANSHI ZUO |5.5 |W 45|W 37|D 12|D 13|D 4|W 14|W 17|"
## [6] "6 | HANSEN SONG |5.0 |W 34|D 29|L 11|W 35|D 10|W 27|W 21|"
## [7] "7 | GARY DEE SWATHELL |5.0 |W 57|W 46|W 13|W 11|L 1|W 9|L 2|"
## [8] "8 | EZEKIEL HOUGHTON |5.0 |W 3|W 32|L 14|L 9|W 47|W 28|W 19|"
## [9] "9 | STEFANO LEE |5.0 |W 25|L 18|W 59|W 8|W 26|L 7|W 20|"
## [10] "10 | ANVIT RAO |5.0 |D 16|L 19|W 55|W 31|D 6|W 25|W 18|"
## [11] "11 | CAMERON WILLIAM MC LEMAN |4.5 |D 38|W 56|W 6|L 7|L 3|W 34|W 26|"
## [12] "12 | KENNETH J TACK |4.5 |W 42|W 33|D 5|W 38|H |D 1|L 3|"
## [13] "13 | TORRANCE HENRY JR |4.5 |W 36|W 27|L 7|D 5|W 33|L 3|W 32|"
## [14] "14 | BRADLEY SHAW |4.5 |W 54|W 44|W 8|L 1|D 27|L 5|W 31|"
## [15] "15 | ZACHARY JAMES HOUGHTON |4.5 |D 19|L 16|W 30|L 22|W 54|W 33|W 38|"
## [16] "16 | MIKE NIKITIN |4.0 |D 10|W 15|H |W 39|L 2|W 36|U |"
## [17] "17 | RONALD GRZEGORCZYK |4.0 |W 48|W 41|L 26|L 2|W 23|W 22|L 5|"
## [18] "18 | DAVID SUNDEEN |4.0 |W 47|W 9|L 1|W 32|L 19|W 38|L 10|"
## [19] "19 | DIPANKAR ROY |4.0 |D 15|W 10|W 52|D 28|W 18|L 4|L 8|"
## [20] "20 | JASON ZHENG |4.0 |L 40|W 49|W 23|W 41|W 28|L 2|L 9|"
## [21] "21 | DINH DANG BUI |4.0 |W 43|L 1|W 47|L 3|W 40|W 39|L 6|"
## [22] "22 | EUGENE L MCCLURE |4.0 |W 64|D 52|L 28|W 15|H |L 17|W 40|"
## [23] "23 | ALAN BUI |4.0 |L 4|W 43|L 20|W 58|L 17|W 37|W 46|"
## [24] "24 | MICHAEL R ALDRICH |4.0 |L 28|L 47|W 43|L 25|W 60|W 44|W 39|"
## [25] "25 | LOREN SCHWIEBERT |3.5 |L 9|W 53|L 3|W 24|D 34|L 10|W 47|"
## [26] "26 | MAX ZHU |3.5 |W 49|W 40|W 17|L 4|L 9|D 32|L 11|"
## [27] "27 | GAURAV GIDWANI |3.5 |W 51|L 13|W 46|W 37|D 14|L 6|U |"
## [28] "28 | SOFIA ADINA STANESCU-BELLU |3.5 |W 24|D 4|W 22|D 19|L 20|L 8|D 36|"
## [29] "29 | CHIEDOZIE OKORIE |3.5 |W 50|D 6|L 38|L 34|W 52|W 48|U |"
## [30] "30 | GEORGE AVERY JONES |3.5 |L 52|D 64|L 15|W 55|L 31|W 61|W 50|"
## [31] "31 | RISHI SHETTY |3.5 |L 58|D 55|W 64|L 10|W 30|W 50|L 14|"
## [32] "32 | JOSHUA PHILIP MATHEWS |3.5 |W 61|L 8|W 44|L 18|W 51|D 26|L 13|"
## [33] "33 | JADE GE |3.5 |W 60|L 12|W 50|D 36|L 13|L 15|W 51|"
## [34] "34 | MICHAEL JEFFERY THOMAS |3.5 |L 6|W 60|L 37|W 29|D 25|L 11|W 52|"
## [35] "35 | JOSHUA DAVID LEE |3.5 |L 46|L 38|W 56|L 6|W 57|D 52|W 48|"
## [36] "36 | SIDDHARTH JHA |3.5 |L 13|W 57|W 51|D 33|H |L 16|D 28|"
## [37] "37 | AMIYATOSH PWNANANDAM |3.5 |B |L 5|W 34|L 27|H |L 23|W 61|"
## [38] "38 | BRIAN LIU |3.0 |D 11|W 35|W 29|L 12|H |L 18|L 15|"
## [39] "39 | JOEL R HENDON |3.0 |L 1|W 54|W 40|L 16|W 44|L 21|L 24|"
## [40] "40 | FOREST ZHANG |3.0 |W 20|L 26|L 39|W 59|L 21|W 56|L 22|"
## [41] "41 | KYLE WILLIAM MURPHY |3.0 |W 59|L 17|W 58|L 20|X |U |U |"
## [42] "42 | JARED GE |3.0 |L 12|L 50|L 57|D 60|D 61|W 64|W 56|"
## [43] "43 | ROBERT GLEN VASEY |3.0 |L 21|L 23|L 24|W 63|W 59|L 46|W 55|"
## [44] "44 | JUSTIN D SCHILLING |3.0 |B |L 14|L 32|W 53|L 39|L 24|W 59|"
## [45] "45 | DEREK YAN |3.0 |L 5|L 51|D 60|L 56|W 63|D 55|W 58|"
## [46] "46 | JACOB ALEXANDER LAVALLEY |3.0 |W 35|L 7|L 27|L 50|W 64|W 43|L 23|"
## [47] "47 | ERIC WRIGHT |2.5 |L 18|W 24|L 21|W 61|L 8|D 51|L 25|"
## [48] "48 | DANIEL KHAIN |2.5 |L 17|W 63|H |D 52|H |L 29|L 35|"
## [49] "49 | MICHAEL J MARTIN |2.5 |L 26|L 20|D 63|D 64|W 58|H |U |"
## [50] "50 | SHIVAM JHA |2.5 |L 29|W 42|L 33|W 46|H |L 31|L 30|"
## [51] "51 | TEJAS AYYAGARI |2.5 |L 27|W 45|L 36|W 57|L 32|D 47|L 33|"
## [52] "52 | ETHAN GUO |2.5 |W 30|D 22|L 19|D 48|L 29|D 35|L 34|"
## [53] "53 | JOSE C YBARRA |2.0 |H |L 25|H |L 44|U |W 57|U |"
## [54] "54 | LARRY HODGE |2.0 |L 14|L 39|L 61|B |L 15|L 59|W 64|"
## [55] "55 | ALEX KONG |2.0 |L 62|D 31|L 10|L 30|B |D 45|L 43|"
## [56] "56 | MARISA RICCI |2.0 |H |L 11|L 35|W 45|H |L 40|L 42|"
## [57] "57 | MICHAEL LU |2.0 |L 7|L 36|W 42|L 51|L 35|L 53|B |"
## [58] "58 | VIRAJ MOHILE |2.0 |W 31|L 2|L 41|L 23|L 49|B |L 45|"
## [59] "59 | SEAN M MC CORMICK |2.0 |L 41|B |L 9|L 40|L 43|W 54|L 44|"
## [60] "60 | JULIA SHEN |1.5 |L 33|L 34|D 45|D 42|L 24|H |U |"
## [61] "61 | JEZZEL FARKAS |1.5 |L 32|L 3|W 54|L 47|D 42|L 30|L 37|"
## [62] "62 | ASHWIN BALAJI |1.0 |W 55|U |U |U |U |U |U |"
## [63] "63 | THOMAS JOSEPH HOSMER |1.0 |L 2|L 48|D 49|L 43|L 45|H |U |"
## [64] "64 | BEN LI |1.0 |L 22|D 30|L 31|D 49|L 46|L 42|L 54|"# matching first numbers
ID <- as.numeric(str_extract(matrix1, '\\d+'))
# matching the first combination of a letter, any amount of characters and "|"
Name <- str_extract(matrix1, '[A-z].{1,32}')
# extracting the name
Name <- str_trim(str_extract(Name, '.+\\s{2,}'))
# matching the first two letters (state) in the second matrix
State <- str_extract(matrix2, '[A-Z]{2}')
# matching at least 1 number, a period, and 1 number
TotalNumberofPoints <- as.numeric(str_extract(matrix1, '\\d+\\.\\d'))
# matching the combination of "R", any characters and "-"
PreRating <- str_extract(matrix2, 'R:.{8,}-')
# matching first 4 numbers
PreRating <- as.numeric(str_extract(PreRating, '\\d{1,4}'))
# matching all combinations of 1 letter 2 spaces and any numbers
Rounds <- str_extract_all(matrix1, '[A-Z]\\s{2,}\\d+')
# matching numbers
Rounds <- str_extract_all(Rounds, '\\d+')## Warning in stri_extract_all_regex(string, pattern, simplify = simplify, :
## argument is not an atomic vector; coercingCalculating Average Pre Chess
AvgOppPreChessRating <- c()
for(i in c(1:length(Rounds))){
AvgOppPreChessRating[i] <- round(mean(PreRating[as.numeric(Rounds[[i]])]),0)
}
AvgOppPreChessRating## [1] 1605 1469 1564 1574 1501 1519 1372 1468 1523 1554 1468 1506 1498 1515 1484
## [16] 1386 1499 1480 1426 1411 1470 1300 1214 1357 1363 1507 1222 1522 1314 1144
## [31] 1260 1379 1277 1375 1150 1388 1385 1539 1430 1391 1248 1150 1107 1327 1152
## [46] 1358 1392 1356 1286 1296 1356 1495 1345 1206 1406 1414 1363 1391 1319 1330
## [61] 1327 1186 1350 1263FINAL DATAFRAME
FINALCHESSPIECE = data.frame(ID,Name,State,TotalNumberofPoints,PreRating,AvgOppPreChessRating)
head(FINALCHESSPIECE)## ID Name State TotalNumberofPoints PreRating
## 1 1 GARY HUA ON 6.0 1794
## 2 2 DAKSHESH DARURI MI 6.0 1553
## 3 3 ADITYA BAJAJ MI 6.0 1384
## 4 4 PATRICK H SCHILLING MI 5.5 1716
## 5 5 HANSHI ZUO MI 5.5 1655
## 6 6 HANSEN SONG OH 5.0 1686
## AvgOppPreChessRating
## 1 1605
## 2 1469
## 3 1564
## 4 1574
## 5 1501
## 6 1519This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.
When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:
You can also embed plots, for example:
Note that the echo = FALSE parameter was added to the
code chunk to prevent printing of the R code that generated the
plot.