Project1
sudhan_maharjan
September 23, 2018
Project 1
In this project, you’re given a text file with chess tournament results where the information has some structure. Your job is to create an R Markdown file that generates a .CSV file (that could for example be imported into a SQL database) with the following information for all of the players:
Player’s Name, Player’s State, Total Number of Points, Player’s Pre-Rating, and Average Pre Chess Rating of Opponents
For the first player, the information would be: Gary Hua, ON, 6.0, 1794, 1605
1605 was calculated by using the pre-tournament opponents’ ratings of 1436, 1563, 1600, 1610, 1649, 1663, 1716, and dividing by the total number of games played.
If you have questions about the meaning of the data or the results, please post them on the discussion forum. Data science, like chess, is a game of back and forth.
The chess rating system (invented by a Minnesota statistician named Arpad Elo) has been used in many other contexts, including assessing relative strength of employment candidates by human resource departments. You may substitute another text file (or set of text files, or data scraped from web pages) of similar or greater complexity, and create your own assignment and solution. You may work in a small team. All of your code should be in an R markdown file (and published to rpubs.com); with your data accessible for the person running the script.
Exerct from the text file
R interface
Looking at the data, the data is not good to be transferred to SQL. We have to do some kind of editing and formatting.
Let’s read the file in R
lines <- read.table("https://raw.githubusercontent.com/maharjansudhan/DATA607/master/tournamentinfo.txt", header=FALSE, sep="\n")
lines## V1
## 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 -----------------------------------------------------------------------------------------str(lines)## 'data.frame': 196 obs. of 1 variable:
## $ V1: Factor w/ 131 levels "-----------------------------------------------------------------------------------------",..: 1 131 130 1 2 127 1 3 90 1 ...I tried to use it to make sure it works taking help with one of my friend. It didn’t work that well.
lines <- readLines("https://raw.githubusercontent.com/maharjansudhan/DATA607/master/tournamentinfo.txt")## Warning in readLines("https://raw.githubusercontent.com/maharjansudhan/
## DATA607/master/tournamentinfo.txt"): incomplete final line found on
## 'https://raw.githubusercontent.com/maharjansudhan/DATA607/master/
## tournamentinfo.txt'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] "-----------------------------------------------------------------------------------------"str(lines)## chr [1:196] "-----------------------------------------------------------------------------------------" ...When you know some of the tools, it makes life easy dealing with tons of data. It saves a lot of time.
output <- scan("https://raw.githubusercontent.com/maharjansudhan/DATA607/master/tournamentinfo.txt", multi.line=TRUE, sep = "|", what=list('', '', '', '', '', '', '', '', '', '', '\n', '', ''), skip= 4, flush = TRUE, comment.char = "-")## Warning in scan("https://raw.githubusercontent.com/maharjansudhan/DATA607/
## master/tournamentinfo.txt", : number of items read is not a multiple of the
## number of columnsstr(output)## List of 13
## $ : chr [1:64] " 1 " " 2 " " 3 " " 4 " ...
## $ : chr [1:64] " GARY HUA " " DAKSHESH DARURI " " ADITYA BAJAJ " " PATRICK H SCHILLING " ...
## $ : chr [1:64] "6.0 " "6.0 " "6.0 " "5.5 " ...
## $ : chr [1:64] "W 39" "W 63" "L 8" "W 23" ...
## $ : chr [1:64] "W 21" "W 58" "W 61" "D 28" ...
## $ : chr [1:64] "W 18" "L 4" "W 25" "W 2" ...
## $ : chr [1:64] "W 14" "W 17" "W 21" "W 26" ...
## $ : chr [1:64] "W 7" "W 16" "W 11" "D 5" ...
## $ : chr [1:64] "D 12" "W 20" "W 13" "W 19" ...
## $ : chr [1:64] "D 4" "W 7" "W 12" "D 1" ...
## $ : chr [1:64] "" "" "" "" ...
## $ : chr [1:64] " ON " " MI " " MI " " MI " ...
## $ : chr [1:64] " 15445895 / R: 1794 " " 14598900 / R: 1553 " " 14959604 / R: 1384 " " 12616049 / R: 1716 " ...output[1]## [[1]]
## [1] " 1 " " 2 " " 3 " " 4 " " 5 " " 6 " " 7 "
## [8] " 8 " " 9 " " 10 " " 11 " " 12 " " 13 " " 14 "
## [15] " 15 " " 16 " " 17 " " 18 " " 19 " " 20 " " 21 "
## [22] " 22 " " 23 " " 24 " " 25 " " 26 " " 27 " " 28 "
## [29] " MI " " ON " " MI " " ON " " MI " " MI " " MI "
## [36] " MI " " MI " " MI " " MI " " MI " " MI " " MI "
## [43] " MI " " MI " " MI " " MI " " MI " " MI " " MI "
## [50] " MI " " MI " " MI " " MI " " MI " " MI " " MI "
## [57] " MI " " MI " " MI " " MI " " ON " " MI " " MI "
## [64] " MI "output[2]## [[1]]
## [1] " GARY HUA "
## [2] " DAKSHESH DARURI "
## [3] " ADITYA BAJAJ "
## [4] " PATRICK H SCHILLING "
## [5] " HANSHI ZUO "
## [6] " HANSEN SONG "
## [7] " GARY DEE SWATHELL "
## [8] " EZEKIEL HOUGHTON "
## [9] " STEFANO LEE "
## [10] " ANVIT RAO "
## [11] " CAMERON WILLIAM MC LEMAN "
## [12] " KENNETH J TACK "
## [13] " TORRANCE HENRY JR "
## [14] " BRADLEY SHAW "
## [15] " ZACHARY JAMES HOUGHTON "
## [16] " MIKE NIKITIN "
## [17] " RONALD GRZEGORCZYK "
## [18] " DAVID SUNDEEN "
## [19] " DIPANKAR ROY "
## [20] " JASON ZHENG "
## [21] " DINH DANG BUI "
## [22] " EUGENE L MCCLURE "
## [23] " ALAN BUI "
## [24] " MICHAEL R ALDRICH "
## [25] " LOREN SCHWIEBERT "
## [26] " MAX ZHU "
## [27] " GAURAV GIDWANI "
## [28] " SOFIA ADINA STANESCU"
## [29] " 15323285 / R: 1602P6 "
## [30] " 12577178 / R: 1522 "
## [31] " 15131618 / R: 1494 "
## [32] " 14073750 / R: 1441 "
## [33] " 14691842 / R: 1449 "
## [34] " 15051807 / R: 1399 "
## [35] " 14601397 / R: 1438 "
## [36] " 14773163 / R: 1355 "
## [37] " 15489571 / R: 980P12"
## [38] " 15108523 / R: 1423 "
## [39] " 12923035 / R: 1436P23"
## [40] " 14892710 / R: 1348 "
## [41] " 15761443 / R: 1403P5 "
## [42] " 14462326 / R: 1332 "
## [43] " 14101068 / R: 1283 "
## [44] " 15323504 / R: 1199 "
## [45] " 15372807 / R: 1242 "
## [46] " 15490981 / R: 377P3 "
## [47] " 12533115 / R: 1362 "
## [48] " 14369165 / R: 1382 "
## [49] " 12531685 / R: 1291P12"
## [50] " 14773178 / R: 1056 "
## [51] " 15205474 / R: 1011 "
## [52] " 14918803 / R: 935 "
## [53] " 12578849 / R: 1393 "
## [54] " 12836773 / R: 1270 "
## [55] " 15412571 / R: 1186 "
## [56] " 14679887 / R: 1153 "
## [57] " 15113330 / R: 1092 "
## [58] " 14700365 / R: 917 "
## [59] " 12841036 / R: 853 "
## [60] " 14579262 / R: 967 "
## [61] " 15771592 / R: 955P11"
## [62] " 15219542 / R: 1530 "
## [63] " 15057092 / R: 1175 "
## [64] " 15006561 / R: 1163 "After using different kinds of tools, delim is one of the best option for this exercise which has the different kinds of wild cards used in the data.
output <- read.delim("https://raw.githubusercontent.com/maharjansudhan/DATA607/master/tournamentinfo.txt", header=FALSE, sep="|", skip = 4, comment.char = "-", stringsAsFactors = FALSE)
str(output)## 'data.frame': 128 obs. of 11 variables:
## $ V1 : chr " 1 " " ON " " 2 " " MI " ...
## $ V2 : chr " GARY HUA " " 15445895 / R: 1794 " " DAKSHESH DARURI " " 14598900 / R: 1553 " ...
## $ V3 : num 6 NA 6 NA 6 NA 5.5 NA 5.5 NA ...
## $ V4 : chr "W 39" "" "W 63" "" ...
## $ V5 : chr "W 21" "" "W 58" "" ...
## $ V6 : chr "W 18" "" "L 4" "" ...
## $ V7 : chr "W 14" "" "W 17" "" ...
## $ V8 : chr "W 7" "" "W 16" "" ...
## $ V9 : chr "D 12" "" "W 20" "" ...
## $ V10: chr "D 4" "" "W 7" "" ...
## $ V11: logi NA NA NA NA NA NA ...output## V1 V2 V3 V4 V5 V6 V7
## 1 1 GARY HUA 6.0 W 39 W 21 W 18 W 14
## 2 ON 15445895 / R: 1794 NA
## 3 2 DAKSHESH DARURI 6.0 W 63 W 58 L 4 W 17
## 4 MI 14598900 / R: 1553 NA
## 5 3 ADITYA BAJAJ 6.0 L 8 W 61 W 25 W 21
## 6 MI 14959604 / R: 1384 NA
## 7 4 PATRICK H SCHILLING 5.5 W 23 D 28 W 2 W 26
## 8 MI 12616049 / R: 1716 NA
## 9 5 HANSHI ZUO 5.5 W 45 W 37 D 12 D 13
## 10 MI 14601533 / R: 1655 NA
## 11 6 HANSEN SONG 5.0 W 34 D 29 L 11 W 35
## 12 OH 15055204 / R: 1686 NA
## 13 7 GARY DEE SWATHELL 5.0 W 57 W 46 W 13 W 11
## 14 MI 11146376 / R: 1649 NA
## 15 8 EZEKIEL HOUGHTON 5.0 W 3 W 32 L 14 L 9
## 16 MI 15142253 / R: 1641P17 NA
## 17 9 STEFANO LEE 5.0 W 25 L 18 W 59 W 8
## 18 ON 14954524 / R: 1411 NA
## 19 10 ANVIT RAO 5.0 D 16 L 19 W 55 W 31
## 20 MI 14150362 / R: 1365 NA
## 21 11 CAMERON WILLIAM MC LEMAN 4.5 D 38 W 56 W 6 L 7
## 22 MI 12581589 / R: 1712 NA
## 23 12 KENNETH J TACK 4.5 W 42 W 33 D 5 W 38
## 24 MI 12681257 / R: 1663 NA
## 25 13 TORRANCE HENRY JR 4.5 W 36 W 27 L 7 D 5
## 26 MI 15082995 / R: 1666 NA
## 27 14 BRADLEY SHAW 4.5 W 54 W 44 W 8 L 1
## 28 MI 10131499 / R: 1610 NA
## 29 15 ZACHARY JAMES HOUGHTON 4.5 D 19 L 16 W 30 L 22
## 30 MI 15619130 / R: 1220P13 NA
## 31 16 MIKE NIKITIN 4.0 D 10 W 15 H W 39
## 32 MI 10295068 / R: 1604 NA
## 33 17 RONALD GRZEGORCZYK 4.0 W 48 W 41 L 26 L 2
## 34 MI 10297702 / R: 1629 NA
## 35 18 DAVID SUNDEEN 4.0 W 47 W 9 L 1 W 32
## 36 MI 11342094 / R: 1600 NA
## 37 19 DIPANKAR ROY 4.0 D 15 W 10 W 52 D 28
## 38 MI 14862333 / R: 1564 NA
## 39 20 JASON ZHENG 4.0 L 40 W 49 W 23 W 41
## 40 MI 14529060 / R: 1595 NA
## 41 21 DINH DANG BUI 4.0 W 43 L 1 W 47 L 3
## 42 ON 15495066 / R: 1563P22 NA
## 43 22 EUGENE L MCCLURE 4.0 W 64 D 52 L 28 W 15
## 44 MI 12405534 / R: 1555 NA
## 45 23 ALAN BUI 4.0 L 4 W 43 L 20 W 58
## 46 ON 15030142 / R: 1363 NA
## 47 24 MICHAEL R ALDRICH 4.0 L 28 L 47 W 43 L 25
## 48 MI 13469010 / R: 1229 NA
## 49 25 LOREN SCHWIEBERT 3.5 L 9 W 53 L 3 W 24
## 50 MI 12486656 / R: 1745 NA
## 51 26 MAX ZHU 3.5 W 49 W 40 W 17 L 4
## 52 ON 15131520 / R: 1579 NA
## 53 27 GAURAV GIDWANI 3.5 W 51 L 13 W 46 W 37
## 54 MI 14476567 / R: 1552 NA
## 55 28 SOFIA ADINA STANESCU NA
## 56 MI 14882954 / R: 1507 NA
## 57 29 CHIEDOZIE OKORIE 3.5 W 50 D 6 L 38 L 34
## 58 MI 15323285 / R: 1602P6 NA
## 59 30 GEORGE AVERY JONES 3.5 L 52 D 64 L 15 W 55
## 60 ON 12577178 / R: 1522 NA
## 61 31 RISHI SHETTY 3.5 L 58 D 55 W 64 L 10
## 62 MI 15131618 / R: 1494 NA
## 63 32 JOSHUA PHILIP MATHEWS 3.5 W 61 L 8 W 44 L 18
## 64 ON 14073750 / R: 1441 NA
## 65 33 JADE GE 3.5 W 60 L 12 W 50 D 36
## 66 MI 14691842 / R: 1449 NA
## 67 34 MICHAEL JEFFERY THOMAS 3.5 L 6 W 60 L 37 W 29
## 68 MI 15051807 / R: 1399 NA
## 69 35 JOSHUA DAVID LEE 3.5 L 46 L 38 W 56 L 6
## 70 MI 14601397 / R: 1438 NA
## 71 36 SIDDHARTH JHA 3.5 L 13 W 57 W 51 D 33
## 72 MI 14773163 / R: 1355 NA
## 73 37 AMIYATOSH PWNANANDAM 3.5 B L 5 W 34 L 27
## 74 MI 15489571 / R: 980P12 NA
## 75 38 BRIAN LIU 3.0 D 11 W 35 W 29 L 12
## 76 MI 15108523 / R: 1423 NA
## 77 39 JOEL R HENDON 3.0 L 1 W 54 W 40 L 16
## 78 MI 12923035 / R: 1436P23 NA
## 79 40 FOREST ZHANG 3.0 W 20 L 26 L 39 W 59
## 80 MI 14892710 / R: 1348 NA
## 81 41 KYLE WILLIAM MURPHY 3.0 W 59 L 17 W 58 L 20
## 82 MI 15761443 / R: 1403P5 NA
## 83 42 JARED GE 3.0 L 12 L 50 L 57 D 60
## 84 MI 14462326 / R: 1332 NA
## 85 43 ROBERT GLEN VASEY 3.0 L 21 L 23 L 24 W 63
## 86 MI 14101068 / R: 1283 NA
## 87 44 JUSTIN D SCHILLING 3.0 B L 14 L 32 W 53
## 88 MI 15323504 / R: 1199 NA
## 89 45 DEREK YAN 3.0 L 5 L 51 D 60 L 56
## 90 MI 15372807 / R: 1242 NA
## 91 46 JACOB ALEXANDER LAVALLEY 3.0 W 35 L 7 L 27 L 50
## 92 MI 15490981 / R: 377P3 NA
## 93 47 ERIC WRIGHT 2.5 L 18 W 24 L 21 W 61
## 94 MI 12533115 / R: 1362 NA
## 95 48 DANIEL KHAIN 2.5 L 17 W 63 H D 52
## 96 MI 14369165 / R: 1382 NA
## 97 49 MICHAEL J MARTIN 2.5 L 26 L 20 D 63 D 64
## 98 MI 12531685 / R: 1291P12 NA
## 99 50 SHIVAM JHA 2.5 L 29 W 42 L 33 W 46
## 100 MI 14773178 / R: 1056 NA
## 101 51 TEJAS AYYAGARI 2.5 L 27 W 45 L 36 W 57
## 102 MI 15205474 / R: 1011 NA
## 103 52 ETHAN GUO 2.5 W 30 D 22 L 19 D 48
## 104 MI 14918803 / R: 935 NA
## 105 53 JOSE C YBARRA 2.0 H L 25 H L 44
## 106 MI 12578849 / R: 1393 NA
## 107 54 LARRY HODGE 2.0 L 14 L 39 L 61 B
## 108 MI 12836773 / R: 1270 NA
## 109 55 ALEX KONG 2.0 L 62 D 31 L 10 L 30
## 110 MI 15412571 / R: 1186 NA
## 111 56 MARISA RICCI 2.0 H L 11 L 35 W 45
## 112 MI 14679887 / R: 1153 NA
## 113 57 MICHAEL LU 2.0 L 7 L 36 W 42 L 51
## 114 MI 15113330 / R: 1092 NA
## 115 58 VIRAJ MOHILE 2.0 W 31 L 2 L 41 L 23
## 116 MI 14700365 / R: 917 NA
## 117 59 SEAN M MC CORMICK 2.0 L 41 B L 9 L 40
## 118 MI 12841036 / R: 853 NA
## 119 60 JULIA SHEN 1.5 L 33 L 34 D 45 D 42
## 120 MI 14579262 / R: 967 NA
## 121 61 JEZZEL FARKAS 1.5 L 32 L 3 W 54 L 47
## 122 ON 15771592 / R: 955P11 NA
## 123 62 ASHWIN BALAJI 1.0 W 55 U U U
## 124 MI 15219542 / R: 1530 NA
## 125 63 THOMAS JOSEPH HOSMER 1.0 L 2 L 48 D 49 L 43
## 126 MI 15057092 / R: 1175 NA
## 127 64 BEN LI 1.0 L 22 D 30 L 31 D 49
## 128 MI 15006561 / R: 1163 NA
## V8 V9 V10 V11
## 1 W 7 D 12 D 4 NA
## 2 NA
## 3 W 16 W 20 W 7 NA
## 4 NA
## 5 W 11 W 13 W 12 NA
## 6 NA
## 7 D 5 W 19 D 1 NA
## 8 NA
## 9 D 4 W 14 W 17 NA
## 10 NA
## 11 D 10 W 27 W 21 NA
## 12 NA
## 13 L 1 W 9 L 2 NA
## 14 NA
## 15 W 47 W 28 W 19 NA
## 16 NA
## 17 W 26 L 7 W 20 NA
## 18 NA
## 19 D 6 W 25 W 18 NA
## 20 NA
## 21 L 3 W 34 W 26 NA
## 22 NA
## 23 H D 1 L 3 NA
## 24 NA
## 25 W 33 L 3 W 32 NA
## 26 NA
## 27 D 27 L 5 W 31 NA
## 28 NA
## 29 W 54 W 33 W 38 NA
## 30 NA
## 31 L 2 W 36 U NA
## 32 NA
## 33 W 23 W 22 L 5 NA
## 34 NA
## 35 L 19 W 38 L 10 NA
## 36 NA
## 37 W 18 L 4 L 8 NA
## 38 NA
## 39 W 28 L 2 L 9 NA
## 40 NA
## 41 W 40 W 39 L 6 NA
## 42 NA
## 43 H L 17 W 40 NA
## 44 NA
## 45 L 17 W 37 W 46 NA
## 46 NA
## 47 W 60 W 44 W 39 NA
## 48 NA
## 49 D 34 L 10 W 47 NA
## 50 NA
## 51 L 9 D 32 L 11 NA
## 52 NA
## 53 D 14 L 6 U NA
## 54 NA
## 55 NA
## 56 NA
## 57 W 52 W 48 U NA
## 58 NA
## 59 L 31 W 61 W 50 NA
## 60 NA
## 61 W 30 W 50 L 14 NA
## 62 NA
## 63 W 51 D 26 L 13 NA
## 64 NA
## 65 L 13 L 15 W 51 NA
## 66 NA
## 67 D 25 L 11 W 52 NA
## 68 NA
## 69 W 57 D 52 W 48 NA
## 70 NA
## 71 H L 16 D 28 NA
## 72 NA
## 73 H L 23 W 61 NA
## 74 NA
## 75 H L 18 L 15 NA
## 76 NA
## 77 W 44 L 21 L 24 NA
## 78 NA
## 79 L 21 W 56 L 22 NA
## 80 NA
## 81 X U U NA
## 82 NA
## 83 D 61 W 64 W 56 NA
## 84 NA
## 85 W 59 L 46 W 55 NA
## 86 NA
## 87 L 39 L 24 W 59 NA
## 88 NA
## 89 W 63 D 55 W 58 NA
## 90 NA
## 91 W 64 W 43 L 23 NA
## 92 NA
## 93 L 8 D 51 L 25 NA
## 94 NA
## 95 H L 29 L 35 NA
## 96 NA
## 97 W 58 H U NA
## 98 NA
## 99 H L 31 L 30 NA
## 100 NA
## 101 L 32 D 47 L 33 NA
## 102 NA
## 103 L 29 D 35 L 34 NA
## 104 NA
## 105 U W 57 U NA
## 106 NA
## 107 L 15 L 59 W 64 NA
## 108 NA
## 109 B D 45 L 43 NA
## 110 NA
## 111 H L 40 L 42 NA
## 112 NA
## 113 L 35 L 53 B NA
## 114 NA
## 115 L 49 B L 45 NA
## 116 NA
## 117 L 43 W 54 L 44 NA
## 118 NA
## 119 L 24 H U NA
## 120 NA
## 121 D 42 L 30 L 37 NA
## 122 NA
## 123 U U U NA
## 124 NA
## 125 L 45 H U NA
## 126 NA
## 127 L 46 L 42 L 54 NA
## 128 NAoutput <- read.delim("https://raw.githubusercontent.com/maharjansudhan/DATA607/master/tournamentinfo.txt", header=FALSE, sep="|", skip = 4, stringsAsFactors = FALSE)
str(output)## 'data.frame': 192 obs. of 11 variables:
## $ V1 : chr " 1 " " ON " "-----------------------------------------------------------------------------------------" " 2 " ...
## $ V2 : chr " GARY HUA " " 15445895 / R: 1794 ->1817 " "" " DAKSHESH DARURI " ...
## $ V3 : chr "6.0 " "N:2 " "" "6.0 " ...
## $ V4 : chr "W 39" "W " "" "W 63" ...
## $ V5 : chr "W 21" "B " "" "W 58" ...
## $ V6 : chr "W 18" "W " "" "L 4" ...
## $ V7 : chr "W 14" "B " "" "W 17" ...
## $ V8 : chr "W 7" "W " "" "W 16" ...
## $ V9 : chr "D 12" "B " "" "W 20" ...
## $ V10: chr "D 4" "W " "" "W 7" ...
## $ V11: logi NA NA NA NA NA NA ...output## V1
## 1 1
## 2 ON
## 3 -----------------------------------------------------------------------------------------
## 4 2
## 5 MI
## 6 -----------------------------------------------------------------------------------------
## 7 3
## 8 MI
## 9 -----------------------------------------------------------------------------------------
## 10 4
## 11 MI
## 12 -----------------------------------------------------------------------------------------
## 13 5
## 14 MI
## 15 -----------------------------------------------------------------------------------------
## 16 6
## 17 OH
## 18 -----------------------------------------------------------------------------------------
## 19 7
## 20 MI
## 21 -----------------------------------------------------------------------------------------
## 22 8
## 23 MI
## 24 -----------------------------------------------------------------------------------------
## 25 9
## 26 ON
## 27 -----------------------------------------------------------------------------------------
## 28 10
## 29 MI
## 30 -----------------------------------------------------------------------------------------
## 31 11
## 32 MI
## 33 -----------------------------------------------------------------------------------------
## 34 12
## 35 MI
## 36 -----------------------------------------------------------------------------------------
## 37 13
## 38 MI
## 39 -----------------------------------------------------------------------------------------
## 40 14
## 41 MI
## 42 -----------------------------------------------------------------------------------------
## 43 15
## 44 MI
## 45 -----------------------------------------------------------------------------------------
## 46 16
## 47 MI
## 48 -----------------------------------------------------------------------------------------
## 49 17
## 50 MI
## 51 -----------------------------------------------------------------------------------------
## 52 18
## 53 MI
## 54 -----------------------------------------------------------------------------------------
## 55 19
## 56 MI
## 57 -----------------------------------------------------------------------------------------
## 58 20
## 59 MI
## 60 -----------------------------------------------------------------------------------------
## 61 21
## 62 ON
## 63 -----------------------------------------------------------------------------------------
## 64 22
## 65 MI
## 66 -----------------------------------------------------------------------------------------
## 67 23
## 68 ON
## 69 -----------------------------------------------------------------------------------------
## 70 24
## 71 MI
## 72 -----------------------------------------------------------------------------------------
## 73 25
## 74 MI
## 75 -----------------------------------------------------------------------------------------
## 76 26
## 77 ON
## 78 -----------------------------------------------------------------------------------------
## 79 27
## 80 MI
## 81 -----------------------------------------------------------------------------------------
## 82 28
## 83 MI
## 84 -----------------------------------------------------------------------------------------
## 85 29
## 86 MI
## 87 -----------------------------------------------------------------------------------------
## 88 30
## 89 ON
## 90 -----------------------------------------------------------------------------------------
## 91 31
## 92 MI
## 93 -----------------------------------------------------------------------------------------
## 94 32
## 95 ON
## 96 -----------------------------------------------------------------------------------------
## 97 33
## 98 MI
## 99 -----------------------------------------------------------------------------------------
## 100 34
## 101 MI
## 102 -----------------------------------------------------------------------------------------
## 103 35
## 104 MI
## 105 -----------------------------------------------------------------------------------------
## 106 36
## 107 MI
## 108 -----------------------------------------------------------------------------------------
## 109 37
## 110 MI
## 111 -----------------------------------------------------------------------------------------
## 112 38
## 113 MI
## 114 -----------------------------------------------------------------------------------------
## 115 39
## 116 MI
## 117 -----------------------------------------------------------------------------------------
## 118 40
## 119 MI
## 120 -----------------------------------------------------------------------------------------
## 121 41
## 122 MI
## 123 -----------------------------------------------------------------------------------------
## 124 42
## 125 MI
## 126 -----------------------------------------------------------------------------------------
## 127 43
## 128 MI
## 129 -----------------------------------------------------------------------------------------
## 130 44
## 131 MI
## 132 -----------------------------------------------------------------------------------------
## 133 45
## 134 MI
## 135 -----------------------------------------------------------------------------------------
## 136 46
## 137 MI
## 138 -----------------------------------------------------------------------------------------
## 139 47
## 140 MI
## 141 -----------------------------------------------------------------------------------------
## 142 48
## 143 MI
## 144 -----------------------------------------------------------------------------------------
## 145 49
## 146 MI
## 147 -----------------------------------------------------------------------------------------
## 148 50
## 149 MI
## 150 -----------------------------------------------------------------------------------------
## 151 51
## 152 MI
## 153 -----------------------------------------------------------------------------------------
## 154 52
## 155 MI
## 156 -----------------------------------------------------------------------------------------
## 157 53
## 158 MI
## 159 -----------------------------------------------------------------------------------------
## 160 54
## 161 MI
## 162 -----------------------------------------------------------------------------------------
## 163 55
## 164 MI
## 165 -----------------------------------------------------------------------------------------
## 166 56
## 167 MI
## 168 -----------------------------------------------------------------------------------------
## 169 57
## 170 MI
## 171 -----------------------------------------------------------------------------------------
## 172 58
## 173 MI
## 174 -----------------------------------------------------------------------------------------
## 175 59
## 176 MI
## 177 -----------------------------------------------------------------------------------------
## 178 60
## 179 MI
## 180 -----------------------------------------------------------------------------------------
## 181 61
## 182 ON
## 183 -----------------------------------------------------------------------------------------
## 184 62
## 185 MI
## 186 -----------------------------------------------------------------------------------------
## 187 63
## 188 MI
## 189 -----------------------------------------------------------------------------------------
## 190 64
## 191 MI
## 192 -----------------------------------------------------------------------------------------
## V2 V3 V4 V5 V6 V7 V8
## 1 GARY HUA 6.0 W 39 W 21 W 18 W 14 W 7
## 2 15445895 / R: 1794 ->1817 N:2 W B W B W
## 3
## 4 DAKSHESH DARURI 6.0 W 63 W 58 L 4 W 17 W 16
## 5 14598900 / R: 1553 ->1663 N:2 B W B W B
## 6
## 7 ADITYA BAJAJ 6.0 L 8 W 61 W 25 W 21 W 11
## 8 14959604 / R: 1384 ->1640 N:2 W B W B W
## 9
## 10 PATRICK H SCHILLING 5.5 W 23 D 28 W 2 W 26 D 5
## 11 12616049 / R: 1716 ->1744 N:2 W B W B W
## 12
## 13 HANSHI ZUO 5.5 W 45 W 37 D 12 D 13 D 4
## 14 14601533 / R: 1655 ->1690 N:2 B W B W B
## 15
## 16 HANSEN SONG 5.0 W 34 D 29 L 11 W 35 D 10
## 17 15055204 / R: 1686 ->1687 N:3 W B W B B
## 18
## 19 GARY DEE SWATHELL 5.0 W 57 W 46 W 13 W 11 L 1
## 20 11146376 / R: 1649 ->1673 N:3 W B W B B
## 21
## 22 EZEKIEL HOUGHTON 5.0 W 3 W 32 L 14 L 9 W 47
## 23 15142253 / R: 1641P17->1657P24 N:3 B W B W B
## 24
## 25 STEFANO LEE 5.0 W 25 L 18 W 59 W 8 W 26
## 26 14954524 / R: 1411 ->1564 N:2 W B W B W
## 27
## 28 ANVIT RAO 5.0 D 16 L 19 W 55 W 31 D 6
## 29 14150362 / R: 1365 ->1544 N:3 W W B B W
## 30
## 31 CAMERON WILLIAM MC LEMAN 4.5 D 38 W 56 W 6 L 7 L 3
## 32 12581589 / R: 1712 ->1696 N:3 B W B W B
## 33
## 34 KENNETH J TACK 4.5 W 42 W 33 D 5 W 38 H
## 35 12681257 / R: 1663 ->1670 N:3 W B W B
## 36
## 37 TORRANCE HENRY JR 4.5 W 36 W 27 L 7 D 5 W 33
## 38 15082995 / R: 1666 ->1662 N:3 B W B B W
## 39
## 40 BRADLEY SHAW 4.5 W 54 W 44 W 8 L 1 D 27
## 41 10131499 / R: 1610 ->1618 N:3 W B W W B
## 42
## 43 ZACHARY JAMES HOUGHTON 4.5 D 19 L 16 W 30 L 22 W 54
## 44 15619130 / R: 1220P13->1416P20 N:3 B B W W B
## 45
## 46 MIKE NIKITIN 4.0 D 10 W 15 H W 39 L 2
## 47 10295068 / R: 1604 ->1613 N:3 B W B W
## 48
## 49 RONALD GRZEGORCZYK 4.0 W 48 W 41 L 26 L 2 W 23
## 50 10297702 / R: 1629 ->1610 N:3 W B W B W
## 51
## 52 DAVID SUNDEEN 4.0 W 47 W 9 L 1 W 32 L 19
## 53 11342094 / R: 1600 ->1600 N:3 B W B W B
## 54
## 55 DIPANKAR ROY 4.0 D 15 W 10 W 52 D 28 W 18
## 56 14862333 / R: 1564 ->1570 N:3 W B W B W
## 57
## 58 JASON ZHENG 4.0 L 40 W 49 W 23 W 41 W 28
## 59 14529060 / R: 1595 ->1569 N:4 W B W B W
## 60
## 61 DINH DANG BUI 4.0 W 43 L 1 W 47 L 3 W 40
## 62 15495066 / R: 1563P22->1562 N:3 B W B W W
## 63
## 64 EUGENE L MCCLURE 4.0 W 64 D 52 L 28 W 15 H
## 65 12405534 / R: 1555 ->1529 N:4 W B W B
## 66
## 67 ALAN BUI 4.0 L 4 W 43 L 20 W 58 L 17
## 68 15030142 / R: 1363 ->1371 B W B W B
## 69
## 70 MICHAEL R ALDRICH 4.0 L 28 L 47 W 43 L 25 W 60
## 71 13469010 / R: 1229 ->1300 N:4 B W B B W
## 72
## 73 LOREN SCHWIEBERT 3.5 L 9 W 53 L 3 W 24 D 34
## 74 12486656 / R: 1745 ->1681 N:4 B W B W B
## 75
## 76 MAX ZHU 3.5 W 49 W 40 W 17 L 4 L 9
## 77 15131520 / R: 1579 ->1564 N:4 B W B W B
## 78
## 79 GAURAV GIDWANI 3.5 W 51 L 13 W 46 W 37 D 14
## 80 14476567 / R: 1552 ->1539 N:4 W B W B W
## 81
## 82 SOFIA ADINA STANESCU-BELLU 3.5 W 24 D 4 W 22 D 19 L 20
## 83 14882954 / R: 1507 ->1513 N:3 W W B W B
## 84
## 85 CHIEDOZIE OKORIE 3.5 W 50 D 6 L 38 L 34 W 52
## 86 15323285 / R: 1602P6 ->1508P12 N:4 B W B W W
## 87
## 88 GEORGE AVERY JONES 3.5 L 52 D 64 L 15 W 55 L 31
## 89 12577178 / R: 1522 ->1444 W B B W W
## 90
## 91 RISHI SHETTY 3.5 L 58 D 55 W 64 L 10 W 30
## 92 15131618 / R: 1494 ->1444 B W B W B
## 93
## 94 JOSHUA PHILIP MATHEWS 3.5 W 61 L 8 W 44 L 18 W 51
## 95 14073750 / R: 1441 ->1433 N:4 W B W B W
## 96
## 97 JADE GE 3.5 W 60 L 12 W 50 D 36 L 13
## 98 14691842 / R: 1449 ->1421 B W B W B
## 99
## 100 MICHAEL JEFFERY THOMAS 3.5 L 6 W 60 L 37 W 29 D 25
## 101 15051807 / R: 1399 ->1400 B W B B W
## 102
## 103 JOSHUA DAVID LEE 3.5 L 46 L 38 W 56 L 6 W 57
## 104 14601397 / R: 1438 ->1392 W W B W B
## 105
## 106 SIDDHARTH JHA 3.5 L 13 W 57 W 51 D 33 H
## 107 14773163 / R: 1355 ->1367 N:4 W B W B
## 108
## 109 AMIYATOSH PWNANANDAM 3.5 B L 5 W 34 L 27 H
## 110 15489571 / R: 980P12->1077P17 B W W
## 111
## 112 BRIAN LIU 3.0 D 11 W 35 W 29 L 12 H
## 113 15108523 / R: 1423 ->1439 N:4 W B W W
## 114
## 115 JOEL R HENDON 3.0 L 1 W 54 W 40 L 16 W 44
## 116 12923035 / R: 1436P23->1413 N:4 B W B W B
## 117
## 118 FOREST ZHANG 3.0 W 20 L 26 L 39 W 59 L 21
## 119 14892710 / R: 1348 ->1346 B B W W B
## 120
## 121 KYLE WILLIAM MURPHY 3.0 W 59 L 17 W 58 L 20 X
## 122 15761443 / R: 1403P5 ->1341P9 B W B W
## 123
## 124 JARED GE 3.0 L 12 L 50 L 57 D 60 D 61
## 125 14462326 / R: 1332 ->1256 B W B B W
## 126
## 127 ROBERT GLEN VASEY 3.0 L 21 L 23 L 24 W 63 W 59
## 128 14101068 / R: 1283 ->1244 W B W W B
## 129
## 130 JUSTIN D SCHILLING 3.0 B L 14 L 32 W 53 L 39
## 131 15323504 / R: 1199 ->1199 W B B W
## 132
## 133 DEREK YAN 3.0 L 5 L 51 D 60 L 56 W 63
## 134 15372807 / R: 1242 ->1191 W B W B W
## 135
## 136 JACOB ALEXANDER LAVALLEY 3.0 W 35 L 7 L 27 L 50 W 64
## 137 15490981 / R: 377P3 ->1076P10 B W B W B
## 138
## 139 ERIC WRIGHT 2.5 L 18 W 24 L 21 W 61 L 8
## 140 12533115 / R: 1362 ->1341 W B W B W
## 141
## 142 DANIEL KHAIN 2.5 L 17 W 63 H D 52 H
## 143 14369165 / R: 1382 ->1335 B W B
## 144
## 145 MICHAEL J MARTIN 2.5 L 26 L 20 D 63 D 64 W 58
## 146 12531685 / R: 1291P12->1259P17 W W B W B
## 147
## 148 SHIVAM JHA 2.5 L 29 W 42 L 33 W 46 H
## 149 14773178 / R: 1056 ->1111 W B W B
## 150
## 151 TEJAS AYYAGARI 2.5 L 27 W 45 L 36 W 57 L 32
## 152 15205474 / R: 1011 ->1097 B W B W B
## 153
## 154 ETHAN GUO 2.5 W 30 D 22 L 19 D 48 L 29
## 155 14918803 / R: 935 ->1092 N:4 B W B W B
## 156
## 157 JOSE C YBARRA 2.0 H L 25 H L 44 U
## 158 12578849 / R: 1393 ->1359 B W
## 159
## 160 LARRY HODGE 2.0 L 14 L 39 L 61 B L 15
## 161 12836773 / R: 1270 ->1200 B B W W
## 162
## 163 ALEX KONG 2.0 L 62 D 31 L 10 L 30 B
## 164 15412571 / R: 1186 ->1163 W B W B
## 165
## 166 MARISA RICCI 2.0 H L 11 L 35 W 45 H
## 167 14679887 / R: 1153 ->1140 B W W
## 168
## 169 MICHAEL LU 2.0 L 7 L 36 W 42 L 51 L 35
## 170 15113330 / R: 1092 ->1079 B W W B W
## 171
## 172 VIRAJ MOHILE 2.0 W 31 L 2 L 41 L 23 L 49
## 173 14700365 / R: 917 -> 941 W B W B W
## 174
## 175 SEAN M MC CORMICK 2.0 L 41 B L 9 L 40 L 43
## 176 12841036 / R: 853 -> 878 W B B W
## 177
## 178 JULIA SHEN 1.5 L 33 L 34 D 45 D 42 L 24
## 179 14579262 / R: 967 -> 984 W B B W B
## 180
## 181 JEZZEL FARKAS 1.5 L 32 L 3 W 54 L 47 D 42
## 182 15771592 / R: 955P11-> 979P18 B W B W B
## 183
## 184 ASHWIN BALAJI 1.0 W 55 U U U U
## 185 15219542 / R: 1530 ->1535 B
## 186
## 187 THOMAS JOSEPH HOSMER 1.0 L 2 L 48 D 49 L 43 L 45
## 188 15057092 / R: 1175 ->1125 W B W B B
## 189
## 190 BEN LI 1.0 L 22 D 30 L 31 D 49 L 46
## 191 15006561 / R: 1163 ->1112 B W W B W
## 192
## V9 V10 V11
## 1 D 12 D 4 NA
## 2 B W NA
## 3 NA
## 4 W 20 W 7 NA
## 5 W B NA
## 6 NA
## 7 W 13 W 12 NA
## 8 B W NA
## 9 NA
## 10 W 19 D 1 NA
## 11 B B NA
## 12 NA
## 13 W 14 W 17 NA
## 14 W B NA
## 15 NA
## 16 W 27 W 21 NA
## 17 W B NA
## 18 NA
## 19 W 9 L 2 NA
## 20 W W NA
## 21 NA
## 22 W 28 W 19 NA
## 23 W W NA
## 24 NA
## 25 L 7 W 20 NA
## 26 B B NA
## 27 NA
## 28 W 25 W 18 NA
## 29 B W NA
## 30 NA
## 31 W 34 W 26 NA
## 32 W B NA
## 33 NA
## 34 D 1 L 3 NA
## 35 W B NA
## 36 NA
## 37 L 3 W 32 NA
## 38 W B NA
## 39 NA
## 40 L 5 W 31 NA
## 41 B W NA
## 42 NA
## 43 W 33 W 38 NA
## 44 B W NA
## 45 NA
## 46 W 36 U NA
## 47 B NA
## 48 NA
## 49 W 22 L 5 NA
## 50 B W NA
## 51 NA
## 52 W 38 L 10 NA
## 53 W B NA
## 54 NA
## 55 L 4 L 8 NA
## 56 W B NA
## 57 NA
## 58 L 2 L 9 NA
## 59 B W NA
## 60 NA
## 61 W 39 L 6 NA
## 62 B W NA
## 63 NA
## 64 L 17 W 40 NA
## 65 W B NA
## 66 NA
## 67 W 37 W 46 NA
## 68 W B NA
## 69 NA
## 70 W 44 W 39 NA
## 71 W B NA
## 72 NA
## 73 L 10 W 47 NA
## 74 W B NA
## 75 NA
## 76 D 32 L 11 NA
## 77 W W NA
## 78 NA
## 79 L 6 U NA
## 80 B NA
## 81 NA
## 82 L 8 D 36 NA
## 83 B W NA
## 84 NA
## 85 W 48 U NA
## 86 B NA
## 87 NA
## 88 W 61 W 50 NA
## 89 B B NA
## 90 NA
## 91 W 50 L 14 NA
## 92 W B NA
## 93 NA
## 94 D 26 L 13 NA
## 95 B W NA
## 96 NA
## 97 L 15 W 51 NA
## 98 W B NA
## 99 NA
## 100 L 11 W 52 NA
## 101 B W NA
## 102 NA
## 103 D 52 W 48 NA
## 104 B W NA
## 105 NA
## 106 L 16 D 28 NA
## 107 W B NA
## 108 NA
## 109 L 23 W 61 NA
## 110 B W NA
## 111 NA
## 112 L 18 L 15 NA
## 113 B B NA
## 114 NA
## 115 L 21 L 24 NA
## 116 W W NA
## 117 NA
## 118 W 56 L 22 NA
## 119 W W NA
## 120 NA
## 121 U U NA
## 122 NA
## 123 NA
## 124 W 64 W 56 NA
## 125 W B NA
## 126 NA
## 127 L 46 W 55 NA
## 128 B W NA
## 129 NA
## 130 L 24 W 59 NA
## 131 B W NA
## 132 NA
## 133 D 55 W 58 NA
## 134 B W NA
## 135 NA
## 136 W 43 L 23 NA
## 137 W W NA
## 138 NA
## 139 D 51 L 25 NA
## 140 B W NA
## 141 NA
## 142 L 29 L 35 NA
## 143 W B NA
## 144 NA
## 145 H U NA
## 146 NA
## 147 NA
## 148 L 31 L 30 NA
## 149 B W NA
## 150 NA
## 151 D 47 L 33 NA
## 152 W W NA
## 153 NA
## 154 D 35 L 34 NA
## 155 W B NA
## 156 NA
## 157 W 57 U NA
## 158 W NA
## 159 NA
## 160 L 59 W 64 NA
## 161 B W NA
## 162 NA
## 163 D 45 L 43 NA
## 164 W B NA
## 165 NA
## 166 L 40 L 42 NA
## 167 B W NA
## 168 NA
## 169 L 53 B NA
## 170 B NA
## 171 NA
## 172 B L 45 NA
## 173 B NA
## 174 NA
## 175 W 54 L 44 NA
## 176 W B NA
## 177 NA
## 178 H U NA
## 179 NA
## 180 NA
## 181 L 30 L 37 NA
## 182 W B NA
## 183 NA
## 184 U U NA
## 185 NA
## 186 NA
## 187 H U NA
## 188 NA
## 189 NA
## 190 L 42 L 54 NA
## 191 B B NA
## 192 NAAfter elminating some columns and ignoring some wild cards. We have
df <- data.frame(Name = output$V2[c(TRUE, FALSE, FALSE)], State = output$V1[c(FALSE, TRUE, FALSE)], Points = round(as.numeric(output$V3[c(TRUE, FALSE, FALSE)]), 1), Rating = integer(64), Opponents = integer(64))
df## Name State Points Rating Opponents
## 1 GARY HUA ON 6.0 0 0
## 2 DAKSHESH DARURI MI 6.0 0 0
## 3 ADITYA BAJAJ MI 6.0 0 0
## 4 PATRICK H SCHILLING MI 5.5 0 0
## 5 HANSHI ZUO MI 5.5 0 0
## 6 HANSEN SONG OH 5.0 0 0
## 7 GARY DEE SWATHELL MI 5.0 0 0
## 8 EZEKIEL HOUGHTON MI 5.0 0 0
## 9 STEFANO LEE ON 5.0 0 0
## 10 ANVIT RAO MI 5.0 0 0
## 11 CAMERON WILLIAM MC LEMAN MI 4.5 0 0
## 12 KENNETH J TACK MI 4.5 0 0
## 13 TORRANCE HENRY JR MI 4.5 0 0
## 14 BRADLEY SHAW MI 4.5 0 0
## 15 ZACHARY JAMES HOUGHTON MI 4.5 0 0
## 16 MIKE NIKITIN MI 4.0 0 0
## 17 RONALD GRZEGORCZYK MI 4.0 0 0
## 18 DAVID SUNDEEN MI 4.0 0 0
## 19 DIPANKAR ROY MI 4.0 0 0
## 20 JASON ZHENG MI 4.0 0 0
## 21 DINH DANG BUI ON 4.0 0 0
## 22 EUGENE L MCCLURE MI 4.0 0 0
## 23 ALAN BUI ON 4.0 0 0
## 24 MICHAEL R ALDRICH MI 4.0 0 0
## 25 LOREN SCHWIEBERT MI 3.5 0 0
## 26 MAX ZHU ON 3.5 0 0
## 27 GAURAV GIDWANI MI 3.5 0 0
## 28 SOFIA ADINA STANESCU-BELLU MI 3.5 0 0
## 29 CHIEDOZIE OKORIE MI 3.5 0 0
## 30 GEORGE AVERY JONES ON 3.5 0 0
## 31 RISHI SHETTY MI 3.5 0 0
## 32 JOSHUA PHILIP MATHEWS ON 3.5 0 0
## 33 JADE GE MI 3.5 0 0
## 34 MICHAEL JEFFERY THOMAS MI 3.5 0 0
## 35 JOSHUA DAVID LEE MI 3.5 0 0
## 36 SIDDHARTH JHA MI 3.5 0 0
## 37 AMIYATOSH PWNANANDAM MI 3.5 0 0
## 38 BRIAN LIU MI 3.0 0 0
## 39 JOEL R HENDON MI 3.0 0 0
## 40 FOREST ZHANG MI 3.0 0 0
## 41 KYLE WILLIAM MURPHY MI 3.0 0 0
## 42 JARED GE MI 3.0 0 0
## 43 ROBERT GLEN VASEY MI 3.0 0 0
## 44 JUSTIN D SCHILLING MI 3.0 0 0
## 45 DEREK YAN MI 3.0 0 0
## 46 JACOB ALEXANDER LAVALLEY MI 3.0 0 0
## 47 ERIC WRIGHT MI 2.5 0 0
## 48 DANIEL KHAIN MI 2.5 0 0
## 49 MICHAEL J MARTIN MI 2.5 0 0
## 50 SHIVAM JHA MI 2.5 0 0
## 51 TEJAS AYYAGARI MI 2.5 0 0
## 52 ETHAN GUO MI 2.5 0 0
## 53 JOSE C YBARRA MI 2.0 0 0
## 54 LARRY HODGE MI 2.0 0 0
## 55 ALEX KONG MI 2.0 0 0
## 56 MARISA RICCI MI 2.0 0 0
## 57 MICHAEL LU MI 2.0 0 0
## 58 VIRAJ MOHILE MI 2.0 0 0
## 59 SEAN M MC CORMICK MI 2.0 0 0
## 60 JULIA SHEN MI 1.5 0 0
## 61 JEZZEL FARKAS ON 1.5 0 0
## 62 ASHWIN BALAJI MI 1.0 0 0
## 63 THOMAS JOSEPH HOSMER MI 1.0 0 0
## 64 BEN LI MI 1.0 0 0We have got some of our columns that can be used for the final output.
library(stringr)## Warning: package 'stringr' was built under R version 3.5.1outputRating <- str_extract(output$V2[c(FALSE, TRUE, FALSE)], "R:[:blank:]+[:digit:]+")
df$Rating <- as.numeric(str_extract(outputRating, "[:digit:]+"))
df## Name State Points Rating Opponents
## 1 GARY HUA ON 6.0 1794 0
## 2 DAKSHESH DARURI MI 6.0 1553 0
## 3 ADITYA BAJAJ MI 6.0 1384 0
## 4 PATRICK H SCHILLING MI 5.5 1716 0
## 5 HANSHI ZUO MI 5.5 1655 0
## 6 HANSEN SONG OH 5.0 1686 0
## 7 GARY DEE SWATHELL MI 5.0 1649 0
## 8 EZEKIEL HOUGHTON MI 5.0 1641 0
## 9 STEFANO LEE ON 5.0 1411 0
## 10 ANVIT RAO MI 5.0 1365 0
## 11 CAMERON WILLIAM MC LEMAN MI 4.5 1712 0
## 12 KENNETH J TACK MI 4.5 1663 0
## 13 TORRANCE HENRY JR MI 4.5 1666 0
## 14 BRADLEY SHAW MI 4.5 1610 0
## 15 ZACHARY JAMES HOUGHTON MI 4.5 1220 0
## 16 MIKE NIKITIN MI 4.0 1604 0
## 17 RONALD GRZEGORCZYK MI 4.0 1629 0
## 18 DAVID SUNDEEN MI 4.0 1600 0
## 19 DIPANKAR ROY MI 4.0 1564 0
## 20 JASON ZHENG MI 4.0 1595 0
## 21 DINH DANG BUI ON 4.0 1563 0
## 22 EUGENE L MCCLURE MI 4.0 1555 0
## 23 ALAN BUI ON 4.0 1363 0
## 24 MICHAEL R ALDRICH MI 4.0 1229 0
## 25 LOREN SCHWIEBERT MI 3.5 1745 0
## 26 MAX ZHU ON 3.5 1579 0
## 27 GAURAV GIDWANI MI 3.5 1552 0
## 28 SOFIA ADINA STANESCU-BELLU MI 3.5 1507 0
## 29 CHIEDOZIE OKORIE MI 3.5 1602 0
## 30 GEORGE AVERY JONES ON 3.5 1522 0
## 31 RISHI SHETTY MI 3.5 1494 0
## 32 JOSHUA PHILIP MATHEWS ON 3.5 1441 0
## 33 JADE GE MI 3.5 1449 0
## 34 MICHAEL JEFFERY THOMAS MI 3.5 1399 0
## 35 JOSHUA DAVID LEE MI 3.5 1438 0
## 36 SIDDHARTH JHA MI 3.5 1355 0
## 37 AMIYATOSH PWNANANDAM MI 3.5 980 0
## 38 BRIAN LIU MI 3.0 1423 0
## 39 JOEL R HENDON MI 3.0 1436 0
## 40 FOREST ZHANG MI 3.0 1348 0
## 41 KYLE WILLIAM MURPHY MI 3.0 1403 0
## 42 JARED GE MI 3.0 1332 0
## 43 ROBERT GLEN VASEY MI 3.0 1283 0
## 44 JUSTIN D SCHILLING MI 3.0 1199 0
## 45 DEREK YAN MI 3.0 1242 0
## 46 JACOB ALEXANDER LAVALLEY MI 3.0 377 0
## 47 ERIC WRIGHT MI 2.5 1362 0
## 48 DANIEL KHAIN MI 2.5 1382 0
## 49 MICHAEL J MARTIN MI 2.5 1291 0
## 50 SHIVAM JHA MI 2.5 1056 0
## 51 TEJAS AYYAGARI MI 2.5 1011 0
## 52 ETHAN GUO MI 2.5 935 0
## 53 JOSE C YBARRA MI 2.0 1393 0
## 54 LARRY HODGE MI 2.0 1270 0
## 55 ALEX KONG MI 2.0 1186 0
## 56 MARISA RICCI MI 2.0 1153 0
## 57 MICHAEL LU MI 2.0 1092 0
## 58 VIRAJ MOHILE MI 2.0 917 0
## 59 SEAN M MC CORMICK MI 2.0 853 0
## 60 JULIA SHEN MI 1.5 967 0
## 61 JEZZEL FARKAS ON 1.5 955 0
## 62 ASHWIN BALAJI MI 1.0 1530 0
## 63 THOMAS JOSEPH HOSMER MI 1.0 1175 0
## 64 BEN LI MI 1.0 1163 0Now we need the value for only one of the columns.
ratings <- data.frame(playnum = str_trim(output$V1[c(TRUE, FALSE, FALSE)]), rate = df$Rating, R1 = as.numeric(str_extract(output$V4[c(TRUE, FALSE, FALSE)], "[:digit:]+")), R2 = as.numeric(str_extract(output$V5[c(TRUE, FALSE, FALSE)], "[:digit:]+")), R3 = as.numeric(str_extract(output$V6[c(TRUE, FALSE, FALSE)], "[:digit:]+")), R4 = as.numeric(str_extract(output$V7[c(TRUE, FALSE, FALSE)], "[:digit:]+")), R5 = as.numeric(str_extract(output$V8[c(TRUE, FALSE, FALSE)], "[:digit:]+")), R6 = as.numeric(str_extract(output$V9[c(TRUE, FALSE, FALSE)], "[:digit:]+")), R7 = as.numeric(str_extract(output$V10[c(TRUE, FALSE, FALSE)], "[:digit:]+")), rateAvg = numeric(64))
ratings## playnum rate R1 R2 R3 R4 R5 R6 R7 rateAvg
## 1 1 1794 39 21 18 14 7 12 4 0
## 2 2 1553 63 58 4 17 16 20 7 0
## 3 3 1384 8 61 25 21 11 13 12 0
## 4 4 1716 23 28 2 26 5 19 1 0
## 5 5 1655 45 37 12 13 4 14 17 0
## 6 6 1686 34 29 11 35 10 27 21 0
## 7 7 1649 57 46 13 11 1 9 2 0
## 8 8 1641 3 32 14 9 47 28 19 0
## 9 9 1411 25 18 59 8 26 7 20 0
## 10 10 1365 16 19 55 31 6 25 18 0
## 11 11 1712 38 56 6 7 3 34 26 0
## 12 12 1663 42 33 5 38 NA 1 3 0
## 13 13 1666 36 27 7 5 33 3 32 0
## 14 14 1610 54 44 8 1 27 5 31 0
## 15 15 1220 19 16 30 22 54 33 38 0
## 16 16 1604 10 15 NA 39 2 36 NA 0
## 17 17 1629 48 41 26 2 23 22 5 0
## 18 18 1600 47 9 1 32 19 38 10 0
## 19 19 1564 15 10 52 28 18 4 8 0
## 20 20 1595 40 49 23 41 28 2 9 0
## 21 21 1563 43 1 47 3 40 39 6 0
## 22 22 1555 64 52 28 15 NA 17 40 0
## 23 23 1363 4 43 20 58 17 37 46 0
## 24 24 1229 28 47 43 25 60 44 39 0
## 25 25 1745 9 53 3 24 34 10 47 0
## 26 26 1579 49 40 17 4 9 32 11 0
## 27 27 1552 51 13 46 37 14 6 NA 0
## 28 28 1507 24 4 22 19 20 8 36 0
## 29 29 1602 50 6 38 34 52 48 NA 0
## 30 30 1522 52 64 15 55 31 61 50 0
## 31 31 1494 58 55 64 10 30 50 14 0
## 32 32 1441 61 8 44 18 51 26 13 0
## 33 33 1449 60 12 50 36 13 15 51 0
## 34 34 1399 6 60 37 29 25 11 52 0
## 35 35 1438 46 38 56 6 57 52 48 0
## 36 36 1355 13 57 51 33 NA 16 28 0
## 37 37 980 NA 5 34 27 NA 23 61 0
## 38 38 1423 11 35 29 12 NA 18 15 0
## 39 39 1436 1 54 40 16 44 21 24 0
## 40 40 1348 20 26 39 59 21 56 22 0
## 41 41 1403 59 17 58 20 NA NA NA 0
## 42 42 1332 12 50 57 60 61 64 56 0
## 43 43 1283 21 23 24 63 59 46 55 0
## 44 44 1199 NA 14 32 53 39 24 59 0
## 45 45 1242 5 51 60 56 63 55 58 0
## 46 46 377 35 7 27 50 64 43 23 0
## 47 47 1362 18 24 21 61 8 51 25 0
## 48 48 1382 17 63 NA 52 NA 29 35 0
## 49 49 1291 26 20 63 64 58 NA NA 0
## 50 50 1056 29 42 33 46 NA 31 30 0
## 51 51 1011 27 45 36 57 32 47 33 0
## 52 52 935 30 22 19 48 29 35 34 0
## 53 53 1393 NA 25 NA 44 NA 57 NA 0
## 54 54 1270 14 39 61 NA 15 59 64 0
## 55 55 1186 62 31 10 30 NA 45 43 0
## 56 56 1153 NA 11 35 45 NA 40 42 0
## 57 57 1092 7 36 42 51 35 53 NA 0
## 58 58 917 31 2 41 23 49 NA 45 0
## 59 59 853 41 NA 9 40 43 54 44 0
## 60 60 967 33 34 45 42 24 NA NA 0
## 61 61 955 32 3 54 47 42 30 37 0
## 62 62 1530 55 NA NA NA NA NA NA 0
## 63 63 1175 2 48 49 43 45 NA NA 0
## 64 64 1163 22 30 31 49 46 42 54 0Now we will be converting the player number with their pre-ranking number.
for (i in 1:64) {
ratings$R1[i] <- ratings$rate[ratings$R1[i]]
ratings$R2[i] <- ratings$rate[ratings$R2[i]]
ratings$R3[i] <- ratings$rate[ratings$R3[i]]
ratings$R4[i] <- ratings$rate[ratings$R4[i]]
ratings$R5[i] <- ratings$rate[ratings$R5[i]]
ratings$R6[i] <- ratings$rate[ratings$R6[i]]
ratings$R7[i] <- ratings$rate[ratings$R7[i]]
}
ratings## playnum rate R1 R2 R3 R4 R5 R6 R7 rateAvg
## 1 1 1794 1436 1563 1600 1610 1649 1663 1716 0
## 2 2 1553 1175 917 1716 1629 1604 1595 1649 0
## 3 3 1384 1641 955 1745 1563 1712 1666 1663 0
## 4 4 1716 1363 1507 1553 1579 1655 1564 1794 0
## 5 5 1655 1242 980 1663 1666 1716 1610 1629 0
## 6 6 1686 1399 1602 1712 1438 1365 1552 1563 0
## 7 7 1649 1092 377 1666 1712 1794 1411 1553 0
## 8 8 1641 1384 1441 1610 1411 1362 1507 1564 0
## 9 9 1411 1745 1600 853 1641 1579 1649 1595 0
## 10 10 1365 1604 1564 1186 1494 1686 1745 1600 0
## 11 11 1712 1423 1153 1686 1649 1384 1399 1579 0
## 12 12 1663 1332 1449 1655 1423 NA 1794 1384 0
## 13 13 1666 1355 1552 1649 1655 1449 1384 1441 0
## 14 14 1610 1270 1199 1641 1794 1552 1655 1494 0
## 15 15 1220 1564 1604 1522 1555 1270 1449 1423 0
## 16 16 1604 1365 1220 NA 1436 1553 1355 NA 0
## 17 17 1629 1382 1403 1579 1553 1363 1555 1655 0
## 18 18 1600 1362 1411 1794 1441 1564 1423 1365 0
## 19 19 1564 1220 1365 935 1507 1600 1716 1641 0
## 20 20 1595 1348 1291 1363 1403 1507 1553 1411 0
## 21 21 1563 1283 1794 1362 1384 1348 1436 1686 0
## 22 22 1555 1163 935 1507 1220 NA 1629 1348 0
## 23 23 1363 1716 1283 1595 917 1629 980 377 0
## 24 24 1229 1507 1362 1283 1745 967 1199 1436 0
## 25 25 1745 1411 1393 1384 1229 1399 1365 1362 0
## 26 26 1579 1291 1348 1629 1716 1411 1441 1712 0
## 27 27 1552 1011 1666 377 980 1610 1686 NA 0
## 28 28 1507 1229 1716 1555 1564 1595 1641 1355 0
## 29 29 1602 1056 1686 1423 1399 935 1382 NA 0
## 30 30 1522 935 1163 1220 1186 1494 955 1056 0
## 31 31 1494 917 1186 1163 1365 1522 1056 1610 0
## 32 32 1441 955 1641 1199 1600 1011 1579 1666 0
## 33 33 1449 967 1663 1056 1355 1666 1220 1011 0
## 34 34 1399 1686 967 980 1602 1745 1712 935 0
## 35 35 1438 377 1423 1153 1686 1092 935 1382 0
## 36 36 1355 1666 1092 1011 1449 NA 1604 1507 0
## 37 37 980 NA 1655 1399 1552 NA 1363 955 0
## 38 38 1423 1712 1438 1602 1663 NA 1600 1220 0
## 39 39 1436 1794 1270 1348 1604 1199 1563 1229 0
## 40 40 1348 1595 1579 1436 853 1563 1153 1555 0
## 41 41 1403 853 1629 917 1595 NA NA NA 0
## 42 42 1332 1663 1056 1092 967 955 1163 1153 0
## 43 43 1283 1563 1363 1229 1175 853 377 1186 0
## 44 44 1199 NA 1610 1441 1393 1436 1229 853 0
## 45 45 1242 1655 1011 967 1153 1175 1186 917 0
## 46 46 377 1438 1649 1552 1056 1163 1283 1363 0
## 47 47 1362 1600 1229 1563 955 1641 1011 1745 0
## 48 48 1382 1629 1175 NA 935 NA 1602 1438 0
## 49 49 1291 1579 1595 1175 1163 917 NA NA 0
## 50 50 1056 1602 1332 1449 377 NA 1494 1522 0
## 51 51 1011 1552 1242 1355 1092 1441 1362 1449 0
## 52 52 935 1522 1555 1564 1382 1602 1438 1399 0
## 53 53 1393 NA 1745 NA 1199 NA 1092 NA 0
## 54 54 1270 1610 1436 955 NA 1220 853 1163 0
## 55 55 1186 1530 1494 1365 1522 NA 1242 1283 0
## 56 56 1153 NA 1712 1438 1242 NA 1348 1332 0
## 57 57 1092 1649 1355 1332 1011 1438 1393 NA 0
## 58 58 917 1494 1553 1403 1363 1291 NA 1242 0
## 59 59 853 1403 NA 1411 1348 1283 1270 1199 0
## 60 60 967 1449 1399 1242 1332 1229 NA NA 0
## 61 61 955 1441 1384 1270 1362 1332 1522 980 0
## 62 62 1530 1186 NA NA NA NA NA NA 0
## 63 63 1175 1553 1382 1291 1283 1242 NA NA 0
## 64 64 1163 1555 1522 1494 1291 377 1332 1270 0To get the last value we need to average the rankings
for (i in 1:64) {
ratings$rateAvg[i] <- rowMeans(ratings[i, 3:9], na.rm = TRUE)
}
ratings## playnum rate R1 R2 R3 R4 R5 R6 R7 rateAvg
## 1 1 1794 1436 1563 1600 1610 1649 1663 1716 1605.286
## 2 2 1553 1175 917 1716 1629 1604 1595 1649 1469.286
## 3 3 1384 1641 955 1745 1563 1712 1666 1663 1563.571
## 4 4 1716 1363 1507 1553 1579 1655 1564 1794 1573.571
## 5 5 1655 1242 980 1663 1666 1716 1610 1629 1500.857
## 6 6 1686 1399 1602 1712 1438 1365 1552 1563 1518.714
## 7 7 1649 1092 377 1666 1712 1794 1411 1553 1372.143
## 8 8 1641 1384 1441 1610 1411 1362 1507 1564 1468.429
## 9 9 1411 1745 1600 853 1641 1579 1649 1595 1523.143
## 10 10 1365 1604 1564 1186 1494 1686 1745 1600 1554.143
## 11 11 1712 1423 1153 1686 1649 1384 1399 1579 1467.571
## 12 12 1663 1332 1449 1655 1423 NA 1794 1384 1506.167
## 13 13 1666 1355 1552 1649 1655 1449 1384 1441 1497.857
## 14 14 1610 1270 1199 1641 1794 1552 1655 1494 1515.000
## 15 15 1220 1564 1604 1522 1555 1270 1449 1423 1483.857
## 16 16 1604 1365 1220 NA 1436 1553 1355 NA 1385.800
## 17 17 1629 1382 1403 1579 1553 1363 1555 1655 1498.571
## 18 18 1600 1362 1411 1794 1441 1564 1423 1365 1480.000
## 19 19 1564 1220 1365 935 1507 1600 1716 1641 1426.286
## 20 20 1595 1348 1291 1363 1403 1507 1553 1411 1410.857
## 21 21 1563 1283 1794 1362 1384 1348 1436 1686 1470.429
## 22 22 1555 1163 935 1507 1220 NA 1629 1348 1300.333
## 23 23 1363 1716 1283 1595 917 1629 980 377 1213.857
## 24 24 1229 1507 1362 1283 1745 967 1199 1436 1357.000
## 25 25 1745 1411 1393 1384 1229 1399 1365 1362 1363.286
## 26 26 1579 1291 1348 1629 1716 1411 1441 1712 1506.857
## 27 27 1552 1011 1666 377 980 1610 1686 NA 1221.667
## 28 28 1507 1229 1716 1555 1564 1595 1641 1355 1522.143
## 29 29 1602 1056 1686 1423 1399 935 1382 NA 1313.500
## 30 30 1522 935 1163 1220 1186 1494 955 1056 1144.143
## 31 31 1494 917 1186 1163 1365 1522 1056 1610 1259.857
## 32 32 1441 955 1641 1199 1600 1011 1579 1666 1378.714
## 33 33 1449 967 1663 1056 1355 1666 1220 1011 1276.857
## 34 34 1399 1686 967 980 1602 1745 1712 935 1375.286
## 35 35 1438 377 1423 1153 1686 1092 935 1382 1149.714
## 36 36 1355 1666 1092 1011 1449 NA 1604 1507 1388.167
## 37 37 980 NA 1655 1399 1552 NA 1363 955 1384.800
## 38 38 1423 1712 1438 1602 1663 NA 1600 1220 1539.167
## 39 39 1436 1794 1270 1348 1604 1199 1563 1229 1429.571
## 40 40 1348 1595 1579 1436 853 1563 1153 1555 1390.571
## 41 41 1403 853 1629 917 1595 NA NA NA 1248.500
## 42 42 1332 1663 1056 1092 967 955 1163 1153 1149.857
## 43 43 1283 1563 1363 1229 1175 853 377 1186 1106.571
## 44 44 1199 NA 1610 1441 1393 1436 1229 853 1327.000
## 45 45 1242 1655 1011 967 1153 1175 1186 917 1152.000
## 46 46 377 1438 1649 1552 1056 1163 1283 1363 1357.714
## 47 47 1362 1600 1229 1563 955 1641 1011 1745 1392.000
## 48 48 1382 1629 1175 NA 935 NA 1602 1438 1355.800
## 49 49 1291 1579 1595 1175 1163 917 NA NA 1285.800
## 50 50 1056 1602 1332 1449 377 NA 1494 1522 1296.000
## 51 51 1011 1552 1242 1355 1092 1441 1362 1449 1356.143
## 52 52 935 1522 1555 1564 1382 1602 1438 1399 1494.571
## 53 53 1393 NA 1745 NA 1199 NA 1092 NA 1345.333
## 54 54 1270 1610 1436 955 NA 1220 853 1163 1206.167
## 55 55 1186 1530 1494 1365 1522 NA 1242 1283 1406.000
## 56 56 1153 NA 1712 1438 1242 NA 1348 1332 1414.400
## 57 57 1092 1649 1355 1332 1011 1438 1393 NA 1363.000
## 58 58 917 1494 1553 1403 1363 1291 NA 1242 1391.000
## 59 59 853 1403 NA 1411 1348 1283 1270 1199 1319.000
## 60 60 967 1449 1399 1242 1332 1229 NA NA 1330.200
## 61 61 955 1441 1384 1270 1362 1332 1522 980 1327.286
## 62 62 1530 1186 NA NA NA NA NA NA 1186.000
## 63 63 1175 1553 1382 1291 1283 1242 NA NA 1350.200
## 64 64 1163 1555 1522 1494 1291 377 1332 1270 1263.000It seems like we have done a good judgement to our data.
df$Opponents <- round(ratings$rateAvg, digits = 0)
df## Name State Points Rating Opponents
## 1 GARY HUA ON 6.0 1794 1605
## 2 DAKSHESH DARURI MI 6.0 1553 1469
## 3 ADITYA BAJAJ MI 6.0 1384 1564
## 4 PATRICK H SCHILLING MI 5.5 1716 1574
## 5 HANSHI ZUO MI 5.5 1655 1501
## 6 HANSEN SONG OH 5.0 1686 1519
## 7 GARY DEE SWATHELL MI 5.0 1649 1372
## 8 EZEKIEL HOUGHTON MI 5.0 1641 1468
## 9 STEFANO LEE ON 5.0 1411 1523
## 10 ANVIT RAO MI 5.0 1365 1554
## 11 CAMERON WILLIAM MC LEMAN MI 4.5 1712 1468
## 12 KENNETH J TACK MI 4.5 1663 1506
## 13 TORRANCE HENRY JR MI 4.5 1666 1498
## 14 BRADLEY SHAW MI 4.5 1610 1515
## 15 ZACHARY JAMES HOUGHTON MI 4.5 1220 1484
## 16 MIKE NIKITIN MI 4.0 1604 1386
## 17 RONALD GRZEGORCZYK MI 4.0 1629 1499
## 18 DAVID SUNDEEN MI 4.0 1600 1480
## 19 DIPANKAR ROY MI 4.0 1564 1426
## 20 JASON ZHENG MI 4.0 1595 1411
## 21 DINH DANG BUI ON 4.0 1563 1470
## 22 EUGENE L MCCLURE MI 4.0 1555 1300
## 23 ALAN BUI ON 4.0 1363 1214
## 24 MICHAEL R ALDRICH MI 4.0 1229 1357
## 25 LOREN SCHWIEBERT MI 3.5 1745 1363
## 26 MAX ZHU ON 3.5 1579 1507
## 27 GAURAV GIDWANI MI 3.5 1552 1222
## 28 SOFIA ADINA STANESCU-BELLU MI 3.5 1507 1522
## 29 CHIEDOZIE OKORIE MI 3.5 1602 1314
## 30 GEORGE AVERY JONES ON 3.5 1522 1144
## 31 RISHI SHETTY MI 3.5 1494 1260
## 32 JOSHUA PHILIP MATHEWS ON 3.5 1441 1379
## 33 JADE GE MI 3.5 1449 1277
## 34 MICHAEL JEFFERY THOMAS MI 3.5 1399 1375
## 35 JOSHUA DAVID LEE MI 3.5 1438 1150
## 36 SIDDHARTH JHA MI 3.5 1355 1388
## 37 AMIYATOSH PWNANANDAM MI 3.5 980 1385
## 38 BRIAN LIU MI 3.0 1423 1539
## 39 JOEL R HENDON MI 3.0 1436 1430
## 40 FOREST ZHANG MI 3.0 1348 1391
## 41 KYLE WILLIAM MURPHY MI 3.0 1403 1248
## 42 JARED GE MI 3.0 1332 1150
## 43 ROBERT GLEN VASEY MI 3.0 1283 1107
## 44 JUSTIN D SCHILLING MI 3.0 1199 1327
## 45 DEREK YAN MI 3.0 1242 1152
## 46 JACOB ALEXANDER LAVALLEY MI 3.0 377 1358
## 47 ERIC WRIGHT MI 2.5 1362 1392
## 48 DANIEL KHAIN MI 2.5 1382 1356
## 49 MICHAEL J MARTIN MI 2.5 1291 1286
## 50 SHIVAM JHA MI 2.5 1056 1296
## 51 TEJAS AYYAGARI MI 2.5 1011 1356
## 52 ETHAN GUO MI 2.5 935 1495
## 53 JOSE C YBARRA MI 2.0 1393 1345
## 54 LARRY HODGE MI 2.0 1270 1206
## 55 ALEX KONG MI 2.0 1186 1406
## 56 MARISA RICCI MI 2.0 1153 1414
## 57 MICHAEL LU MI 2.0 1092 1363
## 58 VIRAJ MOHILE MI 2.0 917 1391
## 59 SEAN M MC CORMICK MI 2.0 853 1319
## 60 JULIA SHEN MI 1.5 967 1330
## 61 JEZZEL FARKAS ON 1.5 955 1327
## 62 ASHWIN BALAJI MI 1.0 1530 1186
## 63 THOMAS JOSEPH HOSMER MI 1.0 1175 1350
## 64 BEN LI MI 1.0 1163 1263To output our csv file to github (I think github doesn’t support writing from the Rstudio yet or may be I don’t know how to do it. I searched google, stackflow and youtube videos also but couldn’t do it. I will upload the tournamentoutput.txt file to github later and put the link on the Project1 link.)
write.csv(df, file = "C:/Users/world/Desktop/CUNYSPS/Fall2018/Data607/Project1/tournamentoutput.txt")