library(tidyverse)
## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.3.6 ✔ purrr 0.3.4
## ✔ tibble 3.1.7 ✔ dplyr 1.0.9
## ✔ tidyr 1.2.0 ✔ stringr 1.4.0
## ✔ readr 2.1.2 ✔ forcats 0.5.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
library(knitr)
library(stringr)
library(tidyr)
chess_data <- read.delim("https://raw.githubusercontent.com/karmaggyatso/CUNY_SPS/main/Github_data607/project1/tournamentinfo.txt", header = FALSE, stringsAsFactors = FALSE)
head(chess_data, n = 80)
## 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|
split_data <- data.frame(str_replace_all(chess_data$V1,"-",""))
head(split_data)
## str_replace_all.chess_data.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 |
split_data <- data.frame(split_data[!apply(split_data == "", 1, all),])
head(split_data)
## split_data..apply.split_data........1..all....
## 1 Pair | Player Name |Total|Round|Round|Round|Round|Round|Round|Round|
## 2 Num | USCF ID / Rtg (Pre>Post) | Pts | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
## 3 1 | GARY HUA |6.0 |W 39|W 21|W 18|W 14|W 7|D 12|D 4|
## 4 ON | 15445895 / R: 1794 >1817 |N:2 |W |B |W |B |W |B |W |
## 5 2 | DAKSHESH DARURI |6.0 |W 63|W 58|L 4|W 17|W 16|W 20|W 7|
## 6 MI | 14598900 / R: 1553 >1663 |N:2 |B |W |B |W |B |W |B |
temp_table <- data.frame(c())
for (i in 1:dim(split_data)[1]){
if (i %% 2 == 1) {
Part1 <- rbind(temp_table$Part1, as.character(split_data[i,1]))
Part2 <- as.character(split_data[i+1,1])
Combined <- data.frame(paste0(Part1, Part2))
names(Combined) <- "Combined"
temp_table <- rbind(temp_table, Combined)
}
}
head(temp_table)
## Combined
## 1 Pair | Player Name |Total|Round|Round|Round|Round|Round|Round|Round| Num | USCF ID / Rtg (Pre>Post) | Pts | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
## 2 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 |
## 3 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 |
## 4 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 |
## 5 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 |
## 6 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 |
Headers <- c("Pair","Player Name","Total","Round 1","Round 2","Round 3", "Round 4","Round 5","Round 6","Round 7","State","USCF ID / Rtg (Pre->Post)","Pts","1","2","3","4","5","6","7","Ave Pre Rating")
newer_table <- separate(data = temp_table, col = Combined, into = Headers, sep = "\\|")
# Need to clear row containing all columns names
newer_table <- newer_table[-c(1), ]
head(newer_table)
## Pair Player Name Total Round 1 Round 2 Round 3
## 2 1 GARY HUA 6.0 W 39 W 21 W 18
## 3 2 DAKSHESH DARURI 6.0 W 63 W 58 L 4
## 4 3 ADITYA BAJAJ 6.0 L 8 W 61 W 25
## 5 4 PATRICK H SCHILLING 5.5 W 23 D 28 W 2
## 6 5 HANSHI ZUO 5.5 W 45 W 37 D 12
## 7 6 HANSEN SONG 5.0 W 34 D 29 L 11
## Round 4 Round 5 Round 6 Round 7 State USCF ID / Rtg (Pre->Post) Pts
## 2 W 14 W 7 D 12 D 4 ON 15445895 / R: 1794 >1817 N:2
## 3 W 17 W 16 W 20 W 7 MI 14598900 / R: 1553 >1663 N:2
## 4 W 21 W 11 W 13 W 12 MI 14959604 / R: 1384 >1640 N:2
## 5 W 26 D 5 W 19 D 1 MI 12616049 / R: 1716 >1744 N:2
## 6 D 13 D 4 W 14 W 17 MI 14601533 / R: 1655 >1690 N:2
## 7 W 35 D 10 W 27 W 21 OH 15055204 / R: 1686 >1687 N:3
## 1 2 3 4 5 6 7 Ave Pre Rating
## 2 W B W B W B W
## 3 B W B W B W B
## 4 W B W B W B W
## 5 W B W B W B B
## 6 B W B W B W B
## 7 W B W B B W B
temp <- str_extract_all(newer_table$`USCF ID / Rtg (Pre->Post)`,"\\b\\d{1,}")
temp <- data.frame(as.character(temp))
# Separating the data frame from one couln to three different columns
temp <- separate(data = temp, col = as.character.temp., into = c("col1","col2","col3"), sep = ",")
kable(head(temp))
| c(“15445895” |
“1794” |
“1817”) |
| c(“14598900” |
“1553” |
“1663”) |
| c(“14959604” |
“1384” |
“1640”) |
| c(“12616049” |
“1716” |
“1744”) |
| c(“14601533” |
“1655” |
“1690”) |
| c(“15055204” |
“1686” |
“1687”) |
temp$col1
## [1] "c(\"15445895\"" "c(\"14598900\"" "c(\"14959604\"" "c(\"12616049\""
## [5] "c(\"14601533\"" "c(\"15055204\"" "c(\"11146376\"" "c(\"15142253\""
## [9] "c(\"14954524\"" "c(\"14150362\"" "c(\"12581589\"" "c(\"12681257\""
## [13] "c(\"15082995\"" "c(\"10131499\"" "c(\"15619130\"" "c(\"10295068\""
## [17] "c(\"10297702\"" "c(\"11342094\"" "c(\"14862333\"" "c(\"14529060\""
## [21] "c(\"15495066\"" "c(\"12405534\"" "c(\"15030142\"" "c(\"13469010\""
## [25] "c(\"12486656\"" "c(\"15131520\"" "c(\"14476567\"" "c(\"14882954\""
## [29] "c(\"15323285\"" "c(\"12577178\"" "c(\"15131618\"" "c(\"14073750\""
## [33] "c(\"14691842\"" "c(\"15051807\"" "c(\"14601397\"" "c(\"14773163\""
## [37] "c(\"15489571\"" "c(\"15108523\"" "c(\"12923035\"" "c(\"14892710\""
## [41] "c(\"15761443\"" "c(\"14462326\"" "c(\"14101068\"" "c(\"15323504\""
## [45] "c(\"15372807\"" "c(\"15490981\"" "c(\"12533115\"" "c(\"14369165\""
## [49] "c(\"12531685\"" "c(\"14773178\"" "c(\"15205474\"" "c(\"14918803\""
## [53] "c(\"12578849\"" "c(\"12836773\"" "c(\"15412571\"" "c(\"14679887\""
## [57] "c(\"15113330\"" "c(\"14700365\"" "c(\"12841036\"" "c(\"14579262\""
## [61] "c(\"15771592\"" "c(\"15219542\"" "c(\"15057092\"" "c(\"15006561\""
col1 <- str_extract_all(temp$col1,"[[:digit:]]{1,}")
col2 <- str_extract_all(temp$col2,"[[:digit:]]{1,}")
col3 <- str_extract_all(temp$col3,"[[:digit:]]{1,}")
newer_table$`USCF ID` <- as.character(col1)
newer_table$`Pre Rating` <- as.character(col2)
newer_table$`Post Rating` <- as.character(col3)
head(newer_table)
## Pair Player Name Total Round 1 Round 2 Round 3
## 2 1 GARY HUA 6.0 W 39 W 21 W 18
## 3 2 DAKSHESH DARURI 6.0 W 63 W 58 L 4
## 4 3 ADITYA BAJAJ 6.0 L 8 W 61 W 25
## 5 4 PATRICK H SCHILLING 5.5 W 23 D 28 W 2
## 6 5 HANSHI ZUO 5.5 W 45 W 37 D 12
## 7 6 HANSEN SONG 5.0 W 34 D 29 L 11
## Round 4 Round 5 Round 6 Round 7 State USCF ID / Rtg (Pre->Post) Pts
## 2 W 14 W 7 D 12 D 4 ON 15445895 / R: 1794 >1817 N:2
## 3 W 17 W 16 W 20 W 7 MI 14598900 / R: 1553 >1663 N:2
## 4 W 21 W 11 W 13 W 12 MI 14959604 / R: 1384 >1640 N:2
## 5 W 26 D 5 W 19 D 1 MI 12616049 / R: 1716 >1744 N:2
## 6 D 13 D 4 W 14 W 17 MI 14601533 / R: 1655 >1690 N:2
## 7 W 35 D 10 W 27 W 21 OH 15055204 / R: 1686 >1687 N:3
## 1 2 3 4 5 6 7 Ave Pre Rating USCF ID Pre Rating
## 2 W B W B W B W 15445895 1794
## 3 B W B W B W B 14598900 1553
## 4 W B W B W B W 14959604 1384
## 5 W B W B W B B 12616049 1716
## 6 B W B W B W B 14601533 1655
## 7 W B W B B W B 15055204 1686
## Post Rating
## 2 1817
## 3 1663
## 4 1640
## 5 1744
## 6 1690
## 7 1687
csv.table <- subset(newer_table, select = c(1,2,3,4,5,6,7,8,9,10, 11, 21, 22, 23,24, 13, 14))
kable(head(csv.table))
| 2 |
1 |
GARY HUA |
6.0 |
W 39 |
W 21 |
W 18 |
W 14 |
W 7 |
D 12 |
D 4 |
ON |
|
15445895 |
1794 |
1817 |
N:2 |
W |
| 3 |
2 |
DAKSHESH DARURI |
6.0 |
W 63 |
W 58 |
L 4 |
W 17 |
W 16 |
W 20 |
W 7 |
MI |
|
14598900 |
1553 |
1663 |
N:2 |
B |
| 4 |
3 |
ADITYA BAJAJ |
6.0 |
L 8 |
W 61 |
W 25 |
W 21 |
W 11 |
W 13 |
W 12 |
MI |
|
14959604 |
1384 |
1640 |
N:2 |
W |
| 5 |
4 |
PATRICK H SCHILLING |
5.5 |
W 23 |
D 28 |
W 2 |
W 26 |
D 5 |
W 19 |
D 1 |
MI |
|
12616049 |
1716 |
1744 |
N:2 |
W |
| 6 |
5 |
HANSHI ZUO |
5.5 |
W 45 |
W 37 |
D 12 |
D 13 |
D 4 |
W 14 |
W 17 |
MI |
|
14601533 |
1655 |
1690 |
N:2 |
B |
| 7 |
6 |
HANSEN SONG |
5.0 |
W 34 |
D 29 |
L 11 |
W 35 |
D 10 |
W 27 |
W 21 |
OH |
|
15055204 |
1686 |
1687 |
N:3 |
W |
kable(csv.table, row.names = FALSE)
| 1 |
GARY HUA |
6.0 |
W 39 |
W 21 |
W 18 |
W 14 |
W 7 |
D 12 |
D 4 |
ON |
|
15445895 |
1794 |
1817 |
N:2 |
W |
| 2 |
DAKSHESH DARURI |
6.0 |
W 63 |
W 58 |
L 4 |
W 17 |
W 16 |
W 20 |
W 7 |
MI |
|
14598900 |
1553 |
1663 |
N:2 |
B |
| 3 |
ADITYA BAJAJ |
6.0 |
L 8 |
W 61 |
W 25 |
W 21 |
W 11 |
W 13 |
W 12 |
MI |
|
14959604 |
1384 |
1640 |
N:2 |
W |
| 4 |
PATRICK H SCHILLING |
5.5 |
W 23 |
D 28 |
W 2 |
W 26 |
D 5 |
W 19 |
D 1 |
MI |
|
12616049 |
1716 |
1744 |
N:2 |
W |
| 5 |
HANSHI ZUO |
5.5 |
W 45 |
W 37 |
D 12 |
D 13 |
D 4 |
W 14 |
W 17 |
MI |
|
14601533 |
1655 |
1690 |
N:2 |
B |
| 6 |
HANSEN SONG |
5.0 |
W 34 |
D 29 |
L 11 |
W 35 |
D 10 |
W 27 |
W 21 |
OH |
|
15055204 |
1686 |
1687 |
N:3 |
W |
| 7 |
GARY DEE SWATHELL |
5.0 |
W 57 |
W 46 |
W 13 |
W 11 |
L 1 |
W 9 |
L 2 |
MI |
|
11146376 |
1649 |
1673 |
N:3 |
W |
| 8 |
EZEKIEL HOUGHTON |
5.0 |
W 3 |
W 32 |
L 14 |
L 9 |
W 47 |
W 28 |
W 19 |
MI |
|
15142253 |
1641 |
1657 |
N:3 |
B |
| 9 |
STEFANO LEE |
5.0 |
W 25 |
L 18 |
W 59 |
W 8 |
W 26 |
L 7 |
W 20 |
ON |
|
14954524 |
1411 |
1564 |
N:2 |
W |
| 10 |
ANVIT RAO |
5.0 |
D 16 |
L 19 |
W 55 |
W 31 |
D 6 |
W 25 |
W 18 |
MI |
|
14150362 |
1365 |
1544 |
N:3 |
W |
| 11 |
CAMERON WILLIAM MC LEMAN |
4.5 |
D 38 |
W 56 |
W 6 |
L 7 |
L 3 |
W 34 |
W 26 |
MI |
|
12581589 |
1712 |
1696 |
N:3 |
B |
| 12 |
KENNETH J TACK |
4.5 |
W 42 |
W 33 |
D 5 |
W 38 |
H |
D 1 |
L 3 |
MI |
|
12681257 |
1663 |
1670 |
N:3 |
W |
| 13 |
TORRANCE HENRY JR |
4.5 |
W 36 |
W 27 |
L 7 |
D 5 |
W 33 |
L 3 |
W 32 |
MI |
|
15082995 |
1666 |
1662 |
N:3 |
B |
| 14 |
BRADLEY SHAW |
4.5 |
W 54 |
W 44 |
W 8 |
L 1 |
D 27 |
L 5 |
W 31 |
MI |
|
10131499 |
1610 |
1618 |
N:3 |
W |
| 15 |
ZACHARY JAMES HOUGHTON |
4.5 |
D 19 |
L 16 |
W 30 |
L 22 |
W 54 |
W 33 |
W 38 |
MI |
|
15619130 |
1220 |
1416 |
N:3 |
B |
| 16 |
MIKE NIKITIN |
4.0 |
D 10 |
W 15 |
H |
W 39 |
L 2 |
W 36 |
U |
MI |
|
10295068 |
1604 |
1613 |
N:3 |
B |
| 17 |
RONALD GRZEGORCZYK |
4.0 |
W 48 |
W 41 |
L 26 |
L 2 |
W 23 |
W 22 |
L 5 |
MI |
|
10297702 |
1629 |
1610 |
N:3 |
W |
| 18 |
DAVID SUNDEEN |
4.0 |
W 47 |
W 9 |
L 1 |
W 32 |
L 19 |
W 38 |
L 10 |
MI |
|
11342094 |
1600 |
1600 |
N:3 |
B |
| 19 |
DIPANKAR ROY |
4.0 |
D 15 |
W 10 |
W 52 |
D 28 |
W 18 |
L 4 |
L 8 |
MI |
|
14862333 |
1564 |
1570 |
N:3 |
W |
| 20 |
JASON ZHENG |
4.0 |
L 40 |
W 49 |
W 23 |
W 41 |
W 28 |
L 2 |
L 9 |
MI |
|
14529060 |
1595 |
1569 |
N:4 |
W |
| 21 |
DINH DANG BUI |
4.0 |
W 43 |
L 1 |
W 47 |
L 3 |
W 40 |
W 39 |
L 6 |
ON |
|
15495066 |
1563 |
1562 |
N:3 |
B |
| 22 |
EUGENE L MCCLURE |
4.0 |
W 64 |
D 52 |
L 28 |
W 15 |
H |
L 17 |
W 40 |
MI |
|
12405534 |
1555 |
1529 |
N:4 |
W |
| 23 |
ALAN BUI |
4.0 |
L 4 |
W 43 |
L 20 |
W 58 |
L 17 |
W 37 |
W 46 |
ON |
|
15030142 |
1363 |
1371 |
|
B |
| 24 |
MICHAEL R ALDRICH |
4.0 |
L 28 |
L 47 |
W 43 |
L 25 |
W 60 |
W 44 |
W 39 |
MI |
|
13469010 |
1229 |
1300 |
N:4 |
B |
| 25 |
LOREN SCHWIEBERT |
3.5 |
L 9 |
W 53 |
L 3 |
W 24 |
D 34 |
L 10 |
W 47 |
MI |
|
12486656 |
1745 |
1681 |
N:4 |
B |
| 26 |
MAX ZHU |
3.5 |
W 49 |
W 40 |
W 17 |
L 4 |
L 9 |
D 32 |
L 11 |
ON |
|
15131520 |
1579 |
1564 |
N:4 |
B |
| 27 |
GAURAV GIDWANI |
3.5 |
W 51 |
L 13 |
W 46 |
W 37 |
D 14 |
L 6 |
U |
MI |
|
14476567 |
1552 |
1539 |
N:4 |
W |
| 28 |
SOFIA ADINA STANESCUBELLU |
3.5 |
W 24 |
D 4 |
W 22 |
D 19 |
L 20 |
L 8 |
D 36 |
MI |
|
14882954 |
1507 |
1513 |
N:3 |
W |
| 29 |
CHIEDOZIE OKORIE |
3.5 |
W 50 |
D 6 |
L 38 |
L 34 |
W 52 |
W 48 |
U |
MI |
|
15323285 |
1602 |
1508 |
N:4 |
B |
| 30 |
GEORGE AVERY JONES |
3.5 |
L 52 |
D 64 |
L 15 |
W 55 |
L 31 |
W 61 |
W 50 |
ON |
|
12577178 |
1522 |
1444 |
|
W |
| 31 |
RISHI SHETTY |
3.5 |
L 58 |
D 55 |
W 64 |
L 10 |
W 30 |
W 50 |
L 14 |
MI |
|
15131618 |
1494 |
1444 |
|
B |
| 32 |
JOSHUA PHILIP MATHEWS |
3.5 |
W 61 |
L 8 |
W 44 |
L 18 |
W 51 |
D 26 |
L 13 |
ON |
|
14073750 |
1441 |
1433 |
N:4 |
W |
| 33 |
JADE GE |
3.5 |
W 60 |
L 12 |
W 50 |
D 36 |
L 13 |
L 15 |
W 51 |
MI |
|
14691842 |
1449 |
1421 |
|
B |
| 34 |
MICHAEL JEFFERY THOMAS |
3.5 |
L 6 |
W 60 |
L 37 |
W 29 |
D 25 |
L 11 |
W 52 |
MI |
|
15051807 |
1399 |
1400 |
|
B |
| 35 |
JOSHUA DAVID LEE |
3.5 |
L 46 |
L 38 |
W 56 |
L 6 |
W 57 |
D 52 |
W 48 |
MI |
|
14601397 |
1438 |
1392 |
|
W |
| 36 |
SIDDHARTH JHA |
3.5 |
L 13 |
W 57 |
W 51 |
D 33 |
H |
L 16 |
D 28 |
MI |
|
14773163 |
1355 |
1367 |
N:4 |
W |
| 37 |
AMIYATOSH PWNANANDAM |
3.5 |
B |
L 5 |
W 34 |
L 27 |
H |
L 23 |
W 61 |
MI |
|
15489571 |
980 |
1077 |
|
|
| 38 |
BRIAN LIU |
3.0 |
D 11 |
W 35 |
W 29 |
L 12 |
H |
L 18 |
L 15 |
MI |
|
15108523 |
1423 |
1439 |
N:4 |
W |
| 39 |
JOEL R HENDON |
3.0 |
L 1 |
W 54 |
W 40 |
L 16 |
W 44 |
L 21 |
L 24 |
MI |
|
12923035 |
1436 |
1413 |
N:4 |
B |
| 40 |
FOREST ZHANG |
3.0 |
W 20 |
L 26 |
L 39 |
W 59 |
L 21 |
W 56 |
L 22 |
MI |
|
14892710 |
1348 |
1346 |
|
B |
| 41 |
KYLE WILLIAM MURPHY |
3.0 |
W 59 |
L 17 |
W 58 |
L 20 |
X |
U |
U |
MI |
|
15761443 |
1403 |
1341 |
|
B |
| 42 |
JARED GE |
3.0 |
L 12 |
L 50 |
L 57 |
D 60 |
D 61 |
W 64 |
W 56 |
MI |
|
14462326 |
1332 |
1256 |
|
B |
| 43 |
ROBERT GLEN VASEY |
3.0 |
L 21 |
L 23 |
L 24 |
W 63 |
W 59 |
L 46 |
W 55 |
MI |
|
14101068 |
1283 |
1244 |
|
W |
| 44 |
JUSTIN D SCHILLING |
3.0 |
B |
L 14 |
L 32 |
W 53 |
L 39 |
L 24 |
W 59 |
MI |
|
15323504 |
1199 |
1199 |
|
|
| 45 |
DEREK YAN |
3.0 |
L 5 |
L 51 |
D 60 |
L 56 |
W 63 |
D 55 |
W 58 |
MI |
|
15372807 |
1242 |
1191 |
|
W |
| 46 |
JACOB ALEXANDER LAVALLEY |
3.0 |
W 35 |
L 7 |
L 27 |
L 50 |
W 64 |
W 43 |
L 23 |
MI |
|
15490981 |
377 |
1076 |
|
B |
| 47 |
ERIC WRIGHT |
2.5 |
L 18 |
W 24 |
L 21 |
W 61 |
L 8 |
D 51 |
L 25 |
MI |
|
12533115 |
1362 |
1341 |
|
W |
| 48 |
DANIEL KHAIN |
2.5 |
L 17 |
W 63 |
H |
D 52 |
H |
L 29 |
L 35 |
MI |
|
14369165 |
1382 |
1335 |
|
B |
| 49 |
MICHAEL J MARTIN |
2.5 |
L 26 |
L 20 |
D 63 |
D 64 |
W 58 |
H |
U |
MI |
|
12531685 |
1291 |
1259 |
|
W |
| 50 |
SHIVAM JHA |
2.5 |
L 29 |
W 42 |
L 33 |
W 46 |
H |
L 31 |
L 30 |
MI |
|
14773178 |
1056 |
1111 |
|
W |
| 51 |
TEJAS AYYAGARI |
2.5 |
L 27 |
W 45 |
L 36 |
W 57 |
L 32 |
D 47 |
L 33 |
MI |
|
15205474 |
1011 |
1097 |
|
B |
| 52 |
ETHAN GUO |
2.5 |
W 30 |
D 22 |
L 19 |
D 48 |
L 29 |
D 35 |
L 34 |
MI |
|
14918803 |
935 |
1092 |
N:4 |
B |
| 53 |
JOSE C YBARRA |
2.0 |
H |
L 25 |
H |
L 44 |
U |
W 57 |
U |
MI |
|
12578849 |
1393 |
1359 |
|
|
| 54 |
LARRY HODGE |
2.0 |
L 14 |
L 39 |
L 61 |
B |
L 15 |
L 59 |
W 64 |
MI |
|
12836773 |
1270 |
1200 |
|
B |
| 55 |
ALEX KONG |
2.0 |
L 62 |
D 31 |
L 10 |
L 30 |
B |
D 45 |
L 43 |
MI |
|
15412571 |
1186 |
1163 |
|
W |
| 56 |
MARISA RICCI |
2.0 |
H |
L 11 |
L 35 |
W 45 |
H |
L 40 |
L 42 |
MI |
|
14679887 |
1153 |
1140 |
|
|
| 57 |
MICHAEL LU |
2.0 |
L 7 |
L 36 |
W 42 |
L 51 |
L 35 |
L 53 |
B |
MI |
|
15113330 |
1092 |
1079 |
|
B |
| 58 |
VIRAJ MOHILE |
2.0 |
W 31 |
L 2 |
L 41 |
L 23 |
L 49 |
B |
L 45 |
MI |
|
14700365 |
917 |
941 |
|
W |
| 59 |
SEAN M MC CORMICK |
2.0 |
L 41 |
B |
L 9 |
L 40 |
L 43 |
W 54 |
L 44 |
MI |
|
12841036 |
853 |
878 |
|
W |
| 60 |
JULIA SHEN |
1.5 |
L 33 |
L 34 |
D 45 |
D 42 |
L 24 |
H |
U |
MI |
|
14579262 |
967 |
984 |
|
W |
| 61 |
JEZZEL FARKAS |
1.5 |
L 32 |
L 3 |
W 54 |
L 47 |
D 42 |
L 30 |
L 37 |
ON |
|
15771592 |
955 |
979 |
|
B |
| 62 |
ASHWIN BALAJI |
1.0 |
W 55 |
U |
U |
U |
U |
U |
U |
MI |
|
15219542 |
1530 |
1535 |
|
B |
| 63 |
THOMAS JOSEPH HOSMER |
1.0 |
L 2 |
L 48 |
D 49 |
L 43 |
L 45 |
H |
U |
MI |
|
15057092 |
1175 |
1125 |
|
W |
| 64 |
BEN LI |
1.0 |
L 22 |
D 30 |
L 31 |
D 49 |
L 46 |
L 42 |
L 54 |
MI |
|
15006561 |
1163 |
1112 |
|
B |
write.table(csv.table, file = "project1-chessTournamentInfo.csv",row.names=FALSE, na="",col.names=TRUE, sep=",")