In this project the goal is to take a text file with chess tournament results, clean it up, and turn it into a data frame or CSV file for analysis. The final dataset should have 64 records
options(repos = c(CRAN = "https://cran.r-project.org"))
example_df <- data.frame(rbind(c("Gary Hua", "ON", 6.0, 1794, 1605)))
names(example_df) <- c("PlayerName", "State", "TotalPoints", "PreRating", "AvgOppPreRating")
knitr::kable(example_df)| PlayerName | State | TotalPoints | PreRating | AvgOppPreRating |
|---|---|---|---|---|
| Gary Hua | ON | 6 | 1794 | 1605 |
suppressPackageStartupMessages(library(dplyr))
library(readr)
library(stringr)
url <- "https://raw.githubusercontent.com/Yedzinovich/Data-607/main/chess.txt"
chess_lines <- read_lines(url)
print(chess_lines)## [1] "-----------------------------------------------------------------------------------------"
## [2] " Pair | Player Name |Total|Round|Round|Round|Round|Round|Round|Round| "
## [3] " Num | USCF ID / Rtg (Pre->Post) | Pts | 1 | 2 | 3 | 4 | 5 | 6 | 7 | "
## [4] "-----------------------------------------------------------------------------------------"
## [5] " 1 | GARY HUA |6.0 |W 39|W 21|W 18|W 14|W 7|D 12|D 4|"
## [6] " ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B |W |B |W |"
## [7] "-----------------------------------------------------------------------------------------"
## [8] " 2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 17|W 16|W 20|W 7|"
## [9] " MI | 14598900 / R: 1553 ->1663 |N:2 |B |W |B |W |B |W |B |"
## [10] "-----------------------------------------------------------------------------------------"
## [11] " 3 | ADITYA BAJAJ |6.0 |L 8|W 61|W 25|W 21|W 11|W 13|W 12|"
## [12] " MI | 14959604 / R: 1384 ->1640 |N:2 |W |B |W |B |W |B |W |"
## [13] "-----------------------------------------------------------------------------------------"
## [14] " 4 | PATRICK H SCHILLING |5.5 |W 23|D 28|W 2|W 26|D 5|W 19|D 1|"
## [15] " MI | 12616049 / R: 1716 ->1744 |N:2 |W |B |W |B |W |B |B |"
## [16] "-----------------------------------------------------------------------------------------"
## [17] " 5 | HANSHI ZUO |5.5 |W 45|W 37|D 12|D 13|D 4|W 14|W 17|"
## [18] " MI | 14601533 / R: 1655 ->1690 |N:2 |B |W |B |W |B |W |B |"
## [19] "-----------------------------------------------------------------------------------------"
## [20] " 6 | HANSEN SONG |5.0 |W 34|D 29|L 11|W 35|D 10|W 27|W 21|"
## [21] " OH | 15055204 / R: 1686 ->1687 |N:3 |W |B |W |B |B |W |B |"
## [22] "-----------------------------------------------------------------------------------------"
## [23] " 7 | GARY DEE SWATHELL |5.0 |W 57|W 46|W 13|W 11|L 1|W 9|L 2|"
## [24] " MI | 11146376 / R: 1649 ->1673 |N:3 |W |B |W |B |B |W |W |"
## [25] "-----------------------------------------------------------------------------------------"
## [26] " 8 | EZEKIEL HOUGHTON |5.0 |W 3|W 32|L 14|L 9|W 47|W 28|W 19|"
## [27] " MI | 15142253 / R: 1641P17->1657P24 |N:3 |B |W |B |W |B |W |W |"
## [28] "-----------------------------------------------------------------------------------------"
## [29] " 9 | STEFANO LEE |5.0 |W 25|L 18|W 59|W 8|W 26|L 7|W 20|"
## [30] " ON | 14954524 / R: 1411 ->1564 |N:2 |W |B |W |B |W |B |B |"
## [31] "-----------------------------------------------------------------------------------------"
## [32] " 10 | ANVIT RAO |5.0 |D 16|L 19|W 55|W 31|D 6|W 25|W 18|"
## [33] " MI | 14150362 / R: 1365 ->1544 |N:3 |W |W |B |B |W |B |W |"
## [34] "-----------------------------------------------------------------------------------------"
## [35] " 11 | CAMERON WILLIAM MC LEMAN |4.5 |D 38|W 56|W 6|L 7|L 3|W 34|W 26|"
## [36] " MI | 12581589 / R: 1712 ->1696 |N:3 |B |W |B |W |B |W |B |"
## [37] "-----------------------------------------------------------------------------------------"
## [38] " 12 | KENNETH J TACK |4.5 |W 42|W 33|D 5|W 38|H |D 1|L 3|"
## [39] " MI | 12681257 / R: 1663 ->1670 |N:3 |W |B |W |B | |W |B |"
## [40] "-----------------------------------------------------------------------------------------"
## [41] " 13 | TORRANCE HENRY JR |4.5 |W 36|W 27|L 7|D 5|W 33|L 3|W 32|"
## [42] " MI | 15082995 / R: 1666 ->1662 |N:3 |B |W |B |B |W |W |B |"
## [43] "-----------------------------------------------------------------------------------------"
## [44] " 14 | BRADLEY SHAW |4.5 |W 54|W 44|W 8|L 1|D 27|L 5|W 31|"
## [45] " MI | 10131499 / R: 1610 ->1618 |N:3 |W |B |W |W |B |B |W |"
## [46] "-----------------------------------------------------------------------------------------"
## [47] " 15 | ZACHARY JAMES HOUGHTON |4.5 |D 19|L 16|W 30|L 22|W 54|W 33|W 38|"
## [48] " MI | 15619130 / R: 1220P13->1416P20 |N:3 |B |B |W |W |B |B |W |"
## [49] "-----------------------------------------------------------------------------------------"
## [50] " 16 | MIKE NIKITIN |4.0 |D 10|W 15|H |W 39|L 2|W 36|U |"
## [51] " MI | 10295068 / R: 1604 ->1613 |N:3 |B |W | |B |W |B | |"
## [52] "-----------------------------------------------------------------------------------------"
## [53] " 17 | RONALD GRZEGORCZYK |4.0 |W 48|W 41|L 26|L 2|W 23|W 22|L 5|"
## [54] " MI | 10297702 / R: 1629 ->1610 |N:3 |W |B |W |B |W |B |W |"
## [55] "-----------------------------------------------------------------------------------------"
## [56] " 18 | DAVID SUNDEEN |4.0 |W 47|W 9|L 1|W 32|L 19|W 38|L 10|"
## [57] " MI | 11342094 / R: 1600 ->1600 |N:3 |B |W |B |W |B |W |B |"
## [58] "-----------------------------------------------------------------------------------------"
## [59] " 19 | DIPANKAR ROY |4.0 |D 15|W 10|W 52|D 28|W 18|L 4|L 8|"
## [60] " MI | 14862333 / R: 1564 ->1570 |N:3 |W |B |W |B |W |W |B |"
## [61] "-----------------------------------------------------------------------------------------"
## [62] " 20 | JASON ZHENG |4.0 |L 40|W 49|W 23|W 41|W 28|L 2|L 9|"
## [63] " MI | 14529060 / R: 1595 ->1569 |N:4 |W |B |W |B |W |B |W |"
## [64] "-----------------------------------------------------------------------------------------"
## [65] " 21 | DINH DANG BUI |4.0 |W 43|L 1|W 47|L 3|W 40|W 39|L 6|"
## [66] " ON | 15495066 / R: 1563P22->1562 |N:3 |B |W |B |W |W |B |W |"
## [67] "-----------------------------------------------------------------------------------------"
## [68] " 22 | EUGENE L MCCLURE |4.0 |W 64|D 52|L 28|W 15|H |L 17|W 40|"
## [69] " MI | 12405534 / R: 1555 ->1529 |N:4 |W |B |W |B | |W |B |"
## [70] "-----------------------------------------------------------------------------------------"
## [71] " 23 | ALAN BUI |4.0 |L 4|W 43|L 20|W 58|L 17|W 37|W 46|"
## [72] " ON | 15030142 / R: 1363 ->1371 | |B |W |B |W |B |W |B |"
## [73] "-----------------------------------------------------------------------------------------"
## [74] " 24 | MICHAEL R ALDRICH |4.0 |L 28|L 47|W 43|L 25|W 60|W 44|W 39|"
## [75] " MI | 13469010 / R: 1229 ->1300 |N:4 |B |W |B |B |W |W |B |"
## [76] "-----------------------------------------------------------------------------------------"
## [77] " 25 | LOREN SCHWIEBERT |3.5 |L 9|W 53|L 3|W 24|D 34|L 10|W 47|"
## [78] " MI | 12486656 / R: 1745 ->1681 |N:4 |B |W |B |W |B |W |B |"
## [79] "-----------------------------------------------------------------------------------------"
## [80] " 26 | MAX ZHU |3.5 |W 49|W 40|W 17|L 4|L 9|D 32|L 11|"
## [81] " ON | 15131520 / R: 1579 ->1564 |N:4 |B |W |B |W |B |W |W |"
## [82] "-----------------------------------------------------------------------------------------"
## [83] " 27 | GAURAV GIDWANI |3.5 |W 51|L 13|W 46|W 37|D 14|L 6|U |"
## [84] " MI | 14476567 / R: 1552 ->1539 |N:4 |W |B |W |B |W |B | |"
## [85] "-----------------------------------------------------------------------------------------"
## [86] " 28 | SOFIA ADINA STANESCU-BELLU |3.5 |W 24|D 4|W 22|D 19|L 20|L 8|D 36|"
## [87] " MI | 14882954 / R: 1507 ->1513 |N:3 |W |W |B |W |B |B |W |"
## [88] "-----------------------------------------------------------------------------------------"
## [89] " 29 | CHIEDOZIE OKORIE |3.5 |W 50|D 6|L 38|L 34|W 52|W 48|U |"
## [90] " MI | 15323285 / R: 1602P6 ->1508P12 |N:4 |B |W |B |W |W |B | |"
## [91] "-----------------------------------------------------------------------------------------"
## [92] " 30 | GEORGE AVERY JONES |3.5 |L 52|D 64|L 15|W 55|L 31|W 61|W 50|"
## [93] " ON | 12577178 / R: 1522 ->1444 | |W |B |B |W |W |B |B |"
## [94] "-----------------------------------------------------------------------------------------"
## [95] " 31 | RISHI SHETTY |3.5 |L 58|D 55|W 64|L 10|W 30|W 50|L 14|"
## [96] " MI | 15131618 / R: 1494 ->1444 | |B |W |B |W |B |W |B |"
## [97] "-----------------------------------------------------------------------------------------"
## [98] " 32 | JOSHUA PHILIP MATHEWS |3.5 |W 61|L 8|W 44|L 18|W 51|D 26|L 13|"
## [99] " ON | 14073750 / R: 1441 ->1433 |N:4 |W |B |W |B |W |B |W |"
## [100] "-----------------------------------------------------------------------------------------"
## [101] " 33 | JADE GE |3.5 |W 60|L 12|W 50|D 36|L 13|L 15|W 51|"
## [102] " MI | 14691842 / R: 1449 ->1421 | |B |W |B |W |B |W |B |"
## [103] "-----------------------------------------------------------------------------------------"
## [104] " 34 | MICHAEL JEFFERY THOMAS |3.5 |L 6|W 60|L 37|W 29|D 25|L 11|W 52|"
## [105] " MI | 15051807 / R: 1399 ->1400 | |B |W |B |B |W |B |W |"
## [106] "-----------------------------------------------------------------------------------------"
## [107] " 35 | JOSHUA DAVID LEE |3.5 |L 46|L 38|W 56|L 6|W 57|D 52|W 48|"
## [108] " MI | 14601397 / R: 1438 ->1392 | |W |W |B |W |B |B |W |"
## [109] "-----------------------------------------------------------------------------------------"
## [110] " 36 | SIDDHARTH JHA |3.5 |L 13|W 57|W 51|D 33|H |L 16|D 28|"
## [111] " MI | 14773163 / R: 1355 ->1367 |N:4 |W |B |W |B | |W |B |"
## [112] "-----------------------------------------------------------------------------------------"
## [113] " 37 | AMIYATOSH PWNANANDAM |3.5 |B |L 5|W 34|L 27|H |L 23|W 61|"
## [114] " MI | 15489571 / R: 980P12->1077P17 | | |B |W |W | |B |W |"
## [115] "-----------------------------------------------------------------------------------------"
## [116] " 38 | BRIAN LIU |3.0 |D 11|W 35|W 29|L 12|H |L 18|L 15|"
## [117] " MI | 15108523 / R: 1423 ->1439 |N:4 |W |B |W |W | |B |B |"
## [118] "-----------------------------------------------------------------------------------------"
## [119] " 39 | JOEL R HENDON |3.0 |L 1|W 54|W 40|L 16|W 44|L 21|L 24|"
## [120] " MI | 12923035 / R: 1436P23->1413 |N:4 |B |W |B |W |B |W |W |"
## [121] "-----------------------------------------------------------------------------------------"
## [122] " 40 | FOREST ZHANG |3.0 |W 20|L 26|L 39|W 59|L 21|W 56|L 22|"
## [123] " MI | 14892710 / R: 1348 ->1346 | |B |B |W |W |B |W |W |"
## [124] "-----------------------------------------------------------------------------------------"
## [125] " 41 | KYLE WILLIAM MURPHY |3.0 |W 59|L 17|W 58|L 20|X |U |U |"
## [126] " MI | 15761443 / R: 1403P5 ->1341P9 | |B |W |B |W | | | |"
## [127] "-----------------------------------------------------------------------------------------"
## [128] " 42 | JARED GE |3.0 |L 12|L 50|L 57|D 60|D 61|W 64|W 56|"
## [129] " MI | 14462326 / R: 1332 ->1256 | |B |W |B |B |W |W |B |"
## [130] "-----------------------------------------------------------------------------------------"
## [131] " 43 | ROBERT GLEN VASEY |3.0 |L 21|L 23|L 24|W 63|W 59|L 46|W 55|"
## [132] " MI | 14101068 / R: 1283 ->1244 | |W |B |W |W |B |B |W |"
## [133] "-----------------------------------------------------------------------------------------"
## [134] " 44 | JUSTIN D SCHILLING |3.0 |B |L 14|L 32|W 53|L 39|L 24|W 59|"
## [135] " MI | 15323504 / R: 1199 ->1199 | | |W |B |B |W |B |W |"
## [136] "-----------------------------------------------------------------------------------------"
## [137] " 45 | DEREK YAN |3.0 |L 5|L 51|D 60|L 56|W 63|D 55|W 58|"
## [138] " MI | 15372807 / R: 1242 ->1191 | |W |B |W |B |W |B |W |"
## [139] "-----------------------------------------------------------------------------------------"
## [140] " 46 | JACOB ALEXANDER LAVALLEY |3.0 |W 35|L 7|L 27|L 50|W 64|W 43|L 23|"
## [141] " MI | 15490981 / R: 377P3 ->1076P10 | |B |W |B |W |B |W |W |"
## [142] "-----------------------------------------------------------------------------------------"
## [143] " 47 | ERIC WRIGHT |2.5 |L 18|W 24|L 21|W 61|L 8|D 51|L 25|"
## [144] " MI | 12533115 / R: 1362 ->1341 | |W |B |W |B |W |B |W |"
## [145] "-----------------------------------------------------------------------------------------"
## [146] " 48 | DANIEL KHAIN |2.5 |L 17|W 63|H |D 52|H |L 29|L 35|"
## [147] " MI | 14369165 / R: 1382 ->1335 | |B |W | |B | |W |B |"
## [148] "-----------------------------------------------------------------------------------------"
## [149] " 49 | MICHAEL J MARTIN |2.5 |L 26|L 20|D 63|D 64|W 58|H |U |"
## [150] " MI | 12531685 / R: 1291P12->1259P17 | |W |W |B |W |B | | |"
## [151] "-----------------------------------------------------------------------------------------"
## [152] " 50 | SHIVAM JHA |2.5 |L 29|W 42|L 33|W 46|H |L 31|L 30|"
## [153] " MI | 14773178 / R: 1056 ->1111 | |W |B |W |B | |B |W |"
## [154] "-----------------------------------------------------------------------------------------"
## [155] " 51 | TEJAS AYYAGARI |2.5 |L 27|W 45|L 36|W 57|L 32|D 47|L 33|"
## [156] " MI | 15205474 / R: 1011 ->1097 | |B |W |B |W |B |W |W |"
## [157] "-----------------------------------------------------------------------------------------"
## [158] " 52 | ETHAN GUO |2.5 |W 30|D 22|L 19|D 48|L 29|D 35|L 34|"
## [159] " MI | 14918803 / R: 935 ->1092 |N:4 |B |W |B |W |B |W |B |"
## [160] "-----------------------------------------------------------------------------------------"
## [161] " 53 | JOSE C YBARRA |2.0 |H |L 25|H |L 44|U |W 57|U |"
## [162] " MI | 12578849 / R: 1393 ->1359 | | |B | |W | |W | |"
## [163] "-----------------------------------------------------------------------------------------"
## [164] " 54 | LARRY HODGE |2.0 |L 14|L 39|L 61|B |L 15|L 59|W 64|"
## [165] " MI | 12836773 / R: 1270 ->1200 | |B |B |W | |W |B |W |"
## [166] "-----------------------------------------------------------------------------------------"
## [167] " 55 | ALEX KONG |2.0 |L 62|D 31|L 10|L 30|B |D 45|L 43|"
## [168] " MI | 15412571 / R: 1186 ->1163 | |W |B |W |B | |W |B |"
## [169] "-----------------------------------------------------------------------------------------"
## [170] " 56 | MARISA RICCI |2.0 |H |L 11|L 35|W 45|H |L 40|L 42|"
## [171] " MI | 14679887 / R: 1153 ->1140 | | |B |W |W | |B |W |"
## [172] "-----------------------------------------------------------------------------------------"
## [173] " 57 | MICHAEL LU |2.0 |L 7|L 36|W 42|L 51|L 35|L 53|B |"
## [174] " MI | 15113330 / R: 1092 ->1079 | |B |W |W |B |W |B | |"
## [175] "-----------------------------------------------------------------------------------------"
## [176] " 58 | VIRAJ MOHILE |2.0 |W 31|L 2|L 41|L 23|L 49|B |L 45|"
## [177] " MI | 14700365 / R: 917 -> 941 | |W |B |W |B |W | |B |"
## [178] "-----------------------------------------------------------------------------------------"
## [179] " 59 | SEAN M MC CORMICK |2.0 |L 41|B |L 9|L 40|L 43|W 54|L 44|"
## [180] " MI | 12841036 / R: 853 -> 878 | |W | |B |B |W |W |B |"
## [181] "-----------------------------------------------------------------------------------------"
## [182] " 60 | JULIA SHEN |1.5 |L 33|L 34|D 45|D 42|L 24|H |U |"
## [183] " MI | 14579262 / R: 967 -> 984 | |W |B |B |W |B | | |"
## [184] "-----------------------------------------------------------------------------------------"
## [185] " 61 | JEZZEL FARKAS |1.5 |L 32|L 3|W 54|L 47|D 42|L 30|L 37|"
## [186] " ON | 15771592 / R: 955P11-> 979P18 | |B |W |B |W |B |W |B |"
## [187] "-----------------------------------------------------------------------------------------"
## [188] " 62 | ASHWIN BALAJI |1.0 |W 55|U |U |U |U |U |U |"
## [189] " MI | 15219542 / R: 1530 ->1535 | |B | | | | | | |"
## [190] "-----------------------------------------------------------------------------------------"
## [191] " 63 | THOMAS JOSEPH HOSMER |1.0 |L 2|L 48|D 49|L 43|L 45|H |U |"
## [192] " MI | 15057092 / R: 1175 ->1125 | |W |B |W |B |B | | |"
## [193] "-----------------------------------------------------------------------------------------"
## [194] " 64 | BEN LI |1.0 |L 22|D 30|L 31|D 49|L 46|L 42|L 54|"
## [195] " MI | 15006561 / R: 1163 ->1112 | |B |W |W |B |W |B |B |"
## [196] "-----------------------------------------------------------------------------------------"Let’s analyze this data to uncover meaningful insights from this seemingly random string of characters. Since I’m unsure of the next steps, I’ll use some probing techniques to explore any potential actions we can take.
chess_text <- c(chess_lines)
print(chess_text)## [1] "-----------------------------------------------------------------------------------------"
## [2] " Pair | Player Name |Total|Round|Round|Round|Round|Round|Round|Round| "
## [3] " Num | USCF ID / Rtg (Pre->Post) | Pts | 1 | 2 | 3 | 4 | 5 | 6 | 7 | "
## [4] "-----------------------------------------------------------------------------------------"
## [5] " 1 | GARY HUA |6.0 |W 39|W 21|W 18|W 14|W 7|D 12|D 4|"
## [6] " ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B |W |B |W |"
## [7] "-----------------------------------------------------------------------------------------"
## [8] " 2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 17|W 16|W 20|W 7|"
## [9] " MI | 14598900 / R: 1553 ->1663 |N:2 |B |W |B |W |B |W |B |"
## [10] "-----------------------------------------------------------------------------------------"
## [11] " 3 | ADITYA BAJAJ |6.0 |L 8|W 61|W 25|W 21|W 11|W 13|W 12|"
## [12] " MI | 14959604 / R: 1384 ->1640 |N:2 |W |B |W |B |W |B |W |"
## [13] "-----------------------------------------------------------------------------------------"
## [14] " 4 | PATRICK H SCHILLING |5.5 |W 23|D 28|W 2|W 26|D 5|W 19|D 1|"
## [15] " MI | 12616049 / R: 1716 ->1744 |N:2 |W |B |W |B |W |B |B |"
## [16] "-----------------------------------------------------------------------------------------"
## [17] " 5 | HANSHI ZUO |5.5 |W 45|W 37|D 12|D 13|D 4|W 14|W 17|"
## [18] " MI | 14601533 / R: 1655 ->1690 |N:2 |B |W |B |W |B |W |B |"
## [19] "-----------------------------------------------------------------------------------------"
## [20] " 6 | HANSEN SONG |5.0 |W 34|D 29|L 11|W 35|D 10|W 27|W 21|"
## [21] " OH | 15055204 / R: 1686 ->1687 |N:3 |W |B |W |B |B |W |B |"
## [22] "-----------------------------------------------------------------------------------------"
## [23] " 7 | GARY DEE SWATHELL |5.0 |W 57|W 46|W 13|W 11|L 1|W 9|L 2|"
## [24] " MI | 11146376 / R: 1649 ->1673 |N:3 |W |B |W |B |B |W |W |"
## [25] "-----------------------------------------------------------------------------------------"
## [26] " 8 | EZEKIEL HOUGHTON |5.0 |W 3|W 32|L 14|L 9|W 47|W 28|W 19|"
## [27] " MI | 15142253 / R: 1641P17->1657P24 |N:3 |B |W |B |W |B |W |W |"
## [28] "-----------------------------------------------------------------------------------------"
## [29] " 9 | STEFANO LEE |5.0 |W 25|L 18|W 59|W 8|W 26|L 7|W 20|"
## [30] " ON | 14954524 / R: 1411 ->1564 |N:2 |W |B |W |B |W |B |B |"
## [31] "-----------------------------------------------------------------------------------------"
## [32] " 10 | ANVIT RAO |5.0 |D 16|L 19|W 55|W 31|D 6|W 25|W 18|"
## [33] " MI | 14150362 / R: 1365 ->1544 |N:3 |W |W |B |B |W |B |W |"
## [34] "-----------------------------------------------------------------------------------------"
## [35] " 11 | CAMERON WILLIAM MC LEMAN |4.5 |D 38|W 56|W 6|L 7|L 3|W 34|W 26|"
## [36] " MI | 12581589 / R: 1712 ->1696 |N:3 |B |W |B |W |B |W |B |"
## [37] "-----------------------------------------------------------------------------------------"
## [38] " 12 | KENNETH J TACK |4.5 |W 42|W 33|D 5|W 38|H |D 1|L 3|"
## [39] " MI | 12681257 / R: 1663 ->1670 |N:3 |W |B |W |B | |W |B |"
## [40] "-----------------------------------------------------------------------------------------"
## [41] " 13 | TORRANCE HENRY JR |4.5 |W 36|W 27|L 7|D 5|W 33|L 3|W 32|"
## [42] " MI | 15082995 / R: 1666 ->1662 |N:3 |B |W |B |B |W |W |B |"
## [43] "-----------------------------------------------------------------------------------------"
## [44] " 14 | BRADLEY SHAW |4.5 |W 54|W 44|W 8|L 1|D 27|L 5|W 31|"
## [45] " MI | 10131499 / R: 1610 ->1618 |N:3 |W |B |W |W |B |B |W |"
## [46] "-----------------------------------------------------------------------------------------"
## [47] " 15 | ZACHARY JAMES HOUGHTON |4.5 |D 19|L 16|W 30|L 22|W 54|W 33|W 38|"
## [48] " MI | 15619130 / R: 1220P13->1416P20 |N:3 |B |B |W |W |B |B |W |"
## [49] "-----------------------------------------------------------------------------------------"
## [50] " 16 | MIKE NIKITIN |4.0 |D 10|W 15|H |W 39|L 2|W 36|U |"
## [51] " MI | 10295068 / R: 1604 ->1613 |N:3 |B |W | |B |W |B | |"
## [52] "-----------------------------------------------------------------------------------------"
## [53] " 17 | RONALD GRZEGORCZYK |4.0 |W 48|W 41|L 26|L 2|W 23|W 22|L 5|"
## [54] " MI | 10297702 / R: 1629 ->1610 |N:3 |W |B |W |B |W |B |W |"
## [55] "-----------------------------------------------------------------------------------------"
## [56] " 18 | DAVID SUNDEEN |4.0 |W 47|W 9|L 1|W 32|L 19|W 38|L 10|"
## [57] " MI | 11342094 / R: 1600 ->1600 |N:3 |B |W |B |W |B |W |B |"
## [58] "-----------------------------------------------------------------------------------------"
## [59] " 19 | DIPANKAR ROY |4.0 |D 15|W 10|W 52|D 28|W 18|L 4|L 8|"
## [60] " MI | 14862333 / R: 1564 ->1570 |N:3 |W |B |W |B |W |W |B |"
## [61] "-----------------------------------------------------------------------------------------"
## [62] " 20 | JASON ZHENG |4.0 |L 40|W 49|W 23|W 41|W 28|L 2|L 9|"
## [63] " MI | 14529060 / R: 1595 ->1569 |N:4 |W |B |W |B |W |B |W |"
## [64] "-----------------------------------------------------------------------------------------"
## [65] " 21 | DINH DANG BUI |4.0 |W 43|L 1|W 47|L 3|W 40|W 39|L 6|"
## [66] " ON | 15495066 / R: 1563P22->1562 |N:3 |B |W |B |W |W |B |W |"
## [67] "-----------------------------------------------------------------------------------------"
## [68] " 22 | EUGENE L MCCLURE |4.0 |W 64|D 52|L 28|W 15|H |L 17|W 40|"
## [69] " MI | 12405534 / R: 1555 ->1529 |N:4 |W |B |W |B | |W |B |"
## [70] "-----------------------------------------------------------------------------------------"
## [71] " 23 | ALAN BUI |4.0 |L 4|W 43|L 20|W 58|L 17|W 37|W 46|"
## [72] " ON | 15030142 / R: 1363 ->1371 | |B |W |B |W |B |W |B |"
## [73] "-----------------------------------------------------------------------------------------"
## [74] " 24 | MICHAEL R ALDRICH |4.0 |L 28|L 47|W 43|L 25|W 60|W 44|W 39|"
## [75] " MI | 13469010 / R: 1229 ->1300 |N:4 |B |W |B |B |W |W |B |"
## [76] "-----------------------------------------------------------------------------------------"
## [77] " 25 | LOREN SCHWIEBERT |3.5 |L 9|W 53|L 3|W 24|D 34|L 10|W 47|"
## [78] " MI | 12486656 / R: 1745 ->1681 |N:4 |B |W |B |W |B |W |B |"
## [79] "-----------------------------------------------------------------------------------------"
## [80] " 26 | MAX ZHU |3.5 |W 49|W 40|W 17|L 4|L 9|D 32|L 11|"
## [81] " ON | 15131520 / R: 1579 ->1564 |N:4 |B |W |B |W |B |W |W |"
## [82] "-----------------------------------------------------------------------------------------"
## [83] " 27 | GAURAV GIDWANI |3.5 |W 51|L 13|W 46|W 37|D 14|L 6|U |"
## [84] " MI | 14476567 / R: 1552 ->1539 |N:4 |W |B |W |B |W |B | |"
## [85] "-----------------------------------------------------------------------------------------"
## [86] " 28 | SOFIA ADINA STANESCU-BELLU |3.5 |W 24|D 4|W 22|D 19|L 20|L 8|D 36|"
## [87] " MI | 14882954 / R: 1507 ->1513 |N:3 |W |W |B |W |B |B |W |"
## [88] "-----------------------------------------------------------------------------------------"
## [89] " 29 | CHIEDOZIE OKORIE |3.5 |W 50|D 6|L 38|L 34|W 52|W 48|U |"
## [90] " MI | 15323285 / R: 1602P6 ->1508P12 |N:4 |B |W |B |W |W |B | |"
## [91] "-----------------------------------------------------------------------------------------"
## [92] " 30 | GEORGE AVERY JONES |3.5 |L 52|D 64|L 15|W 55|L 31|W 61|W 50|"
## [93] " ON | 12577178 / R: 1522 ->1444 | |W |B |B |W |W |B |B |"
## [94] "-----------------------------------------------------------------------------------------"
## [95] " 31 | RISHI SHETTY |3.5 |L 58|D 55|W 64|L 10|W 30|W 50|L 14|"
## [96] " MI | 15131618 / R: 1494 ->1444 | |B |W |B |W |B |W |B |"
## [97] "-----------------------------------------------------------------------------------------"
## [98] " 32 | JOSHUA PHILIP MATHEWS |3.5 |W 61|L 8|W 44|L 18|W 51|D 26|L 13|"
## [99] " ON | 14073750 / R: 1441 ->1433 |N:4 |W |B |W |B |W |B |W |"
## [100] "-----------------------------------------------------------------------------------------"
## [101] " 33 | JADE GE |3.5 |W 60|L 12|W 50|D 36|L 13|L 15|W 51|"
## [102] " MI | 14691842 / R: 1449 ->1421 | |B |W |B |W |B |W |B |"
## [103] "-----------------------------------------------------------------------------------------"
## [104] " 34 | MICHAEL JEFFERY THOMAS |3.5 |L 6|W 60|L 37|W 29|D 25|L 11|W 52|"
## [105] " MI | 15051807 / R: 1399 ->1400 | |B |W |B |B |W |B |W |"
## [106] "-----------------------------------------------------------------------------------------"
## [107] " 35 | JOSHUA DAVID LEE |3.5 |L 46|L 38|W 56|L 6|W 57|D 52|W 48|"
## [108] " MI | 14601397 / R: 1438 ->1392 | |W |W |B |W |B |B |W |"
## [109] "-----------------------------------------------------------------------------------------"
## [110] " 36 | SIDDHARTH JHA |3.5 |L 13|W 57|W 51|D 33|H |L 16|D 28|"
## [111] " MI | 14773163 / R: 1355 ->1367 |N:4 |W |B |W |B | |W |B |"
## [112] "-----------------------------------------------------------------------------------------"
## [113] " 37 | AMIYATOSH PWNANANDAM |3.5 |B |L 5|W 34|L 27|H |L 23|W 61|"
## [114] " MI | 15489571 / R: 980P12->1077P17 | | |B |W |W | |B |W |"
## [115] "-----------------------------------------------------------------------------------------"
## [116] " 38 | BRIAN LIU |3.0 |D 11|W 35|W 29|L 12|H |L 18|L 15|"
## [117] " MI | 15108523 / R: 1423 ->1439 |N:4 |W |B |W |W | |B |B |"
## [118] "-----------------------------------------------------------------------------------------"
## [119] " 39 | JOEL R HENDON |3.0 |L 1|W 54|W 40|L 16|W 44|L 21|L 24|"
## [120] " MI | 12923035 / R: 1436P23->1413 |N:4 |B |W |B |W |B |W |W |"
## [121] "-----------------------------------------------------------------------------------------"
## [122] " 40 | FOREST ZHANG |3.0 |W 20|L 26|L 39|W 59|L 21|W 56|L 22|"
## [123] " MI | 14892710 / R: 1348 ->1346 | |B |B |W |W |B |W |W |"
## [124] "-----------------------------------------------------------------------------------------"
## [125] " 41 | KYLE WILLIAM MURPHY |3.0 |W 59|L 17|W 58|L 20|X |U |U |"
## [126] " MI | 15761443 / R: 1403P5 ->1341P9 | |B |W |B |W | | | |"
## [127] "-----------------------------------------------------------------------------------------"
## [128] " 42 | JARED GE |3.0 |L 12|L 50|L 57|D 60|D 61|W 64|W 56|"
## [129] " MI | 14462326 / R: 1332 ->1256 | |B |W |B |B |W |W |B |"
## [130] "-----------------------------------------------------------------------------------------"
## [131] " 43 | ROBERT GLEN VASEY |3.0 |L 21|L 23|L 24|W 63|W 59|L 46|W 55|"
## [132] " MI | 14101068 / R: 1283 ->1244 | |W |B |W |W |B |B |W |"
## [133] "-----------------------------------------------------------------------------------------"
## [134] " 44 | JUSTIN D SCHILLING |3.0 |B |L 14|L 32|W 53|L 39|L 24|W 59|"
## [135] " MI | 15323504 / R: 1199 ->1199 | | |W |B |B |W |B |W |"
## [136] "-----------------------------------------------------------------------------------------"
## [137] " 45 | DEREK YAN |3.0 |L 5|L 51|D 60|L 56|W 63|D 55|W 58|"
## [138] " MI | 15372807 / R: 1242 ->1191 | |W |B |W |B |W |B |W |"
## [139] "-----------------------------------------------------------------------------------------"
## [140] " 46 | JACOB ALEXANDER LAVALLEY |3.0 |W 35|L 7|L 27|L 50|W 64|W 43|L 23|"
## [141] " MI | 15490981 / R: 377P3 ->1076P10 | |B |W |B |W |B |W |W |"
## [142] "-----------------------------------------------------------------------------------------"
## [143] " 47 | ERIC WRIGHT |2.5 |L 18|W 24|L 21|W 61|L 8|D 51|L 25|"
## [144] " MI | 12533115 / R: 1362 ->1341 | |W |B |W |B |W |B |W |"
## [145] "-----------------------------------------------------------------------------------------"
## [146] " 48 | DANIEL KHAIN |2.5 |L 17|W 63|H |D 52|H |L 29|L 35|"
## [147] " MI | 14369165 / R: 1382 ->1335 | |B |W | |B | |W |B |"
## [148] "-----------------------------------------------------------------------------------------"
## [149] " 49 | MICHAEL J MARTIN |2.5 |L 26|L 20|D 63|D 64|W 58|H |U |"
## [150] " MI | 12531685 / R: 1291P12->1259P17 | |W |W |B |W |B | | |"
## [151] "-----------------------------------------------------------------------------------------"
## [152] " 50 | SHIVAM JHA |2.5 |L 29|W 42|L 33|W 46|H |L 31|L 30|"
## [153] " MI | 14773178 / R: 1056 ->1111 | |W |B |W |B | |B |W |"
## [154] "-----------------------------------------------------------------------------------------"
## [155] " 51 | TEJAS AYYAGARI |2.5 |L 27|W 45|L 36|W 57|L 32|D 47|L 33|"
## [156] " MI | 15205474 / R: 1011 ->1097 | |B |W |B |W |B |W |W |"
## [157] "-----------------------------------------------------------------------------------------"
## [158] " 52 | ETHAN GUO |2.5 |W 30|D 22|L 19|D 48|L 29|D 35|L 34|"
## [159] " MI | 14918803 / R: 935 ->1092 |N:4 |B |W |B |W |B |W |B |"
## [160] "-----------------------------------------------------------------------------------------"
## [161] " 53 | JOSE C YBARRA |2.0 |H |L 25|H |L 44|U |W 57|U |"
## [162] " MI | 12578849 / R: 1393 ->1359 | | |B | |W | |W | |"
## [163] "-----------------------------------------------------------------------------------------"
## [164] " 54 | LARRY HODGE |2.0 |L 14|L 39|L 61|B |L 15|L 59|W 64|"
## [165] " MI | 12836773 / R: 1270 ->1200 | |B |B |W | |W |B |W |"
## [166] "-----------------------------------------------------------------------------------------"
## [167] " 55 | ALEX KONG |2.0 |L 62|D 31|L 10|L 30|B |D 45|L 43|"
## [168] " MI | 15412571 / R: 1186 ->1163 | |W |B |W |B | |W |B |"
## [169] "-----------------------------------------------------------------------------------------"
## [170] " 56 | MARISA RICCI |2.0 |H |L 11|L 35|W 45|H |L 40|L 42|"
## [171] " MI | 14679887 / R: 1153 ->1140 | | |B |W |W | |B |W |"
## [172] "-----------------------------------------------------------------------------------------"
## [173] " 57 | MICHAEL LU |2.0 |L 7|L 36|W 42|L 51|L 35|L 53|B |"
## [174] " MI | 15113330 / R: 1092 ->1079 | |B |W |W |B |W |B | |"
## [175] "-----------------------------------------------------------------------------------------"
## [176] " 58 | VIRAJ MOHILE |2.0 |W 31|L 2|L 41|L 23|L 49|B |L 45|"
## [177] " MI | 14700365 / R: 917 -> 941 | |W |B |W |B |W | |B |"
## [178] "-----------------------------------------------------------------------------------------"
## [179] " 59 | SEAN M MC CORMICK |2.0 |L 41|B |L 9|L 40|L 43|W 54|L 44|"
## [180] " MI | 12841036 / R: 853 -> 878 | |W | |B |B |W |W |B |"
## [181] "-----------------------------------------------------------------------------------------"
## [182] " 60 | JULIA SHEN |1.5 |L 33|L 34|D 45|D 42|L 24|H |U |"
## [183] " MI | 14579262 / R: 967 -> 984 | |W |B |B |W |B | | |"
## [184] "-----------------------------------------------------------------------------------------"
## [185] " 61 | JEZZEL FARKAS |1.5 |L 32|L 3|W 54|L 47|D 42|L 30|L 37|"
## [186] " ON | 15771592 / R: 955P11-> 979P18 | |B |W |B |W |B |W |B |"
## [187] "-----------------------------------------------------------------------------------------"
## [188] " 62 | ASHWIN BALAJI |1.0 |W 55|U |U |U |U |U |U |"
## [189] " MI | 15219542 / R: 1530 ->1535 | |B | | | | | | |"
## [190] "-----------------------------------------------------------------------------------------"
## [191] " 63 | THOMAS JOSEPH HOSMER |1.0 |L 2|L 48|D 49|L 43|L 45|H |U |"
## [192] " MI | 15057092 / R: 1175 ->1125 | |W |B |W |B |B | | |"
## [193] "-----------------------------------------------------------------------------------------"
## [194] " 64 | BEN LI |1.0 |L 22|D 30|L 31|D 49|L 46|L 42|L 54|"
## [195] " MI | 15006561 / R: 1163 ->1112 | |B |W |W |B |W |B |B |"
## [196] "-----------------------------------------------------------------------------------------"Alright, this didn’t help and appears to have the same effect.
Let’s try anything else using https://www.tidytextmining.com/tidytext as a reference.
Let’s calculate the number of lines first and then use the tibble() function to see if we can extract any useful insights from the data.
lines <- strsplit(chess_text, "\n")[]
num_lines <- length(lines)
print(num_lines)## [1] 196library(dplyr)
chess_text_df <- tibble(line = 1:num_lines, text = chess_text)
print(chess_text_df)## # A tibble: 196 × 2
## line text
## <int> <chr>
## 1 1 "---------------------------------------------------------------------…
## 2 2 " Pair | Player Name |Total|Round|Round|Round|Roun…
## 3 3 " Num | USCF ID / Rtg (Pre->Post) | Pts | 1 | 2 | 3 | 4 …
## 4 4 "---------------------------------------------------------------------…
## 5 5 " 1 | GARY HUA |6.0 |W 39|W 21|W 18|W 1…
## 6 6 " ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B …
## 7 7 "---------------------------------------------------------------------…
## 8 8 " 2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 1…
## 9 9 " MI | 14598900 / R: 1553 ->1663 |N:2 |B |W |B |W …
## 10 10 "---------------------------------------------------------------------…
## # ℹ 186 more rowsIt’s clear that lines [1, 4, 7, 10 …] in this sequence are not useful, so let’s remove them.
lines_to_remove <- seq(1, num_lines, by = 3)
filtered_chess_text_df <- chess_text_df %>% filter(!line %in% lines_to_remove)
print(filtered_chess_text_df)## # A tibble: 130 × 2
## line text
## <int> <chr>
## 1 2 " Pair | Player Name |Total|Round|Round|Round|Roun…
## 2 3 " Num | USCF ID / Rtg (Pre->Post) | Pts | 1 | 2 | 3 | 4 …
## 3 5 " 1 | GARY HUA |6.0 |W 39|W 21|W 18|W 1…
## 4 6 " ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B …
## 5 8 " 2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 1…
## 6 9 " MI | 14598900 / R: 1553 ->1663 |N:2 |B |W |B |W …
## 7 11 " 3 | ADITYA BAJAJ |6.0 |L 8|W 61|W 25|W 2…
## 8 12 " MI | 14959604 / R: 1384 ->1640 |N:2 |W |B |W |B …
## 9 14 " 4 | PATRICK H SCHILLING |5.5 |W 23|D 28|W 2|W 2…
## 10 15 " MI | 12616049 / R: 1716 ->1744 |N:2 |W |B |W |B …
## # ℹ 120 more rowsIt appears the first two lines serve as the header for our dataframe. Let’s try using the unnest_tokens() function to convert our messy string into ‘word’ tokens and see if we can make it more manageable.
install.packages("tidytext")##
## The downloaded binary packages are in
## /var/folders/s3/v3s06grs4td_hm4kgmt3q2ww0000gn/T//RtmpxyG5D5/downloaded_packageslibrary(tidytext)
library(tidyverse)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ forcats 1.0.0 ✔ purrr 1.0.2
## ✔ ggplot2 3.5.1 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ tidyr 1.3.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errorstoken_chess_text_df <- filtered_chess_text_df %>% unnest_tokens(word, text)
print(token_chess_text_df)## # A tibble: 1,957 × 2
## line word
## <int> <chr>
## 1 2 pair
## 2 2 player
## 3 2 name
## 4 2 total
## 5 2 round
## 6 2 round
## 7 2 round
## 8 2 round
## 9 2 round
## 10 2 round
## # ℹ 1,947 more rowsIt seems there are no discernible patterns to automatically create a header, so let’s try to define it manually.
What we need:
These will correspond to the columns in our dataframe
column_names <- c("player_name", "player_state", "total_num_of_points", "player_pre_rating", "average_pre_chess_rating_of_opponent") #vector with names
print(column_names)## [1] "player_name"
## [2] "player_state"
## [3] "total_num_of_points"
## [4] "player_pre_rating"
## [5] "average_pre_chess_rating_of_opponent"our_chess_df <- data.frame(matrix(ncol = length(column_names), nrow = 0))
colnames(our_chess_df) <- column_names
print(our_chess_df)## [1] player_name player_state
## [3] total_num_of_points player_pre_rating
## [5] average_pre_chess_rating_of_opponent
## <0 rows> (or 0-length row.names)Let’s clean token_chess_text_df by removing the header data, as it’s no longer needed.
print(token_chess_text_df, n = 35)## # A tibble: 1,957 × 2
## line word
## <int> <chr>
## 1 2 pair
## 2 2 player
## 3 2 name
## 4 2 total
## 5 2 round
## 6 2 round
## 7 2 round
## 8 2 round
## 9 2 round
## 10 2 round
## 11 2 round
## 12 3 num
## 13 3 uscf
## 14 3 id
## 15 3 rtg
## 16 3 pre
## 17 3 post
## 18 3 pts
## 19 3 1
## 20 3 2
## 21 3 3
## 22 3 4
## 23 3 5
## 24 3 6
## 25 3 7
## 26 5 1
## 27 5 gary
## 28 5 hua
## 29 5 6.0
## 30 5 w
## 31 5 39
## 32 5 w
## 33 5 21
## 34 5 w
## 35 5 18
## # ℹ 1,922 more rowstoken_chess_text_df <- token_chess_text_df[!token_chess_text_df$line %in% c(2, 3), ]
print(token_chess_text_df, n = 100)## # A tibble: 1,932 × 2
## line word
## <int> <chr>
## 1 5 1
## 2 5 gary
## 3 5 hua
## 4 5 6.0
## 5 5 w
## 6 5 39
## 7 5 w
## 8 5 21
## 9 5 w
## 10 5 18
## 11 5 w
## 12 5 14
## 13 5 w
## 14 5 7
## 15 5 d
## 16 5 12
## 17 5 d
## 18 5 4
## 19 6 on
## 20 6 15445895
## 21 6 r
## 22 6 1794
## 23 6 1817
## 24 6 n
## 25 6 2
## 26 6 w
## 27 6 b
## 28 6 w
## 29 6 b
## 30 6 w
## 31 6 b
## 32 6 w
## 33 8 2
## 34 8 dakshesh
## 35 8 daruri
## 36 8 6.0
## 37 8 w
## 38 8 63
## 39 8 w
## 40 8 58
## 41 8 l
## 42 8 4
## 43 8 w
## 44 8 17
## 45 8 w
## 46 8 16
## 47 8 w
## 48 8 20
## 49 8 w
## 50 8 7
## 51 9 mi
## 52 9 14598900
## 53 9 r
## 54 9 1553
## 55 9 1663
## 56 9 n
## 57 9 2
## 58 9 b
## 59 9 w
## 60 9 b
## 61 9 w
## 62 9 b
## 63 9 w
## 64 9 b
## 65 11 3
## 66 11 aditya
## 67 11 bajaj
## 68 11 6.0
## 69 11 l
## 70 11 8
## 71 11 w
## 72 11 61
## 73 11 w
## 74 11 25
## 75 11 w
## 76 11 21
## 77 11 w
## 78 11 11
## 79 11 w
## 80 11 13
## 81 11 w
## 82 11 12
## 83 12 mi
## 84 12 14959604
## 85 12 r
## 86 12 1384
## 87 12 1640
## 88 12 n
## 89 12 2
## 90 12 w
## 91 12 b
## 92 12 w
## 93 12 b
## 94 12 w
## 95 12 b
## 96 12 w
## 97 14 4
## 98 14 patrick
## 99 14 h
## 100 14 schilling
## # ℹ 1,832 more rowsAha, it seems we need an additional column named opponent to store information about the opponent, and an id column to uniquely identify each player.
column_names <- c("id", "player_name", "player_state", "total_num_of_points", "player_pre_rating", "opponent")
print(column_names)## [1] "id" "player_name" "player_state"
## [4] "total_num_of_points" "player_pre_rating" "opponent"our_chess_df <- data.frame(matrix(ncol = length(column_names), nrow = 0))
colnames(our_chess_df) <- column_namesNow, let’s loop over the dataframe to extract and populate data for each player
start_lines <- seq(5, max(token_chess_text_df$line), by = 3)
print(start_lines) #start of each new player## [1] 5 8 11 14 17 20 23 26 29 32 35 38 41 44 47 50 53 56 59
## [20] 62 65 68 71 74 77 80 83 86 89 92 95 98 101 104 107 110 113 116
## [39] 119 122 125 128 131 134 137 140 143 146 149 152 155 158 161 164 167 170 173
## [58] 176 179 182 185 188 191 194id_counter <- 1
for (line in start_lines) {
print(line)
player_name <- paste(token_chess_text_df$word[token_chess_text_df$line == line][2:3], collapse = " ")
print(player_name)
player_state <- token_chess_text_df$word[token_chess_text_df$line == line + 1][1]
print(player_state)
total_num_of_points <- token_chess_text_df$word[token_chess_text_df$line == line + 3][4]
print(total_num_of_points)
player_pre_rating <- token_chess_text_df$word[token_chess_text_df$line == line + 1][4]
print(player_pre_rating)
opponent_indices <- seq(6, length(token_chess_text_df$word[token_chess_text_df$line == line]), by = 2)
print(opponent_indices)
opponent <- paste(token_chess_text_df$word[token_chess_text_df$line == line][opponent_indices], collapse = ", ")
print(opponent)
our_chess_df <- rbind(our_chess_df, data.frame(
id = id_counter,
player_name = player_name,
player_state = player_state,
total_num_of_points = total_num_of_points,
player_pre_rating = player_pre_rating,
opponent = as.character(opponent), # Ensure string
stringsAsFactors = FALSE
))
id_counter <- id_counter + 1
}## [1] 5
## [1] "gary hua"
## [1] "on"
## [1] "6.0"
## [1] "1794"
## [1] 6 8 10 12 14 16 18
## [1] "39, 21, 18, 14, 7, 12, 4"
## [1] 8
## [1] "dakshesh daruri"
## [1] "mi"
## [1] "6.0"
## [1] "1553"
## [1] 6 8 10 12 14 16 18
## [1] "63, 58, 4, 17, 16, 20, 7"
## [1] 11
## [1] "aditya bajaj"
## [1] "mi"
## [1] "schilling"
## [1] "1384"
## [1] 6 8 10 12 14 16 18
## [1] "8, 61, 25, 21, 11, 13, 12"
## [1] 14
## [1] "patrick h"
## [1] "mi"
## [1] "5.5"
## [1] "1716"
## [1] 6 8 10 12 14 16 18
## [1] "w, d, w, w, d, w, d"
## [1] 17
## [1] "hanshi zuo"
## [1] "mi"
## [1] "5.0"
## [1] "1655"
## [1] 6 8 10 12 14 16 18
## [1] "45, 37, 12, 13, 4, 14, 17"
## [1] 20
## [1] "hansen song"
## [1] "oh"
## [1] "swathell"
## [1] "1686"
## [1] 6 8 10 12 14 16 18
## [1] "34, 29, 11, 35, 10, 27, 21"
## [1] 23
## [1] "gary dee"
## [1] "mi"
## [1] "5.0"
## [1] "1649"
## [1] 6 8 10 12 14 16 18
## [1] "w, w, w, w, l, w, l"
## [1] 26
## [1] "ezekiel houghton"
## [1] "mi"
## [1] "5.0"
## [1] "1641p17"
## [1] 6 8 10 12 14 16 18
## [1] "3, 32, 14, 9, 47, 28, 19"
## [1] 29
## [1] "stefano lee"
## [1] "on"
## [1] "5.0"
## [1] "1411"
## [1] 6 8 10 12 14 16 18
## [1] "25, 18, 59, 8, 26, 7, 20"
## [1] 32
## [1] "anvit rao"
## [1] "mi"
## [1] "mc"
## [1] "1365"
## [1] 6 8 10 12 14 16 18
## [1] "16, 19, 55, 31, 6, 25, 18"
## [1] 35
## [1] "cameron william"
## [1] "mi"
## [1] "tack"
## [1] "1712"
## [1] 6 8 10 12 14 16 18 20
## [1] "4.5, 38, 56, 6, 7, 3, 34, 26"
## [1] 38
## [1] "kenneth j"
## [1] "mi"
## [1] "jr"
## [1] "1663"
## [1] 6 8 10 12 14 16 18
## [1] "w, w, d, w, h, 1, 3"
## [1] 41
## [1] "torrance henry"
## [1] "mi"
## [1] "4.5"
## [1] "1666"
## [1] 6 8 10 12 14 16 18
## [1] "w, w, l, d, w, l, w"
## [1] 44
## [1] "bradley shaw"
## [1] "mi"
## [1] "houghton"
## [1] "1610"
## [1] 6 8 10 12 14 16 18
## [1] "54, 44, 8, 1, 27, 5, 31"
## [1] 47
## [1] "zachary james"
## [1] "mi"
## [1] "4.0"
## [1] "1220p13"
## [1] 6 8 10 12 14 16 18
## [1] "d, l, w, l, w, w, w"
## [1] 50
## [1] "mike nikitin"
## [1] "mi"
## [1] "4.0"
## [1] "1604"
## [1] 6 8 10 12 14 16
## [1] "10, 15, w, l, w, u"
## [1] 53
## [1] "ronald grzegorczyk"
## [1] "mi"
## [1] "4.0"
## [1] "1629"
## [1] 6 8 10 12 14 16 18
## [1] "48, 41, 26, 2, 23, 22, 5"
## [1] 56
## [1] "david sundeen"
## [1] "mi"
## [1] "4.0"
## [1] "1600"
## [1] 6 8 10 12 14 16 18
## [1] "47, 9, 1, 32, 19, 38, 10"
## [1] 59
## [1] "dipankar roy"
## [1] "mi"
## [1] "4.0"
## [1] "1564"
## [1] 6 8 10 12 14 16 18
## [1] "15, 10, 52, 28, 18, 4, 8"
## [1] 62
## [1] "jason zheng"
## [1] "mi"
## [1] "bui"
## [1] "1595"
## [1] 6 8 10 12 14 16 18
## [1] "40, 49, 23, 41, 28, 2, 9"
## [1] 65
## [1] "dinh dang"
## [1] "on"
## [1] "mcclure"
## [1] "1563p22"
## [1] 6 8 10 12 14 16 18
## [1] "w, l, w, l, w, w, l"
## [1] 68
## [1] "eugene l"
## [1] "mi"
## [1] "4.0"
## [1] "1555"
## [1] 6 8 10 12 14 16 18
## [1] "w, d, l, w, h, 17, 40"
## [1] 71
## [1] "alan bui"
## [1] "on"
## [1] "aldrich"
## [1] "1363"
## [1] 6 8 10 12 14 16 18
## [1] "4, 43, 20, 58, 17, 37, 46"
## [1] 74
## [1] "michael r"
## [1] "mi"
## [1] "3.5"
## [1] "1229"
## [1] 6 8 10 12 14 16 18
## [1] "l, l, w, l, w, w, w"
## [1] 77
## [1] "loren schwiebert"
## [1] "mi"
## [1] "3.5"
## [1] "1745"
## [1] 6 8 10 12 14 16 18
## [1] "9, 53, 3, 24, 34, 10, 47"
## [1] 80
## [1] "max zhu"
## [1] "on"
## [1] "3.5"
## [1] "1579"
## [1] 6 8 10 12 14 16 18
## [1] "49, 40, 17, 4, 9, 32, 11"
## [1] 83
## [1] "gaurav gidwani"
## [1] "mi"
## [1] "stanescu"
## [1] "1552"
## [1] 6 8 10 12 14 16
## [1] "51, 13, 46, 37, 14, 6"
## [1] 86
## [1] "sofia adina"
## [1] "mi"
## [1] "3.5"
## [1] "1507"
## [1] 6 8 10 12 14 16 18 20
## [1] "3.5, 24, 4, 22, 19, 20, 8, 36"
## [1] 89
## [1] "chiedozie okorie"
## [1] "mi"
## [1] "jones"
## [1] "1602p6"
## [1] 6 8 10 12 14 16
## [1] "50, 6, 38, 34, 52, 48"
## [1] 92
## [1] "george avery"
## [1] "on"
## [1] "3.5"
## [1] "1522"
## [1] 6 8 10 12 14 16 18
## [1] "l, d, l, w, l, w, w"
## [1] 95
## [1] "rishi shetty"
## [1] "mi"
## [1] "mathews"
## [1] "1494"
## [1] 6 8 10 12 14 16 18
## [1] "58, 55, 64, 10, 30, 50, 14"
## [1] 98
## [1] "joshua philip"
## [1] "on"
## [1] "3.5"
## [1] "1441"
## [1] 6 8 10 12 14 16 18
## [1] "w, l, w, l, w, d, l"
## [1] 101
## [1] "jade ge"
## [1] "mi"
## [1] "thomas"
## [1] "1449"
## [1] 6 8 10 12 14 16 18
## [1] "60, 12, 50, 36, 13, 15, 51"
## [1] 104
## [1] "michael jeffery"
## [1] "mi"
## [1] "lee"
## [1] "1399"
## [1] 6 8 10 12 14 16 18
## [1] "l, w, l, w, d, l, w"
## [1] 107
## [1] "joshua david"
## [1] "mi"
## [1] "3.5"
## [1] "1438"
## [1] 6 8 10 12 14 16 18
## [1] "l, l, w, l, w, d, w"
## [1] 110
## [1] "siddharth jha"
## [1] "mi"
## [1] "3.5"
## [1] "1355"
## [1] 6 8 10 12 14 16
## [1] "13, 57, 51, 33, l, d"
## [1] 113
## [1] "amiyatosh pwnanandam"
## [1] "mi"
## [1] "3.0"
## [1] "980p12"
## [1] 6 8 10 12 14 16
## [1] "l, w, l, h, 23, 61"
## [1] 116
## [1] "brian liu"
## [1] "mi"
## [1] "hendon"
## [1] "1423"
## [1] 6 8 10 12 14 16
## [1] "11, 35, 29, 12, l, l"
## [1] 119
## [1] "joel r"
## [1] "mi"
## [1] "3.0"
## [1] "1436p23"
## [1] 6 8 10 12 14 16 18
## [1] "l, w, w, l, w, l, l"
## [1] 122
## [1] "forest zhang"
## [1] "mi"
## [1] "murphy"
## [1] "1348"
## [1] 6 8 10 12 14 16 18
## [1] "20, 26, 39, 59, 21, 56, 22"
## [1] 125
## [1] "kyle william"
## [1] "mi"
## [1] "3.0"
## [1] "1403p5"
## [1] 6 8 10 12 14 16
## [1] "w, l, w, l, x, u"
## [1] 128
## [1] "jared ge"
## [1] "mi"
## [1] "vasey"
## [1] "1332"
## [1] 6 8 10 12 14 16 18
## [1] "12, 50, 57, 60, 61, 64, 56"
## [1] 131
## [1] "robert glen"
## [1] "mi"
## [1] "schilling"
## [1] "1283"
## [1] 6 8 10 12 14 16 18
## [1] "l, l, l, w, w, l, w"
## [1] 134
## [1] "justin d"
## [1] "mi"
## [1] "3.0"
## [1] "1199"
## [1] 6 8 10 12 14 16 18
## [1] "b, 14, 32, 53, 39, 24, 59"
## [1] 137
## [1] "derek yan"
## [1] "mi"
## [1] "lavalley"
## [1] "1242"
## [1] 6 8 10 12 14 16 18
## [1] "5, 51, 60, 56, 63, 55, 58"
## [1] 140
## [1] "jacob alexander"
## [1] "mi"
## [1] "2.5"
## [1] "377p3"
## [1] 6 8 10 12 14 16 18
## [1] "w, l, l, l, w, w, l"
## [1] 143
## [1] "eric wright"
## [1] "mi"
## [1] "2.5"
## [1] "1362"
## [1] 6 8 10 12 14 16 18
## [1] "18, 24, 21, 61, 8, 51, 25"
## [1] 146
## [1] "daniel khain"
## [1] "mi"
## [1] "martin"
## [1] "1382"
## [1] 6 8 10 12 14 16
## [1] "17, 63, d, h, 29, 35"
## [1] 149
## [1] "michael j"
## [1] "mi"
## [1] "2.5"
## [1] "1291p12"
## [1] 6 8 10 12 14 16
## [1] "l, l, d, d, w, h"
## [1] 152
## [1] "shivam jha"
## [1] "mi"
## [1] "2.5"
## [1] "1056"
## [1] 6 8 10 12 14 16
## [1] "29, 42, 33, 46, l, l"
## [1] 155
## [1] "tejas ayyagari"
## [1] "mi"
## [1] "2.5"
## [1] "1011"
## [1] 6 8 10 12 14 16 18
## [1] "27, 45, 36, 57, 32, 47, 33"
## [1] 158
## [1] "ethan guo"
## [1] "mi"
## [1] "ybarra"
## [1] "935"
## [1] 6 8 10 12 14 16 18
## [1] "30, 22, 19, 48, 29, 35, 34"
## [1] 161
## [1] "jose c"
## [1] "mi"
## [1] "2.0"
## [1] "1393"
## [1] 6 8 10 12 14
## [1] "h, 25, l, u, 57"
## [1] 164
## [1] "larry hodge"
## [1] "mi"
## [1] "2.0"
## [1] "1270"
## [1] 6 8 10 12 14 16
## [1] "14, 39, 61, l, l, w"
## [1] 167
## [1] "alex kong"
## [1] "mi"
## [1] "2.0"
## [1] "1186"
## [1] 6 8 10 12 14 16
## [1] "62, 31, 10, 30, d, l"
## [1] 170
## [1] "marisa ricci"
## [1] "mi"
## [1] "2.0"
## [1] "1153"
## [1] 6 8 10 12 14 16
## [1] "l, l, w, h, 40, 42"
## [1] 173
## [1] "michael lu"
## [1] "mi"
## [1] "2.0"
## [1] "1092"
## [1] 6 8 10 12 14 16
## [1] "7, 36, 42, 51, 35, 53"
## [1] 176
## [1] "viraj mohile"
## [1] "mi"
## [1] "mc"
## [1] "917"
## [1] 6 8 10 12 14 16
## [1] "31, 2, 41, 23, 49, l"
## [1] 179
## [1] "sean m"
## [1] "mi"
## [1] "1.5"
## [1] "853"
## [1] 6 8 10 12 14 16 18
## [1] "2.0, 41, l, l, l, w, l"
## [1] 182
## [1] "julia shen"
## [1] "mi"
## [1] "1.5"
## [1] "967"
## [1] 6 8 10 12 14 16
## [1] "33, 34, 45, 42, 24, u"
## [1] 185
## [1] "jezzel farkas"
## [1] "on"
## [1] "1.0"
## [1] "955p11"
## [1] 6 8 10 12 14 16 18
## [1] "32, 3, 54, 47, 42, 30, 37"
## [1] 188
## [1] "ashwin balaji"
## [1] "mi"
## [1] "hosmer"
## [1] "1530"
## [1] 6 8 10 12
## [1] "55, u, u, u"
## [1] 191
## [1] "thomas joseph"
## [1] "mi"
## [1] "1.0"
## [1] "1175"
## [1] 6 8 10 12 14 16
## [1] "l, l, d, l, l, h"
## [1] 194
## [1] "ben li"
## [1] "mi"
## [1] NA
## [1] "1163"
## [1] 6 8 10 12 14 16 18
## [1] "22, 30, 31, 49, 46, 42, 54"print(our_chess_df)## id player_name player_state total_num_of_points player_pre_rating
## 1 1 gary hua on 6.0 1794
## 2 2 dakshesh daruri mi 6.0 1553
## 3 3 aditya bajaj mi schilling 1384
## 4 4 patrick h mi 5.5 1716
## 5 5 hanshi zuo mi 5.0 1655
## 6 6 hansen song oh swathell 1686
## 7 7 gary dee mi 5.0 1649
## 8 8 ezekiel houghton mi 5.0 1641p17
## 9 9 stefano lee on 5.0 1411
## 10 10 anvit rao mi mc 1365
## 11 11 cameron william mi tack 1712
## 12 12 kenneth j mi jr 1663
## 13 13 torrance henry mi 4.5 1666
## 14 14 bradley shaw mi houghton 1610
## 15 15 zachary james mi 4.0 1220p13
## 16 16 mike nikitin mi 4.0 1604
## 17 17 ronald grzegorczyk mi 4.0 1629
## 18 18 david sundeen mi 4.0 1600
## 19 19 dipankar roy mi 4.0 1564
## 20 20 jason zheng mi bui 1595
## 21 21 dinh dang on mcclure 1563p22
## 22 22 eugene l mi 4.0 1555
## 23 23 alan bui on aldrich 1363
## 24 24 michael r mi 3.5 1229
## 25 25 loren schwiebert mi 3.5 1745
## 26 26 max zhu on 3.5 1579
## 27 27 gaurav gidwani mi stanescu 1552
## 28 28 sofia adina mi 3.5 1507
## 29 29 chiedozie okorie mi jones 1602p6
## 30 30 george avery on 3.5 1522
## 31 31 rishi shetty mi mathews 1494
## 32 32 joshua philip on 3.5 1441
## 33 33 jade ge mi thomas 1449
## 34 34 michael jeffery mi lee 1399
## 35 35 joshua david mi 3.5 1438
## 36 36 siddharth jha mi 3.5 1355
## 37 37 amiyatosh pwnanandam mi 3.0 980p12
## 38 38 brian liu mi hendon 1423
## 39 39 joel r mi 3.0 1436p23
## 40 40 forest zhang mi murphy 1348
## 41 41 kyle william mi 3.0 1403p5
## 42 42 jared ge mi vasey 1332
## 43 43 robert glen mi schilling 1283
## 44 44 justin d mi 3.0 1199
## 45 45 derek yan mi lavalley 1242
## 46 46 jacob alexander mi 2.5 377p3
## 47 47 eric wright mi 2.5 1362
## 48 48 daniel khain mi martin 1382
## 49 49 michael j mi 2.5 1291p12
## 50 50 shivam jha mi 2.5 1056
## 51 51 tejas ayyagari mi 2.5 1011
## 52 52 ethan guo mi ybarra 935
## 53 53 jose c mi 2.0 1393
## 54 54 larry hodge mi 2.0 1270
## 55 55 alex kong mi 2.0 1186
## 56 56 marisa ricci mi 2.0 1153
## 57 57 michael lu mi 2.0 1092
## 58 58 viraj mohile mi mc 917
## 59 59 sean m mi 1.5 853
## 60 60 julia shen mi 1.5 967
## 61 61 jezzel farkas on 1.0 955p11
## 62 62 ashwin balaji mi hosmer 1530
## 63 63 thomas joseph mi 1.0 1175
## 64 64 ben li mi <NA> 1163
## opponent
## 1 39, 21, 18, 14, 7, 12, 4
## 2 63, 58, 4, 17, 16, 20, 7
## 3 8, 61, 25, 21, 11, 13, 12
## 4 w, d, w, w, d, w, d
## 5 45, 37, 12, 13, 4, 14, 17
## 6 34, 29, 11, 35, 10, 27, 21
## 7 w, w, w, w, l, w, l
## 8 3, 32, 14, 9, 47, 28, 19
## 9 25, 18, 59, 8, 26, 7, 20
## 10 16, 19, 55, 31, 6, 25, 18
## 11 4.5, 38, 56, 6, 7, 3, 34, 26
## 12 w, w, d, w, h, 1, 3
## 13 w, w, l, d, w, l, w
## 14 54, 44, 8, 1, 27, 5, 31
## 15 d, l, w, l, w, w, w
## 16 10, 15, w, l, w, u
## 17 48, 41, 26, 2, 23, 22, 5
## 18 47, 9, 1, 32, 19, 38, 10
## 19 15, 10, 52, 28, 18, 4, 8
## 20 40, 49, 23, 41, 28, 2, 9
## 21 w, l, w, l, w, w, l
## 22 w, d, l, w, h, 17, 40
## 23 4, 43, 20, 58, 17, 37, 46
## 24 l, l, w, l, w, w, w
## 25 9, 53, 3, 24, 34, 10, 47
## 26 49, 40, 17, 4, 9, 32, 11
## 27 51, 13, 46, 37, 14, 6
## 28 3.5, 24, 4, 22, 19, 20, 8, 36
## 29 50, 6, 38, 34, 52, 48
## 30 l, d, l, w, l, w, w
## 31 58, 55, 64, 10, 30, 50, 14
## 32 w, l, w, l, w, d, l
## 33 60, 12, 50, 36, 13, 15, 51
## 34 l, w, l, w, d, l, w
## 35 l, l, w, l, w, d, w
## 36 13, 57, 51, 33, l, d
## 37 l, w, l, h, 23, 61
## 38 11, 35, 29, 12, l, l
## 39 l, w, w, l, w, l, l
## 40 20, 26, 39, 59, 21, 56, 22
## 41 w, l, w, l, x, u
## 42 12, 50, 57, 60, 61, 64, 56
## 43 l, l, l, w, w, l, w
## 44 b, 14, 32, 53, 39, 24, 59
## 45 5, 51, 60, 56, 63, 55, 58
## 46 w, l, l, l, w, w, l
## 47 18, 24, 21, 61, 8, 51, 25
## 48 17, 63, d, h, 29, 35
## 49 l, l, d, d, w, h
## 50 29, 42, 33, 46, l, l
## 51 27, 45, 36, 57, 32, 47, 33
## 52 30, 22, 19, 48, 29, 35, 34
## 53 h, 25, l, u, 57
## 54 14, 39, 61, l, l, w
## 55 62, 31, 10, 30, d, l
## 56 l, l, w, h, 40, 42
## 57 7, 36, 42, 51, 35, 53
## 58 31, 2, 41, 23, 49, l
## 59 2.0, 41, l, l, l, w, l
## 60 33, 34, 45, 42, 24, u
## 61 32, 3, 54, 47, 42, 30, 37
## 62 55, u, u, u
## 63 l, l, d, l, l, h
## 64 22, 30, 31, 49, 46, 42, 54Well, as we can see, the following logic does not work because some people have their middle names listed.
Let’s explore other options. I’d like to keep the header setup unchanged, as I don’t see an alternative way to define it.
chess_text <- c(chess_lines)
print(chess_text)## [1] "-----------------------------------------------------------------------------------------"
## [2] " Pair | Player Name |Total|Round|Round|Round|Round|Round|Round|Round| "
## [3] " Num | USCF ID / Rtg (Pre->Post) | Pts | 1 | 2 | 3 | 4 | 5 | 6 | 7 | "
## [4] "-----------------------------------------------------------------------------------------"
## [5] " 1 | GARY HUA |6.0 |W 39|W 21|W 18|W 14|W 7|D 12|D 4|"
## [6] " ON | 15445895 / R: 1794 ->1817 |N:2 |W |B |W |B |W |B |W |"
## [7] "-----------------------------------------------------------------------------------------"
## [8] " 2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 17|W 16|W 20|W 7|"
## [9] " MI | 14598900 / R: 1553 ->1663 |N:2 |B |W |B |W |B |W |B |"
## [10] "-----------------------------------------------------------------------------------------"
## [11] " 3 | ADITYA BAJAJ |6.0 |L 8|W 61|W 25|W 21|W 11|W 13|W 12|"
## [12] " MI | 14959604 / R: 1384 ->1640 |N:2 |W |B |W |B |W |B |W |"
## [13] "-----------------------------------------------------------------------------------------"
## [14] " 4 | PATRICK H SCHILLING |5.5 |W 23|D 28|W 2|W 26|D 5|W 19|D 1|"
## [15] " MI | 12616049 / R: 1716 ->1744 |N:2 |W |B |W |B |W |B |B |"
## [16] "-----------------------------------------------------------------------------------------"
## [17] " 5 | HANSHI ZUO |5.5 |W 45|W 37|D 12|D 13|D 4|W 14|W 17|"
## [18] " MI | 14601533 / R: 1655 ->1690 |N:2 |B |W |B |W |B |W |B |"
## [19] "-----------------------------------------------------------------------------------------"
## [20] " 6 | HANSEN SONG |5.0 |W 34|D 29|L 11|W 35|D 10|W 27|W 21|"
## [21] " OH | 15055204 / R: 1686 ->1687 |N:3 |W |B |W |B |B |W |B |"
## [22] "-----------------------------------------------------------------------------------------"
## [23] " 7 | GARY DEE SWATHELL |5.0 |W 57|W 46|W 13|W 11|L 1|W 9|L 2|"
## [24] " MI | 11146376 / R: 1649 ->1673 |N:3 |W |B |W |B |B |W |W |"
## [25] "-----------------------------------------------------------------------------------------"
## [26] " 8 | EZEKIEL HOUGHTON |5.0 |W 3|W 32|L 14|L 9|W 47|W 28|W 19|"
## [27] " MI | 15142253 / R: 1641P17->1657P24 |N:3 |B |W |B |W |B |W |W |"
## [28] "-----------------------------------------------------------------------------------------"
## [29] " 9 | STEFANO LEE |5.0 |W 25|L 18|W 59|W 8|W 26|L 7|W 20|"
## [30] " ON | 14954524 / R: 1411 ->1564 |N:2 |W |B |W |B |W |B |B |"
## [31] "-----------------------------------------------------------------------------------------"
## [32] " 10 | ANVIT RAO |5.0 |D 16|L 19|W 55|W 31|D 6|W 25|W 18|"
## [33] " MI | 14150362 / R: 1365 ->1544 |N:3 |W |W |B |B |W |B |W |"
## [34] "-----------------------------------------------------------------------------------------"
## [35] " 11 | CAMERON WILLIAM MC LEMAN |4.5 |D 38|W 56|W 6|L 7|L 3|W 34|W 26|"
## [36] " MI | 12581589 / R: 1712 ->1696 |N:3 |B |W |B |W |B |W |B |"
## [37] "-----------------------------------------------------------------------------------------"
## [38] " 12 | KENNETH J TACK |4.5 |W 42|W 33|D 5|W 38|H |D 1|L 3|"
## [39] " MI | 12681257 / R: 1663 ->1670 |N:3 |W |B |W |B | |W |B |"
## [40] "-----------------------------------------------------------------------------------------"
## [41] " 13 | TORRANCE HENRY JR |4.5 |W 36|W 27|L 7|D 5|W 33|L 3|W 32|"
## [42] " MI | 15082995 / R: 1666 ->1662 |N:3 |B |W |B |B |W |W |B |"
## [43] "-----------------------------------------------------------------------------------------"
## [44] " 14 | BRADLEY SHAW |4.5 |W 54|W 44|W 8|L 1|D 27|L 5|W 31|"
## [45] " MI | 10131499 / R: 1610 ->1618 |N:3 |W |B |W |W |B |B |W |"
## [46] "-----------------------------------------------------------------------------------------"
## [47] " 15 | ZACHARY JAMES HOUGHTON |4.5 |D 19|L 16|W 30|L 22|W 54|W 33|W 38|"
## [48] " MI | 15619130 / R: 1220P13->1416P20 |N:3 |B |B |W |W |B |B |W |"
## [49] "-----------------------------------------------------------------------------------------"
## [50] " 16 | MIKE NIKITIN |4.0 |D 10|W 15|H |W 39|L 2|W 36|U |"
## [51] " MI | 10295068 / R: 1604 ->1613 |N:3 |B |W | |B |W |B | |"
## [52] "-----------------------------------------------------------------------------------------"
## [53] " 17 | RONALD GRZEGORCZYK |4.0 |W 48|W 41|L 26|L 2|W 23|W 22|L 5|"
## [54] " MI | 10297702 / R: 1629 ->1610 |N:3 |W |B |W |B |W |B |W |"
## [55] "-----------------------------------------------------------------------------------------"
## [56] " 18 | DAVID SUNDEEN |4.0 |W 47|W 9|L 1|W 32|L 19|W 38|L 10|"
## [57] " MI | 11342094 / R: 1600 ->1600 |N:3 |B |W |B |W |B |W |B |"
## [58] "-----------------------------------------------------------------------------------------"
## [59] " 19 | DIPANKAR ROY |4.0 |D 15|W 10|W 52|D 28|W 18|L 4|L 8|"
## [60] " MI | 14862333 / R: 1564 ->1570 |N:3 |W |B |W |B |W |W |B |"
## [61] "-----------------------------------------------------------------------------------------"
## [62] " 20 | JASON ZHENG |4.0 |L 40|W 49|W 23|W 41|W 28|L 2|L 9|"
## [63] " MI | 14529060 / R: 1595 ->1569 |N:4 |W |B |W |B |W |B |W |"
## [64] "-----------------------------------------------------------------------------------------"
## [65] " 21 | DINH DANG BUI |4.0 |W 43|L 1|W 47|L 3|W 40|W 39|L 6|"
## [66] " ON | 15495066 / R: 1563P22->1562 |N:3 |B |W |B |W |W |B |W |"
## [67] "-----------------------------------------------------------------------------------------"
## [68] " 22 | EUGENE L MCCLURE |4.0 |W 64|D 52|L 28|W 15|H |L 17|W 40|"
## [69] " MI | 12405534 / R: 1555 ->1529 |N:4 |W |B |W |B | |W |B |"
## [70] "-----------------------------------------------------------------------------------------"
## [71] " 23 | ALAN BUI |4.0 |L 4|W 43|L 20|W 58|L 17|W 37|W 46|"
## [72] " ON | 15030142 / R: 1363 ->1371 | |B |W |B |W |B |W |B |"
## [73] "-----------------------------------------------------------------------------------------"
## [74] " 24 | MICHAEL R ALDRICH |4.0 |L 28|L 47|W 43|L 25|W 60|W 44|W 39|"
## [75] " MI | 13469010 / R: 1229 ->1300 |N:4 |B |W |B |B |W |W |B |"
## [76] "-----------------------------------------------------------------------------------------"
## [77] " 25 | LOREN SCHWIEBERT |3.5 |L 9|W 53|L 3|W 24|D 34|L 10|W 47|"
## [78] " MI | 12486656 / R: 1745 ->1681 |N:4 |B |W |B |W |B |W |B |"
## [79] "-----------------------------------------------------------------------------------------"
## [80] " 26 | MAX ZHU |3.5 |W 49|W 40|W 17|L 4|L 9|D 32|L 11|"
## [81] " ON | 15131520 / R: 1579 ->1564 |N:4 |B |W |B |W |B |W |W |"
## [82] "-----------------------------------------------------------------------------------------"
## [83] " 27 | GAURAV GIDWANI |3.5 |W 51|L 13|W 46|W 37|D 14|L 6|U |"
## [84] " MI | 14476567 / R: 1552 ->1539 |N:4 |W |B |W |B |W |B | |"
## [85] "-----------------------------------------------------------------------------------------"
## [86] " 28 | SOFIA ADINA STANESCU-BELLU |3.5 |W 24|D 4|W 22|D 19|L 20|L 8|D 36|"
## [87] " MI | 14882954 / R: 1507 ->1513 |N:3 |W |W |B |W |B |B |W |"
## [88] "-----------------------------------------------------------------------------------------"
## [89] " 29 | CHIEDOZIE OKORIE |3.5 |W 50|D 6|L 38|L 34|W 52|W 48|U |"
## [90] " MI | 15323285 / R: 1602P6 ->1508P12 |N:4 |B |W |B |W |W |B | |"
## [91] "-----------------------------------------------------------------------------------------"
## [92] " 30 | GEORGE AVERY JONES |3.5 |L 52|D 64|L 15|W 55|L 31|W 61|W 50|"
## [93] " ON | 12577178 / R: 1522 ->1444 | |W |B |B |W |W |B |B |"
## [94] "-----------------------------------------------------------------------------------------"
## [95] " 31 | RISHI SHETTY |3.5 |L 58|D 55|W 64|L 10|W 30|W 50|L 14|"
## [96] " MI | 15131618 / R: 1494 ->1444 | |B |W |B |W |B |W |B |"
## [97] "-----------------------------------------------------------------------------------------"
## [98] " 32 | JOSHUA PHILIP MATHEWS |3.5 |W 61|L 8|W 44|L 18|W 51|D 26|L 13|"
## [99] " ON | 14073750 / R: 1441 ->1433 |N:4 |W |B |W |B |W |B |W |"
## [100] "-----------------------------------------------------------------------------------------"
## [101] " 33 | JADE GE |3.5 |W 60|L 12|W 50|D 36|L 13|L 15|W 51|"
## [102] " MI | 14691842 / R: 1449 ->1421 | |B |W |B |W |B |W |B |"
## [103] "-----------------------------------------------------------------------------------------"
## [104] " 34 | MICHAEL JEFFERY THOMAS |3.5 |L 6|W 60|L 37|W 29|D 25|L 11|W 52|"
## [105] " MI | 15051807 / R: 1399 ->1400 | |B |W |B |B |W |B |W |"
## [106] "-----------------------------------------------------------------------------------------"
## [107] " 35 | JOSHUA DAVID LEE |3.5 |L 46|L 38|W 56|L 6|W 57|D 52|W 48|"
## [108] " MI | 14601397 / R: 1438 ->1392 | |W |W |B |W |B |B |W |"
## [109] "-----------------------------------------------------------------------------------------"
## [110] " 36 | SIDDHARTH JHA |3.5 |L 13|W 57|W 51|D 33|H |L 16|D 28|"
## [111] " MI | 14773163 / R: 1355 ->1367 |N:4 |W |B |W |B | |W |B |"
## [112] "-----------------------------------------------------------------------------------------"
## [113] " 37 | AMIYATOSH PWNANANDAM |3.5 |B |L 5|W 34|L 27|H |L 23|W 61|"
## [114] " MI | 15489571 / R: 980P12->1077P17 | | |B |W |W | |B |W |"
## [115] "-----------------------------------------------------------------------------------------"
## [116] " 38 | BRIAN LIU |3.0 |D 11|W 35|W 29|L 12|H |L 18|L 15|"
## [117] " MI | 15108523 / R: 1423 ->1439 |N:4 |W |B |W |W | |B |B |"
## [118] "-----------------------------------------------------------------------------------------"
## [119] " 39 | JOEL R HENDON |3.0 |L 1|W 54|W 40|L 16|W 44|L 21|L 24|"
## [120] " MI | 12923035 / R: 1436P23->1413 |N:4 |B |W |B |W |B |W |W |"
## [121] "-----------------------------------------------------------------------------------------"
## [122] " 40 | FOREST ZHANG |3.0 |W 20|L 26|L 39|W 59|L 21|W 56|L 22|"
## [123] " MI | 14892710 / R: 1348 ->1346 | |B |B |W |W |B |W |W |"
## [124] "-----------------------------------------------------------------------------------------"
## [125] " 41 | KYLE WILLIAM MURPHY |3.0 |W 59|L 17|W 58|L 20|X |U |U |"
## [126] " MI | 15761443 / R: 1403P5 ->1341P9 | |B |W |B |W | | | |"
## [127] "-----------------------------------------------------------------------------------------"
## [128] " 42 | JARED GE |3.0 |L 12|L 50|L 57|D 60|D 61|W 64|W 56|"
## [129] " MI | 14462326 / R: 1332 ->1256 | |B |W |B |B |W |W |B |"
## [130] "-----------------------------------------------------------------------------------------"
## [131] " 43 | ROBERT GLEN VASEY |3.0 |L 21|L 23|L 24|W 63|W 59|L 46|W 55|"
## [132] " MI | 14101068 / R: 1283 ->1244 | |W |B |W |W |B |B |W |"
## [133] "-----------------------------------------------------------------------------------------"
## [134] " 44 | JUSTIN D SCHILLING |3.0 |B |L 14|L 32|W 53|L 39|L 24|W 59|"
## [135] " MI | 15323504 / R: 1199 ->1199 | | |W |B |B |W |B |W |"
## [136] "-----------------------------------------------------------------------------------------"
## [137] " 45 | DEREK YAN |3.0 |L 5|L 51|D 60|L 56|W 63|D 55|W 58|"
## [138] " MI | 15372807 / R: 1242 ->1191 | |W |B |W |B |W |B |W |"
## [139] "-----------------------------------------------------------------------------------------"
## [140] " 46 | JACOB ALEXANDER LAVALLEY |3.0 |W 35|L 7|L 27|L 50|W 64|W 43|L 23|"
## [141] " MI | 15490981 / R: 377P3 ->1076P10 | |B |W |B |W |B |W |W |"
## [142] "-----------------------------------------------------------------------------------------"
## [143] " 47 | ERIC WRIGHT |2.5 |L 18|W 24|L 21|W 61|L 8|D 51|L 25|"
## [144] " MI | 12533115 / R: 1362 ->1341 | |W |B |W |B |W |B |W |"
## [145] "-----------------------------------------------------------------------------------------"
## [146] " 48 | DANIEL KHAIN |2.5 |L 17|W 63|H |D 52|H |L 29|L 35|"
## [147] " MI | 14369165 / R: 1382 ->1335 | |B |W | |B | |W |B |"
## [148] "-----------------------------------------------------------------------------------------"
## [149] " 49 | MICHAEL J MARTIN |2.5 |L 26|L 20|D 63|D 64|W 58|H |U |"
## [150] " MI | 12531685 / R: 1291P12->1259P17 | |W |W |B |W |B | | |"
## [151] "-----------------------------------------------------------------------------------------"
## [152] " 50 | SHIVAM JHA |2.5 |L 29|W 42|L 33|W 46|H |L 31|L 30|"
## [153] " MI | 14773178 / R: 1056 ->1111 | |W |B |W |B | |B |W |"
## [154] "-----------------------------------------------------------------------------------------"
## [155] " 51 | TEJAS AYYAGARI |2.5 |L 27|W 45|L 36|W 57|L 32|D 47|L 33|"
## [156] " MI | 15205474 / R: 1011 ->1097 | |B |W |B |W |B |W |W |"
## [157] "-----------------------------------------------------------------------------------------"
## [158] " 52 | ETHAN GUO |2.5 |W 30|D 22|L 19|D 48|L 29|D 35|L 34|"
## [159] " MI | 14918803 / R: 935 ->1092 |N:4 |B |W |B |W |B |W |B |"
## [160] "-----------------------------------------------------------------------------------------"
## [161] " 53 | JOSE C YBARRA |2.0 |H |L 25|H |L 44|U |W 57|U |"
## [162] " MI | 12578849 / R: 1393 ->1359 | | |B | |W | |W | |"
## [163] "-----------------------------------------------------------------------------------------"
## [164] " 54 | LARRY HODGE |2.0 |L 14|L 39|L 61|B |L 15|L 59|W 64|"
## [165] " MI | 12836773 / R: 1270 ->1200 | |B |B |W | |W |B |W |"
## [166] "-----------------------------------------------------------------------------------------"
## [167] " 55 | ALEX KONG |2.0 |L 62|D 31|L 10|L 30|B |D 45|L 43|"
## [168] " MI | 15412571 / R: 1186 ->1163 | |W |B |W |B | |W |B |"
## [169] "-----------------------------------------------------------------------------------------"
## [170] " 56 | MARISA RICCI |2.0 |H |L 11|L 35|W 45|H |L 40|L 42|"
## [171] " MI | 14679887 / R: 1153 ->1140 | | |B |W |W | |B |W |"
## [172] "-----------------------------------------------------------------------------------------"
## [173] " 57 | MICHAEL LU |2.0 |L 7|L 36|W 42|L 51|L 35|L 53|B |"
## [174] " MI | 15113330 / R: 1092 ->1079 | |B |W |W |B |W |B | |"
## [175] "-----------------------------------------------------------------------------------------"
## [176] " 58 | VIRAJ MOHILE |2.0 |W 31|L 2|L 41|L 23|L 49|B |L 45|"
## [177] " MI | 14700365 / R: 917 -> 941 | |W |B |W |B |W | |B |"
## [178] "-----------------------------------------------------------------------------------------"
## [179] " 59 | SEAN M MC CORMICK |2.0 |L 41|B |L 9|L 40|L 43|W 54|L 44|"
## [180] " MI | 12841036 / R: 853 -> 878 | |W | |B |B |W |W |B |"
## [181] "-----------------------------------------------------------------------------------------"
## [182] " 60 | JULIA SHEN |1.5 |L 33|L 34|D 45|D 42|L 24|H |U |"
## [183] " MI | 14579262 / R: 967 -> 984 | |W |B |B |W |B | | |"
## [184] "-----------------------------------------------------------------------------------------"
## [185] " 61 | JEZZEL FARKAS |1.5 |L 32|L 3|W 54|L 47|D 42|L 30|L 37|"
## [186] " ON | 15771592 / R: 955P11-> 979P18 | |B |W |B |W |B |W |B |"
## [187] "-----------------------------------------------------------------------------------------"
## [188] " 62 | ASHWIN BALAJI |1.0 |W 55|U |U |U |U |U |U |"
## [189] " MI | 15219542 / R: 1530 ->1535 | |B | | | | | | |"
## [190] "-----------------------------------------------------------------------------------------"
## [191] " 63 | THOMAS JOSEPH HOSMER |1.0 |L 2|L 48|D 49|L 43|L 45|H |U |"
## [192] " MI | 15057092 / R: 1175 ->1125 | |W |B |W |B |B | | |"
## [193] "-----------------------------------------------------------------------------------------"
## [194] " 64 | BEN LI |1.0 |L 22|D 30|L 31|D 49|L 46|L 42|L 54|"
## [195] " MI | 15006561 / R: 1163 ->1112 | |B |W |W |B |W |B |B |"
## [196] "-----------------------------------------------------------------------------------------"column_names <- c("id", "player_name", "player_state", "total_num_of_points", "player_pre_rating", "opponent")
print(column_names)## [1] "id" "player_name" "player_state"
## [4] "total_num_of_points" "player_pre_rating" "opponent"our_chess_df <- data.frame(matrix(ncol = length(column_names), nrow = 0))
colnames(our_chess_df) <- column_names
# Let's split the raw data into new lines
lines <- unlist(strsplit(chess_lines, "\n"))
# Filter out the lines that contain player data by using regex pattern that is used to identify lines that begin with an optional whitespace, followed by a number, a space, and then a pipe character.
player_lines_one <- lines[grepl("^\\s*\\d+ \\|", lines)]
player_lines_two <- lines[grepl("^\\s*[A-Z]{2} \\|", lines)]
# Create a tibble from the player lines similar to the way we did before
player_tibble_one <- tibble(text = player_lines_one)
player_tibble_two <- tibble(text = player_lines_two)
## loop over each raw and get the information
for (i in seq(1, nrow(player_tibble_one), by = 1)) {
player_info_one <- unlist(strsplit(player_tibble_one$text[i], "\\|"))
print(player_info_one)
player_info_two <- unlist(strsplit(player_tibble_two$text[i], "\\|"))
print(player_info_two)
player_name <- player_info_one[2]
print(player_name)
player_state <- player_info_two[1]
print(player_state)
total_num_of_points <- player_info_one[3]
print(total_num_of_points)
player_pre_rating_dirty <- player_info_two[2]
pattern <- "R:\\s*(\\d{3,4})"
matches <- regmatches(player_pre_rating_dirty, regexec(pattern, player_pre_rating_dirty))
player_pre_rating <- as.integer(matches[[1]][2])
print(player_pre_rating)
pattern <- "[WD]\\s+(\\d+)"
matches <- regmatches(player_info_one, gregexpr(pattern, player_info_one))
opponent_one <- as.numeric(unlist(lapply(matches, function(x) gsub("[WD]\\s+", "", x))))
print(opponent_one)
pattern <- "[WD]\\s+(\\d+)"
matches <- regmatches(player_info_two, gregexpr(pattern, player_info_two))
opponent_two <- as.numeric(unlist(lapply(matches, function(x) gsub("[WD]\\s+", "", x))))
print(opponent_two)
opponent <- c(opponent_one, opponent_two)
print(opponent)
our_chess_df <- rbind(our_chess_df, data.frame(
id = player_info_one[1],
player_name = player_name,
player_state = player_state,
total_num_of_points = total_num_of_points,
player_pre_rating = player_pre_rating,
opponent = opponent,
stringsAsFactors = FALSE
))
}## [1] " 1 " " GARY HUA "
## [3] "6.0 " "W 39"
## [5] "W 21" "W 18"
## [7] "W 14" "W 7"
## [9] "D 12" "D 4"
## [1] " ON " " 15445895 / R: 1794 ->1817 "
## [3] "N:2 " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " "W "
## [1] " GARY HUA "
## [1] " ON "
## [1] "6.0 "
## [1] 1794
## [1] 39 21 18 14 7 12 4
## numeric(0)
## [1] 39 21 18 14 7 12 4
## [1] " 2 " " DAKSHESH DARURI "
## [3] "6.0 " "W 63"
## [5] "W 58" "L 4"
## [7] "W 17" "W 16"
## [9] "W 20" "W 7"
## [1] " MI " " 14598900 / R: 1553 ->1663 "
## [3] "N:2 " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " DAKSHESH DARURI "
## [1] " MI "
## [1] "6.0 "
## [1] 1553
## [1] 63 58 17 16 20 7
## numeric(0)
## [1] 63 58 17 16 20 7
## [1] " 3 " " ADITYA BAJAJ "
## [3] "6.0 " "L 8"
## [5] "W 61" "W 25"
## [7] "W 21" "W 11"
## [9] "W 13" "W 12"
## [1] " MI " " 14959604 / R: 1384 ->1640 "
## [3] "N:2 " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " "W "
## [1] " ADITYA BAJAJ "
## [1] " MI "
## [1] "6.0 "
## [1] 1384
## [1] 61 25 21 11 13 12
## numeric(0)
## [1] 61 25 21 11 13 12
## [1] " 4 " " PATRICK H SCHILLING "
## [3] "5.5 " "W 23"
## [5] "D 28" "W 2"
## [7] "W 26" "D 5"
## [9] "W 19" "D 1"
## [1] " MI " " 12616049 / R: 1716 ->1744 "
## [3] "N:2 " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " "B "
## [1] " PATRICK H SCHILLING "
## [1] " MI "
## [1] "5.5 "
## [1] 1716
## [1] 23 28 2 26 5 19 1
## numeric(0)
## [1] 23 28 2 26 5 19 1
## [1] " 5 " " HANSHI ZUO "
## [3] "5.5 " "W 45"
## [5] "W 37" "D 12"
## [7] "D 13" "D 4"
## [9] "W 14" "W 17"
## [1] " MI " " 14601533 / R: 1655 ->1690 "
## [3] "N:2 " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " HANSHI ZUO "
## [1] " MI "
## [1] "5.5 "
## [1] 1655
## [1] 45 37 12 13 4 14 17
## numeric(0)
## [1] 45 37 12 13 4 14 17
## [1] " 6 " " HANSEN SONG "
## [3] "5.0 " "W 34"
## [5] "D 29" "L 11"
## [7] "W 35" "D 10"
## [9] "W 27" "W 21"
## [1] " OH " " 15055204 / R: 1686 ->1687 "
## [3] "N:3 " "W "
## [5] "B " "W "
## [7] "B " "B "
## [9] "W " "B "
## [1] " HANSEN SONG "
## [1] " OH "
## [1] "5.0 "
## [1] 1686
## [1] 34 29 35 10 27 21
## numeric(0)
## [1] 34 29 35 10 27 21
## [1] " 7 " " GARY DEE SWATHELL "
## [3] "5.0 " "W 57"
## [5] "W 46" "W 13"
## [7] "W 11" "L 1"
## [9] "W 9" "L 2"
## [1] " MI " " 11146376 / R: 1649 ->1673 "
## [3] "N:3 " "W "
## [5] "B " "W "
## [7] "B " "B "
## [9] "W " "W "
## [1] " GARY DEE SWATHELL "
## [1] " MI "
## [1] "5.0 "
## [1] 1649
## [1] 57 46 13 11 9
## numeric(0)
## [1] 57 46 13 11 9
## [1] " 8 " " EZEKIEL HOUGHTON "
## [3] "5.0 " "W 3"
## [5] "W 32" "L 14"
## [7] "L 9" "W 47"
## [9] "W 28" "W 19"
## [1] " MI " " 15142253 / R: 1641P17->1657P24 "
## [3] "N:3 " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "W "
## [1] " EZEKIEL HOUGHTON "
## [1] " MI "
## [1] "5.0 "
## [1] 1641
## [1] 3 32 47 28 19
## numeric(0)
## [1] 3 32 47 28 19
## [1] " 9 " " STEFANO LEE "
## [3] "5.0 " "W 25"
## [5] "L 18" "W 59"
## [7] "W 8" "W 26"
## [9] "L 7" "W 20"
## [1] " ON " " 14954524 / R: 1411 ->1564 "
## [3] "N:2 " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " "B "
## [1] " STEFANO LEE "
## [1] " ON "
## [1] "5.0 "
## [1] 1411
## [1] 25 59 8 26 20
## numeric(0)
## [1] 25 59 8 26 20
## [1] " 10 " " ANVIT RAO "
## [3] "5.0 " "D 16"
## [5] "L 19" "W 55"
## [7] "W 31" "D 6"
## [9] "W 25" "W 18"
## [1] " MI " " 14150362 / R: 1365 ->1544 "
## [3] "N:3 " "W "
## [5] "W " "B "
## [7] "B " "W "
## [9] "B " "W "
## [1] " ANVIT RAO "
## [1] " MI "
## [1] "5.0 "
## [1] 1365
## [1] 16 55 31 6 25 18
## numeric(0)
## [1] 16 55 31 6 25 18
## [1] " 11 " " CAMERON WILLIAM MC LEMAN "
## [3] "4.5 " "D 38"
## [5] "W 56" "W 6"
## [7] "L 7" "L 3"
## [9] "W 34" "W 26"
## [1] " MI " " 12581589 / R: 1712 ->1696 "
## [3] "N:3 " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " CAMERON WILLIAM MC LEMAN "
## [1] " MI "
## [1] "4.5 "
## [1] 1712
## [1] 38 56 6 34 26
## numeric(0)
## [1] 38 56 6 34 26
## [1] " 12 " " KENNETH J TACK "
## [3] "4.5 " "W 42"
## [5] "W 33" "D 5"
## [7] "W 38" "H "
## [9] "D 1" "L 3"
## [1] " MI " " 12681257 / R: 1663 ->1670 "
## [3] "N:3 " "W "
## [5] "B " "W "
## [7] "B " " "
## [9] "W " "B "
## [1] " KENNETH J TACK "
## [1] " MI "
## [1] "4.5 "
## [1] 1663
## [1] 42 33 5 38 1
## numeric(0)
## [1] 42 33 5 38 1
## [1] " 13 " " TORRANCE HENRY JR "
## [3] "4.5 " "W 36"
## [5] "W 27" "L 7"
## [7] "D 5" "W 33"
## [9] "L 3" "W 32"
## [1] " MI " " 15082995 / R: 1666 ->1662 "
## [3] "N:3 " "B "
## [5] "W " "B "
## [7] "B " "W "
## [9] "W " "B "
## [1] " TORRANCE HENRY JR "
## [1] " MI "
## [1] "4.5 "
## [1] 1666
## [1] 36 27 5 33 32
## numeric(0)
## [1] 36 27 5 33 32
## [1] " 14 " " BRADLEY SHAW "
## [3] "4.5 " "W 54"
## [5] "W 44" "W 8"
## [7] "L 1" "D 27"
## [9] "L 5" "W 31"
## [1] " MI " " 10131499 / R: 1610 ->1618 "
## [3] "N:3 " "W "
## [5] "B " "W "
## [7] "W " "B "
## [9] "B " "W "
## [1] " BRADLEY SHAW "
## [1] " MI "
## [1] "4.5 "
## [1] 1610
## [1] 54 44 8 27 31
## numeric(0)
## [1] 54 44 8 27 31
## [1] " 15 " " ZACHARY JAMES HOUGHTON "
## [3] "4.5 " "D 19"
## [5] "L 16" "W 30"
## [7] "L 22" "W 54"
## [9] "W 33" "W 38"
## [1] " MI " " 15619130 / R: 1220P13->1416P20 "
## [3] "N:3 " "B "
## [5] "B " "W "
## [7] "W " "B "
## [9] "B " "W "
## [1] " ZACHARY JAMES HOUGHTON "
## [1] " MI "
## [1] "4.5 "
## [1] 1220
## [1] 19 30 54 33 38
## numeric(0)
## [1] 19 30 54 33 38
## [1] " 16 " " MIKE NIKITIN "
## [3] "4.0 " "D 10"
## [5] "W 15" "H "
## [7] "W 39" "L 2"
## [9] "W 36" "U "
## [1] " MI " " 10295068 / R: 1604 ->1613 "
## [3] "N:3 " "B "
## [5] "W " " "
## [7] "B " "W "
## [9] "B " " "
## [1] " MIKE NIKITIN "
## [1] " MI "
## [1] "4.0 "
## [1] 1604
## [1] 10 15 39 36
## numeric(0)
## [1] 10 15 39 36
## [1] " 17 " " RONALD GRZEGORCZYK "
## [3] "4.0 " "W 48"
## [5] "W 41" "L 26"
## [7] "L 2" "W 23"
## [9] "W 22" "L 5"
## [1] " MI " " 10297702 / R: 1629 ->1610 "
## [3] "N:3 " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " "W "
## [1] " RONALD GRZEGORCZYK "
## [1] " MI "
## [1] "4.0 "
## [1] 1629
## [1] 48 41 23 22
## numeric(0)
## [1] 48 41 23 22
## [1] " 18 " " DAVID SUNDEEN "
## [3] "4.0 " "W 47"
## [5] "W 9" "L 1"
## [7] "W 32" "L 19"
## [9] "W 38" "L 10"
## [1] " MI " " 11342094 / R: 1600 ->1600 "
## [3] "N:3 " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " DAVID SUNDEEN "
## [1] " MI "
## [1] "4.0 "
## [1] 1600
## [1] 47 9 32 38
## numeric(0)
## [1] 47 9 32 38
## [1] " 19 " " DIPANKAR ROY "
## [3] "4.0 " "D 15"
## [5] "W 10" "W 52"
## [7] "D 28" "W 18"
## [9] "L 4" "L 8"
## [1] " MI " " 14862333 / R: 1564 ->1570 "
## [3] "N:3 " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "W " "B "
## [1] " DIPANKAR ROY "
## [1] " MI "
## [1] "4.0 "
## [1] 1564
## [1] 15 10 52 28 18
## numeric(0)
## [1] 15 10 52 28 18
## [1] " 20 " " JASON ZHENG "
## [3] "4.0 " "L 40"
## [5] "W 49" "W 23"
## [7] "W 41" "W 28"
## [9] "L 2" "L 9"
## [1] " MI " " 14529060 / R: 1595 ->1569 "
## [3] "N:4 " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " "W "
## [1] " JASON ZHENG "
## [1] " MI "
## [1] "4.0 "
## [1] 1595
## [1] 49 23 41 28
## numeric(0)
## [1] 49 23 41 28
## [1] " 21 " " DINH DANG BUI "
## [3] "4.0 " "W 43"
## [5] "L 1" "W 47"
## [7] "L 3" "W 40"
## [9] "W 39" "L 6"
## [1] " ON " " 15495066 / R: 1563P22->1562 "
## [3] "N:3 " "B "
## [5] "W " "B "
## [7] "W " "W "
## [9] "B " "W "
## [1] " DINH DANG BUI "
## [1] " ON "
## [1] "4.0 "
## [1] 1563
## [1] 43 47 40 39
## numeric(0)
## [1] 43 47 40 39
## [1] " 22 " " EUGENE L MCCLURE "
## [3] "4.0 " "W 64"
## [5] "D 52" "L 28"
## [7] "W 15" "H "
## [9] "L 17" "W 40"
## [1] " MI " " 12405534 / R: 1555 ->1529 "
## [3] "N:4 " "W "
## [5] "B " "W "
## [7] "B " " "
## [9] "W " "B "
## [1] " EUGENE L MCCLURE "
## [1] " MI "
## [1] "4.0 "
## [1] 1555
## [1] 64 52 15 40
## numeric(0)
## [1] 64 52 15 40
## [1] " 23 " " ALAN BUI "
## [3] "4.0 " "L 4"
## [5] "W 43" "L 20"
## [7] "W 58" "L 17"
## [9] "W 37" "W 46"
## [1] " ON " " 15030142 / R: 1363 ->1371 "
## [3] " " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " ALAN BUI "
## [1] " ON "
## [1] "4.0 "
## [1] 1363
## [1] 43 58 37 46
## numeric(0)
## [1] 43 58 37 46
## [1] " 24 " " MICHAEL R ALDRICH "
## [3] "4.0 " "L 28"
## [5] "L 47" "W 43"
## [7] "L 25" "W 60"
## [9] "W 44" "W 39"
## [1] " MI " " 13469010 / R: 1229 ->1300 "
## [3] "N:4 " "B "
## [5] "W " "B "
## [7] "B " "W "
## [9] "W " "B "
## [1] " MICHAEL R ALDRICH "
## [1] " MI "
## [1] "4.0 "
## [1] 1229
## [1] 43 60 44 39
## numeric(0)
## [1] 43 60 44 39
## [1] " 25 " " LOREN SCHWIEBERT "
## [3] "3.5 " "L 9"
## [5] "W 53" "L 3"
## [7] "W 24" "D 34"
## [9] "L 10" "W 47"
## [1] " MI " " 12486656 / R: 1745 ->1681 "
## [3] "N:4 " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " LOREN SCHWIEBERT "
## [1] " MI "
## [1] "3.5 "
## [1] 1745
## [1] 53 24 34 47
## numeric(0)
## [1] 53 24 34 47
## [1] " 26 " " MAX ZHU "
## [3] "3.5 " "W 49"
## [5] "W 40" "W 17"
## [7] "L 4" "L 9"
## [9] "D 32" "L 11"
## [1] " ON " " 15131520 / R: 1579 ->1564 "
## [3] "N:4 " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "W "
## [1] " MAX ZHU "
## [1] " ON "
## [1] "3.5 "
## [1] 1579
## [1] 49 40 17 32
## numeric(0)
## [1] 49 40 17 32
## [1] " 27 " " GAURAV GIDWANI "
## [3] "3.5 " "W 51"
## [5] "L 13" "W 46"
## [7] "W 37" "D 14"
## [9] "L 6" "U "
## [1] " MI " " 14476567 / R: 1552 ->1539 "
## [3] "N:4 " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " " "
## [1] " GAURAV GIDWANI "
## [1] " MI "
## [1] "3.5 "
## [1] 1552
## [1] 51 46 37 14
## numeric(0)
## [1] 51 46 37 14
## [1] " 28 " " SOFIA ADINA STANESCU-BELLU "
## [3] "3.5 " "W 24"
## [5] "D 4" "W 22"
## [7] "D 19" "L 20"
## [9] "L 8" "D 36"
## [1] " MI " " 14882954 / R: 1507 ->1513 "
## [3] "N:3 " "W "
## [5] "W " "B "
## [7] "W " "B "
## [9] "B " "W "
## [1] " SOFIA ADINA STANESCU-BELLU "
## [1] " MI "
## [1] "3.5 "
## [1] 1507
## [1] 24 4 22 19 36
## numeric(0)
## [1] 24 4 22 19 36
## [1] " 29 " " CHIEDOZIE OKORIE "
## [3] "3.5 " "W 50"
## [5] "D 6" "L 38"
## [7] "L 34" "W 52"
## [9] "W 48" "U "
## [1] " MI " " 15323285 / R: 1602P6 ->1508P12 "
## [3] "N:4 " "B "
## [5] "W " "B "
## [7] "W " "W "
## [9] "B " " "
## [1] " CHIEDOZIE OKORIE "
## [1] " MI "
## [1] "3.5 "
## [1] 1602
## [1] 50 6 52 48
## numeric(0)
## [1] 50 6 52 48
## [1] " 30 " " GEORGE AVERY JONES "
## [3] "3.5 " "L 52"
## [5] "D 64" "L 15"
## [7] "W 55" "L 31"
## [9] "W 61" "W 50"
## [1] " ON " " 12577178 / R: 1522 ->1444 "
## [3] " " "W "
## [5] "B " "B "
## [7] "W " "W "
## [9] "B " "B "
## [1] " GEORGE AVERY JONES "
## [1] " ON "
## [1] "3.5 "
## [1] 1522
## [1] 64 55 61 50
## numeric(0)
## [1] 64 55 61 50
## [1] " 31 " " RISHI SHETTY "
## [3] "3.5 " "L 58"
## [5] "D 55" "W 64"
## [7] "L 10" "W 30"
## [9] "W 50" "L 14"
## [1] " MI " " 15131618 / R: 1494 ->1444 "
## [3] " " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " RISHI SHETTY "
## [1] " MI "
## [1] "3.5 "
## [1] 1494
## [1] 55 64 30 50
## numeric(0)
## [1] 55 64 30 50
## [1] " 32 " " JOSHUA PHILIP MATHEWS "
## [3] "3.5 " "W 61"
## [5] "L 8" "W 44"
## [7] "L 18" "W 51"
## [9] "D 26" "L 13"
## [1] " ON " " 14073750 / R: 1441 ->1433 "
## [3] "N:4 " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " "W "
## [1] " JOSHUA PHILIP MATHEWS "
## [1] " ON "
## [1] "3.5 "
## [1] 1441
## [1] 61 44 51 26
## numeric(0)
## [1] 61 44 51 26
## [1] " 33 " " JADE GE "
## [3] "3.5 " "W 60"
## [5] "L 12" "W 50"
## [7] "D 36" "L 13"
## [9] "L 15" "W 51"
## [1] " MI " " 14691842 / R: 1449 ->1421 "
## [3] " " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " JADE GE "
## [1] " MI "
## [1] "3.5 "
## [1] 1449
## [1] 60 50 36 51
## numeric(0)
## [1] 60 50 36 51
## [1] " 34 " " MICHAEL JEFFERY THOMAS "
## [3] "3.5 " "L 6"
## [5] "W 60" "L 37"
## [7] "W 29" "D 25"
## [9] "L 11" "W 52"
## [1] " MI " " 15051807 / R: 1399 ->1400 "
## [3] " " "B "
## [5] "W " "B "
## [7] "B " "W "
## [9] "B " "W "
## [1] " MICHAEL JEFFERY THOMAS "
## [1] " MI "
## [1] "3.5 "
## [1] 1399
## [1] 60 29 25 52
## numeric(0)
## [1] 60 29 25 52
## [1] " 35 " " JOSHUA DAVID LEE "
## [3] "3.5 " "L 46"
## [5] "L 38" "W 56"
## [7] "L 6" "W 57"
## [9] "D 52" "W 48"
## [1] " MI " " 14601397 / R: 1438 ->1392 "
## [3] " " "W "
## [5] "W " "B "
## [7] "W " "B "
## [9] "B " "W "
## [1] " JOSHUA DAVID LEE "
## [1] " MI "
## [1] "3.5 "
## [1] 1438
## [1] 56 57 52 48
## numeric(0)
## [1] 56 57 52 48
## [1] " 36 " " SIDDHARTH JHA "
## [3] "3.5 " "L 13"
## [5] "W 57" "W 51"
## [7] "D 33" "H "
## [9] "L 16" "D 28"
## [1] " MI " " 14773163 / R: 1355 ->1367 "
## [3] "N:4 " "W "
## [5] "B " "W "
## [7] "B " " "
## [9] "W " "B "
## [1] " SIDDHARTH JHA "
## [1] " MI "
## [1] "3.5 "
## [1] 1355
## [1] 57 51 33 28
## numeric(0)
## [1] 57 51 33 28
## [1] " 37 " " AMIYATOSH PWNANANDAM "
## [3] "3.5 " "B "
## [5] "L 5" "W 34"
## [7] "L 27" "H "
## [9] "L 23" "W 61"
## [1] " MI " " 15489571 / R: 980P12->1077P17 "
## [3] " " " "
## [5] "B " "W "
## [7] "W " " "
## [9] "B " "W "
## [1] " AMIYATOSH PWNANANDAM "
## [1] " MI "
## [1] "3.5 "
## [1] 980
## [1] 34 61
## numeric(0)
## [1] 34 61
## [1] " 38 " " BRIAN LIU "
## [3] "3.0 " "D 11"
## [5] "W 35" "W 29"
## [7] "L 12" "H "
## [9] "L 18" "L 15"
## [1] " MI " " 15108523 / R: 1423 ->1439 "
## [3] "N:4 " "W "
## [5] "B " "W "
## [7] "W " " "
## [9] "B " "B "
## [1] " BRIAN LIU "
## [1] " MI "
## [1] "3.0 "
## [1] 1423
## [1] 11 35 29
## numeric(0)
## [1] 11 35 29
## [1] " 39 " " JOEL R HENDON "
## [3] "3.0 " "L 1"
## [5] "W 54" "W 40"
## [7] "L 16" "W 44"
## [9] "L 21" "L 24"
## [1] " MI " " 12923035 / R: 1436P23->1413 "
## [3] "N:4 " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "W "
## [1] " JOEL R HENDON "
## [1] " MI "
## [1] "3.0 "
## [1] 1436
## [1] 54 40 44
## numeric(0)
## [1] 54 40 44
## [1] " 40 " " FOREST ZHANG "
## [3] "3.0 " "W 20"
## [5] "L 26" "L 39"
## [7] "W 59" "L 21"
## [9] "W 56" "L 22"
## [1] " MI " " 14892710 / R: 1348 ->1346 "
## [3] " " "B "
## [5] "B " "W "
## [7] "W " "B "
## [9] "W " "W "
## [1] " FOREST ZHANG "
## [1] " MI "
## [1] "3.0 "
## [1] 1348
## [1] 20 59 56
## numeric(0)
## [1] 20 59 56
## [1] " 41 " " KYLE WILLIAM MURPHY "
## [3] "3.0 " "W 59"
## [5] "L 17" "W 58"
## [7] "L 20" "X "
## [9] "U " "U "
## [1] " MI " " 15761443 / R: 1403P5 ->1341P9 "
## [3] " " "B "
## [5] "W " "B "
## [7] "W " " "
## [9] " " " "
## [1] " KYLE WILLIAM MURPHY "
## [1] " MI "
## [1] "3.0 "
## [1] 1403
## [1] 59 58
## numeric(0)
## [1] 59 58
## [1] " 42 " " JARED GE "
## [3] "3.0 " "L 12"
## [5] "L 50" "L 57"
## [7] "D 60" "D 61"
## [9] "W 64" "W 56"
## [1] " MI " " 14462326 / R: 1332 ->1256 "
## [3] " " "B "
## [5] "W " "B "
## [7] "B " "W "
## [9] "W " "B "
## [1] " JARED GE "
## [1] " MI "
## [1] "3.0 "
## [1] 1332
## [1] 60 61 64 56
## numeric(0)
## [1] 60 61 64 56
## [1] " 43 " " ROBERT GLEN VASEY "
## [3] "3.0 " "L 21"
## [5] "L 23" "L 24"
## [7] "W 63" "W 59"
## [9] "L 46" "W 55"
## [1] " MI " " 14101068 / R: 1283 ->1244 "
## [3] " " "W "
## [5] "B " "W "
## [7] "W " "B "
## [9] "B " "W "
## [1] " ROBERT GLEN VASEY "
## [1] " MI "
## [1] "3.0 "
## [1] 1283
## [1] 63 59 55
## numeric(0)
## [1] 63 59 55
## [1] " 44 " " JUSTIN D SCHILLING "
## [3] "3.0 " "B "
## [5] "L 14" "L 32"
## [7] "W 53" "L 39"
## [9] "L 24" "W 59"
## [1] " MI " " 15323504 / R: 1199 ->1199 "
## [3] " " " "
## [5] "W " "B "
## [7] "B " "W "
## [9] "B " "W "
## [1] " JUSTIN D SCHILLING "
## [1] " MI "
## [1] "3.0 "
## [1] 1199
## [1] 53 59
## numeric(0)
## [1] 53 59
## [1] " 45 " " DEREK YAN "
## [3] "3.0 " "L 5"
## [5] "L 51" "D 60"
## [7] "L 56" "W 63"
## [9] "D 55" "W 58"
## [1] " MI " " 15372807 / R: 1242 ->1191 "
## [3] " " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " "W "
## [1] " DEREK YAN "
## [1] " MI "
## [1] "3.0 "
## [1] 1242
## [1] 60 63 55 58
## numeric(0)
## [1] 60 63 55 58
## [1] " 46 " " JACOB ALEXANDER LAVALLEY "
## [3] "3.0 " "W 35"
## [5] "L 7" "L 27"
## [7] "L 50" "W 64"
## [9] "W 43" "L 23"
## [1] " MI " " 15490981 / R: 377P3 ->1076P10 "
## [3] " " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "W "
## [1] " JACOB ALEXANDER LAVALLEY "
## [1] " MI "
## [1] "3.0 "
## [1] 377
## [1] 35 64 43
## numeric(0)
## [1] 35 64 43
## [1] " 47 " " ERIC WRIGHT "
## [3] "2.5 " "L 18"
## [5] "W 24" "L 21"
## [7] "W 61" "L 8"
## [9] "D 51" "L 25"
## [1] " MI " " 12533115 / R: 1362 ->1341 "
## [3] " " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] "B " "W "
## [1] " ERIC WRIGHT "
## [1] " MI "
## [1] "2.5 "
## [1] 1362
## [1] 24 61 51
## numeric(0)
## [1] 24 61 51
## [1] " 48 " " DANIEL KHAIN "
## [3] "2.5 " "L 17"
## [5] "W 63" "H "
## [7] "D 52" "H "
## [9] "L 29" "L 35"
## [1] " MI " " 14369165 / R: 1382 ->1335 "
## [3] " " "B "
## [5] "W " " "
## [7] "B " " "
## [9] "W " "B "
## [1] " DANIEL KHAIN "
## [1] " MI "
## [1] "2.5 "
## [1] 1382
## [1] 63 52
## numeric(0)
## [1] 63 52
## [1] " 49 " " MICHAEL J MARTIN "
## [3] "2.5 " "L 26"
## [5] "L 20" "D 63"
## [7] "D 64" "W 58"
## [9] "H " "U "
## [1] " MI " " 12531685 / R: 1291P12->1259P17 "
## [3] " " "W "
## [5] "W " "B "
## [7] "W " "B "
## [9] " " " "
## [1] " MICHAEL J MARTIN "
## [1] " MI "
## [1] "2.5 "
## [1] 1291
## [1] 63 64 58
## numeric(0)
## [1] 63 64 58
## [1] " 50 " " SHIVAM JHA "
## [3] "2.5 " "L 29"
## [5] "W 42" "L 33"
## [7] "W 46" "H "
## [9] "L 31" "L 30"
## [1] " MI " " 14773178 / R: 1056 ->1111 "
## [3] " " "W "
## [5] "B " "W "
## [7] "B " " "
## [9] "B " "W "
## [1] " SHIVAM JHA "
## [1] " MI "
## [1] "2.5 "
## [1] 1056
## [1] 42 46
## numeric(0)
## [1] 42 46
## [1] " 51 " " TEJAS AYYAGARI "
## [3] "2.5 " "L 27"
## [5] "W 45" "L 36"
## [7] "W 57" "L 32"
## [9] "D 47" "L 33"
## [1] " MI " " 15205474 / R: 1011 ->1097 "
## [3] " " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "W "
## [1] " TEJAS AYYAGARI "
## [1] " MI "
## [1] "2.5 "
## [1] 1011
## [1] 45 57 47
## numeric(0)
## [1] 45 57 47
## [1] " 52 " " ETHAN GUO "
## [3] "2.5 " "W 30"
## [5] "D 22" "L 19"
## [7] "D 48" "L 29"
## [9] "D 35" "L 34"
## [1] " MI " " 14918803 / R: 935 ->1092 "
## [3] "N:4 " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " ETHAN GUO "
## [1] " MI "
## [1] "2.5 "
## [1] 935
## [1] 30 22 48 35
## numeric(0)
## [1] 30 22 48 35
## [1] " 53 " " JOSE C YBARRA "
## [3] "2.0 " "H "
## [5] "L 25" "H "
## [7] "L 44" "U "
## [9] "W 57" "U "
## [1] " MI " " 12578849 / R: 1393 ->1359 "
## [3] " " " "
## [5] "B " " "
## [7] "W " " "
## [9] "W " " "
## [1] " JOSE C YBARRA "
## [1] " MI "
## [1] "2.0 "
## [1] 1393
## [1] 57
## numeric(0)
## [1] 57
## [1] " 54 " " LARRY HODGE "
## [3] "2.0 " "L 14"
## [5] "L 39" "L 61"
## [7] "B " "L 15"
## [9] "L 59" "W 64"
## [1] " MI " " 12836773 / R: 1270 ->1200 "
## [3] " " "B "
## [5] "B " "W "
## [7] " " "W "
## [9] "B " "W "
## [1] " LARRY HODGE "
## [1] " MI "
## [1] "2.0 "
## [1] 1270
## [1] 64
## numeric(0)
## [1] 64
## [1] " 55 " " ALEX KONG "
## [3] "2.0 " "L 62"
## [5] "D 31" "L 10"
## [7] "L 30" "B "
## [9] "D 45" "L 43"
## [1] " MI " " 15412571 / R: 1186 ->1163 "
## [3] " " "W "
## [5] "B " "W "
## [7] "B " " "
## [9] "W " "B "
## [1] " ALEX KONG "
## [1] " MI "
## [1] "2.0 "
## [1] 1186
## [1] 31 45
## numeric(0)
## [1] 31 45
## [1] " 56 " " MARISA RICCI "
## [3] "2.0 " "H "
## [5] "L 11" "L 35"
## [7] "W 45" "H "
## [9] "L 40" "L 42"
## [1] " MI " " 14679887 / R: 1153 ->1140 "
## [3] " " " "
## [5] "B " "W "
## [7] "W " " "
## [9] "B " "W "
## [1] " MARISA RICCI "
## [1] " MI "
## [1] "2.0 "
## [1] 1153
## [1] 45
## numeric(0)
## [1] 45
## [1] " 57 " " MICHAEL LU "
## [3] "2.0 " "L 7"
## [5] "L 36" "W 42"
## [7] "L 51" "L 35"
## [9] "L 53" "B "
## [1] " MI " " 15113330 / R: 1092 ->1079 "
## [3] " " "B "
## [5] "W " "W "
## [7] "B " "W "
## [9] "B " " "
## [1] " MICHAEL LU "
## [1] " MI "
## [1] "2.0 "
## [1] 1092
## [1] 42
## numeric(0)
## [1] 42
## [1] " 58 " " VIRAJ MOHILE "
## [3] "2.0 " "W 31"
## [5] "L 2" "L 41"
## [7] "L 23" "L 49"
## [9] "B " "L 45"
## [1] " MI " " 14700365 / R: 917 -> 941 "
## [3] " " "W "
## [5] "B " "W "
## [7] "B " "W "
## [9] " " "B "
## [1] " VIRAJ MOHILE "
## [1] " MI "
## [1] "2.0 "
## [1] 917
## [1] 31
## numeric(0)
## [1] 31
## [1] " 59 " " SEAN M MC CORMICK "
## [3] "2.0 " "L 41"
## [5] "B " "L 9"
## [7] "L 40" "L 43"
## [9] "W 54" "L 44"
## [1] " MI " " 12841036 / R: 853 -> 878 "
## [3] " " "W "
## [5] " " "B "
## [7] "B " "W "
## [9] "W " "B "
## [1] " SEAN M MC CORMICK "
## [1] " MI "
## [1] "2.0 "
## [1] 853
## [1] 54
## numeric(0)
## [1] 54
## [1] " 60 " " JULIA SHEN "
## [3] "1.5 " "L 33"
## [5] "L 34" "D 45"
## [7] "D 42" "L 24"
## [9] "H " "U "
## [1] " MI " " 14579262 / R: 967 -> 984 "
## [3] " " "W "
## [5] "B " "B "
## [7] "W " "B "
## [9] " " " "
## [1] " JULIA SHEN "
## [1] " MI "
## [1] "1.5 "
## [1] 967
## [1] 45 42
## numeric(0)
## [1] 45 42
## [1] " 61 " " JEZZEL FARKAS "
## [3] "1.5 " "L 32"
## [5] "L 3" "W 54"
## [7] "L 47" "D 42"
## [9] "L 30" "L 37"
## [1] " ON " " 15771592 / R: 955P11-> 979P18 "
## [3] " " "B "
## [5] "W " "B "
## [7] "W " "B "
## [9] "W " "B "
## [1] " JEZZEL FARKAS "
## [1] " ON "
## [1] "1.5 "
## [1] 955
## [1] 54 42
## numeric(0)
## [1] 54 42
## [1] " 62 " " ASHWIN BALAJI "
## [3] "1.0 " "W 55"
## [5] "U " "U "
## [7] "U " "U "
## [9] "U " "U "
## [1] " MI " " 15219542 / R: 1530 ->1535 "
## [3] " " "B "
## [5] " " " "
## [7] " " " "
## [9] " " " "
## [1] " ASHWIN BALAJI "
## [1] " MI "
## [1] "1.0 "
## [1] 1530
## [1] 55
## numeric(0)
## [1] 55
## [1] " 63 " " THOMAS JOSEPH HOSMER "
## [3] "1.0 " "L 2"
## [5] "L 48" "D 49"
## [7] "L 43" "L 45"
## [9] "H " "U "
## [1] " MI " " 15057092 / R: 1175 ->1125 "
## [3] " " "W "
## [5] "B " "W "
## [7] "B " "B "
## [9] " " " "
## [1] " THOMAS JOSEPH HOSMER "
## [1] " MI "
## [1] "1.0 "
## [1] 1175
## [1] 49
## numeric(0)
## [1] 49
## [1] " 64 " " BEN LI "
## [3] "1.0 " "L 22"
## [5] "D 30" "L 31"
## [7] "D 49" "L 46"
## [9] "L 42" "L 54"
## [1] " MI " " 15006561 / R: 1163 ->1112 "
## [3] " " "B "
## [5] "W " "W "
## [7] "B " "W "
## [9] "B " "B "
## [1] " BEN LI "
## [1] " MI "
## [1] "1.0 "
## [1] 1163
## [1] 30 49
## numeric(0)
## [1] 30 49print(our_chess_df)## id player_name player_state total_num_of_points
## 1 1 GARY HUA ON 6.0
## 2 1 GARY HUA ON 6.0
## 3 1 GARY HUA ON 6.0
## 4 1 GARY HUA ON 6.0
## 5 1 GARY HUA ON 6.0
## 6 1 GARY HUA ON 6.0
## 7 1 GARY HUA ON 6.0
## 8 2 DAKSHESH DARURI MI 6.0
## 9 2 DAKSHESH DARURI MI 6.0
## 10 2 DAKSHESH DARURI MI 6.0
## 11 2 DAKSHESH DARURI MI 6.0
## 12 2 DAKSHESH DARURI MI 6.0
## 13 2 DAKSHESH DARURI MI 6.0
## 14 3 ADITYA BAJAJ MI 6.0
## 15 3 ADITYA BAJAJ MI 6.0
## 16 3 ADITYA BAJAJ MI 6.0
## 17 3 ADITYA BAJAJ MI 6.0
## 18 3 ADITYA BAJAJ MI 6.0
## 19 3 ADITYA BAJAJ MI 6.0
## 20 4 PATRICK H SCHILLING MI 5.5
## 21 4 PATRICK H SCHILLING MI 5.5
## 22 4 PATRICK H SCHILLING MI 5.5
## 23 4 PATRICK H SCHILLING MI 5.5
## 24 4 PATRICK H SCHILLING MI 5.5
## 25 4 PATRICK H SCHILLING MI 5.5
## 26 4 PATRICK H SCHILLING MI 5.5
## 27 5 HANSHI ZUO MI 5.5
## 28 5 HANSHI ZUO MI 5.5
## 29 5 HANSHI ZUO MI 5.5
## 30 5 HANSHI ZUO MI 5.5
## 31 5 HANSHI ZUO MI 5.5
## 32 5 HANSHI ZUO MI 5.5
## 33 5 HANSHI ZUO MI 5.5
## 34 6 HANSEN SONG OH 5.0
## 35 6 HANSEN SONG OH 5.0
## 36 6 HANSEN SONG OH 5.0
## 37 6 HANSEN SONG OH 5.0
## 38 6 HANSEN SONG OH 5.0
## 39 6 HANSEN SONG OH 5.0
## 40 7 GARY DEE SWATHELL MI 5.0
## 41 7 GARY DEE SWATHELL MI 5.0
## 42 7 GARY DEE SWATHELL MI 5.0
## 43 7 GARY DEE SWATHELL MI 5.0
## 44 7 GARY DEE SWATHELL MI 5.0
## 45 8 EZEKIEL HOUGHTON MI 5.0
## 46 8 EZEKIEL HOUGHTON MI 5.0
## 47 8 EZEKIEL HOUGHTON MI 5.0
## 48 8 EZEKIEL HOUGHTON MI 5.0
## 49 8 EZEKIEL HOUGHTON MI 5.0
## 50 9 STEFANO LEE ON 5.0
## 51 9 STEFANO LEE ON 5.0
## 52 9 STEFANO LEE ON 5.0
## 53 9 STEFANO LEE ON 5.0
## 54 9 STEFANO LEE ON 5.0
## 55 10 ANVIT RAO MI 5.0
## 56 10 ANVIT RAO MI 5.0
## 57 10 ANVIT RAO MI 5.0
## 58 10 ANVIT RAO MI 5.0
## 59 10 ANVIT RAO MI 5.0
## 60 10 ANVIT RAO MI 5.0
## 61 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 62 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 63 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 64 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 65 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 66 12 KENNETH J TACK MI 4.5
## 67 12 KENNETH J TACK MI 4.5
## 68 12 KENNETH J TACK MI 4.5
## 69 12 KENNETH J TACK MI 4.5
## 70 12 KENNETH J TACK MI 4.5
## 71 13 TORRANCE HENRY JR MI 4.5
## 72 13 TORRANCE HENRY JR MI 4.5
## 73 13 TORRANCE HENRY JR MI 4.5
## 74 13 TORRANCE HENRY JR MI 4.5
## 75 13 TORRANCE HENRY JR MI 4.5
## 76 14 BRADLEY SHAW MI 4.5
## 77 14 BRADLEY SHAW MI 4.5
## 78 14 BRADLEY SHAW MI 4.5
## 79 14 BRADLEY SHAW MI 4.5
## 80 14 BRADLEY SHAW MI 4.5
## 81 15 ZACHARY JAMES HOUGHTON MI 4.5
## 82 15 ZACHARY JAMES HOUGHTON MI 4.5
## 83 15 ZACHARY JAMES HOUGHTON MI 4.5
## 84 15 ZACHARY JAMES HOUGHTON MI 4.5
## 85 15 ZACHARY JAMES HOUGHTON MI 4.5
## 86 16 MIKE NIKITIN MI 4.0
## 87 16 MIKE NIKITIN MI 4.0
## 88 16 MIKE NIKITIN MI 4.0
## 89 16 MIKE NIKITIN MI 4.0
## 90 17 RONALD GRZEGORCZYK MI 4.0
## 91 17 RONALD GRZEGORCZYK MI 4.0
## 92 17 RONALD GRZEGORCZYK MI 4.0
## 93 17 RONALD GRZEGORCZYK MI 4.0
## 94 18 DAVID SUNDEEN MI 4.0
## 95 18 DAVID SUNDEEN MI 4.0
## 96 18 DAVID SUNDEEN MI 4.0
## 97 18 DAVID SUNDEEN MI 4.0
## 98 19 DIPANKAR ROY MI 4.0
## 99 19 DIPANKAR ROY MI 4.0
## 100 19 DIPANKAR ROY MI 4.0
## 101 19 DIPANKAR ROY MI 4.0
## 102 19 DIPANKAR ROY MI 4.0
## 103 20 JASON ZHENG MI 4.0
## 104 20 JASON ZHENG MI 4.0
## 105 20 JASON ZHENG MI 4.0
## 106 20 JASON ZHENG MI 4.0
## 107 21 DINH DANG BUI ON 4.0
## 108 21 DINH DANG BUI ON 4.0
## 109 21 DINH DANG BUI ON 4.0
## 110 21 DINH DANG BUI ON 4.0
## 111 22 EUGENE L MCCLURE MI 4.0
## 112 22 EUGENE L MCCLURE MI 4.0
## 113 22 EUGENE L MCCLURE MI 4.0
## 114 22 EUGENE L MCCLURE MI 4.0
## 115 23 ALAN BUI ON 4.0
## 116 23 ALAN BUI ON 4.0
## 117 23 ALAN BUI ON 4.0
## 118 23 ALAN BUI ON 4.0
## 119 24 MICHAEL R ALDRICH MI 4.0
## 120 24 MICHAEL R ALDRICH MI 4.0
## 121 24 MICHAEL R ALDRICH MI 4.0
## 122 24 MICHAEL R ALDRICH MI 4.0
## 123 25 LOREN SCHWIEBERT MI 3.5
## 124 25 LOREN SCHWIEBERT MI 3.5
## 125 25 LOREN SCHWIEBERT MI 3.5
## 126 25 LOREN SCHWIEBERT MI 3.5
## 127 26 MAX ZHU ON 3.5
## 128 26 MAX ZHU ON 3.5
## 129 26 MAX ZHU ON 3.5
## 130 26 MAX ZHU ON 3.5
## 131 27 GAURAV GIDWANI MI 3.5
## 132 27 GAURAV GIDWANI MI 3.5
## 133 27 GAURAV GIDWANI MI 3.5
## 134 27 GAURAV GIDWANI MI 3.5
## 135 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 136 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 137 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 138 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 139 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 140 29 CHIEDOZIE OKORIE MI 3.5
## 141 29 CHIEDOZIE OKORIE MI 3.5
## 142 29 CHIEDOZIE OKORIE MI 3.5
## 143 29 CHIEDOZIE OKORIE MI 3.5
## 144 30 GEORGE AVERY JONES ON 3.5
## 145 30 GEORGE AVERY JONES ON 3.5
## 146 30 GEORGE AVERY JONES ON 3.5
## 147 30 GEORGE AVERY JONES ON 3.5
## 148 31 RISHI SHETTY MI 3.5
## 149 31 RISHI SHETTY MI 3.5
## 150 31 RISHI SHETTY MI 3.5
## 151 31 RISHI SHETTY MI 3.5
## 152 32 JOSHUA PHILIP MATHEWS ON 3.5
## 153 32 JOSHUA PHILIP MATHEWS ON 3.5
## 154 32 JOSHUA PHILIP MATHEWS ON 3.5
## 155 32 JOSHUA PHILIP MATHEWS ON 3.5
## 156 33 JADE GE MI 3.5
## 157 33 JADE GE MI 3.5
## 158 33 JADE GE MI 3.5
## 159 33 JADE GE MI 3.5
## 160 34 MICHAEL JEFFERY THOMAS MI 3.5
## 161 34 MICHAEL JEFFERY THOMAS MI 3.5
## 162 34 MICHAEL JEFFERY THOMAS MI 3.5
## 163 34 MICHAEL JEFFERY THOMAS MI 3.5
## 164 35 JOSHUA DAVID LEE MI 3.5
## 165 35 JOSHUA DAVID LEE MI 3.5
## 166 35 JOSHUA DAVID LEE MI 3.5
## 167 35 JOSHUA DAVID LEE MI 3.5
## 168 36 SIDDHARTH JHA MI 3.5
## 169 36 SIDDHARTH JHA MI 3.5
## 170 36 SIDDHARTH JHA MI 3.5
## 171 36 SIDDHARTH JHA MI 3.5
## 172 37 AMIYATOSH PWNANANDAM MI 3.5
## 173 37 AMIYATOSH PWNANANDAM MI 3.5
## 174 38 BRIAN LIU MI 3.0
## 175 38 BRIAN LIU MI 3.0
## 176 38 BRIAN LIU MI 3.0
## 177 39 JOEL R HENDON MI 3.0
## 178 39 JOEL R HENDON MI 3.0
## 179 39 JOEL R HENDON MI 3.0
## 180 40 FOREST ZHANG MI 3.0
## 181 40 FOREST ZHANG MI 3.0
## 182 40 FOREST ZHANG MI 3.0
## 183 41 KYLE WILLIAM MURPHY MI 3.0
## 184 41 KYLE WILLIAM MURPHY MI 3.0
## 185 42 JARED GE MI 3.0
## 186 42 JARED GE MI 3.0
## 187 42 JARED GE MI 3.0
## 188 42 JARED GE MI 3.0
## 189 43 ROBERT GLEN VASEY MI 3.0
## 190 43 ROBERT GLEN VASEY MI 3.0
## 191 43 ROBERT GLEN VASEY MI 3.0
## 192 44 JUSTIN D SCHILLING MI 3.0
## 193 44 JUSTIN D SCHILLING MI 3.0
## 194 45 DEREK YAN MI 3.0
## 195 45 DEREK YAN MI 3.0
## 196 45 DEREK YAN MI 3.0
## 197 45 DEREK YAN MI 3.0
## 198 46 JACOB ALEXANDER LAVALLEY MI 3.0
## 199 46 JACOB ALEXANDER LAVALLEY MI 3.0
## 200 46 JACOB ALEXANDER LAVALLEY MI 3.0
## 201 47 ERIC WRIGHT MI 2.5
## 202 47 ERIC WRIGHT MI 2.5
## 203 47 ERIC WRIGHT MI 2.5
## 204 48 DANIEL KHAIN MI 2.5
## 205 48 DANIEL KHAIN MI 2.5
## 206 49 MICHAEL J MARTIN MI 2.5
## 207 49 MICHAEL J MARTIN MI 2.5
## 208 49 MICHAEL J MARTIN MI 2.5
## 209 50 SHIVAM JHA MI 2.5
## 210 50 SHIVAM JHA MI 2.5
## 211 51 TEJAS AYYAGARI MI 2.5
## 212 51 TEJAS AYYAGARI MI 2.5
## 213 51 TEJAS AYYAGARI MI 2.5
## 214 52 ETHAN GUO MI 2.5
## 215 52 ETHAN GUO MI 2.5
## 216 52 ETHAN GUO MI 2.5
## 217 52 ETHAN GUO MI 2.5
## 218 53 JOSE C YBARRA MI 2.0
## 219 54 LARRY HODGE MI 2.0
## 220 55 ALEX KONG MI 2.0
## 221 55 ALEX KONG MI 2.0
## 222 56 MARISA RICCI MI 2.0
## 223 57 MICHAEL LU MI 2.0
## 224 58 VIRAJ MOHILE MI 2.0
## 225 59 SEAN M MC CORMICK MI 2.0
## 226 60 JULIA SHEN MI 1.5
## 227 60 JULIA SHEN MI 1.5
## 228 61 JEZZEL FARKAS ON 1.5
## 229 61 JEZZEL FARKAS ON 1.5
## 230 62 ASHWIN BALAJI MI 1.0
## 231 63 THOMAS JOSEPH HOSMER MI 1.0
## 232 64 BEN LI MI 1.0
## 233 64 BEN LI MI 1.0
## player_pre_rating opponent
## 1 1794 39
## 2 1794 21
## 3 1794 18
## 4 1794 14
## 5 1794 7
## 6 1794 12
## 7 1794 4
## 8 1553 63
## 9 1553 58
## 10 1553 17
## 11 1553 16
## 12 1553 20
## 13 1553 7
## 14 1384 61
## 15 1384 25
## 16 1384 21
## 17 1384 11
## 18 1384 13
## 19 1384 12
## 20 1716 23
## 21 1716 28
## 22 1716 2
## 23 1716 26
## 24 1716 5
## 25 1716 19
## 26 1716 1
## 27 1655 45
## 28 1655 37
## 29 1655 12
## 30 1655 13
## 31 1655 4
## 32 1655 14
## 33 1655 17
## 34 1686 34
## 35 1686 29
## 36 1686 35
## 37 1686 10
## 38 1686 27
## 39 1686 21
## 40 1649 57
## 41 1649 46
## 42 1649 13
## 43 1649 11
## 44 1649 9
## 45 1641 3
## 46 1641 32
## 47 1641 47
## 48 1641 28
## 49 1641 19
## 50 1411 25
## 51 1411 59
## 52 1411 8
## 53 1411 26
## 54 1411 20
## 55 1365 16
## 56 1365 55
## 57 1365 31
## 58 1365 6
## 59 1365 25
## 60 1365 18
## 61 1712 38
## 62 1712 56
## 63 1712 6
## 64 1712 34
## 65 1712 26
## 66 1663 42
## 67 1663 33
## 68 1663 5
## 69 1663 38
## 70 1663 1
## 71 1666 36
## 72 1666 27
## 73 1666 5
## 74 1666 33
## 75 1666 32
## 76 1610 54
## 77 1610 44
## 78 1610 8
## 79 1610 27
## 80 1610 31
## 81 1220 19
## 82 1220 30
## 83 1220 54
## 84 1220 33
## 85 1220 38
## 86 1604 10
## 87 1604 15
## 88 1604 39
## 89 1604 36
## 90 1629 48
## 91 1629 41
## 92 1629 23
## 93 1629 22
## 94 1600 47
## 95 1600 9
## 96 1600 32
## 97 1600 38
## 98 1564 15
## 99 1564 10
## 100 1564 52
## 101 1564 28
## 102 1564 18
## 103 1595 49
## 104 1595 23
## 105 1595 41
## 106 1595 28
## 107 1563 43
## 108 1563 47
## 109 1563 40
## 110 1563 39
## 111 1555 64
## 112 1555 52
## 113 1555 15
## 114 1555 40
## 115 1363 43
## 116 1363 58
## 117 1363 37
## 118 1363 46
## 119 1229 43
## 120 1229 60
## 121 1229 44
## 122 1229 39
## 123 1745 53
## 124 1745 24
## 125 1745 34
## 126 1745 47
## 127 1579 49
## 128 1579 40
## 129 1579 17
## 130 1579 32
## 131 1552 51
## 132 1552 46
## 133 1552 37
## 134 1552 14
## 135 1507 24
## 136 1507 4
## 137 1507 22
## 138 1507 19
## 139 1507 36
## 140 1602 50
## 141 1602 6
## 142 1602 52
## 143 1602 48
## 144 1522 64
## 145 1522 55
## 146 1522 61
## 147 1522 50
## 148 1494 55
## 149 1494 64
## 150 1494 30
## 151 1494 50
## 152 1441 61
## 153 1441 44
## 154 1441 51
## 155 1441 26
## 156 1449 60
## 157 1449 50
## 158 1449 36
## 159 1449 51
## 160 1399 60
## 161 1399 29
## 162 1399 25
## 163 1399 52
## 164 1438 56
## 165 1438 57
## 166 1438 52
## 167 1438 48
## 168 1355 57
## 169 1355 51
## 170 1355 33
## 171 1355 28
## 172 980 34
## 173 980 61
## 174 1423 11
## 175 1423 35
## 176 1423 29
## 177 1436 54
## 178 1436 40
## 179 1436 44
## 180 1348 20
## 181 1348 59
## 182 1348 56
## 183 1403 59
## 184 1403 58
## 185 1332 60
## 186 1332 61
## 187 1332 64
## 188 1332 56
## 189 1283 63
## 190 1283 59
## 191 1283 55
## 192 1199 53
## 193 1199 59
## 194 1242 60
## 195 1242 63
## 196 1242 55
## 197 1242 58
## 198 377 35
## 199 377 64
## 200 377 43
## 201 1362 24
## 202 1362 61
## 203 1362 51
## 204 1382 63
## 205 1382 52
## 206 1291 63
## 207 1291 64
## 208 1291 58
## 209 1056 42
## 210 1056 46
## 211 1011 45
## 212 1011 57
## 213 1011 47
## 214 935 30
## 215 935 22
## 216 935 48
## 217 935 35
## 218 1393 57
## 219 1270 64
## 220 1186 31
## 221 1186 45
## 222 1153 45
## 223 1092 42
## 224 917 31
## 225 853 54
## 226 967 45
## 227 967 42
## 228 955 54
## 229 955 42
## 230 1530 55
## 231 1175 49
## 232 1163 30
## 233 1163 49Now that our intermediate table is ready, let’s proceed to create our final table.
column_names <- c("player_name", "player_state", "total_num_of_points", "player_pre_rating", "average_pre_chess_rating_of_opponent")
our_final_chess_df <- data.frame(matrix(ncol = length(column_names), nrow = 0))
colnames(our_final_chess_df) <- column_names
our_chess_df$player_pre_rating <- as.numeric(our_chess_df$player_pre_rating)
our_chess_df_desc <- our_chess_df %>% arrange(desc(id))
df_opponents <- data.frame(
id = numeric(),
average_pre_chess_rating_of_opponent = numeric()
)
# Initialize variables
current_id <- 0
sum <- 0
count_opponents <- 0
# Create an empty data frame for results
df_opponents <- data.frame(
id = integer(),
average_pre_chess_rating_of_opponent = numeric()
)
# Iterate over the rows of our_chess_df_desc
for (i in 1:nrow(our_chess_df_desc)) {
if (current_id != our_chess_df_desc$id[i] && current_id != 0) {
print(current_id)
print(sum)
df_opponents <- rbind(df_opponents, data.frame(
id = current_id,
average_pre_chess_rating_of_opponent = sum / count_opponents
))
current_id <- our_chess_df_desc$id[i]
sum <- 0
count_opponents <- 0
}
current_opponent_id <- our_chess_df_desc$opponent[i]
sum <- sum + our_chess_df_desc$player_pre_rating[current_opponent_id]
count_opponents <- count_opponents + 1
if (current_id == 0) {
current_id <- our_chess_df_desc$id[i]
}
}## [1] " 64 "
## [1] 2714
## [1] " 63 "
## [1] 1332
## [1] " 62 "
## [1] 1436
## [1] " 61 "
## [1] 2547
## [1] " 60 "
## [1] 2482
## [1] " 59 "
## [1] 1348
## [1] " 58 "
## [1] 1362
## [1] " 57 "
## [1] 1199
## [1] " 56 "
## [1] 1283
## [1] " 55 "
## [1] 2645
## [1] " 54 "
## [1] 1355
## [1] " 53 "
## [1] 1436
## [1] " 52 "
## [1] 4102
## [1] " 51 "
## [1] 4051
## [1] " 50 "
## [1] 2531
## [1] " 49 "
## [1] 4133
## [1] " 48 "
## [1] 2703
## [1] " 47 "
## [1] 3439
## [1] " 46 "
## [1] 3015
## [1] " 45 "
## [1] 5637
## [1] " 44 "
## [1] 2771
## [1] " 43 "
## [1] 4214
## [1] " 42 "
## [1] 5194
## [1] " 41 "
## [1] 2846
## [1] " 40 "
## [1] 3794
## [1] " 39 "
## [1] 3873
## [1] " 38 "
## [1] 2851
## [1] " 37 "
## [1] 1357
## [1] " 36 "
## [1] 5492
## [1] " 35 "
## [1] 5552
## [1] " 34 "
## [1] 5209
## [1] " 33 "
## [1] 4606
## [1] " 32 "
## [1] 4957
## [1] " 31 "
## [1] 5576
## [1] " 30 "
## [1] 5174
## [1] " 29 "
## [1] 5038
## [1] " 28 "
## [1] 4909
## [1] " 27 "
## [1] 5163
## [1] " 26 "
## [1] 4871
## [1] " 25 "
## [1] 4113
## [1] " 24 "
## [1] 5231
## [1] " 23 "
## [1] 5280
## [1] " 22 "
## [1] 5215
## [1] " 21 "
## [1] 5099
## [1] " 20 "
## [1] 4833
## [1] " 19 "
## [1] 5761
## [1] " 18 "
## [1] 4789
## [1] " 17 "
## [1] 4553
## [1] " 16 "
## [1] 3806
## [1] " 15 "
## [1] 6269
## [1] " 14 "
## [1] 6251
## [1] " 13 "
## [1] 5347
## [1] " 12 "
## [1] 5921
## [1] " 11 "
## [1] 5301
## [1] " 10 "
## [1] 7137
## [1] " 9 "
## [1] 5672
## [1] " 8 "
## [1] 6095
## [1] " 7 "
## [1] 5899
## [1] " 6 "
## [1] 5355
## [1] " 5 "
## [1] 8515
## [1] " 4 "
## [1] 7809
## [1] " 3 "
## [1] 6478
## [1] " 2 "
## [1] 7008if (current_id != 0) {
df_opponents <- rbind(df_opponents, data.frame(
id = current_id,
average_pre_chess_rating_of_opponent = sum / count_opponents
))
}
print(df_opponents)## id average_pre_chess_rating_of_opponent
## 1 64 1357.0000
## 2 63 1332.0000
## 3 62 1436.0000
## 4 61 1273.5000
## 5 60 1241.0000
## 6 59 1348.0000
## 7 58 1362.0000
## 8 57 1199.0000
## 9 56 1283.0000
## 10 55 1322.5000
## 11 54 1355.0000
## 12 53 1436.0000
## 13 52 1025.5000
## 14 51 1350.3333
## 15 50 1265.5000
## 16 49 1377.6667
## 17 48 1351.5000
## 18 47 1146.3333
## 19 46 1005.0000
## 20 45 1409.2500
## 21 44 1385.5000
## 22 43 1404.6667
## 23 42 1298.5000
## 24 41 1423.0000
## 25 40 1264.6667
## 26 39 1291.0000
## 27 38 950.3333
## 28 37 678.5000
## 29 36 1373.0000
## 30 35 1388.0000
## 31 34 1302.2500
## 32 33 1151.5000
## 33 32 1239.2500
## 34 31 1394.0000
## 35 30 1293.5000
## 36 29 1259.5000
## 37 28 981.8000
## 38 27 1290.7500
## 39 26 1217.7500
## 40 25 1028.2500
## 41 24 1307.7500
## 42 23 1320.0000
## 43 22 1303.7500
## 44 21 1274.7500
## 45 20 1208.2500
## 46 19 1152.2000
## 47 18 1197.2500
## 48 17 1138.2500
## 49 16 951.5000
## 50 15 1253.8000
## 51 14 1250.2000
## 52 13 1069.4000
## 53 12 1184.2000
## 54 11 1060.2000
## 55 10 1189.5000
## 56 9 1134.4000
## 57 8 1219.0000
## 58 7 1179.8000
## 59 6 892.5000
## 60 5 1216.4286
## 61 4 1115.5714
## 62 3 1079.6667
## 63 2 1168.0000
## 64 1 1146.2857merged_df <- our_chess_df %>% left_join(df_opponents, by = "id")
print(merged_df)## id player_name player_state total_num_of_points
## 1 1 GARY HUA ON 6.0
## 2 1 GARY HUA ON 6.0
## 3 1 GARY HUA ON 6.0
## 4 1 GARY HUA ON 6.0
## 5 1 GARY HUA ON 6.0
## 6 1 GARY HUA ON 6.0
## 7 1 GARY HUA ON 6.0
## 8 2 DAKSHESH DARURI MI 6.0
## 9 2 DAKSHESH DARURI MI 6.0
## 10 2 DAKSHESH DARURI MI 6.0
## 11 2 DAKSHESH DARURI MI 6.0
## 12 2 DAKSHESH DARURI MI 6.0
## 13 2 DAKSHESH DARURI MI 6.0
## 14 3 ADITYA BAJAJ MI 6.0
## 15 3 ADITYA BAJAJ MI 6.0
## 16 3 ADITYA BAJAJ MI 6.0
## 17 3 ADITYA BAJAJ MI 6.0
## 18 3 ADITYA BAJAJ MI 6.0
## 19 3 ADITYA BAJAJ MI 6.0
## 20 4 PATRICK H SCHILLING MI 5.5
## 21 4 PATRICK H SCHILLING MI 5.5
## 22 4 PATRICK H SCHILLING MI 5.5
## 23 4 PATRICK H SCHILLING MI 5.5
## 24 4 PATRICK H SCHILLING MI 5.5
## 25 4 PATRICK H SCHILLING MI 5.5
## 26 4 PATRICK H SCHILLING MI 5.5
## 27 5 HANSHI ZUO MI 5.5
## 28 5 HANSHI ZUO MI 5.5
## 29 5 HANSHI ZUO MI 5.5
## 30 5 HANSHI ZUO MI 5.5
## 31 5 HANSHI ZUO MI 5.5
## 32 5 HANSHI ZUO MI 5.5
## 33 5 HANSHI ZUO MI 5.5
## 34 6 HANSEN SONG OH 5.0
## 35 6 HANSEN SONG OH 5.0
## 36 6 HANSEN SONG OH 5.0
## 37 6 HANSEN SONG OH 5.0
## 38 6 HANSEN SONG OH 5.0
## 39 6 HANSEN SONG OH 5.0
## 40 7 GARY DEE SWATHELL MI 5.0
## 41 7 GARY DEE SWATHELL MI 5.0
## 42 7 GARY DEE SWATHELL MI 5.0
## 43 7 GARY DEE SWATHELL MI 5.0
## 44 7 GARY DEE SWATHELL MI 5.0
## 45 8 EZEKIEL HOUGHTON MI 5.0
## 46 8 EZEKIEL HOUGHTON MI 5.0
## 47 8 EZEKIEL HOUGHTON MI 5.0
## 48 8 EZEKIEL HOUGHTON MI 5.0
## 49 8 EZEKIEL HOUGHTON MI 5.0
## 50 9 STEFANO LEE ON 5.0
## 51 9 STEFANO LEE ON 5.0
## 52 9 STEFANO LEE ON 5.0
## 53 9 STEFANO LEE ON 5.0
## 54 9 STEFANO LEE ON 5.0
## 55 10 ANVIT RAO MI 5.0
## 56 10 ANVIT RAO MI 5.0
## 57 10 ANVIT RAO MI 5.0
## 58 10 ANVIT RAO MI 5.0
## 59 10 ANVIT RAO MI 5.0
## 60 10 ANVIT RAO MI 5.0
## 61 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 62 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 63 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 64 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 65 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 66 12 KENNETH J TACK MI 4.5
## 67 12 KENNETH J TACK MI 4.5
## 68 12 KENNETH J TACK MI 4.5
## 69 12 KENNETH J TACK MI 4.5
## 70 12 KENNETH J TACK MI 4.5
## 71 13 TORRANCE HENRY JR MI 4.5
## 72 13 TORRANCE HENRY JR MI 4.5
## 73 13 TORRANCE HENRY JR MI 4.5
## 74 13 TORRANCE HENRY JR MI 4.5
## 75 13 TORRANCE HENRY JR MI 4.5
## 76 14 BRADLEY SHAW MI 4.5
## 77 14 BRADLEY SHAW MI 4.5
## 78 14 BRADLEY SHAW MI 4.5
## 79 14 BRADLEY SHAW MI 4.5
## 80 14 BRADLEY SHAW MI 4.5
## 81 15 ZACHARY JAMES HOUGHTON MI 4.5
## 82 15 ZACHARY JAMES HOUGHTON MI 4.5
## 83 15 ZACHARY JAMES HOUGHTON MI 4.5
## 84 15 ZACHARY JAMES HOUGHTON MI 4.5
## 85 15 ZACHARY JAMES HOUGHTON MI 4.5
## 86 16 MIKE NIKITIN MI 4.0
## 87 16 MIKE NIKITIN MI 4.0
## 88 16 MIKE NIKITIN MI 4.0
## 89 16 MIKE NIKITIN MI 4.0
## 90 17 RONALD GRZEGORCZYK MI 4.0
## 91 17 RONALD GRZEGORCZYK MI 4.0
## 92 17 RONALD GRZEGORCZYK MI 4.0
## 93 17 RONALD GRZEGORCZYK MI 4.0
## 94 18 DAVID SUNDEEN MI 4.0
## 95 18 DAVID SUNDEEN MI 4.0
## 96 18 DAVID SUNDEEN MI 4.0
## 97 18 DAVID SUNDEEN MI 4.0
## 98 19 DIPANKAR ROY MI 4.0
## 99 19 DIPANKAR ROY MI 4.0
## 100 19 DIPANKAR ROY MI 4.0
## 101 19 DIPANKAR ROY MI 4.0
## 102 19 DIPANKAR ROY MI 4.0
## 103 20 JASON ZHENG MI 4.0
## 104 20 JASON ZHENG MI 4.0
## 105 20 JASON ZHENG MI 4.0
## 106 20 JASON ZHENG MI 4.0
## 107 21 DINH DANG BUI ON 4.0
## 108 21 DINH DANG BUI ON 4.0
## 109 21 DINH DANG BUI ON 4.0
## 110 21 DINH DANG BUI ON 4.0
## 111 22 EUGENE L MCCLURE MI 4.0
## 112 22 EUGENE L MCCLURE MI 4.0
## 113 22 EUGENE L MCCLURE MI 4.0
## 114 22 EUGENE L MCCLURE MI 4.0
## 115 23 ALAN BUI ON 4.0
## 116 23 ALAN BUI ON 4.0
## 117 23 ALAN BUI ON 4.0
## 118 23 ALAN BUI ON 4.0
## 119 24 MICHAEL R ALDRICH MI 4.0
## 120 24 MICHAEL R ALDRICH MI 4.0
## 121 24 MICHAEL R ALDRICH MI 4.0
## 122 24 MICHAEL R ALDRICH MI 4.0
## 123 25 LOREN SCHWIEBERT MI 3.5
## 124 25 LOREN SCHWIEBERT MI 3.5
## 125 25 LOREN SCHWIEBERT MI 3.5
## 126 25 LOREN SCHWIEBERT MI 3.5
## 127 26 MAX ZHU ON 3.5
## 128 26 MAX ZHU ON 3.5
## 129 26 MAX ZHU ON 3.5
## 130 26 MAX ZHU ON 3.5
## 131 27 GAURAV GIDWANI MI 3.5
## 132 27 GAURAV GIDWANI MI 3.5
## 133 27 GAURAV GIDWANI MI 3.5
## 134 27 GAURAV GIDWANI MI 3.5
## 135 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 136 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 137 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 138 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 139 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 140 29 CHIEDOZIE OKORIE MI 3.5
## 141 29 CHIEDOZIE OKORIE MI 3.5
## 142 29 CHIEDOZIE OKORIE MI 3.5
## 143 29 CHIEDOZIE OKORIE MI 3.5
## 144 30 GEORGE AVERY JONES ON 3.5
## 145 30 GEORGE AVERY JONES ON 3.5
## 146 30 GEORGE AVERY JONES ON 3.5
## 147 30 GEORGE AVERY JONES ON 3.5
## 148 31 RISHI SHETTY MI 3.5
## 149 31 RISHI SHETTY MI 3.5
## 150 31 RISHI SHETTY MI 3.5
## 151 31 RISHI SHETTY MI 3.5
## 152 32 JOSHUA PHILIP MATHEWS ON 3.5
## 153 32 JOSHUA PHILIP MATHEWS ON 3.5
## 154 32 JOSHUA PHILIP MATHEWS ON 3.5
## 155 32 JOSHUA PHILIP MATHEWS ON 3.5
## 156 33 JADE GE MI 3.5
## 157 33 JADE GE MI 3.5
## 158 33 JADE GE MI 3.5
## 159 33 JADE GE MI 3.5
## 160 34 MICHAEL JEFFERY THOMAS MI 3.5
## 161 34 MICHAEL JEFFERY THOMAS MI 3.5
## 162 34 MICHAEL JEFFERY THOMAS MI 3.5
## 163 34 MICHAEL JEFFERY THOMAS MI 3.5
## 164 35 JOSHUA DAVID LEE MI 3.5
## 165 35 JOSHUA DAVID LEE MI 3.5
## 166 35 JOSHUA DAVID LEE MI 3.5
## 167 35 JOSHUA DAVID LEE MI 3.5
## 168 36 SIDDHARTH JHA MI 3.5
## 169 36 SIDDHARTH JHA MI 3.5
## 170 36 SIDDHARTH JHA MI 3.5
## 171 36 SIDDHARTH JHA MI 3.5
## 172 37 AMIYATOSH PWNANANDAM MI 3.5
## 173 37 AMIYATOSH PWNANANDAM MI 3.5
## 174 38 BRIAN LIU MI 3.0
## 175 38 BRIAN LIU MI 3.0
## 176 38 BRIAN LIU MI 3.0
## 177 39 JOEL R HENDON MI 3.0
## 178 39 JOEL R HENDON MI 3.0
## 179 39 JOEL R HENDON MI 3.0
## 180 40 FOREST ZHANG MI 3.0
## 181 40 FOREST ZHANG MI 3.0
## 182 40 FOREST ZHANG MI 3.0
## 183 41 KYLE WILLIAM MURPHY MI 3.0
## 184 41 KYLE WILLIAM MURPHY MI 3.0
## 185 42 JARED GE MI 3.0
## 186 42 JARED GE MI 3.0
## 187 42 JARED GE MI 3.0
## 188 42 JARED GE MI 3.0
## 189 43 ROBERT GLEN VASEY MI 3.0
## 190 43 ROBERT GLEN VASEY MI 3.0
## 191 43 ROBERT GLEN VASEY MI 3.0
## 192 44 JUSTIN D SCHILLING MI 3.0
## 193 44 JUSTIN D SCHILLING MI 3.0
## 194 45 DEREK YAN MI 3.0
## 195 45 DEREK YAN MI 3.0
## 196 45 DEREK YAN MI 3.0
## 197 45 DEREK YAN MI 3.0
## 198 46 JACOB ALEXANDER LAVALLEY MI 3.0
## 199 46 JACOB ALEXANDER LAVALLEY MI 3.0
## 200 46 JACOB ALEXANDER LAVALLEY MI 3.0
## 201 47 ERIC WRIGHT MI 2.5
## 202 47 ERIC WRIGHT MI 2.5
## 203 47 ERIC WRIGHT MI 2.5
## 204 48 DANIEL KHAIN MI 2.5
## 205 48 DANIEL KHAIN MI 2.5
## 206 49 MICHAEL J MARTIN MI 2.5
## 207 49 MICHAEL J MARTIN MI 2.5
## 208 49 MICHAEL J MARTIN MI 2.5
## 209 50 SHIVAM JHA MI 2.5
## 210 50 SHIVAM JHA MI 2.5
## 211 51 TEJAS AYYAGARI MI 2.5
## 212 51 TEJAS AYYAGARI MI 2.5
## 213 51 TEJAS AYYAGARI MI 2.5
## 214 52 ETHAN GUO MI 2.5
## 215 52 ETHAN GUO MI 2.5
## 216 52 ETHAN GUO MI 2.5
## 217 52 ETHAN GUO MI 2.5
## 218 53 JOSE C YBARRA MI 2.0
## 219 54 LARRY HODGE MI 2.0
## 220 55 ALEX KONG MI 2.0
## 221 55 ALEX KONG MI 2.0
## 222 56 MARISA RICCI MI 2.0
## 223 57 MICHAEL LU MI 2.0
## 224 58 VIRAJ MOHILE MI 2.0
## 225 59 SEAN M MC CORMICK MI 2.0
## 226 60 JULIA SHEN MI 1.5
## 227 60 JULIA SHEN MI 1.5
## 228 61 JEZZEL FARKAS ON 1.5
## 229 61 JEZZEL FARKAS ON 1.5
## 230 62 ASHWIN BALAJI MI 1.0
## 231 63 THOMAS JOSEPH HOSMER MI 1.0
## 232 64 BEN LI MI 1.0
## 233 64 BEN LI MI 1.0
## player_pre_rating opponent average_pre_chess_rating_of_opponent
## 1 1794 39 1146.2857
## 2 1794 21 1146.2857
## 3 1794 18 1146.2857
## 4 1794 14 1146.2857
## 5 1794 7 1146.2857
## 6 1794 12 1146.2857
## 7 1794 4 1146.2857
## 8 1553 63 1168.0000
## 9 1553 58 1168.0000
## 10 1553 17 1168.0000
## 11 1553 16 1168.0000
## 12 1553 20 1168.0000
## 13 1553 7 1168.0000
## 14 1384 61 1079.6667
## 15 1384 25 1079.6667
## 16 1384 21 1079.6667
## 17 1384 11 1079.6667
## 18 1384 13 1079.6667
## 19 1384 12 1079.6667
## 20 1716 23 1115.5714
## 21 1716 28 1115.5714
## 22 1716 2 1115.5714
## 23 1716 26 1115.5714
## 24 1716 5 1115.5714
## 25 1716 19 1115.5714
## 26 1716 1 1115.5714
## 27 1655 45 1216.4286
## 28 1655 37 1216.4286
## 29 1655 12 1216.4286
## 30 1655 13 1216.4286
## 31 1655 4 1216.4286
## 32 1655 14 1216.4286
## 33 1655 17 1216.4286
## 34 1686 34 892.5000
## 35 1686 29 892.5000
## 36 1686 35 892.5000
## 37 1686 10 892.5000
## 38 1686 27 892.5000
## 39 1686 21 892.5000
## 40 1649 57 1179.8000
## 41 1649 46 1179.8000
## 42 1649 13 1179.8000
## 43 1649 11 1179.8000
## 44 1649 9 1179.8000
## 45 1641 3 1219.0000
## 46 1641 32 1219.0000
## 47 1641 47 1219.0000
## 48 1641 28 1219.0000
## 49 1641 19 1219.0000
## 50 1411 25 1134.4000
## 51 1411 59 1134.4000
## 52 1411 8 1134.4000
## 53 1411 26 1134.4000
## 54 1411 20 1134.4000
## 55 1365 16 1189.5000
## 56 1365 55 1189.5000
## 57 1365 31 1189.5000
## 58 1365 6 1189.5000
## 59 1365 25 1189.5000
## 60 1365 18 1189.5000
## 61 1712 38 1060.2000
## 62 1712 56 1060.2000
## 63 1712 6 1060.2000
## 64 1712 34 1060.2000
## 65 1712 26 1060.2000
## 66 1663 42 1184.2000
## 67 1663 33 1184.2000
## 68 1663 5 1184.2000
## 69 1663 38 1184.2000
## 70 1663 1 1184.2000
## 71 1666 36 1069.4000
## 72 1666 27 1069.4000
## 73 1666 5 1069.4000
## 74 1666 33 1069.4000
## 75 1666 32 1069.4000
## 76 1610 54 1250.2000
## 77 1610 44 1250.2000
## 78 1610 8 1250.2000
## 79 1610 27 1250.2000
## 80 1610 31 1250.2000
## 81 1220 19 1253.8000
## 82 1220 30 1253.8000
## 83 1220 54 1253.8000
## 84 1220 33 1253.8000
## 85 1220 38 1253.8000
## 86 1604 10 951.5000
## 87 1604 15 951.5000
## 88 1604 39 951.5000
## 89 1604 36 951.5000
## 90 1629 48 1138.2500
## 91 1629 41 1138.2500
## 92 1629 23 1138.2500
## 93 1629 22 1138.2500
## 94 1600 47 1197.2500
## 95 1600 9 1197.2500
## 96 1600 32 1197.2500
## 97 1600 38 1197.2500
## 98 1564 15 1152.2000
## 99 1564 10 1152.2000
## 100 1564 52 1152.2000
## 101 1564 28 1152.2000
## 102 1564 18 1152.2000
## 103 1595 49 1208.2500
## 104 1595 23 1208.2500
## 105 1595 41 1208.2500
## 106 1595 28 1208.2500
## 107 1563 43 1274.7500
## 108 1563 47 1274.7500
## 109 1563 40 1274.7500
## 110 1563 39 1274.7500
## 111 1555 64 1303.7500
## 112 1555 52 1303.7500
## 113 1555 15 1303.7500
## 114 1555 40 1303.7500
## 115 1363 43 1320.0000
## 116 1363 58 1320.0000
## 117 1363 37 1320.0000
## 118 1363 46 1320.0000
## 119 1229 43 1307.7500
## 120 1229 60 1307.7500
## 121 1229 44 1307.7500
## 122 1229 39 1307.7500
## 123 1745 53 1028.2500
## 124 1745 24 1028.2500
## 125 1745 34 1028.2500
## 126 1745 47 1028.2500
## 127 1579 49 1217.7500
## 128 1579 40 1217.7500
## 129 1579 17 1217.7500
## 130 1579 32 1217.7500
## 131 1552 51 1290.7500
## 132 1552 46 1290.7500
## 133 1552 37 1290.7500
## 134 1552 14 1290.7500
## 135 1507 24 981.8000
## 136 1507 4 981.8000
## 137 1507 22 981.8000
## 138 1507 19 981.8000
## 139 1507 36 981.8000
## 140 1602 50 1259.5000
## 141 1602 6 1259.5000
## 142 1602 52 1259.5000
## 143 1602 48 1259.5000
## 144 1522 64 1293.5000
## 145 1522 55 1293.5000
## 146 1522 61 1293.5000
## 147 1522 50 1293.5000
## 148 1494 55 1394.0000
## 149 1494 64 1394.0000
## 150 1494 30 1394.0000
## 151 1494 50 1394.0000
## 152 1441 61 1239.2500
## 153 1441 44 1239.2500
## 154 1441 51 1239.2500
## 155 1441 26 1239.2500
## 156 1449 60 1151.5000
## 157 1449 50 1151.5000
## 158 1449 36 1151.5000
## 159 1449 51 1151.5000
## 160 1399 60 1302.2500
## 161 1399 29 1302.2500
## 162 1399 25 1302.2500
## 163 1399 52 1302.2500
## 164 1438 56 1388.0000
## 165 1438 57 1388.0000
## 166 1438 52 1388.0000
## 167 1438 48 1388.0000
## 168 1355 57 1373.0000
## 169 1355 51 1373.0000
## 170 1355 33 1373.0000
## 171 1355 28 1373.0000
## 172 980 34 678.5000
## 173 980 61 678.5000
## 174 1423 11 950.3333
## 175 1423 35 950.3333
## 176 1423 29 950.3333
## 177 1436 54 1291.0000
## 178 1436 40 1291.0000
## 179 1436 44 1291.0000
## 180 1348 20 1264.6667
## 181 1348 59 1264.6667
## 182 1348 56 1264.6667
## 183 1403 59 1423.0000
## 184 1403 58 1423.0000
## 185 1332 60 1298.5000
## 186 1332 61 1298.5000
## 187 1332 64 1298.5000
## 188 1332 56 1298.5000
## 189 1283 63 1404.6667
## 190 1283 59 1404.6667
## 191 1283 55 1404.6667
## 192 1199 53 1385.5000
## 193 1199 59 1385.5000
## 194 1242 60 1409.2500
## 195 1242 63 1409.2500
## 196 1242 55 1409.2500
## 197 1242 58 1409.2500
## 198 377 35 1005.0000
## 199 377 64 1005.0000
## 200 377 43 1005.0000
## 201 1362 24 1146.3333
## 202 1362 61 1146.3333
## 203 1362 51 1146.3333
## 204 1382 63 1351.5000
## 205 1382 52 1351.5000
## 206 1291 63 1377.6667
## 207 1291 64 1377.6667
## 208 1291 58 1377.6667
## 209 1056 42 1265.5000
## 210 1056 46 1265.5000
## 211 1011 45 1350.3333
## 212 1011 57 1350.3333
## 213 1011 47 1350.3333
## 214 935 30 1025.5000
## 215 935 22 1025.5000
## 216 935 48 1025.5000
## 217 935 35 1025.5000
## 218 1393 57 1436.0000
## 219 1270 64 1355.0000
## 220 1186 31 1322.5000
## 221 1186 45 1322.5000
## 222 1153 45 1283.0000
## 223 1092 42 1199.0000
## 224 917 31 1362.0000
## 225 853 54 1348.0000
## 226 967 45 1241.0000
## 227 967 42 1241.0000
## 228 955 54 1273.5000
## 229 955 42 1273.5000
## 230 1530 55 1436.0000
## 231 1175 49 1332.0000
## 232 1163 30 1357.0000
## 233 1163 49 1357.0000selected_columns <- merged_df %>%
select(player_name, player_state, total_num_of_points, player_pre_rating, average_pre_chess_rating_of_opponent)
print(selected_columns)## player_name player_state total_num_of_points
## 1 GARY HUA ON 6.0
## 2 GARY HUA ON 6.0
## 3 GARY HUA ON 6.0
## 4 GARY HUA ON 6.0
## 5 GARY HUA ON 6.0
## 6 GARY HUA ON 6.0
## 7 GARY HUA ON 6.0
## 8 DAKSHESH DARURI MI 6.0
## 9 DAKSHESH DARURI MI 6.0
## 10 DAKSHESH DARURI MI 6.0
## 11 DAKSHESH DARURI MI 6.0
## 12 DAKSHESH DARURI MI 6.0
## 13 DAKSHESH DARURI MI 6.0
## 14 ADITYA BAJAJ MI 6.0
## 15 ADITYA BAJAJ MI 6.0
## 16 ADITYA BAJAJ MI 6.0
## 17 ADITYA BAJAJ MI 6.0
## 18 ADITYA BAJAJ MI 6.0
## 19 ADITYA BAJAJ MI 6.0
## 20 PATRICK H SCHILLING MI 5.5
## 21 PATRICK H SCHILLING MI 5.5
## 22 PATRICK H SCHILLING MI 5.5
## 23 PATRICK H SCHILLING MI 5.5
## 24 PATRICK H SCHILLING MI 5.5
## 25 PATRICK H SCHILLING MI 5.5
## 26 PATRICK H SCHILLING MI 5.5
## 27 HANSHI ZUO MI 5.5
## 28 HANSHI ZUO MI 5.5
## 29 HANSHI ZUO MI 5.5
## 30 HANSHI ZUO MI 5.5
## 31 HANSHI ZUO MI 5.5
## 32 HANSHI ZUO MI 5.5
## 33 HANSHI ZUO MI 5.5
## 34 HANSEN SONG OH 5.0
## 35 HANSEN SONG OH 5.0
## 36 HANSEN SONG OH 5.0
## 37 HANSEN SONG OH 5.0
## 38 HANSEN SONG OH 5.0
## 39 HANSEN SONG OH 5.0
## 40 GARY DEE SWATHELL MI 5.0
## 41 GARY DEE SWATHELL MI 5.0
## 42 GARY DEE SWATHELL MI 5.0
## 43 GARY DEE SWATHELL MI 5.0
## 44 GARY DEE SWATHELL MI 5.0
## 45 EZEKIEL HOUGHTON MI 5.0
## 46 EZEKIEL HOUGHTON MI 5.0
## 47 EZEKIEL HOUGHTON MI 5.0
## 48 EZEKIEL HOUGHTON MI 5.0
## 49 EZEKIEL HOUGHTON MI 5.0
## 50 STEFANO LEE ON 5.0
## 51 STEFANO LEE ON 5.0
## 52 STEFANO LEE ON 5.0
## 53 STEFANO LEE ON 5.0
## 54 STEFANO LEE ON 5.0
## 55 ANVIT RAO MI 5.0
## 56 ANVIT RAO MI 5.0
## 57 ANVIT RAO MI 5.0
## 58 ANVIT RAO MI 5.0
## 59 ANVIT RAO MI 5.0
## 60 ANVIT RAO MI 5.0
## 61 CAMERON WILLIAM MC LEMAN MI 4.5
## 62 CAMERON WILLIAM MC LEMAN MI 4.5
## 63 CAMERON WILLIAM MC LEMAN MI 4.5
## 64 CAMERON WILLIAM MC LEMAN MI 4.5
## 65 CAMERON WILLIAM MC LEMAN MI 4.5
## 66 KENNETH J TACK MI 4.5
## 67 KENNETH J TACK MI 4.5
## 68 KENNETH J TACK MI 4.5
## 69 KENNETH J TACK MI 4.5
## 70 KENNETH J TACK MI 4.5
## 71 TORRANCE HENRY JR MI 4.5
## 72 TORRANCE HENRY JR MI 4.5
## 73 TORRANCE HENRY JR MI 4.5
## 74 TORRANCE HENRY JR MI 4.5
## 75 TORRANCE HENRY JR MI 4.5
## 76 BRADLEY SHAW MI 4.5
## 77 BRADLEY SHAW MI 4.5
## 78 BRADLEY SHAW MI 4.5
## 79 BRADLEY SHAW MI 4.5
## 80 BRADLEY SHAW MI 4.5
## 81 ZACHARY JAMES HOUGHTON MI 4.5
## 82 ZACHARY JAMES HOUGHTON MI 4.5
## 83 ZACHARY JAMES HOUGHTON MI 4.5
## 84 ZACHARY JAMES HOUGHTON MI 4.5
## 85 ZACHARY JAMES HOUGHTON MI 4.5
## 86 MIKE NIKITIN MI 4.0
## 87 MIKE NIKITIN MI 4.0
## 88 MIKE NIKITIN MI 4.0
## 89 MIKE NIKITIN MI 4.0
## 90 RONALD GRZEGORCZYK MI 4.0
## 91 RONALD GRZEGORCZYK MI 4.0
## 92 RONALD GRZEGORCZYK MI 4.0
## 93 RONALD GRZEGORCZYK MI 4.0
## 94 DAVID SUNDEEN MI 4.0
## 95 DAVID SUNDEEN MI 4.0
## 96 DAVID SUNDEEN MI 4.0
## 97 DAVID SUNDEEN MI 4.0
## 98 DIPANKAR ROY MI 4.0
## 99 DIPANKAR ROY MI 4.0
## 100 DIPANKAR ROY MI 4.0
## 101 DIPANKAR ROY MI 4.0
## 102 DIPANKAR ROY MI 4.0
## 103 JASON ZHENG MI 4.0
## 104 JASON ZHENG MI 4.0
## 105 JASON ZHENG MI 4.0
## 106 JASON ZHENG MI 4.0
## 107 DINH DANG BUI ON 4.0
## 108 DINH DANG BUI ON 4.0
## 109 DINH DANG BUI ON 4.0
## 110 DINH DANG BUI ON 4.0
## 111 EUGENE L MCCLURE MI 4.0
## 112 EUGENE L MCCLURE MI 4.0
## 113 EUGENE L MCCLURE MI 4.0
## 114 EUGENE L MCCLURE MI 4.0
## 115 ALAN BUI ON 4.0
## 116 ALAN BUI ON 4.0
## 117 ALAN BUI ON 4.0
## 118 ALAN BUI ON 4.0
## 119 MICHAEL R ALDRICH MI 4.0
## 120 MICHAEL R ALDRICH MI 4.0
## 121 MICHAEL R ALDRICH MI 4.0
## 122 MICHAEL R ALDRICH MI 4.0
## 123 LOREN SCHWIEBERT MI 3.5
## 124 LOREN SCHWIEBERT MI 3.5
## 125 LOREN SCHWIEBERT MI 3.5
## 126 LOREN SCHWIEBERT MI 3.5
## 127 MAX ZHU ON 3.5
## 128 MAX ZHU ON 3.5
## 129 MAX ZHU ON 3.5
## 130 MAX ZHU ON 3.5
## 131 GAURAV GIDWANI MI 3.5
## 132 GAURAV GIDWANI MI 3.5
## 133 GAURAV GIDWANI MI 3.5
## 134 GAURAV GIDWANI MI 3.5
## 135 SOFIA ADINA STANESCU-BELLU MI 3.5
## 136 SOFIA ADINA STANESCU-BELLU MI 3.5
## 137 SOFIA ADINA STANESCU-BELLU MI 3.5
## 138 SOFIA ADINA STANESCU-BELLU MI 3.5
## 139 SOFIA ADINA STANESCU-BELLU MI 3.5
## 140 CHIEDOZIE OKORIE MI 3.5
## 141 CHIEDOZIE OKORIE MI 3.5
## 142 CHIEDOZIE OKORIE MI 3.5
## 143 CHIEDOZIE OKORIE MI 3.5
## 144 GEORGE AVERY JONES ON 3.5
## 145 GEORGE AVERY JONES ON 3.5
## 146 GEORGE AVERY JONES ON 3.5
## 147 GEORGE AVERY JONES ON 3.5
## 148 RISHI SHETTY MI 3.5
## 149 RISHI SHETTY MI 3.5
## 150 RISHI SHETTY MI 3.5
## 151 RISHI SHETTY MI 3.5
## 152 JOSHUA PHILIP MATHEWS ON 3.5
## 153 JOSHUA PHILIP MATHEWS ON 3.5
## 154 JOSHUA PHILIP MATHEWS ON 3.5
## 155 JOSHUA PHILIP MATHEWS ON 3.5
## 156 JADE GE MI 3.5
## 157 JADE GE MI 3.5
## 158 JADE GE MI 3.5
## 159 JADE GE MI 3.5
## 160 MICHAEL JEFFERY THOMAS MI 3.5
## 161 MICHAEL JEFFERY THOMAS MI 3.5
## 162 MICHAEL JEFFERY THOMAS MI 3.5
## 163 MICHAEL JEFFERY THOMAS MI 3.5
## 164 JOSHUA DAVID LEE MI 3.5
## 165 JOSHUA DAVID LEE MI 3.5
## 166 JOSHUA DAVID LEE MI 3.5
## 167 JOSHUA DAVID LEE MI 3.5
## 168 SIDDHARTH JHA MI 3.5
## 169 SIDDHARTH JHA MI 3.5
## 170 SIDDHARTH JHA MI 3.5
## 171 SIDDHARTH JHA MI 3.5
## 172 AMIYATOSH PWNANANDAM MI 3.5
## 173 AMIYATOSH PWNANANDAM MI 3.5
## 174 BRIAN LIU MI 3.0
## 175 BRIAN LIU MI 3.0
## 176 BRIAN LIU MI 3.0
## 177 JOEL R HENDON MI 3.0
## 178 JOEL R HENDON MI 3.0
## 179 JOEL R HENDON MI 3.0
## 180 FOREST ZHANG MI 3.0
## 181 FOREST ZHANG MI 3.0
## 182 FOREST ZHANG MI 3.0
## 183 KYLE WILLIAM MURPHY MI 3.0
## 184 KYLE WILLIAM MURPHY MI 3.0
## 185 JARED GE MI 3.0
## 186 JARED GE MI 3.0
## 187 JARED GE MI 3.0
## 188 JARED GE MI 3.0
## 189 ROBERT GLEN VASEY MI 3.0
## 190 ROBERT GLEN VASEY MI 3.0
## 191 ROBERT GLEN VASEY MI 3.0
## 192 JUSTIN D SCHILLING MI 3.0
## 193 JUSTIN D SCHILLING MI 3.0
## 194 DEREK YAN MI 3.0
## 195 DEREK YAN MI 3.0
## 196 DEREK YAN MI 3.0
## 197 DEREK YAN MI 3.0
## 198 JACOB ALEXANDER LAVALLEY MI 3.0
## 199 JACOB ALEXANDER LAVALLEY MI 3.0
## 200 JACOB ALEXANDER LAVALLEY MI 3.0
## 201 ERIC WRIGHT MI 2.5
## 202 ERIC WRIGHT MI 2.5
## 203 ERIC WRIGHT MI 2.5
## 204 DANIEL KHAIN MI 2.5
## 205 DANIEL KHAIN MI 2.5
## 206 MICHAEL J MARTIN MI 2.5
## 207 MICHAEL J MARTIN MI 2.5
## 208 MICHAEL J MARTIN MI 2.5
## 209 SHIVAM JHA MI 2.5
## 210 SHIVAM JHA MI 2.5
## 211 TEJAS AYYAGARI MI 2.5
## 212 TEJAS AYYAGARI MI 2.5
## 213 TEJAS AYYAGARI MI 2.5
## 214 ETHAN GUO MI 2.5
## 215 ETHAN GUO MI 2.5
## 216 ETHAN GUO MI 2.5
## 217 ETHAN GUO MI 2.5
## 218 JOSE C YBARRA MI 2.0
## 219 LARRY HODGE MI 2.0
## 220 ALEX KONG MI 2.0
## 221 ALEX KONG MI 2.0
## 222 MARISA RICCI MI 2.0
## 223 MICHAEL LU MI 2.0
## 224 VIRAJ MOHILE MI 2.0
## 225 SEAN M MC CORMICK MI 2.0
## 226 JULIA SHEN MI 1.5
## 227 JULIA SHEN MI 1.5
## 228 JEZZEL FARKAS ON 1.5
## 229 JEZZEL FARKAS ON 1.5
## 230 ASHWIN BALAJI MI 1.0
## 231 THOMAS JOSEPH HOSMER MI 1.0
## 232 BEN LI MI 1.0
## 233 BEN LI MI 1.0
## player_pre_rating average_pre_chess_rating_of_opponent
## 1 1794 1146.2857
## 2 1794 1146.2857
## 3 1794 1146.2857
## 4 1794 1146.2857
## 5 1794 1146.2857
## 6 1794 1146.2857
## 7 1794 1146.2857
## 8 1553 1168.0000
## 9 1553 1168.0000
## 10 1553 1168.0000
## 11 1553 1168.0000
## 12 1553 1168.0000
## 13 1553 1168.0000
## 14 1384 1079.6667
## 15 1384 1079.6667
## 16 1384 1079.6667
## 17 1384 1079.6667
## 18 1384 1079.6667
## 19 1384 1079.6667
## 20 1716 1115.5714
## 21 1716 1115.5714
## 22 1716 1115.5714
## 23 1716 1115.5714
## 24 1716 1115.5714
## 25 1716 1115.5714
## 26 1716 1115.5714
## 27 1655 1216.4286
## 28 1655 1216.4286
## 29 1655 1216.4286
## 30 1655 1216.4286
## 31 1655 1216.4286
## 32 1655 1216.4286
## 33 1655 1216.4286
## 34 1686 892.5000
## 35 1686 892.5000
## 36 1686 892.5000
## 37 1686 892.5000
## 38 1686 892.5000
## 39 1686 892.5000
## 40 1649 1179.8000
## 41 1649 1179.8000
## 42 1649 1179.8000
## 43 1649 1179.8000
## 44 1649 1179.8000
## 45 1641 1219.0000
## 46 1641 1219.0000
## 47 1641 1219.0000
## 48 1641 1219.0000
## 49 1641 1219.0000
## 50 1411 1134.4000
## 51 1411 1134.4000
## 52 1411 1134.4000
## 53 1411 1134.4000
## 54 1411 1134.4000
## 55 1365 1189.5000
## 56 1365 1189.5000
## 57 1365 1189.5000
## 58 1365 1189.5000
## 59 1365 1189.5000
## 60 1365 1189.5000
## 61 1712 1060.2000
## 62 1712 1060.2000
## 63 1712 1060.2000
## 64 1712 1060.2000
## 65 1712 1060.2000
## 66 1663 1184.2000
## 67 1663 1184.2000
## 68 1663 1184.2000
## 69 1663 1184.2000
## 70 1663 1184.2000
## 71 1666 1069.4000
## 72 1666 1069.4000
## 73 1666 1069.4000
## 74 1666 1069.4000
## 75 1666 1069.4000
## 76 1610 1250.2000
## 77 1610 1250.2000
## 78 1610 1250.2000
## 79 1610 1250.2000
## 80 1610 1250.2000
## 81 1220 1253.8000
## 82 1220 1253.8000
## 83 1220 1253.8000
## 84 1220 1253.8000
## 85 1220 1253.8000
## 86 1604 951.5000
## 87 1604 951.5000
## 88 1604 951.5000
## 89 1604 951.5000
## 90 1629 1138.2500
## 91 1629 1138.2500
## 92 1629 1138.2500
## 93 1629 1138.2500
## 94 1600 1197.2500
## 95 1600 1197.2500
## 96 1600 1197.2500
## 97 1600 1197.2500
## 98 1564 1152.2000
## 99 1564 1152.2000
## 100 1564 1152.2000
## 101 1564 1152.2000
## 102 1564 1152.2000
## 103 1595 1208.2500
## 104 1595 1208.2500
## 105 1595 1208.2500
## 106 1595 1208.2500
## 107 1563 1274.7500
## 108 1563 1274.7500
## 109 1563 1274.7500
## 110 1563 1274.7500
## 111 1555 1303.7500
## 112 1555 1303.7500
## 113 1555 1303.7500
## 114 1555 1303.7500
## 115 1363 1320.0000
## 116 1363 1320.0000
## 117 1363 1320.0000
## 118 1363 1320.0000
## 119 1229 1307.7500
## 120 1229 1307.7500
## 121 1229 1307.7500
## 122 1229 1307.7500
## 123 1745 1028.2500
## 124 1745 1028.2500
## 125 1745 1028.2500
## 126 1745 1028.2500
## 127 1579 1217.7500
## 128 1579 1217.7500
## 129 1579 1217.7500
## 130 1579 1217.7500
## 131 1552 1290.7500
## 132 1552 1290.7500
## 133 1552 1290.7500
## 134 1552 1290.7500
## 135 1507 981.8000
## 136 1507 981.8000
## 137 1507 981.8000
## 138 1507 981.8000
## 139 1507 981.8000
## 140 1602 1259.5000
## 141 1602 1259.5000
## 142 1602 1259.5000
## 143 1602 1259.5000
## 144 1522 1293.5000
## 145 1522 1293.5000
## 146 1522 1293.5000
## 147 1522 1293.5000
## 148 1494 1394.0000
## 149 1494 1394.0000
## 150 1494 1394.0000
## 151 1494 1394.0000
## 152 1441 1239.2500
## 153 1441 1239.2500
## 154 1441 1239.2500
## 155 1441 1239.2500
## 156 1449 1151.5000
## 157 1449 1151.5000
## 158 1449 1151.5000
## 159 1449 1151.5000
## 160 1399 1302.2500
## 161 1399 1302.2500
## 162 1399 1302.2500
## 163 1399 1302.2500
## 164 1438 1388.0000
## 165 1438 1388.0000
## 166 1438 1388.0000
## 167 1438 1388.0000
## 168 1355 1373.0000
## 169 1355 1373.0000
## 170 1355 1373.0000
## 171 1355 1373.0000
## 172 980 678.5000
## 173 980 678.5000
## 174 1423 950.3333
## 175 1423 950.3333
## 176 1423 950.3333
## 177 1436 1291.0000
## 178 1436 1291.0000
## 179 1436 1291.0000
## 180 1348 1264.6667
## 181 1348 1264.6667
## 182 1348 1264.6667
## 183 1403 1423.0000
## 184 1403 1423.0000
## 185 1332 1298.5000
## 186 1332 1298.5000
## 187 1332 1298.5000
## 188 1332 1298.5000
## 189 1283 1404.6667
## 190 1283 1404.6667
## 191 1283 1404.6667
## 192 1199 1385.5000
## 193 1199 1385.5000
## 194 1242 1409.2500
## 195 1242 1409.2500
## 196 1242 1409.2500
## 197 1242 1409.2500
## 198 377 1005.0000
## 199 377 1005.0000
## 200 377 1005.0000
## 201 1362 1146.3333
## 202 1362 1146.3333
## 203 1362 1146.3333
## 204 1382 1351.5000
## 205 1382 1351.5000
## 206 1291 1377.6667
## 207 1291 1377.6667
## 208 1291 1377.6667
## 209 1056 1265.5000
## 210 1056 1265.5000
## 211 1011 1350.3333
## 212 1011 1350.3333
## 213 1011 1350.3333
## 214 935 1025.5000
## 215 935 1025.5000
## 216 935 1025.5000
## 217 935 1025.5000
## 218 1393 1436.0000
## 219 1270 1355.0000
## 220 1186 1322.5000
## 221 1186 1322.5000
## 222 1153 1283.0000
## 223 1092 1199.0000
## 224 917 1362.0000
## 225 853 1348.0000
## 226 967 1241.0000
## 227 967 1241.0000
## 228 955 1273.5000
## 229 955 1273.5000
## 230 1530 1436.0000
## 231 1175 1332.0000
## 232 1163 1357.0000
## 233 1163 1357.0000our_final_chess_df <- selected_columns %>% distinct()
print(our_final_chess_df)## player_name player_state total_num_of_points
## 1 GARY HUA ON 6.0
## 2 DAKSHESH DARURI MI 6.0
## 3 ADITYA BAJAJ MI 6.0
## 4 PATRICK H SCHILLING MI 5.5
## 5 HANSHI ZUO MI 5.5
## 6 HANSEN SONG OH 5.0
## 7 GARY DEE SWATHELL MI 5.0
## 8 EZEKIEL HOUGHTON MI 5.0
## 9 STEFANO LEE ON 5.0
## 10 ANVIT RAO MI 5.0
## 11 CAMERON WILLIAM MC LEMAN MI 4.5
## 12 KENNETH J TACK MI 4.5
## 13 TORRANCE HENRY JR MI 4.5
## 14 BRADLEY SHAW MI 4.5
## 15 ZACHARY JAMES HOUGHTON MI 4.5
## 16 MIKE NIKITIN MI 4.0
## 17 RONALD GRZEGORCZYK MI 4.0
## 18 DAVID SUNDEEN MI 4.0
## 19 DIPANKAR ROY MI 4.0
## 20 JASON ZHENG MI 4.0
## 21 DINH DANG BUI ON 4.0
## 22 EUGENE L MCCLURE MI 4.0
## 23 ALAN BUI ON 4.0
## 24 MICHAEL R ALDRICH MI 4.0
## 25 LOREN SCHWIEBERT MI 3.5
## 26 MAX ZHU ON 3.5
## 27 GAURAV GIDWANI MI 3.5
## 28 SOFIA ADINA STANESCU-BELLU MI 3.5
## 29 CHIEDOZIE OKORIE MI 3.5
## 30 GEORGE AVERY JONES ON 3.5
## 31 RISHI SHETTY MI 3.5
## 32 JOSHUA PHILIP MATHEWS ON 3.5
## 33 JADE GE MI 3.5
## 34 MICHAEL JEFFERY THOMAS MI 3.5
## 35 JOSHUA DAVID LEE MI 3.5
## 36 SIDDHARTH JHA MI 3.5
## 37 AMIYATOSH PWNANANDAM MI 3.5
## 38 BRIAN LIU MI 3.0
## 39 JOEL R HENDON MI 3.0
## 40 FOREST ZHANG MI 3.0
## 41 KYLE WILLIAM MURPHY MI 3.0
## 42 JARED GE MI 3.0
## 43 ROBERT GLEN VASEY MI 3.0
## 44 JUSTIN D SCHILLING MI 3.0
## 45 DEREK YAN MI 3.0
## 46 JACOB ALEXANDER LAVALLEY MI 3.0
## 47 ERIC WRIGHT MI 2.5
## 48 DANIEL KHAIN MI 2.5
## 49 MICHAEL J MARTIN MI 2.5
## 50 SHIVAM JHA MI 2.5
## 51 TEJAS AYYAGARI MI 2.5
## 52 ETHAN GUO MI 2.5
## 53 JOSE C YBARRA MI 2.0
## 54 LARRY HODGE MI 2.0
## 55 ALEX KONG MI 2.0
## 56 MARISA RICCI MI 2.0
## 57 MICHAEL LU MI 2.0
## 58 VIRAJ MOHILE MI 2.0
## 59 SEAN M MC CORMICK MI 2.0
## 60 JULIA SHEN MI 1.5
## 61 JEZZEL FARKAS ON 1.5
## 62 ASHWIN BALAJI MI 1.0
## 63 THOMAS JOSEPH HOSMER MI 1.0
## 64 BEN LI MI 1.0
## player_pre_rating average_pre_chess_rating_of_opponent
## 1 1794 1146.2857
## 2 1553 1168.0000
## 3 1384 1079.6667
## 4 1716 1115.5714
## 5 1655 1216.4286
## 6 1686 892.5000
## 7 1649 1179.8000
## 8 1641 1219.0000
## 9 1411 1134.4000
## 10 1365 1189.5000
## 11 1712 1060.2000
## 12 1663 1184.2000
## 13 1666 1069.4000
## 14 1610 1250.2000
## 15 1220 1253.8000
## 16 1604 951.5000
## 17 1629 1138.2500
## 18 1600 1197.2500
## 19 1564 1152.2000
## 20 1595 1208.2500
## 21 1563 1274.7500
## 22 1555 1303.7500
## 23 1363 1320.0000
## 24 1229 1307.7500
## 25 1745 1028.2500
## 26 1579 1217.7500
## 27 1552 1290.7500
## 28 1507 981.8000
## 29 1602 1259.5000
## 30 1522 1293.5000
## 31 1494 1394.0000
## 32 1441 1239.2500
## 33 1449 1151.5000
## 34 1399 1302.2500
## 35 1438 1388.0000
## 36 1355 1373.0000
## 37 980 678.5000
## 38 1423 950.3333
## 39 1436 1291.0000
## 40 1348 1264.6667
## 41 1403 1423.0000
## 42 1332 1298.5000
## 43 1283 1404.6667
## 44 1199 1385.5000
## 45 1242 1409.2500
## 46 377 1005.0000
## 47 1362 1146.3333
## 48 1382 1351.5000
## 49 1291 1377.6667
## 50 1056 1265.5000
## 51 1011 1350.3333
## 52 935 1025.5000
## 53 1393 1436.0000
## 54 1270 1355.0000
## 55 1186 1322.5000
## 56 1153 1283.0000
## 57 1092 1199.0000
## 58 917 1362.0000
## 59 853 1348.0000
## 60 967 1241.0000
## 61 955 1273.5000
## 62 1530 1436.0000
## 63 1175 1332.0000
## 64 1163 1357.0000Let me try to do the same but without for-loop.
# column_names <- c("player_name", "player_state", "total_num_of_points", "player_pre_rating", "average_pre_chess_rating_of_opponent")
#
# our_final_chess_df <- data.frame(matrix(ncol = length(column_names), nrow = 0))
# colnames(our_final_chess_df) <- column_names
#
# our_chess_df$player_pre_rating <- as.numeric(our_chess_df$player_pre_rating)
#
# df_opponents <- our_chess_df %>%
# group_by(id) %>%
# summarize(average_pre_chess_rating_of_opponent = mean(player_pre_rating[match(opponent, id)], na.rm = TRUE))
# !!!!!issue is here df_opponents !!!!
#
# merged_df <- our_chess_df %>%
# left_join(df_opponents, by = "id")
#
# selected_columns <- merged_df %>%
# select(player_name, player_state, total_num_of_points, player_pre_rating, average_pre_chess_rating_of_opponent)
#
# our_final_chess_df <- selected_columns %>% distinct()
# print(our_final_chess_df)Unfortunately, this approach isn’t working due to issues with calculating the mean value. It seems that using a loop is a more effective solution for this task. Please disregard the previous method.
Now, we need to store our dataframe in .CSV file. Let us do it.
write.csv(our_final_chess_df, "final_chess_data.csv", row.names = FALSE)String manipulation to find patterns with regex and extract necessary data is quite challenging. Hopefully, people will stop storing data in text files in incredibly inconvenient formats. There are so many better tools available, such as Excel, databases, or even Word tables or Microsoft Access, that make data handling much easier.
I dedicated 25 hours to complete this task, and I hope it proves valuable. Thank you!