The goal of this project is to transform, clean, and tidy a delimited text file with chess tournament results. The resulting data is output into a csv file containing the following columns as needed: Player Name, Player State, Total Number of Points, Player Pre-Rating, and Average Pre Chess Rating of Opponents.
Read in txt file as data frame
data = read.delim("https://raw.githubusercontent.com/okazevedo90/DATA607_GitHub/refs/heads/main/tournamentinfo.txt",
header = FALSE, sep = "|", skip = 4,
col.names = c('Num', 'Player', 'Pts', 'Round_1', 'Round_2', 'Round_3', 'Round_4', 'Round_5', 'Round_6', 'Round_7', 'NA'))| Num | Player | Pts | Round_1 | Round_2 | Round_3 | Round_4 | Round_5 | Round_6 | Round_7 | NA. |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | GARY HUA | 6.0 | W 39 | W 21 | W 18 | W 14 | W 7 | D 12 | D 4 | NA |
| ON | 15445895 / R: 1794 ->1817 | N:2 | W | B | W | B | W | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 2 | DAKSHESH DARURI | 6.0 | W 63 | W 58 | L 4 | W 17 | W 16 | W 20 | W 7 | NA |
| MI | 14598900 / R: 1553 ->1663 | N:2 | B | W | B | W | B | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 3 | ADITYA BAJAJ | 6.0 | L 8 | W 61 | W 25 | W 21 | W 11 | W 13 | W 12 | NA |
| MI | 14959604 / R: 1384 ->1640 | N:2 | W | B | W | B | W | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 4 | PATRICK H SCHILLING | 5.5 | W 23 | D 28 | W 2 | W 26 | D 5 | W 19 | D 1 | NA |
| MI | 12616049 / R: 1716 ->1744 | N:2 | W | B | W | B | W | B | B | NA |
| —————————————————————————————– | NA | |||||||||
| 5 | HANSHI ZUO | 5.5 | W 45 | W 37 | D 12 | D 13 | D 4 | W 14 | W 17 | NA |
| MI | 14601533 / R: 1655 ->1690 | N:2 | B | W | B | W | B | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 6 | HANSEN SONG | 5.0 | W 34 | D 29 | L 11 | W 35 | D 10 | W 27 | W 21 | NA |
| OH | 15055204 / R: 1686 ->1687 | N:3 | W | B | W | B | B | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 7 | GARY DEE SWATHELL | 5.0 | W 57 | W 46 | W 13 | W 11 | L 1 | W 9 | L 2 | NA |
| MI | 11146376 / R: 1649 ->1673 | N:3 | W | B | W | B | B | W | W | NA |
| —————————————————————————————– | NA | |||||||||
| 8 | EZEKIEL HOUGHTON | 5.0 | W 3 | W 32 | L 14 | L 9 | W 47 | W 28 | W 19 | NA |
| MI | 15142253 / R: 1641P17->1657P24 | N:3 | B | W | B | W | B | W | W | NA |
| —————————————————————————————– | NA | |||||||||
| 9 | STEFANO LEE | 5.0 | W 25 | L 18 | W 59 | W 8 | W 26 | L 7 | W 20 | NA |
| ON | 14954524 / R: 1411 ->1564 | N:2 | W | B | W | B | W | B | B | NA |
| —————————————————————————————– | NA | |||||||||
| 10 | ANVIT RAO | 5.0 | D 16 | L 19 | W 55 | W 31 | D 6 | W 25 | W 18 | NA |
| MI | 14150362 / R: 1365 ->1544 | N:3 | W | W | B | B | W | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | D 38 | W 56 | W 6 | L 7 | L 3 | W 34 | W 26 | NA |
| MI | 12581589 / R: 1712 ->1696 | N:3 | B | W | B | W | B | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 12 | KENNETH J TACK | 4.5 | W 42 | W 33 | D 5 | W 38 | H | D 1 | L 3 | NA |
| MI | 12681257 / R: 1663 ->1670 | N:3 | W | B | W | B | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 13 | TORRANCE HENRY JR | 4.5 | W 36 | W 27 | L 7 | D 5 | W 33 | L 3 | W 32 | NA |
| MI | 15082995 / R: 1666 ->1662 | N:3 | B | W | B | B | W | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 14 | BRADLEY SHAW | 4.5 | W 54 | W 44 | W 8 | L 1 | D 27 | L 5 | W 31 | NA |
| MI | 10131499 / R: 1610 ->1618 | N:3 | W | B | W | W | B | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | D 19 | L 16 | W 30 | L 22 | W 54 | W 33 | W 38 | NA |
| MI | 15619130 / R: 1220P13->1416P20 | N:3 | B | B | W | W | B | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 16 | MIKE NIKITIN | 4.0 | D 10 | W 15 | H | W 39 | L 2 | W 36 | U | NA |
| MI | 10295068 / R: 1604 ->1613 | N:3 | B | W | B | W | B | NA | ||
| —————————————————————————————– | NA | |||||||||
| 17 | RONALD GRZEGORCZYK | 4.0 | W 48 | W 41 | L 26 | L 2 | W 23 | W 22 | L 5 | NA |
| MI | 10297702 / R: 1629 ->1610 | N:3 | W | B | W | B | W | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 18 | DAVID SUNDEEN | 4.0 | W 47 | W 9 | L 1 | W 32 | L 19 | W 38 | L 10 | NA |
| MI | 11342094 / R: 1600 ->1600 | N:3 | B | W | B | W | B | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 19 | DIPANKAR ROY | 4.0 | D 15 | W 10 | W 52 | D 28 | W 18 | L 4 | L 8 | NA |
| MI | 14862333 / R: 1564 ->1570 | N:3 | W | B | W | B | W | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 20 | JASON ZHENG | 4.0 | L 40 | W 49 | W 23 | W 41 | W 28 | L 2 | L 9 | NA |
| MI | 14529060 / R: 1595 ->1569 | N:4 | W | B | W | B | W | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 21 | DINH DANG BUI | 4.0 | W 43 | L 1 | W 47 | L 3 | W 40 | W 39 | L 6 | NA |
| ON | 15495066 / R: 1563P22->1562 | N:3 | B | W | B | W | W | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 22 | EUGENE L MCCLURE | 4.0 | W 64 | D 52 | L 28 | W 15 | H | L 17 | W 40 | NA |
| MI | 12405534 / R: 1555 ->1529 | N:4 | W | B | W | B | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 23 | ALAN BUI | 4.0 | L 4 | W 43 | L 20 | W 58 | L 17 | W 37 | W 46 | NA |
| ON | 15030142 / R: 1363 ->1371 | B | W | B | W | B | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 24 | MICHAEL R ALDRICH | 4.0 | L 28 | L 47 | W 43 | L 25 | W 60 | W 44 | W 39 | NA |
| MI | 13469010 / R: 1229 ->1300 | N:4 | B | W | B | B | W | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 25 | LOREN SCHWIEBERT | 3.5 | L 9 | W 53 | L 3 | W 24 | D 34 | L 10 | W 47 | NA |
| MI | 12486656 / R: 1745 ->1681 | N:4 | B | W | B | W | B | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 26 | MAX ZHU | 3.5 | W 49 | W 40 | W 17 | L 4 | L 9 | D 32 | L 11 | NA |
| ON | 15131520 / R: 1579 ->1564 | N:4 | B | W | B | W | B | W | W | NA |
| —————————————————————————————– | NA | |||||||||
| 27 | GAURAV GIDWANI | 3.5 | W 51 | L 13 | W 46 | W 37 | D 14 | L 6 | U | NA |
| MI | 14476567 / R: 1552 ->1539 | N:4 | W | B | W | B | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | W 24 | D 4 | W 22 | D 19 | L 20 | L 8 | D 36 | NA |
| MI | 14882954 / R: 1507 ->1513 | N:3 | W | W | B | W | B | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 29 | CHIEDOZIE OKORIE | 3.5 | W 50 | D 6 | L 38 | L 34 | W 52 | W 48 | U | NA |
| MI | 15323285 / R: 1602P6 ->1508P12 | N:4 | B | W | B | W | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 30 | GEORGE AVERY JONES | 3.5 | L 52 | D 64 | L 15 | W 55 | L 31 | W 61 | W 50 | NA |
| ON | 12577178 / R: 1522 ->1444 | W | B | B | W | W | B | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 31 | RISHI SHETTY | 3.5 | L 58 | D 55 | W 64 | L 10 | W 30 | W 50 | L 14 | NA |
| MI | 15131618 / R: 1494 ->1444 | B | W | B | W | B | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | W 61 | L 8 | W 44 | L 18 | W 51 | D 26 | L 13 | NA |
| ON | 14073750 / R: 1441 ->1433 | N:4 | W | B | W | B | W | B | W | NA |
| —————————————————————————————– | NA | |||||||||
| 33 | JADE GE | 3.5 | W 60 | L 12 | W 50 | D 36 | L 13 | L 15 | W 51 | NA |
| MI | 14691842 / R: 1449 ->1421 | B | W | B | W | B | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | L 6 | W 60 | L 37 | W 29 | D 25 | L 11 | W 52 | NA |
| MI | 15051807 / R: 1399 ->1400 | B | W | B | B | W | B | W | NA | |
| —————————————————————————————– | NA | |||||||||
| 35 | JOSHUA DAVID LEE | 3.5 | L 46 | L 38 | W 56 | L 6 | W 57 | D 52 | W 48 | NA |
| MI | 14601397 / R: 1438 ->1392 | W | W | B | W | B | B | W | NA | |
| —————————————————————————————– | NA | |||||||||
| 36 | SIDDHARTH JHA | 3.5 | L 13 | W 57 | W 51 | D 33 | H | L 16 | D 28 | NA |
| MI | 14773163 / R: 1355 ->1367 | N:4 | W | B | W | B | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 37 | AMIYATOSH PWNANANDAM | 3.5 | B | L 5 | W 34 | L 27 | H | L 23 | W 61 | NA |
| MI | 15489571 / R: 980P12->1077P17 | B | W | W | B | W | NA | |||
| —————————————————————————————– | NA | |||||||||
| 38 | BRIAN LIU | 3.0 | D 11 | W 35 | W 29 | L 12 | H | L 18 | L 15 | NA |
| MI | 15108523 / R: 1423 ->1439 | N:4 | W | B | W | W | B | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 39 | JOEL R HENDON | 3.0 | L 1 | W 54 | W 40 | L 16 | W 44 | L 21 | L 24 | NA |
| MI | 12923035 / R: 1436P23->1413 | N:4 | B | W | B | W | B | W | W | NA |
| —————————————————————————————– | NA | |||||||||
| 40 | FOREST ZHANG | 3.0 | W 20 | L 26 | L 39 | W 59 | L 21 | W 56 | L 22 | NA |
| MI | 14892710 / R: 1348 ->1346 | B | B | W | W | B | W | W | NA | |
| —————————————————————————————– | NA | |||||||||
| 41 | KYLE WILLIAM MURPHY | 3.0 | W 59 | L 17 | W 58 | L 20 | X | U | U | NA |
| MI | 15761443 / R: 1403P5 ->1341P9 | B | W | B | W | NA | ||||
| —————————————————————————————– | NA | |||||||||
| 42 | JARED GE | 3.0 | L 12 | L 50 | L 57 | D 60 | D 61 | W 64 | W 56 | NA |
| MI | 14462326 / R: 1332 ->1256 | B | W | B | B | W | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 43 | ROBERT GLEN VASEY | 3.0 | L 21 | L 23 | L 24 | W 63 | W 59 | L 46 | W 55 | NA |
| MI | 14101068 / R: 1283 ->1244 | W | B | W | W | B | B | W | NA | |
| —————————————————————————————– | NA | |||||||||
| 44 | JUSTIN D SCHILLING | 3.0 | B | L 14 | L 32 | W 53 | L 39 | L 24 | W 59 | NA |
| MI | 15323504 / R: 1199 ->1199 | W | B | B | W | B | W | NA | ||
| —————————————————————————————– | NA | |||||||||
| 45 | DEREK YAN | 3.0 | L 5 | L 51 | D 60 | L 56 | W 63 | D 55 | W 58 | NA |
| MI | 15372807 / R: 1242 ->1191 | W | B | W | B | W | B | W | NA | |
| —————————————————————————————– | NA | |||||||||
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | W 35 | L 7 | L 27 | L 50 | W 64 | W 43 | L 23 | NA |
| MI | 15490981 / R: 377P3 ->1076P10 | B | W | B | W | B | W | W | NA | |
| —————————————————————————————– | NA | |||||||||
| 47 | ERIC WRIGHT | 2.5 | L 18 | W 24 | L 21 | W 61 | L 8 | D 51 | L 25 | NA |
| MI | 12533115 / R: 1362 ->1341 | W | B | W | B | W | B | W | NA | |
| —————————————————————————————– | NA | |||||||||
| 48 | DANIEL KHAIN | 2.5 | L 17 | W 63 | H | D 52 | H | L 29 | L 35 | NA |
| MI | 14369165 / R: 1382 ->1335 | B | W | B | W | B | NA | |||
| —————————————————————————————– | NA | |||||||||
| 49 | MICHAEL J MARTIN | 2.5 | L 26 | L 20 | D 63 | D 64 | W 58 | H | U | NA |
| MI | 12531685 / R: 1291P12->1259P17 | W | W | B | W | B | NA | |||
| —————————————————————————————– | NA | |||||||||
| 50 | SHIVAM JHA | 2.5 | L 29 | W 42 | L 33 | W 46 | H | L 31 | L 30 | NA |
| MI | 14773178 / R: 1056 ->1111 | W | B | W | B | B | W | NA | ||
| —————————————————————————————– | NA | |||||||||
| 51 | TEJAS AYYAGARI | 2.5 | L 27 | W 45 | L 36 | W 57 | L 32 | D 47 | L 33 | NA |
| MI | 15205474 / R: 1011 ->1097 | B | W | B | W | B | W | W | NA | |
| —————————————————————————————– | NA | |||||||||
| 52 | ETHAN GUO | 2.5 | W 30 | D 22 | L 19 | D 48 | L 29 | D 35 | L 34 | NA |
| MI | 14918803 / R: 935 ->1092 | N:4 | B | W | B | W | B | W | B | NA |
| —————————————————————————————– | NA | |||||||||
| 53 | JOSE C YBARRA | 2.0 | H | L 25 | H | L 44 | U | W 57 | U | NA |
| MI | 12578849 / R: 1393 ->1359 | B | W | W | NA | |||||
| —————————————————————————————– | NA | |||||||||
| 54 | LARRY HODGE | 2.0 | L 14 | L 39 | L 61 | B | L 15 | L 59 | W 64 | NA |
| MI | 12836773 / R: 1270 ->1200 | B | B | W | W | B | W | NA | ||
| —————————————————————————————– | NA | |||||||||
| 55 | ALEX KONG | 2.0 | L 62 | D 31 | L 10 | L 30 | B | D 45 | L 43 | NA |
| MI | 15412571 / R: 1186 ->1163 | W | B | W | B | W | B | NA | ||
| —————————————————————————————– | NA | |||||||||
| 56 | MARISA RICCI | 2.0 | H | L 11 | L 35 | W 45 | H | L 40 | L 42 | NA |
| MI | 14679887 / R: 1153 ->1140 | B | W | W | B | W | NA | |||
| —————————————————————————————– | NA | |||||||||
| 57 | MICHAEL LU | 2.0 | L 7 | L 36 | W 42 | L 51 | L 35 | L 53 | B | NA |
| MI | 15113330 / R: 1092 ->1079 | B | W | W | B | W | B | NA | ||
| —————————————————————————————– | NA | |||||||||
| 58 | VIRAJ MOHILE | 2.0 | W 31 | L 2 | L 41 | L 23 | L 49 | B | L 45 | NA |
| MI | 14700365 / R: 917 -> 941 | W | B | W | B | W | B | NA | ||
| —————————————————————————————– | NA | |||||||||
| 59 | SEAN M MC CORMICK | 2.0 | L 41 | B | L 9 | L 40 | L 43 | W 54 | L 44 | NA |
| MI | 12841036 / R: 853 -> 878 | W | B | B | W | W | B | NA | ||
| —————————————————————————————– | NA | |||||||||
| 60 | JULIA SHEN | 1.5 | L 33 | L 34 | D 45 | D 42 | L 24 | H | U | NA |
| MI | 14579262 / R: 967 -> 984 | W | B | B | W | B | NA | |||
| —————————————————————————————– | NA | |||||||||
| 61 | JEZZEL FARKAS | 1.5 | L 32 | L 3 | W 54 | L 47 | D 42 | L 30 | L 37 | NA |
| ON | 15771592 / R: 955P11-> 979P18 | B | W | B | W | B | W | B | NA | |
| —————————————————————————————– | NA | |||||||||
| 62 | ASHWIN BALAJI | 1.0 | W 55 | U | U | U | U | U | U | NA |
| MI | 15219542 / R: 1530 ->1535 | B | NA | |||||||
| —————————————————————————————– | NA | |||||||||
| 63 | THOMAS JOSEPH HOSMER | 1.0 | L 2 | L 48 | D 49 | L 43 | L 45 | H | U | NA |
| MI | 15057092 / R: 1175 ->1125 | W | B | W | B | B | NA | |||
| —————————————————————————————– | NA | |||||||||
| 64 | BEN LI | 1.0 | L 22 | D 30 | L 31 | D 49 | L 46 | L 42 | L 54 | NA |
| MI | 15006561 / R: 1163 ->1112 | B | W | W | B | W | B | B | NA | |
| —————————————————————————————– | NA |
df = data |>
filter(!str_detect(Num, "-")) |>
mutate_if(is.character, str_trim) |>
select(-last_col())| Num | Player | Pts | Round_1 | Round_2 | Round_3 | Round_4 | Round_5 | Round_6 | Round_7 |
|---|---|---|---|---|---|---|---|---|---|
| 1 | GARY HUA | 6.0 | W 39 | W 21 | W 18 | W 14 | W 7 | D 12 | D 4 |
| ON | 15445895 / R: 1794 ->1817 | N:2 | W | B | W | B | W | B | W |
| 2 | DAKSHESH DARURI | 6.0 | W 63 | W 58 | L 4 | W 17 | W 16 | W 20 | W 7 |
| MI | 14598900 / R: 1553 ->1663 | N:2 | B | W | B | W | B | W | B |
| 3 | ADITYA BAJAJ | 6.0 | L 8 | W 61 | W 25 | W 21 | W 11 | W 13 | W 12 |
| MI | 14959604 / R: 1384 ->1640 | N:2 | W | B | W | B | W | B | W |
| 4 | PATRICK H SCHILLING | 5.5 | W 23 | D 28 | W 2 | W 26 | D 5 | W 19 | D 1 |
| MI | 12616049 / R: 1716 ->1744 | N:2 | W | B | W | B | W | B | B |
| 5 | HANSHI ZUO | 5.5 | W 45 | W 37 | D 12 | D 13 | D 4 | W 14 | W 17 |
| MI | 14601533 / R: 1655 ->1690 | N:2 | B | W | B | W | B | W | B |
| 6 | HANSEN SONG | 5.0 | W 34 | D 29 | L 11 | W 35 | D 10 | W 27 | W 21 |
| OH | 15055204 / R: 1686 ->1687 | N:3 | W | B | W | B | B | W | B |
| 7 | GARY DEE SWATHELL | 5.0 | W 57 | W 46 | W 13 | W 11 | L 1 | W 9 | L 2 |
| MI | 11146376 / R: 1649 ->1673 | N:3 | W | B | W | B | B | W | W |
| 8 | EZEKIEL HOUGHTON | 5.0 | W 3 | W 32 | L 14 | L 9 | W 47 | W 28 | W 19 |
| MI | 15142253 / R: 1641P17->1657P24 | N:3 | B | W | B | W | B | W | W |
| 9 | STEFANO LEE | 5.0 | W 25 | L 18 | W 59 | W 8 | W 26 | L 7 | W 20 |
| ON | 14954524 / R: 1411 ->1564 | N:2 | W | B | W | B | W | B | B |
| 10 | ANVIT RAO | 5.0 | D 16 | L 19 | W 55 | W 31 | D 6 | W 25 | W 18 |
| MI | 14150362 / R: 1365 ->1544 | N:3 | W | W | B | B | W | B | W |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | D 38 | W 56 | W 6 | L 7 | L 3 | W 34 | W 26 |
| MI | 12581589 / R: 1712 ->1696 | N:3 | B | W | B | W | B | W | B |
| 12 | KENNETH J TACK | 4.5 | W 42 | W 33 | D 5 | W 38 | H | D 1 | L 3 |
| MI | 12681257 / R: 1663 ->1670 | N:3 | W | B | W | B | W | B | |
| 13 | TORRANCE HENRY JR | 4.5 | W 36 | W 27 | L 7 | D 5 | W 33 | L 3 | W 32 |
| MI | 15082995 / R: 1666 ->1662 | N:3 | B | W | B | B | W | W | B |
| 14 | BRADLEY SHAW | 4.5 | W 54 | W 44 | W 8 | L 1 | D 27 | L 5 | W 31 |
| MI | 10131499 / R: 1610 ->1618 | N:3 | W | B | W | W | B | B | W |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | D 19 | L 16 | W 30 | L 22 | W 54 | W 33 | W 38 |
| MI | 15619130 / R: 1220P13->1416P20 | N:3 | B | B | W | W | B | B | W |
| 16 | MIKE NIKITIN | 4.0 | D 10 | W 15 | H | W 39 | L 2 | W 36 | U |
| MI | 10295068 / R: 1604 ->1613 | N:3 | B | W | B | W | B | ||
| 17 | RONALD GRZEGORCZYK | 4.0 | W 48 | W 41 | L 26 | L 2 | W 23 | W 22 | L 5 |
| MI | 10297702 / R: 1629 ->1610 | N:3 | W | B | W | B | W | B | W |
| 18 | DAVID SUNDEEN | 4.0 | W 47 | W 9 | L 1 | W 32 | L 19 | W 38 | L 10 |
| MI | 11342094 / R: 1600 ->1600 | N:3 | B | W | B | W | B | W | B |
| 19 | DIPANKAR ROY | 4.0 | D 15 | W 10 | W 52 | D 28 | W 18 | L 4 | L 8 |
| MI | 14862333 / R: 1564 ->1570 | N:3 | W | B | W | B | W | W | B |
| 20 | JASON ZHENG | 4.0 | L 40 | W 49 | W 23 | W 41 | W 28 | L 2 | L 9 |
| MI | 14529060 / R: 1595 ->1569 | N:4 | W | B | W | B | W | B | W |
| 21 | DINH DANG BUI | 4.0 | W 43 | L 1 | W 47 | L 3 | W 40 | W 39 | L 6 |
| ON | 15495066 / R: 1563P22->1562 | N:3 | B | W | B | W | W | B | W |
| 22 | EUGENE L MCCLURE | 4.0 | W 64 | D 52 | L 28 | W 15 | H | L 17 | W 40 |
| MI | 12405534 / R: 1555 ->1529 | N:4 | W | B | W | B | W | B | |
| 23 | ALAN BUI | 4.0 | L 4 | W 43 | L 20 | W 58 | L 17 | W 37 | W 46 |
| ON | 15030142 / R: 1363 ->1371 | B | W | B | W | B | W | B | |
| 24 | MICHAEL R ALDRICH | 4.0 | L 28 | L 47 | W 43 | L 25 | W 60 | W 44 | W 39 |
| MI | 13469010 / R: 1229 ->1300 | N:4 | B | W | B | B | W | W | B |
| 25 | LOREN SCHWIEBERT | 3.5 | L 9 | W 53 | L 3 | W 24 | D 34 | L 10 | W 47 |
| MI | 12486656 / R: 1745 ->1681 | N:4 | B | W | B | W | B | W | B |
| 26 | MAX ZHU | 3.5 | W 49 | W 40 | W 17 | L 4 | L 9 | D 32 | L 11 |
| ON | 15131520 / R: 1579 ->1564 | N:4 | B | W | B | W | B | W | W |
| 27 | GAURAV GIDWANI | 3.5 | W 51 | L 13 | W 46 | W 37 | D 14 | L 6 | U |
| MI | 14476567 / R: 1552 ->1539 | N:4 | W | B | W | B | W | B | |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | W 24 | D 4 | W 22 | D 19 | L 20 | L 8 | D 36 |
| MI | 14882954 / R: 1507 ->1513 | N:3 | W | W | B | W | B | B | W |
| 29 | CHIEDOZIE OKORIE | 3.5 | W 50 | D 6 | L 38 | L 34 | W 52 | W 48 | U |
| MI | 15323285 / R: 1602P6 ->1508P12 | N:4 | B | W | B | W | W | B | |
| 30 | GEORGE AVERY JONES | 3.5 | L 52 | D 64 | L 15 | W 55 | L 31 | W 61 | W 50 |
| ON | 12577178 / R: 1522 ->1444 | W | B | B | W | W | B | B | |
| 31 | RISHI SHETTY | 3.5 | L 58 | D 55 | W 64 | L 10 | W 30 | W 50 | L 14 |
| MI | 15131618 / R: 1494 ->1444 | B | W | B | W | B | W | B | |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | W 61 | L 8 | W 44 | L 18 | W 51 | D 26 | L 13 |
| ON | 14073750 / R: 1441 ->1433 | N:4 | W | B | W | B | W | B | W |
| 33 | JADE GE | 3.5 | W 60 | L 12 | W 50 | D 36 | L 13 | L 15 | W 51 |
| MI | 14691842 / R: 1449 ->1421 | B | W | B | W | B | W | B | |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | L 6 | W 60 | L 37 | W 29 | D 25 | L 11 | W 52 |
| MI | 15051807 / R: 1399 ->1400 | B | W | B | B | W | B | W | |
| 35 | JOSHUA DAVID LEE | 3.5 | L 46 | L 38 | W 56 | L 6 | W 57 | D 52 | W 48 |
| MI | 14601397 / R: 1438 ->1392 | W | W | B | W | B | B | W | |
| 36 | SIDDHARTH JHA | 3.5 | L 13 | W 57 | W 51 | D 33 | H | L 16 | D 28 |
| MI | 14773163 / R: 1355 ->1367 | N:4 | W | B | W | B | W | B | |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | B | L 5 | W 34 | L 27 | H | L 23 | W 61 |
| MI | 15489571 / R: 980P12->1077P17 | B | W | W | B | W | |||
| 38 | BRIAN LIU | 3.0 | D 11 | W 35 | W 29 | L 12 | H | L 18 | L 15 |
| MI | 15108523 / R: 1423 ->1439 | N:4 | W | B | W | W | B | B | |
| 39 | JOEL R HENDON | 3.0 | L 1 | W 54 | W 40 | L 16 | W 44 | L 21 | L 24 |
| MI | 12923035 / R: 1436P23->1413 | N:4 | B | W | B | W | B | W | W |
| 40 | FOREST ZHANG | 3.0 | W 20 | L 26 | L 39 | W 59 | L 21 | W 56 | L 22 |
| MI | 14892710 / R: 1348 ->1346 | B | B | W | W | B | W | W | |
| 41 | KYLE WILLIAM MURPHY | 3.0 | W 59 | L 17 | W 58 | L 20 | X | U | U |
| MI | 15761443 / R: 1403P5 ->1341P9 | B | W | B | W | ||||
| 42 | JARED GE | 3.0 | L 12 | L 50 | L 57 | D 60 | D 61 | W 64 | W 56 |
| MI | 14462326 / R: 1332 ->1256 | B | W | B | B | W | W | B | |
| 43 | ROBERT GLEN VASEY | 3.0 | L 21 | L 23 | L 24 | W 63 | W 59 | L 46 | W 55 |
| MI | 14101068 / R: 1283 ->1244 | W | B | W | W | B | B | W | |
| 44 | JUSTIN D SCHILLING | 3.0 | B | L 14 | L 32 | W 53 | L 39 | L 24 | W 59 |
| MI | 15323504 / R: 1199 ->1199 | W | B | B | W | B | W | ||
| 45 | DEREK YAN | 3.0 | L 5 | L 51 | D 60 | L 56 | W 63 | D 55 | W 58 |
| MI | 15372807 / R: 1242 ->1191 | W | B | W | B | W | B | W | |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | W 35 | L 7 | L 27 | L 50 | W 64 | W 43 | L 23 |
| MI | 15490981 / R: 377P3 ->1076P10 | B | W | B | W | B | W | W | |
| 47 | ERIC WRIGHT | 2.5 | L 18 | W 24 | L 21 | W 61 | L 8 | D 51 | L 25 |
| MI | 12533115 / R: 1362 ->1341 | W | B | W | B | W | B | W | |
| 48 | DANIEL KHAIN | 2.5 | L 17 | W 63 | H | D 52 | H | L 29 | L 35 |
| MI | 14369165 / R: 1382 ->1335 | B | W | B | W | B | |||
| 49 | MICHAEL J MARTIN | 2.5 | L 26 | L 20 | D 63 | D 64 | W 58 | H | U |
| MI | 12531685 / R: 1291P12->1259P17 | W | W | B | W | B | |||
| 50 | SHIVAM JHA | 2.5 | L 29 | W 42 | L 33 | W 46 | H | L 31 | L 30 |
| MI | 14773178 / R: 1056 ->1111 | W | B | W | B | B | W | ||
| 51 | TEJAS AYYAGARI | 2.5 | L 27 | W 45 | L 36 | W 57 | L 32 | D 47 | L 33 |
| MI | 15205474 / R: 1011 ->1097 | B | W | B | W | B | W | W | |
| 52 | ETHAN GUO | 2.5 | W 30 | D 22 | L 19 | D 48 | L 29 | D 35 | L 34 |
| MI | 14918803 / R: 935 ->1092 | N:4 | B | W | B | W | B | W | B |
| 53 | JOSE C YBARRA | 2.0 | H | L 25 | H | L 44 | U | W 57 | U |
| MI | 12578849 / R: 1393 ->1359 | B | W | W | |||||
| 54 | LARRY HODGE | 2.0 | L 14 | L 39 | L 61 | B | L 15 | L 59 | W 64 |
| MI | 12836773 / R: 1270 ->1200 | B | B | W | W | B | W | ||
| 55 | ALEX KONG | 2.0 | L 62 | D 31 | L 10 | L 30 | B | D 45 | L 43 |
| MI | 15412571 / R: 1186 ->1163 | W | B | W | B | W | B | ||
| 56 | MARISA RICCI | 2.0 | H | L 11 | L 35 | W 45 | H | L 40 | L 42 |
| MI | 14679887 / R: 1153 ->1140 | B | W | W | B | W | |||
| 57 | MICHAEL LU | 2.0 | L 7 | L 36 | W 42 | L 51 | L 35 | L 53 | B |
| MI | 15113330 / R: 1092 ->1079 | B | W | W | B | W | B | ||
| 58 | VIRAJ MOHILE | 2.0 | W 31 | L 2 | L 41 | L 23 | L 49 | B | L 45 |
| MI | 14700365 / R: 917 -> 941 | W | B | W | B | W | B | ||
| 59 | SEAN M MC CORMICK | 2.0 | L 41 | B | L 9 | L 40 | L 43 | W 54 | L 44 |
| MI | 12841036 / R: 853 -> 878 | W | B | B | W | W | B | ||
| 60 | JULIA SHEN | 1.5 | L 33 | L 34 | D 45 | D 42 | L 24 | H | U |
| MI | 14579262 / R: 967 -> 984 | W | B | B | W | B | |||
| 61 | JEZZEL FARKAS | 1.5 | L 32 | L 3 | W 54 | L 47 | D 42 | L 30 | L 37 |
| ON | 15771592 / R: 955P11-> 979P18 | B | W | B | W | B | W | B | |
| 62 | ASHWIN BALAJI | 1.0 | W 55 | U | U | U | U | U | U |
| MI | 15219542 / R: 1530 ->1535 | B | |||||||
| 63 | THOMAS JOSEPH HOSMER | 1.0 | L 2 | L 48 | D 49 | L 43 | L 45 | H | U |
| MI | 15057092 / R: 1175 ->1125 | W | B | W | B | B | |||
| 64 | BEN LI | 1.0 | L 22 | D 30 | L 31 | D 49 | L 46 | L 42 | L 54 |
| MI | 15006561 / R: 1163 ->1112 | B | W | W | B | W | B | B |
Make each observation a single row rather than two
df_num = df |>
filter(str_detect(Num, '\\d'))
df_state = df |>
filter(!str_detect(Num, '\\d')) |>
mutate(Pre_Rating = str_match(Player, ":\\s*(\\d*)\\S*\\s*->")[,2]) |>
select(Num, Pre_Rating) |>
setNames(c('State','Pre_Rating'))
df = cbind(df_num, df_state)| Num | Player | Pts | Round_1 | Round_2 | Round_3 | Round_4 | Round_5 | Round_6 | Round_7 | State | Pre_Rating |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | GARY HUA | 6.0 | W 39 | W 21 | W 18 | W 14 | W 7 | D 12 | D 4 | ON | 1794 |
| 2 | DAKSHESH DARURI | 6.0 | W 63 | W 58 | L 4 | W 17 | W 16 | W 20 | W 7 | MI | 1553 |
| 3 | ADITYA BAJAJ | 6.0 | L 8 | W 61 | W 25 | W 21 | W 11 | W 13 | W 12 | MI | 1384 |
| 4 | PATRICK H SCHILLING | 5.5 | W 23 | D 28 | W 2 | W 26 | D 5 | W 19 | D 1 | MI | 1716 |
| 5 | HANSHI ZUO | 5.5 | W 45 | W 37 | D 12 | D 13 | D 4 | W 14 | W 17 | MI | 1655 |
| 6 | HANSEN SONG | 5.0 | W 34 | D 29 | L 11 | W 35 | D 10 | W 27 | W 21 | OH | 1686 |
| 7 | GARY DEE SWATHELL | 5.0 | W 57 | W 46 | W 13 | W 11 | L 1 | W 9 | L 2 | MI | 1649 |
| 8 | EZEKIEL HOUGHTON | 5.0 | W 3 | W 32 | L 14 | L 9 | W 47 | W 28 | W 19 | MI | 1641 |
| 9 | STEFANO LEE | 5.0 | W 25 | L 18 | W 59 | W 8 | W 26 | L 7 | W 20 | ON | 1411 |
| 10 | ANVIT RAO | 5.0 | D 16 | L 19 | W 55 | W 31 | D 6 | W 25 | W 18 | MI | 1365 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | D 38 | W 56 | W 6 | L 7 | L 3 | W 34 | W 26 | MI | 1712 |
| 12 | KENNETH J TACK | 4.5 | W 42 | W 33 | D 5 | W 38 | H | D 1 | L 3 | MI | 1663 |
| 13 | TORRANCE HENRY JR | 4.5 | W 36 | W 27 | L 7 | D 5 | W 33 | L 3 | W 32 | MI | 1666 |
| 14 | BRADLEY SHAW | 4.5 | W 54 | W 44 | W 8 | L 1 | D 27 | L 5 | W 31 | MI | 1610 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | D 19 | L 16 | W 30 | L 22 | W 54 | W 33 | W 38 | MI | 1220 |
| 16 | MIKE NIKITIN | 4.0 | D 10 | W 15 | H | W 39 | L 2 | W 36 | U | MI | 1604 |
| 17 | RONALD GRZEGORCZYK | 4.0 | W 48 | W 41 | L 26 | L 2 | W 23 | W 22 | L 5 | MI | 1629 |
| 18 | DAVID SUNDEEN | 4.0 | W 47 | W 9 | L 1 | W 32 | L 19 | W 38 | L 10 | MI | 1600 |
| 19 | DIPANKAR ROY | 4.0 | D 15 | W 10 | W 52 | D 28 | W 18 | L 4 | L 8 | MI | 1564 |
| 20 | JASON ZHENG | 4.0 | L 40 | W 49 | W 23 | W 41 | W 28 | L 2 | L 9 | MI | 1595 |
| 21 | DINH DANG BUI | 4.0 | W 43 | L 1 | W 47 | L 3 | W 40 | W 39 | L 6 | ON | 1563 |
| 22 | EUGENE L MCCLURE | 4.0 | W 64 | D 52 | L 28 | W 15 | H | L 17 | W 40 | MI | 1555 |
| 23 | ALAN BUI | 4.0 | L 4 | W 43 | L 20 | W 58 | L 17 | W 37 | W 46 | ON | 1363 |
| 24 | MICHAEL R ALDRICH | 4.0 | L 28 | L 47 | W 43 | L 25 | W 60 | W 44 | W 39 | MI | 1229 |
| 25 | LOREN SCHWIEBERT | 3.5 | L 9 | W 53 | L 3 | W 24 | D 34 | L 10 | W 47 | MI | 1745 |
| 26 | MAX ZHU | 3.5 | W 49 | W 40 | W 17 | L 4 | L 9 | D 32 | L 11 | ON | 1579 |
| 27 | GAURAV GIDWANI | 3.5 | W 51 | L 13 | W 46 | W 37 | D 14 | L 6 | U | MI | 1552 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | W 24 | D 4 | W 22 | D 19 | L 20 | L 8 | D 36 | MI | 1507 |
| 29 | CHIEDOZIE OKORIE | 3.5 | W 50 | D 6 | L 38 | L 34 | W 52 | W 48 | U | MI | 1602 |
| 30 | GEORGE AVERY JONES | 3.5 | L 52 | D 64 | L 15 | W 55 | L 31 | W 61 | W 50 | ON | 1522 |
| 31 | RISHI SHETTY | 3.5 | L 58 | D 55 | W 64 | L 10 | W 30 | W 50 | L 14 | MI | 1494 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | W 61 | L 8 | W 44 | L 18 | W 51 | D 26 | L 13 | ON | 1441 |
| 33 | JADE GE | 3.5 | W 60 | L 12 | W 50 | D 36 | L 13 | L 15 | W 51 | MI | 1449 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | L 6 | W 60 | L 37 | W 29 | D 25 | L 11 | W 52 | MI | 1399 |
| 35 | JOSHUA DAVID LEE | 3.5 | L 46 | L 38 | W 56 | L 6 | W 57 | D 52 | W 48 | MI | 1438 |
| 36 | SIDDHARTH JHA | 3.5 | L 13 | W 57 | W 51 | D 33 | H | L 16 | D 28 | MI | 1355 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | B | L 5 | W 34 | L 27 | H | L 23 | W 61 | MI | 980 |
| 38 | BRIAN LIU | 3.0 | D 11 | W 35 | W 29 | L 12 | H | L 18 | L 15 | MI | 1423 |
| 39 | JOEL R HENDON | 3.0 | L 1 | W 54 | W 40 | L 16 | W 44 | L 21 | L 24 | MI | 1436 |
| 40 | FOREST ZHANG | 3.0 | W 20 | L 26 | L 39 | W 59 | L 21 | W 56 | L 22 | MI | 1348 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | W 59 | L 17 | W 58 | L 20 | X | U | U | MI | 1403 |
| 42 | JARED GE | 3.0 | L 12 | L 50 | L 57 | D 60 | D 61 | W 64 | W 56 | MI | 1332 |
| 43 | ROBERT GLEN VASEY | 3.0 | L 21 | L 23 | L 24 | W 63 | W 59 | L 46 | W 55 | MI | 1283 |
| 44 | JUSTIN D SCHILLING | 3.0 | B | L 14 | L 32 | W 53 | L 39 | L 24 | W 59 | MI | 1199 |
| 45 | DEREK YAN | 3.0 | L 5 | L 51 | D 60 | L 56 | W 63 | D 55 | W 58 | MI | 1242 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | W 35 | L 7 | L 27 | L 50 | W 64 | W 43 | L 23 | MI | 377 |
| 47 | ERIC WRIGHT | 2.5 | L 18 | W 24 | L 21 | W 61 | L 8 | D 51 | L 25 | MI | 1362 |
| 48 | DANIEL KHAIN | 2.5 | L 17 | W 63 | H | D 52 | H | L 29 | L 35 | MI | 1382 |
| 49 | MICHAEL J MARTIN | 2.5 | L 26 | L 20 | D 63 | D 64 | W 58 | H | U | MI | 1291 |
| 50 | SHIVAM JHA | 2.5 | L 29 | W 42 | L 33 | W 46 | H | L 31 | L 30 | MI | 1056 |
| 51 | TEJAS AYYAGARI | 2.5 | L 27 | W 45 | L 36 | W 57 | L 32 | D 47 | L 33 | MI | 1011 |
| 52 | ETHAN GUO | 2.5 | W 30 | D 22 | L 19 | D 48 | L 29 | D 35 | L 34 | MI | 935 |
| 53 | JOSE C YBARRA | 2.0 | H | L 25 | H | L 44 | U | W 57 | U | MI | 1393 |
| 54 | LARRY HODGE | 2.0 | L 14 | L 39 | L 61 | B | L 15 | L 59 | W 64 | MI | 1270 |
| 55 | ALEX KONG | 2.0 | L 62 | D 31 | L 10 | L 30 | B | D 45 | L 43 | MI | 1186 |
| 56 | MARISA RICCI | 2.0 | H | L 11 | L 35 | W 45 | H | L 40 | L 42 | MI | 1153 |
| 57 | MICHAEL LU | 2.0 | L 7 | L 36 | W 42 | L 51 | L 35 | L 53 | B | MI | 1092 |
| 58 | VIRAJ MOHILE | 2.0 | W 31 | L 2 | L 41 | L 23 | L 49 | B | L 45 | MI | 917 |
| 59 | SEAN M MC CORMICK | 2.0 | L 41 | B | L 9 | L 40 | L 43 | W 54 | L 44 | MI | 853 |
| 60 | JULIA SHEN | 1.5 | L 33 | L 34 | D 45 | D 42 | L 24 | H | U | MI | 967 |
| 61 | JEZZEL FARKAS | 1.5 | L 32 | L 3 | W 54 | L 47 | D 42 | L 30 | L 37 | ON | 955 |
| 62 | ASHWIN BALAJI | 1.0 | W 55 | U | U | U | U | U | U | MI | 1530 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | L 2 | L 48 | D 49 | L 43 | L 45 | H | U | MI | 1175 |
| 64 | BEN LI | 1.0 | L 22 | D 30 | L 31 | D 49 | L 46 | L 42 | L 54 | MI | 1163 |
Make each variable a column
df = df |>
pivot_longer(
cols = starts_with("Round"),
names_to = "Round",
values_to = 'Result',
names_prefix = 'Round_'
)| Num | Player | Pts | State | Pre_Rating | Round | Result |
|---|---|---|---|---|---|---|
| 1 | GARY HUA | 6.0 | ON | 1794 | 1 | W 39 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 2 | W 21 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 3 | W 18 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 4 | W 14 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 5 | W 7 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 6 | D 12 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 7 | D 4 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 1 | W 63 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 2 | W 58 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 3 | L 4 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 4 | W 17 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 5 | W 16 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 6 | W 20 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 7 | W 7 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 1 | L 8 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 2 | W 61 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 3 | W 25 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 4 | W 21 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 5 | W 11 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 6 | W 13 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 7 | W 12 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 1 | W 23 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 2 | D 28 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 3 | W 2 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 4 | W 26 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 5 | D 5 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 6 | W 19 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 7 | D 1 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 1 | W 45 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 2 | W 37 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 3 | D 12 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 4 | D 13 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 5 | D 4 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 6 | W 14 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 7 | W 17 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 1 | W 34 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 2 | D 29 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 3 | L 11 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 4 | W 35 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 5 | D 10 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 6 | W 27 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 7 | W 21 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 1 | W 57 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 2 | W 46 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 3 | W 13 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 4 | W 11 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 5 | L 1 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 6 | W 9 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 7 | L 2 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 1 | W 3 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 2 | W 32 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 3 | L 14 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 4 | L 9 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 5 | W 47 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 6 | W 28 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 7 | W 19 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 1 | W 25 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 2 | L 18 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 3 | W 59 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 4 | W 8 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 5 | W 26 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 6 | L 7 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 7 | W 20 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 1 | D 16 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 2 | L 19 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 3 | W 55 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 4 | W 31 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 5 | D 6 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 6 | W 25 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 7 | W 18 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 1 | D 38 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 2 | W 56 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 3 | W 6 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 4 | L 7 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 5 | L 3 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 6 | W 34 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 7 | W 26 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 1 | W 42 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 2 | W 33 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 3 | D 5 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 4 | W 38 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 5 | H |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 6 | D 1 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 7 | L 3 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 1 | W 36 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 2 | W 27 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 3 | L 7 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 4 | D 5 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 5 | W 33 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 6 | L 3 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 7 | W 32 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 1 | W 54 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 2 | W 44 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 3 | W 8 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 4 | L 1 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 5 | D 27 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 6 | L 5 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 7 | W 31 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 1 | D 19 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 2 | L 16 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 3 | W 30 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 4 | L 22 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 5 | W 54 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 6 | W 33 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 7 | W 38 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 1 | D 10 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 2 | W 15 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 3 | H |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 4 | W 39 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 5 | L 2 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 6 | W 36 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 7 | U |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 1 | W 48 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 2 | W 41 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 3 | L 26 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 4 | L 2 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 5 | W 23 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 6 | W 22 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 7 | L 5 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 1 | W 47 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 2 | W 9 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 3 | L 1 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 4 | W 32 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 5 | L 19 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 6 | W 38 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 7 | L 10 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 1 | D 15 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 2 | W 10 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 3 | W 52 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 4 | D 28 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 5 | W 18 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 6 | L 4 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 7 | L 8 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 1 | L 40 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 2 | W 49 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 3 | W 23 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 4 | W 41 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 5 | W 28 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 6 | L 2 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 7 | L 9 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 1 | W 43 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 2 | L 1 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 3 | W 47 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 4 | L 3 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 5 | W 40 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 6 | W 39 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 7 | L 6 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 1 | W 64 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 2 | D 52 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 3 | L 28 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 4 | W 15 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 5 | H |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 6 | L 17 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 7 | W 40 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 1 | L 4 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 2 | W 43 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 3 | L 20 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 4 | W 58 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 5 | L 17 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 6 | W 37 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 7 | W 46 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 1 | L 28 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 2 | L 47 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 3 | W 43 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 4 | L 25 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 5 | W 60 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 6 | W 44 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 7 | W 39 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 1 | L 9 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 2 | W 53 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 3 | L 3 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 4 | W 24 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 5 | D 34 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 6 | L 10 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 7 | W 47 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 1 | W 49 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 2 | W 40 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 3 | W 17 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 4 | L 4 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 5 | L 9 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 6 | D 32 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 7 | L 11 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 1 | W 51 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 2 | L 13 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 3 | W 46 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 4 | W 37 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 5 | D 14 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 6 | L 6 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 7 | U |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 1 | W 24 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 2 | D 4 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 3 | W 22 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 4 | D 19 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 5 | L 20 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 6 | L 8 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 7 | D 36 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 1 | W 50 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 2 | D 6 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 3 | L 38 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 4 | L 34 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 5 | W 52 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 6 | W 48 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 7 | U |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 1 | L 52 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 2 | D 64 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 3 | L 15 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 4 | W 55 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 5 | L 31 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 6 | W 61 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 7 | W 50 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 1 | L 58 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 2 | D 55 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 3 | W 64 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 4 | L 10 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 5 | W 30 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 6 | W 50 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 7 | L 14 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 1 | W 61 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 2 | L 8 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 3 | W 44 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 4 | L 18 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 5 | W 51 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 6 | D 26 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 7 | L 13 |
| 33 | JADE GE | 3.5 | MI | 1449 | 1 | W 60 |
| 33 | JADE GE | 3.5 | MI | 1449 | 2 | L 12 |
| 33 | JADE GE | 3.5 | MI | 1449 | 3 | W 50 |
| 33 | JADE GE | 3.5 | MI | 1449 | 4 | D 36 |
| 33 | JADE GE | 3.5 | MI | 1449 | 5 | L 13 |
| 33 | JADE GE | 3.5 | MI | 1449 | 6 | L 15 |
| 33 | JADE GE | 3.5 | MI | 1449 | 7 | W 51 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 1 | L 6 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 2 | W 60 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 3 | L 37 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 4 | W 29 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 5 | D 25 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 6 | L 11 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 7 | W 52 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 1 | L 46 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 2 | L 38 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 3 | W 56 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 4 | L 6 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 5 | W 57 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 6 | D 52 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 7 | W 48 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 1 | L 13 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 2 | W 57 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 3 | W 51 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 4 | D 33 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 5 | H |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 6 | L 16 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 7 | D 28 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 1 | B |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 2 | L 5 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 3 | W 34 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 4 | L 27 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 5 | H |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 6 | L 23 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 7 | W 61 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 1 | D 11 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 2 | W 35 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 3 | W 29 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 4 | L 12 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 5 | H |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 6 | L 18 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 7 | L 15 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 1 | L 1 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 2 | W 54 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 3 | W 40 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 4 | L 16 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 5 | W 44 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 6 | L 21 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 7 | L 24 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 1 | W 20 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 2 | L 26 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 3 | L 39 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 4 | W 59 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 5 | L 21 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 6 | W 56 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 7 | L 22 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 1 | W 59 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 2 | L 17 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 3 | W 58 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 4 | L 20 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 5 | X |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 6 | U |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 7 | U |
| 42 | JARED GE | 3.0 | MI | 1332 | 1 | L 12 |
| 42 | JARED GE | 3.0 | MI | 1332 | 2 | L 50 |
| 42 | JARED GE | 3.0 | MI | 1332 | 3 | L 57 |
| 42 | JARED GE | 3.0 | MI | 1332 | 4 | D 60 |
| 42 | JARED GE | 3.0 | MI | 1332 | 5 | D 61 |
| 42 | JARED GE | 3.0 | MI | 1332 | 6 | W 64 |
| 42 | JARED GE | 3.0 | MI | 1332 | 7 | W 56 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 1 | L 21 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 2 | L 23 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 3 | L 24 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 4 | W 63 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 5 | W 59 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 6 | L 46 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 7 | W 55 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 1 | B |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 2 | L 14 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 3 | L 32 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 4 | W 53 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 5 | L 39 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 6 | L 24 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 7 | W 59 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 1 | L 5 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 2 | L 51 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 3 | D 60 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 4 | L 56 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 5 | W 63 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 6 | D 55 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 7 | W 58 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 1 | W 35 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 2 | L 7 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 3 | L 27 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 4 | L 50 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 5 | W 64 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 6 | W 43 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 7 | L 23 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 1 | L 18 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 2 | W 24 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 3 | L 21 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 4 | W 61 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 5 | L 8 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 6 | D 51 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 7 | L 25 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 1 | L 17 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 2 | W 63 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 3 | H |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 4 | D 52 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 5 | H |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 6 | L 29 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 7 | L 35 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 1 | L 26 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 2 | L 20 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 3 | D 63 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 4 | D 64 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 5 | W 58 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 6 | H |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 7 | U |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 1 | L 29 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 2 | W 42 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 3 | L 33 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 4 | W 46 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 5 | H |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 6 | L 31 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 7 | L 30 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 1 | L 27 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 2 | W 45 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 3 | L 36 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 4 | W 57 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 5 | L 32 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 6 | D 47 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 7 | L 33 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 1 | W 30 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 2 | D 22 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 3 | L 19 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 4 | D 48 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 5 | L 29 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 6 | D 35 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 7 | L 34 |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 1 | H |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 2 | L 25 |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 3 | H |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 4 | L 44 |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 5 | U |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 6 | W 57 |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 7 | U |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 1 | L 14 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 2 | L 39 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 3 | L 61 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 4 | B |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 5 | L 15 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 6 | L 59 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 7 | W 64 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 1 | L 62 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 2 | D 31 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 3 | L 10 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 4 | L 30 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 5 | B |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 6 | D 45 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 7 | L 43 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 1 | H |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 2 | L 11 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 3 | L 35 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 4 | W 45 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 5 | H |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 6 | L 40 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 7 | L 42 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 1 | L 7 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 2 | L 36 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 3 | W 42 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 4 | L 51 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 5 | L 35 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 6 | L 53 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 7 | B |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 1 | W 31 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 2 | L 2 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 3 | L 41 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 4 | L 23 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 5 | L 49 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 6 | B |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 7 | L 45 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 1 | L 41 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 2 | B |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 3 | L 9 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 4 | L 40 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 5 | L 43 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 6 | W 54 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 7 | L 44 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 1 | L 33 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 2 | L 34 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 3 | D 45 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 4 | D 42 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 5 | L 24 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 6 | H |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 7 | U |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 1 | L 32 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 2 | L 3 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 3 | W 54 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 4 | L 47 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 5 | D 42 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 6 | L 30 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 7 | L 37 |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 1 | W 55 |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 2 | U |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 3 | U |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 4 | U |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 5 | U |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 6 | U |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 7 | U |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 1 | L 2 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 2 | L 48 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 3 | D 49 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 4 | L 43 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 5 | L 45 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 6 | H |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 7 | U |
| 64 | BEN LI | 1.0 | MI | 1163 | 1 | L 22 |
| 64 | BEN LI | 1.0 | MI | 1163 | 2 | D 30 |
| 64 | BEN LI | 1.0 | MI | 1163 | 3 | L 31 |
| 64 | BEN LI | 1.0 | MI | 1163 | 4 | D 49 |
| 64 | BEN LI | 1.0 | MI | 1163 | 5 | L 46 |
| 64 | BEN LI | 1.0 | MI | 1163 | 6 | L 42 |
| 64 | BEN LI | 1.0 | MI | 1163 | 7 | L 54 |
Prep data to allow for calculation of Average Pre Chess Rating of Opponents
rate_df = df |>
distinct(Num, Pre_Rating) |>
mutate(Pre_Rating = as.integer(Pre_Rating)) |>
setNames(c('Opponent','Opp_Pre_Rating'))
df = df |>
mutate(Opponent = str_match(Result, "\\s*(\\d+)")[,2])
df = left_join(df, rate_df, by = join_by(Opponent))| Num | Player | Pts | State | Pre_Rating | Round | Result | Opponent | Opp_Pre_Rating |
|---|---|---|---|---|---|---|---|---|
| 1 | GARY HUA | 6.0 | ON | 1794 | 1 | W 39 | 39 | 1436 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 2 | W 21 | 21 | 1563 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 3 | W 18 | 18 | 1600 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 4 | W 14 | 14 | 1610 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 5 | W 7 | 7 | 1649 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 6 | D 12 | 12 | 1663 |
| 1 | GARY HUA | 6.0 | ON | 1794 | 7 | D 4 | 4 | 1716 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 1 | W 63 | 63 | 1175 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 2 | W 58 | 58 | 917 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 3 | L 4 | 4 | 1716 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 4 | W 17 | 17 | 1629 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 5 | W 16 | 16 | 1604 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 6 | W 20 | 20 | 1595 |
| 2 | DAKSHESH DARURI | 6.0 | MI | 1553 | 7 | W 7 | 7 | 1649 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 1 | L 8 | 8 | 1641 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 2 | W 61 | 61 | 955 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 3 | W 25 | 25 | 1745 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 4 | W 21 | 21 | 1563 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 5 | W 11 | 11 | 1712 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 6 | W 13 | 13 | 1666 |
| 3 | ADITYA BAJAJ | 6.0 | MI | 1384 | 7 | W 12 | 12 | 1663 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 1 | W 23 | 23 | 1363 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 2 | D 28 | 28 | 1507 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 3 | W 2 | 2 | 1553 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 4 | W 26 | 26 | 1579 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 5 | D 5 | 5 | 1655 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 6 | W 19 | 19 | 1564 |
| 4 | PATRICK H SCHILLING | 5.5 | MI | 1716 | 7 | D 1 | 1 | 1794 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 1 | W 45 | 45 | 1242 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 2 | W 37 | 37 | 980 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 3 | D 12 | 12 | 1663 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 4 | D 13 | 13 | 1666 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 5 | D 4 | 4 | 1716 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 6 | W 14 | 14 | 1610 |
| 5 | HANSHI ZUO | 5.5 | MI | 1655 | 7 | W 17 | 17 | 1629 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 1 | W 34 | 34 | 1399 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 2 | D 29 | 29 | 1602 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 3 | L 11 | 11 | 1712 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 4 | W 35 | 35 | 1438 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 5 | D 10 | 10 | 1365 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 6 | W 27 | 27 | 1552 |
| 6 | HANSEN SONG | 5.0 | OH | 1686 | 7 | W 21 | 21 | 1563 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 1 | W 57 | 57 | 1092 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 2 | W 46 | 46 | 377 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 3 | W 13 | 13 | 1666 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 4 | W 11 | 11 | 1712 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 5 | L 1 | 1 | 1794 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 6 | W 9 | 9 | 1411 |
| 7 | GARY DEE SWATHELL | 5.0 | MI | 1649 | 7 | L 2 | 2 | 1553 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 1 | W 3 | 3 | 1384 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 2 | W 32 | 32 | 1441 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 3 | L 14 | 14 | 1610 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 4 | L 9 | 9 | 1411 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 5 | W 47 | 47 | 1362 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 6 | W 28 | 28 | 1507 |
| 8 | EZEKIEL HOUGHTON | 5.0 | MI | 1641 | 7 | W 19 | 19 | 1564 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 1 | W 25 | 25 | 1745 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 2 | L 18 | 18 | 1600 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 3 | W 59 | 59 | 853 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 4 | W 8 | 8 | 1641 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 5 | W 26 | 26 | 1579 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 6 | L 7 | 7 | 1649 |
| 9 | STEFANO LEE | 5.0 | ON | 1411 | 7 | W 20 | 20 | 1595 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 1 | D 16 | 16 | 1604 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 2 | L 19 | 19 | 1564 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 3 | W 55 | 55 | 1186 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 4 | W 31 | 31 | 1494 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 5 | D 6 | 6 | 1686 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 6 | W 25 | 25 | 1745 |
| 10 | ANVIT RAO | 5.0 | MI | 1365 | 7 | W 18 | 18 | 1600 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 1 | D 38 | 38 | 1423 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 2 | W 56 | 56 | 1153 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 3 | W 6 | 6 | 1686 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 4 | L 7 | 7 | 1649 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 5 | L 3 | 3 | 1384 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 6 | W 34 | 34 | 1399 |
| 11 | CAMERON WILLIAM MC LEMAN | 4.5 | MI | 1712 | 7 | W 26 | 26 | 1579 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 1 | W 42 | 42 | 1332 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 2 | W 33 | 33 | 1449 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 3 | D 5 | 5 | 1655 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 4 | W 38 | 38 | 1423 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 5 | H | NA | NA |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 6 | D 1 | 1 | 1794 |
| 12 | KENNETH J TACK | 4.5 | MI | 1663 | 7 | L 3 | 3 | 1384 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 1 | W 36 | 36 | 1355 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 2 | W 27 | 27 | 1552 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 3 | L 7 | 7 | 1649 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 4 | D 5 | 5 | 1655 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 5 | W 33 | 33 | 1449 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 6 | L 3 | 3 | 1384 |
| 13 | TORRANCE HENRY JR | 4.5 | MI | 1666 | 7 | W 32 | 32 | 1441 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 1 | W 54 | 54 | 1270 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 2 | W 44 | 44 | 1199 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 3 | W 8 | 8 | 1641 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 4 | L 1 | 1 | 1794 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 5 | D 27 | 27 | 1552 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 6 | L 5 | 5 | 1655 |
| 14 | BRADLEY SHAW | 4.5 | MI | 1610 | 7 | W 31 | 31 | 1494 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 1 | D 19 | 19 | 1564 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 2 | L 16 | 16 | 1604 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 3 | W 30 | 30 | 1522 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 4 | L 22 | 22 | 1555 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 5 | W 54 | 54 | 1270 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 6 | W 33 | 33 | 1449 |
| 15 | ZACHARY JAMES HOUGHTON | 4.5 | MI | 1220 | 7 | W 38 | 38 | 1423 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 1 | D 10 | 10 | 1365 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 2 | W 15 | 15 | 1220 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 3 | H | NA | NA |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 4 | W 39 | 39 | 1436 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 5 | L 2 | 2 | 1553 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 6 | W 36 | 36 | 1355 |
| 16 | MIKE NIKITIN | 4.0 | MI | 1604 | 7 | U | NA | NA |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 1 | W 48 | 48 | 1382 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 2 | W 41 | 41 | 1403 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 3 | L 26 | 26 | 1579 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 4 | L 2 | 2 | 1553 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 5 | W 23 | 23 | 1363 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 6 | W 22 | 22 | 1555 |
| 17 | RONALD GRZEGORCZYK | 4.0 | MI | 1629 | 7 | L 5 | 5 | 1655 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 1 | W 47 | 47 | 1362 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 2 | W 9 | 9 | 1411 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 3 | L 1 | 1 | 1794 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 4 | W 32 | 32 | 1441 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 5 | L 19 | 19 | 1564 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 6 | W 38 | 38 | 1423 |
| 18 | DAVID SUNDEEN | 4.0 | MI | 1600 | 7 | L 10 | 10 | 1365 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 1 | D 15 | 15 | 1220 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 2 | W 10 | 10 | 1365 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 3 | W 52 | 52 | 935 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 4 | D 28 | 28 | 1507 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 5 | W 18 | 18 | 1600 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 6 | L 4 | 4 | 1716 |
| 19 | DIPANKAR ROY | 4.0 | MI | 1564 | 7 | L 8 | 8 | 1641 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 1 | L 40 | 40 | 1348 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 2 | W 49 | 49 | 1291 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 3 | W 23 | 23 | 1363 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 4 | W 41 | 41 | 1403 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 5 | W 28 | 28 | 1507 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 6 | L 2 | 2 | 1553 |
| 20 | JASON ZHENG | 4.0 | MI | 1595 | 7 | L 9 | 9 | 1411 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 1 | W 43 | 43 | 1283 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 2 | L 1 | 1 | 1794 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 3 | W 47 | 47 | 1362 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 4 | L 3 | 3 | 1384 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 5 | W 40 | 40 | 1348 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 6 | W 39 | 39 | 1436 |
| 21 | DINH DANG BUI | 4.0 | ON | 1563 | 7 | L 6 | 6 | 1686 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 1 | W 64 | 64 | 1163 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 2 | D 52 | 52 | 935 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 3 | L 28 | 28 | 1507 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 4 | W 15 | 15 | 1220 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 5 | H | NA | NA |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 6 | L 17 | 17 | 1629 |
| 22 | EUGENE L MCCLURE | 4.0 | MI | 1555 | 7 | W 40 | 40 | 1348 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 1 | L 4 | 4 | 1716 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 2 | W 43 | 43 | 1283 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 3 | L 20 | 20 | 1595 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 4 | W 58 | 58 | 917 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 5 | L 17 | 17 | 1629 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 6 | W 37 | 37 | 980 |
| 23 | ALAN BUI | 4.0 | ON | 1363 | 7 | W 46 | 46 | 377 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 1 | L 28 | 28 | 1507 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 2 | L 47 | 47 | 1362 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 3 | W 43 | 43 | 1283 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 4 | L 25 | 25 | 1745 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 5 | W 60 | 60 | 967 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 6 | W 44 | 44 | 1199 |
| 24 | MICHAEL R ALDRICH | 4.0 | MI | 1229 | 7 | W 39 | 39 | 1436 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 1 | L 9 | 9 | 1411 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 2 | W 53 | 53 | 1393 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 3 | L 3 | 3 | 1384 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 4 | W 24 | 24 | 1229 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 5 | D 34 | 34 | 1399 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 6 | L 10 | 10 | 1365 |
| 25 | LOREN SCHWIEBERT | 3.5 | MI | 1745 | 7 | W 47 | 47 | 1362 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 1 | W 49 | 49 | 1291 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 2 | W 40 | 40 | 1348 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 3 | W 17 | 17 | 1629 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 4 | L 4 | 4 | 1716 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 5 | L 9 | 9 | 1411 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 6 | D 32 | 32 | 1441 |
| 26 | MAX ZHU | 3.5 | ON | 1579 | 7 | L 11 | 11 | 1712 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 1 | W 51 | 51 | 1011 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 2 | L 13 | 13 | 1666 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 3 | W 46 | 46 | 377 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 4 | W 37 | 37 | 980 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 5 | D 14 | 14 | 1610 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 6 | L 6 | 6 | 1686 |
| 27 | GAURAV GIDWANI | 3.5 | MI | 1552 | 7 | U | NA | NA |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 1 | W 24 | 24 | 1229 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 2 | D 4 | 4 | 1716 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 3 | W 22 | 22 | 1555 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 4 | D 19 | 19 | 1564 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 5 | L 20 | 20 | 1595 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 6 | L 8 | 8 | 1641 |
| 28 | SOFIA ADINA STANESCU-BELLU | 3.5 | MI | 1507 | 7 | D 36 | 36 | 1355 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 1 | W 50 | 50 | 1056 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 2 | D 6 | 6 | 1686 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 3 | L 38 | 38 | 1423 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 4 | L 34 | 34 | 1399 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 5 | W 52 | 52 | 935 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 6 | W 48 | 48 | 1382 |
| 29 | CHIEDOZIE OKORIE | 3.5 | MI | 1602 | 7 | U | NA | NA |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 1 | L 52 | 52 | 935 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 2 | D 64 | 64 | 1163 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 3 | L 15 | 15 | 1220 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 4 | W 55 | 55 | 1186 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 5 | L 31 | 31 | 1494 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 6 | W 61 | 61 | 955 |
| 30 | GEORGE AVERY JONES | 3.5 | ON | 1522 | 7 | W 50 | 50 | 1056 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 1 | L 58 | 58 | 917 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 2 | D 55 | 55 | 1186 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 3 | W 64 | 64 | 1163 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 4 | L 10 | 10 | 1365 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 5 | W 30 | 30 | 1522 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 6 | W 50 | 50 | 1056 |
| 31 | RISHI SHETTY | 3.5 | MI | 1494 | 7 | L 14 | 14 | 1610 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 1 | W 61 | 61 | 955 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 2 | L 8 | 8 | 1641 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 3 | W 44 | 44 | 1199 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 4 | L 18 | 18 | 1600 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 5 | W 51 | 51 | 1011 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 6 | D 26 | 26 | 1579 |
| 32 | JOSHUA PHILIP MATHEWS | 3.5 | ON | 1441 | 7 | L 13 | 13 | 1666 |
| 33 | JADE GE | 3.5 | MI | 1449 | 1 | W 60 | 60 | 967 |
| 33 | JADE GE | 3.5 | MI | 1449 | 2 | L 12 | 12 | 1663 |
| 33 | JADE GE | 3.5 | MI | 1449 | 3 | W 50 | 50 | 1056 |
| 33 | JADE GE | 3.5 | MI | 1449 | 4 | D 36 | 36 | 1355 |
| 33 | JADE GE | 3.5 | MI | 1449 | 5 | L 13 | 13 | 1666 |
| 33 | JADE GE | 3.5 | MI | 1449 | 6 | L 15 | 15 | 1220 |
| 33 | JADE GE | 3.5 | MI | 1449 | 7 | W 51 | 51 | 1011 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 1 | L 6 | 6 | 1686 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 2 | W 60 | 60 | 967 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 3 | L 37 | 37 | 980 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 4 | W 29 | 29 | 1602 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 5 | D 25 | 25 | 1745 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 6 | L 11 | 11 | 1712 |
| 34 | MICHAEL JEFFERY THOMAS | 3.5 | MI | 1399 | 7 | W 52 | 52 | 935 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 1 | L 46 | 46 | 377 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 2 | L 38 | 38 | 1423 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 3 | W 56 | 56 | 1153 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 4 | L 6 | 6 | 1686 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 5 | W 57 | 57 | 1092 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 6 | D 52 | 52 | 935 |
| 35 | JOSHUA DAVID LEE | 3.5 | MI | 1438 | 7 | W 48 | 48 | 1382 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 1 | L 13 | 13 | 1666 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 2 | W 57 | 57 | 1092 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 3 | W 51 | 51 | 1011 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 4 | D 33 | 33 | 1449 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 5 | H | NA | NA |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 6 | L 16 | 16 | 1604 |
| 36 | SIDDHARTH JHA | 3.5 | MI | 1355 | 7 | D 28 | 28 | 1507 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 1 | B | NA | NA |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 2 | L 5 | 5 | 1655 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 3 | W 34 | 34 | 1399 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 4 | L 27 | 27 | 1552 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 5 | H | NA | NA |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 6 | L 23 | 23 | 1363 |
| 37 | AMIYATOSH PWNANANDAM | 3.5 | MI | 980 | 7 | W 61 | 61 | 955 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 1 | D 11 | 11 | 1712 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 2 | W 35 | 35 | 1438 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 3 | W 29 | 29 | 1602 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 4 | L 12 | 12 | 1663 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 5 | H | NA | NA |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 6 | L 18 | 18 | 1600 |
| 38 | BRIAN LIU | 3.0 | MI | 1423 | 7 | L 15 | 15 | 1220 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 1 | L 1 | 1 | 1794 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 2 | W 54 | 54 | 1270 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 3 | W 40 | 40 | 1348 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 4 | L 16 | 16 | 1604 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 5 | W 44 | 44 | 1199 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 6 | L 21 | 21 | 1563 |
| 39 | JOEL R HENDON | 3.0 | MI | 1436 | 7 | L 24 | 24 | 1229 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 1 | W 20 | 20 | 1595 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 2 | L 26 | 26 | 1579 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 3 | L 39 | 39 | 1436 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 4 | W 59 | 59 | 853 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 5 | L 21 | 21 | 1563 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 6 | W 56 | 56 | 1153 |
| 40 | FOREST ZHANG | 3.0 | MI | 1348 | 7 | L 22 | 22 | 1555 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 1 | W 59 | 59 | 853 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 2 | L 17 | 17 | 1629 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 3 | W 58 | 58 | 917 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 4 | L 20 | 20 | 1595 |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 5 | X | NA | NA |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 6 | U | NA | NA |
| 41 | KYLE WILLIAM MURPHY | 3.0 | MI | 1403 | 7 | U | NA | NA |
| 42 | JARED GE | 3.0 | MI | 1332 | 1 | L 12 | 12 | 1663 |
| 42 | JARED GE | 3.0 | MI | 1332 | 2 | L 50 | 50 | 1056 |
| 42 | JARED GE | 3.0 | MI | 1332 | 3 | L 57 | 57 | 1092 |
| 42 | JARED GE | 3.0 | MI | 1332 | 4 | D 60 | 60 | 967 |
| 42 | JARED GE | 3.0 | MI | 1332 | 5 | D 61 | 61 | 955 |
| 42 | JARED GE | 3.0 | MI | 1332 | 6 | W 64 | 64 | 1163 |
| 42 | JARED GE | 3.0 | MI | 1332 | 7 | W 56 | 56 | 1153 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 1 | L 21 | 21 | 1563 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 2 | L 23 | 23 | 1363 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 3 | L 24 | 24 | 1229 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 4 | W 63 | 63 | 1175 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 5 | W 59 | 59 | 853 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 6 | L 46 | 46 | 377 |
| 43 | ROBERT GLEN VASEY | 3.0 | MI | 1283 | 7 | W 55 | 55 | 1186 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 1 | B | NA | NA |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 2 | L 14 | 14 | 1610 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 3 | L 32 | 32 | 1441 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 4 | W 53 | 53 | 1393 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 5 | L 39 | 39 | 1436 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 6 | L 24 | 24 | 1229 |
| 44 | JUSTIN D SCHILLING | 3.0 | MI | 1199 | 7 | W 59 | 59 | 853 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 1 | L 5 | 5 | 1655 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 2 | L 51 | 51 | 1011 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 3 | D 60 | 60 | 967 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 4 | L 56 | 56 | 1153 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 5 | W 63 | 63 | 1175 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 6 | D 55 | 55 | 1186 |
| 45 | DEREK YAN | 3.0 | MI | 1242 | 7 | W 58 | 58 | 917 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 1 | W 35 | 35 | 1438 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 2 | L 7 | 7 | 1649 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 3 | L 27 | 27 | 1552 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 4 | L 50 | 50 | 1056 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 5 | W 64 | 64 | 1163 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 6 | W 43 | 43 | 1283 |
| 46 | JACOB ALEXANDER LAVALLEY | 3.0 | MI | 377 | 7 | L 23 | 23 | 1363 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 1 | L 18 | 18 | 1600 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 2 | W 24 | 24 | 1229 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 3 | L 21 | 21 | 1563 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 4 | W 61 | 61 | 955 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 5 | L 8 | 8 | 1641 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 6 | D 51 | 51 | 1011 |
| 47 | ERIC WRIGHT | 2.5 | MI | 1362 | 7 | L 25 | 25 | 1745 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 1 | L 17 | 17 | 1629 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 2 | W 63 | 63 | 1175 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 3 | H | NA | NA |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 4 | D 52 | 52 | 935 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 5 | H | NA | NA |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 6 | L 29 | 29 | 1602 |
| 48 | DANIEL KHAIN | 2.5 | MI | 1382 | 7 | L 35 | 35 | 1438 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 1 | L 26 | 26 | 1579 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 2 | L 20 | 20 | 1595 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 3 | D 63 | 63 | 1175 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 4 | D 64 | 64 | 1163 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 5 | W 58 | 58 | 917 |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 6 | H | NA | NA |
| 49 | MICHAEL J MARTIN | 2.5 | MI | 1291 | 7 | U | NA | NA |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 1 | L 29 | 29 | 1602 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 2 | W 42 | 42 | 1332 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 3 | L 33 | 33 | 1449 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 4 | W 46 | 46 | 377 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 5 | H | NA | NA |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 6 | L 31 | 31 | 1494 |
| 50 | SHIVAM JHA | 2.5 | MI | 1056 | 7 | L 30 | 30 | 1522 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 1 | L 27 | 27 | 1552 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 2 | W 45 | 45 | 1242 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 3 | L 36 | 36 | 1355 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 4 | W 57 | 57 | 1092 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 5 | L 32 | 32 | 1441 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 6 | D 47 | 47 | 1362 |
| 51 | TEJAS AYYAGARI | 2.5 | MI | 1011 | 7 | L 33 | 33 | 1449 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 1 | W 30 | 30 | 1522 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 2 | D 22 | 22 | 1555 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 3 | L 19 | 19 | 1564 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 4 | D 48 | 48 | 1382 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 5 | L 29 | 29 | 1602 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 6 | D 35 | 35 | 1438 |
| 52 | ETHAN GUO | 2.5 | MI | 935 | 7 | L 34 | 34 | 1399 |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 1 | H | NA | NA |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 2 | L 25 | 25 | 1745 |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 3 | H | NA | NA |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 4 | L 44 | 44 | 1199 |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 5 | U | NA | NA |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 6 | W 57 | 57 | 1092 |
| 53 | JOSE C YBARRA | 2.0 | MI | 1393 | 7 | U | NA | NA |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 1 | L 14 | 14 | 1610 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 2 | L 39 | 39 | 1436 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 3 | L 61 | 61 | 955 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 4 | B | NA | NA |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 5 | L 15 | 15 | 1220 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 6 | L 59 | 59 | 853 |
| 54 | LARRY HODGE | 2.0 | MI | 1270 | 7 | W 64 | 64 | 1163 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 1 | L 62 | 62 | 1530 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 2 | D 31 | 31 | 1494 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 3 | L 10 | 10 | 1365 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 4 | L 30 | 30 | 1522 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 5 | B | NA | NA |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 6 | D 45 | 45 | 1242 |
| 55 | ALEX KONG | 2.0 | MI | 1186 | 7 | L 43 | 43 | 1283 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 1 | H | NA | NA |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 2 | L 11 | 11 | 1712 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 3 | L 35 | 35 | 1438 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 4 | W 45 | 45 | 1242 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 5 | H | NA | NA |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 6 | L 40 | 40 | 1348 |
| 56 | MARISA RICCI | 2.0 | MI | 1153 | 7 | L 42 | 42 | 1332 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 1 | L 7 | 7 | 1649 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 2 | L 36 | 36 | 1355 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 3 | W 42 | 42 | 1332 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 4 | L 51 | 51 | 1011 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 5 | L 35 | 35 | 1438 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 6 | L 53 | 53 | 1393 |
| 57 | MICHAEL LU | 2.0 | MI | 1092 | 7 | B | NA | NA |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 1 | W 31 | 31 | 1494 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 2 | L 2 | 2 | 1553 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 3 | L 41 | 41 | 1403 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 4 | L 23 | 23 | 1363 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 5 | L 49 | 49 | 1291 |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 6 | B | NA | NA |
| 58 | VIRAJ MOHILE | 2.0 | MI | 917 | 7 | L 45 | 45 | 1242 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 1 | L 41 | 41 | 1403 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 2 | B | NA | NA |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 3 | L 9 | 9 | 1411 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 4 | L 40 | 40 | 1348 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 5 | L 43 | 43 | 1283 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 6 | W 54 | 54 | 1270 |
| 59 | SEAN M MC CORMICK | 2.0 | MI | 853 | 7 | L 44 | 44 | 1199 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 1 | L 33 | 33 | 1449 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 2 | L 34 | 34 | 1399 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 3 | D 45 | 45 | 1242 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 4 | D 42 | 42 | 1332 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 5 | L 24 | 24 | 1229 |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 6 | H | NA | NA |
| 60 | JULIA SHEN | 1.5 | MI | 967 | 7 | U | NA | NA |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 1 | L 32 | 32 | 1441 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 2 | L 3 | 3 | 1384 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 3 | W 54 | 54 | 1270 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 4 | L 47 | 47 | 1362 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 5 | D 42 | 42 | 1332 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 6 | L 30 | 30 | 1522 |
| 61 | JEZZEL FARKAS | 1.5 | ON | 955 | 7 | L 37 | 37 | 980 |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 1 | W 55 | 55 | 1186 |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 2 | U | NA | NA |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 3 | U | NA | NA |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 4 | U | NA | NA |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 5 | U | NA | NA |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 6 | U | NA | NA |
| 62 | ASHWIN BALAJI | 1.0 | MI | 1530 | 7 | U | NA | NA |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 1 | L 2 | 2 | 1553 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 2 | L 48 | 48 | 1382 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 3 | D 49 | 49 | 1291 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 4 | L 43 | 43 | 1283 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 5 | L 45 | 45 | 1242 |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 6 | H | NA | NA |
| 63 | THOMAS JOSEPH HOSMER | 1.0 | MI | 1175 | 7 | U | NA | NA |
| 64 | BEN LI | 1.0 | MI | 1163 | 1 | L 22 | 22 | 1555 |
| 64 | BEN LI | 1.0 | MI | 1163 | 2 | D 30 | 30 | 1522 |
| 64 | BEN LI | 1.0 | MI | 1163 | 3 | L 31 | 31 | 1494 |
| 64 | BEN LI | 1.0 | MI | 1163 | 4 | D 49 | 49 | 1291 |
| 64 | BEN LI | 1.0 | MI | 1163 | 5 | L 46 | 46 | 377 |
| 64 | BEN LI | 1.0 | MI | 1163 | 6 | L 42 | 42 | 1332 |
| 64 | BEN LI | 1.0 | MI | 1163 | 7 | L 54 | 54 | 1270 |
Final Data Handling
df = df |>
group_by(Num) |>
mutate(Avg_Opp_Rate = round(mean(Opp_Pre_Rating, na.rm = TRUE))) |>
ungroup() |>
distinct(Player, State, Pts, Pre_Rating, Avg_Opp_Rate) |>
mutate_at(c('Pts', 'Pre_Rating'), as.numeric)| Player | State | Pts | Pre_Rating | Avg_Opp_Rate |
|---|---|---|---|---|
| GARY HUA | ON | 6.0 | 1794 | 1605 |
| DAKSHESH DARURI | MI | 6.0 | 1553 | 1469 |
| ADITYA BAJAJ | MI | 6.0 | 1384 | 1564 |
| PATRICK H SCHILLING | MI | 5.5 | 1716 | 1574 |
| HANSHI ZUO | MI | 5.5 | 1655 | 1501 |
| HANSEN SONG | OH | 5.0 | 1686 | 1519 |
| GARY DEE SWATHELL | MI | 5.0 | 1649 | 1372 |
| EZEKIEL HOUGHTON | MI | 5.0 | 1641 | 1468 |
| STEFANO LEE | ON | 5.0 | 1411 | 1523 |
| ANVIT RAO | MI | 5.0 | 1365 | 1554 |
| CAMERON WILLIAM MC LEMAN | MI | 4.5 | 1712 | 1468 |
| KENNETH J TACK | MI | 4.5 | 1663 | 1506 |
| TORRANCE HENRY JR | MI | 4.5 | 1666 | 1498 |
| BRADLEY SHAW | MI | 4.5 | 1610 | 1515 |
| ZACHARY JAMES HOUGHTON | MI | 4.5 | 1220 | 1484 |
| MIKE NIKITIN | MI | 4.0 | 1604 | 1386 |
| RONALD GRZEGORCZYK | MI | 4.0 | 1629 | 1499 |
| DAVID SUNDEEN | MI | 4.0 | 1600 | 1480 |
| DIPANKAR ROY | MI | 4.0 | 1564 | 1426 |
| JASON ZHENG | MI | 4.0 | 1595 | 1411 |
| DINH DANG BUI | ON | 4.0 | 1563 | 1470 |
| EUGENE L MCCLURE | MI | 4.0 | 1555 | 1300 |
| ALAN BUI | ON | 4.0 | 1363 | 1214 |
| MICHAEL R ALDRICH | MI | 4.0 | 1229 | 1357 |
| LOREN SCHWIEBERT | MI | 3.5 | 1745 | 1363 |
| MAX ZHU | ON | 3.5 | 1579 | 1507 |
| GAURAV GIDWANI | MI | 3.5 | 1552 | 1222 |
| SOFIA ADINA STANESCU-BELLU | MI | 3.5 | 1507 | 1522 |
| CHIEDOZIE OKORIE | MI | 3.5 | 1602 | 1314 |
| GEORGE AVERY JONES | ON | 3.5 | 1522 | 1144 |
| RISHI SHETTY | MI | 3.5 | 1494 | 1260 |
| JOSHUA PHILIP MATHEWS | ON | 3.5 | 1441 | 1379 |
| JADE GE | MI | 3.5 | 1449 | 1277 |
| MICHAEL JEFFERY THOMAS | MI | 3.5 | 1399 | 1375 |
| JOSHUA DAVID LEE | MI | 3.5 | 1438 | 1150 |
| SIDDHARTH JHA | MI | 3.5 | 1355 | 1388 |
| AMIYATOSH PWNANANDAM | MI | 3.5 | 980 | 1385 |
| BRIAN LIU | MI | 3.0 | 1423 | 1539 |
| JOEL R HENDON | MI | 3.0 | 1436 | 1430 |
| FOREST ZHANG | MI | 3.0 | 1348 | 1391 |
| KYLE WILLIAM MURPHY | MI | 3.0 | 1403 | 1248 |
| JARED GE | MI | 3.0 | 1332 | 1150 |
| ROBERT GLEN VASEY | MI | 3.0 | 1283 | 1107 |
| JUSTIN D SCHILLING | MI | 3.0 | 1199 | 1327 |
| DEREK YAN | MI | 3.0 | 1242 | 1152 |
| JACOB ALEXANDER LAVALLEY | MI | 3.0 | 377 | 1358 |
| ERIC WRIGHT | MI | 2.5 | 1362 | 1392 |
| DANIEL KHAIN | MI | 2.5 | 1382 | 1356 |
| MICHAEL J MARTIN | MI | 2.5 | 1291 | 1286 |
| SHIVAM JHA | MI | 2.5 | 1056 | 1296 |
| TEJAS AYYAGARI | MI | 2.5 | 1011 | 1356 |
| ETHAN GUO | MI | 2.5 | 935 | 1495 |
| JOSE C YBARRA | MI | 2.0 | 1393 | 1345 |
| LARRY HODGE | MI | 2.0 | 1270 | 1206 |
| ALEX KONG | MI | 2.0 | 1186 | 1406 |
| MARISA RICCI | MI | 2.0 | 1153 | 1414 |
| MICHAEL LU | MI | 2.0 | 1092 | 1363 |
| VIRAJ MOHILE | MI | 2.0 | 917 | 1391 |
| SEAN M MC CORMICK | MI | 2.0 | 853 | 1319 |
| JULIA SHEN | MI | 1.5 | 967 | 1330 |
| JEZZEL FARKAS | ON | 1.5 | 955 | 1327 |
| ASHWIN BALAJI | MI | 1.0 | 1530 | 1186 |
| THOMAS JOSEPH HOSMER | MI | 1.0 | 1175 | 1350 |
| BEN LI | MI | 1.0 | 1163 | 1263 |
Write out data frame as csv file
write.csv(df, "tournamentinfo_cleaned.csv", row.names = F)