## Warning in readLines(mySourceFile): incomplete final line found on 'C:/
## Users/Debabrata/Documents/GitHub/CUNY-Assignments/DATA 607 02[15961]/Week 4
## Assignment [Feb 18 - Feb 24]/tournamentinfo.txt'## [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] "-----------------------------------------------------------------------------------------"## [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 |"
## [7] " 3 | ADITYA BAJAJ |6.0 |L 8|W 61|W 25|W 21|W 11|W 13|W 12|"
## [8] " MI | 14959604 / R: 1384 ->1640 |N:2 |W |B |W |B |W |B |W |"
## [9] " 4 | PATRICK H SCHILLING |5.5 |W 23|D 28|W 2|W 26|D 5|W 19|D 1|"
## [10] " MI | 12616049 / R: 1716 ->1744 |N:2 |W |B |W |B |W |B |B |"## [1] "character"## Loading required package: gsubfn## Loading required package: proto## Loading required package: RSQLite## PlayerNo PlayerName TotalPoints Round1 Round2
## 1 1 GARY HUA 6.0 W 39 W 21
## 2 2 DAKSHESH DARURI 6.0 W 63 W 58
## 3 3 ADITYA BAJAJ 6.0 L 8 W 61
## 4 4 PATRICK H SCHILLING 5.5 W 23 D 28
## 5 5 HANSHI ZUO 5.5 W 45 W 37
## 6 6 HANSEN SONG 5.0 W 34 D 29
## 7 7 GARY DEE SWATHELL 5.0 W 57 W 46
## 8 8 EZEKIEL HOUGHTON 5.0 W 3 W 32
## 9 9 STEFANO LEE 5.0 W 25 L 18
## 10 10 ANVIT RAO 5.0 D 16 L 19
## 11 11 CAMERON WILLIAM MC LEMAN 4.5 D 38 W 56
## 12 12 KENNETH J TACK 4.5 W 42 W 33
## 13 13 TORRANCE HENRY JR 4.5 W 36 W 27
## 14 14 BRADLEY SHAW 4.5 W 54 W 44
## 15 15 ZACHARY JAMES HOUGHTON 4.5 D 19 L 16
## 16 16 MIKE NIKITIN 4.0 D 10 W 15
## 17 17 RONALD GRZEGORCZYK 4.0 W 48 W 41
## 18 18 DAVID SUNDEEN 4.0 W 47 W 9
## 19 19 DIPANKAR ROY 4.0 D 15 W 10
## 20 20 JASON ZHENG 4.0 L 40 W 49
## 21 21 DINH DANG BUI 4.0 W 43 L 1
## 22 22 EUGENE L MCCLURE 4.0 W 64 D 52
## 23 23 ALAN BUI 4.0 L 4 W 43
## 24 24 MICHAEL R ALDRICH 4.0 L 28 L 47
## 25 25 LOREN SCHWIEBERT 3.5 L 9 W 53
## 26 26 MAX ZHU 3.5 W 49 W 40
## 27 27 GAURAV GIDWANI 3.5 W 51 L 13
## 28 28 SOFIA ADINA STANESCU-BELLU 3.5 W 24 D 4
## 29 29 CHIEDOZIE OKORIE 3.5 W 50 D 6
## 30 30 GEORGE AVERY JONES 3.5 L 52 D 64
## 31 31 RISHI SHETTY 3.5 L 58 D 55
## 32 32 JOSHUA PHILIP MATHEWS 3.5 W 61 L 8
## 33 33 JADE GE 3.5 W 60 L 12
## 34 34 MICHAEL JEFFERY THOMAS 3.5 L 6 W 60
## 35 35 JOSHUA DAVID LEE 3.5 L 46 L 38
## 36 36 SIDDHARTH JHA 3.5 L 13 W 57
## 37 37 AMIYATOSH PWNANANDAM 3.5 B L 5
## 38 38 BRIAN LIU 3.0 D 11 W 35
## 39 39 JOEL R HENDON 3.0 L 1 W 54
## 40 40 FOREST ZHANG 3.0 W 20 L 26
## 41 41 KYLE WILLIAM MURPHY 3.0 W 59 L 17
## 42 42 JARED GE 3.0 L 12 L 50
## 43 43 ROBERT GLEN VASEY 3.0 L 21 L 23
## 44 44 JUSTIN D SCHILLING 3.0 B L 14
## 45 45 DEREK YAN 3.0 L 5 L 51
## 46 46 JACOB ALEXANDER LAVALLEY 3.0 W 35 L 7
## 47 47 ERIC WRIGHT 2.5 L 18 W 24
## 48 48 DANIEL KHAIN 2.5 L 17 W 63
## 49 49 MICHAEL J MARTIN 2.5 L 26 L 20
## 50 50 SHIVAM JHA 2.5 L 29 W 42
## 51 51 TEJAS AYYAGARI 2.5 L 27 W 45
## 52 52 ETHAN GUO 2.5 W 30 D 22
## 53 53 JOSE C YBARRA 2.0 H L 25
## 54 54 LARRY HODGE 2.0 L 14 L 39
## 55 55 ALEX KONG 2.0 L 62 D 31
## 56 56 MARISA RICCI 2.0 H L 11
## 57 57 MICHAEL LU 2.0 L 7 L 36
## 58 58 VIRAJ MOHILE 2.0 W 31 L 2
## 59 59 SEAN M MC CORMICK 2.0 L 41 B
## 60 60 JULIA SHEN 1.5 L 33 L 34
## 61 61 JEZZEL FARKAS 1.5 L 32 L 3
## 62 62 ASHWIN BALAJI 1.0 W 55 U
## 63 63 THOMAS JOSEPH HOSMER 1.0 L 2 L 48
## 64 64 BEN LI 1.0 L 22 D 30
## Round3 Round4 Round5 Round6 Round7 State USCFID PreRanking
## 1 W 18 W 14 W 7 D 12 D 4 ON 15445895 1794
## 2 L 4 W 17 W 16 W 20 W 7 MI 14598900 1553
## 3 W 25 W 21 W 11 W 13 W 12 MI 14959604 1384
## 4 W 2 W 26 D 5 W 19 D 1 MI 12616049 1716
## 5 D 12 D 13 D 4 W 14 W 17 MI 14601533 1655
## 6 L 11 W 35 D 10 W 27 W 21 OH 15055204 1686
## 7 W 13 W 11 L 1 W 9 L 2 MI 11146376 1649
## 8 L 14 L 9 W 47 W 28 W 19 MI 15142253 1641P17
## 9 W 59 W 8 W 26 L 7 W 20 ON 14954524 1411
## 10 W 55 W 31 D 6 W 25 W 18 MI 14150362 1365
## 11 W 6 L 7 L 3 W 34 W 26 MI 12581589 1712
## 12 D 5 W 38 H D 1 L 3 MI 12681257 1663
## 13 L 7 D 5 W 33 L 3 W 32 MI 15082995 1666
## 14 W 8 L 1 D 27 L 5 W 31 MI 10131499 1610
## 15 W 30 L 22 W 54 W 33 W 38 MI 15619130 1220P13
## 16 H W 39 L 2 W 36 U MI 10295068 1604
## 17 L 26 L 2 W 23 W 22 L 5 MI 10297702 1629
## 18 L 1 W 32 L 19 W 38 L 10 MI 11342094 1600
## 19 W 52 D 28 W 18 L 4 L 8 MI 14862333 1564
## 20 W 23 W 41 W 28 L 2 L 9 MI 14529060 1595
## 21 W 47 L 3 W 40 W 39 L 6 ON 15495066 1563P22
## 22 L 28 W 15 H L 17 W 40 MI 12405534 1555
## 23 L 20 W 58 L 17 W 37 W 46 ON 15030142 1363
## 24 W 43 L 25 W 60 W 44 W 39 MI 13469010 1229
## 25 L 3 W 24 D 34 L 10 W 47 MI 12486656 1745
## 26 W 17 L 4 L 9 D 32 L 11 ON 15131520 1579
## 27 W 46 W 37 D 14 L 6 U MI 14476567 1552
## 28 W 22 D 19 L 20 L 8 D 36 MI 14882954 1507
## 29 L 38 L 34 W 52 W 48 U MI 15323285 1602P6
## 30 L 15 W 55 L 31 W 61 W 50 ON 12577178 1522
## 31 W 64 L 10 W 30 W 50 L 14 MI 15131618 1494
## 32 W 44 L 18 W 51 D 26 L 13 ON 14073750 1441
## 33 W 50 D 36 L 13 L 15 W 51 MI 14691842 1449
## 34 L 37 W 29 D 25 L 11 W 52 MI 15051807 1399
## 35 W 56 L 6 W 57 D 52 W 48 MI 14601397 1438
## 36 W 51 D 33 H L 16 D 28 MI 14773163 1355
## 37 W 34 L 27 H L 23 W 61 MI 15489571 980P12
## 38 W 29 L 12 H L 18 L 15 MI 15108523 1423
## 39 W 40 L 16 W 44 L 21 L 24 MI 12923035 1436P23
## 40 L 39 W 59 L 21 W 56 L 22 MI 14892710 1348
## 41 W 58 L 20 X U U MI 15761443 1403P5
## 42 L 57 D 60 D 61 W 64 W 56 MI 14462326 1332
## 43 L 24 W 63 W 59 L 46 W 55 MI 14101068 1283
## 44 L 32 W 53 L 39 L 24 W 59 MI 15323504 1199
## 45 D 60 L 56 W 63 D 55 W 58 MI 15372807 1242
## 46 L 27 L 50 W 64 W 43 L 23 MI 15490981 377P3
## 47 L 21 W 61 L 8 D 51 L 25 MI 12533115 1362
## 48 H D 52 H L 29 L 35 MI 14369165 1382
## 49 D 63 D 64 W 58 H U MI 12531685 1291P12
## 50 L 33 W 46 H L 31 L 30 MI 14773178 1056
## 51 L 36 W 57 L 32 D 47 L 33 MI 15205474 1011
## 52 L 19 D 48 L 29 D 35 L 34 MI 14918803 935
## 53 H L 44 U W 57 U MI 12578849 1393
## 54 L 61 B L 15 L 59 W 64 MI 12836773 1270
## 55 L 10 L 30 B D 45 L 43 MI 15412571 1186
## 56 L 35 W 45 H L 40 L 42 MI 14679887 1153
## 57 W 42 L 51 L 35 L 53 B MI 15113330 1092
## 58 L 41 L 23 L 49 B L 45 MI 14700365 917
## 59 L 9 L 40 L 43 W 54 L 44 MI 12841036 853
## 60 D 45 D 42 L 24 H U MI 14579262 967
## 61 W 54 L 47 D 42 L 30 L 37 ON 15771592 955P11
## 62 U U U U U MI 15219542 1530
## 63 D 49 L 43 L 45 H U MI 15057092 1175
## 64 L 31 D 49 L 46 L 42 L 54 MI 15006561 1163
## PostRanking Points 1 2 3 4 5 6 7
## 1 1817 N:2 W B W B W B W
## 2 1663 N:2 B W B W B W B
## 3 1640 N:2 W B W B W B W
## 4 1744 N:2 W B W B W B B
## 5 1690 N:2 B W B W B W B
## 6 1687 N:3 W B W B B W B
## 7 1673 N:3 W B W B B W W
## 8 1657P24 N:3 B W B W B W W
## 9 1564 N:2 W B W B W B B
## 10 1544 N:3 W W B B W B W
## 11 1696 N:3 B W B W B W B
## 12 1670 N:3 W B W B W B
## 13 1662 N:3 B W B B W W B
## 14 1618 N:3 W B W W B B W
## 15 1416P20 N:3 B B W W B B W
## 16 1613 N:3 B W B W B
## 17 1610 N:3 W B W B W B W
## 18 1600 N:3 B W B W B W B
## 19 1570 N:3 W B W B W W B
## 20 1569 N:4 W B W B W B W
## 21 1562 N:3 B W B W W B W
## 22 1529 N:4 W B W B W B
## 23 1371 B W B W B W B
## 24 1300 N:4 B W B B W W B
## 25 1681 N:4 B W B W B W B
## 26 1564 N:4 B W B W B W W
## 27 1539 N:4 W B W B W B
## 28 1513 N:3 W W B W B B W
## 29 1508P12 N:4 B W B W W B
## 30 1444 W B B W W B B
## 31 1444 B W B W B W B
## 32 1433 N:4 W B W B W B W
## 33 1421 B W B W B W B
## 34 1400 B W B B W B W
## 35 1392 W W B W B B W
## 36 1367 N:4 W B W B W B
## 37 1077P17 B W W B W
## 38 1439 N:4 W B W W B B
## 39 1413 N:4 B W B W B W W
## 40 1346 B B W W B W W
## 41 1341P9 B W B W
## 42 1256 B W B B W W B
## 43 1244 W B W W B B W
## 44 1199 W B B W B W
## 45 1191 W B W B W B W
## 46 1076P10 B W B W B W W
## 47 1341 W B W B W B W
## 48 1335 B W B W B
## 49 1259P17 W W B W B
## 50 1111 W B W B B W
## 51 1097 B W B W B W W
## 52 1092 N:4 B W B W B W B
## 53 1359 B W W
## 54 1200 B B W W B W
## 55 1163 W B W B W B
## 56 1140 B W W B W
## 57 1079 B W W B W B
## 58 941 W B W B W B
## 59 878 W B B W W B
## 60 984 W B B W B
## 61 979P18 B W B W B W B
## 62 1535 B
## 63 1125 W B W B B
## 64 1112 B W W B W B B
## NotApplicable
## 1
## 2
## 3
## 4
## 5
## 6
## 7
## 8
## 9
## 10
## 11
## 12
## 13
## 14
## 15
## 16
## 17
## 18
## 19
## 20
## 21
## 22
## 23
## 24
## 25
## 26
## 27
## 28
## 29
## 30
## 31
## 32
## 33
## 34
## 35
## 36
## 37
## 38
## 39
## 40
## 41
## 42
## 43
## 44
## 45
## 46
## 47
## 48
## 49
## 50
## 51
## 52
## 53
## 54
## 55
## 56
## 57
## 58
## 59
## 60
## 61
## 62
## 63
## 64Created CSV file by the name Chess_Players_with_Ratings.csv
message("Connected to MySQL hosted on Google Cloud at ", date())## Connected to MySQL hosted on Google Cloud at Thu Feb 21 22:08:30 2019dbReadTable(conn, "Chess_Players_with_Ratings")## Warning in .local(conn, statement, ...): Decimal MySQL column 3 imported as
## numeric## PlayerNo PlayerName PlayerState TotalPoints PreRating
## 1 1 GARY HUA ON 6.0 1794
## 2 3 ADITYA BAJAJ MI 6.0 1384
## 3 5 HANSHI ZUO MI 5.5 1655
## 4 7 GARY DEE SWATHELL MI 5.0 1649
## 5 9 STEFANO LEE ON 5.0 1411
## 6 11 CAMERON WILLIAM MC LEMAN MI 4.5 1712
## 7 13 TORRANCE HENRY JR MI 4.5 1666
## 8 15 ZACHARY JAMES HOUGHTON MI 4.5 1220
## 9 17 RONALD GRZEGORCZYK MI 4.0 1629
## 10 19 DIPANKAR ROY MI 4.0 1564
## 11 21 DINH DANG BUI ON 4.0 1563
## 12 23 ALAN BUI ON 4.0 1363
## 13 25 LOREN SCHWIEBERT MI 3.5 1745
## 14 27 GAURAV GIDWANI MI 3.5 1552
## 15 29 CHIEDOZIE OKORIE MI 3.5 1602
## 16 31 RISHI SHETTY MI 3.5 1494
## 17 33 JADE GE MI 3.5 1449
## 18 35 JOSHUA DAVID LEE MI 3.5 1438
## 19 37 AMIYATOSH PWNANANDAM MI 3.5 980
## 20 39 JOEL R HENDON MI 3.0 1436
## 21 41 KYLE WILLIAM MURPHY MI 3.0 1403
## 22 43 ROBERT GLEN VASEY MI 3.0 1283
## 23 45 DEREK YAN MI 3.0 1242
## 24 47 ERIC WRIGHT MI 2.5 1362
## 25 49 MICHAEL J MARTIN MI 2.5 1291
## 26 51 TEJAS AYYAGARI MI 2.5 1011
## 27 53 JOSE C YBARRA MI 2.0 1393
## 28 55 ALEX KONG MI 2.0 1186
## 29 57 MICHAEL LU MI 2.0 1092
## 30 59 SEAN M MC CORMICK MI 2.0 853
## 31 61 JEZZEL FARKAS ON 1.5 955
## 32 63 THOMAS JOSEPH HOSMER MI 1.0 1175
## PostRating OpponentAvgPreRating
## 1 1817 1605
## 2 1640 1564
## 3 1690 1501
## 4 1673 1372
## 5 1564 1523
## 6 1696 1468
## 7 1662 1498
## 8 1416 1484
## 9 1610 1499
## 10 1570 1426
## 11 1562 1470
## 12 1371 1214
## 13 1681 1363
## 14 1539 1222
## 15 1508 1314
## 16 1444 1260
## 17 1421 1277
## 18 1392 1150
## 19 1077 1385
## 20 1413 1430
## 21 1341 1248
## 22 1244 1107
## 23 1191 1152
## 24 1341 1392
## 25 1259 1286
## 26 1097 1356
## 27 1359 1345
## 28 1163 1406
## 29 1079 1363
## 30 878 1319
## 31 979 1327
## 32 1125 1350dbGetQuery(conn, "SELECT * FROM Chess_Players_with_Ratings ORDER BY PlayerNo")## Warning in .local(conn, statement, ...): Decimal MySQL column 3 imported as
## numeric## PlayerNo PlayerName PlayerState TotalPoints PreRating
## 1 1 GARY HUA ON 6.0 1794
## 2 3 ADITYA BAJAJ MI 6.0 1384
## 3 5 HANSHI ZUO MI 5.5 1655
## 4 7 GARY DEE SWATHELL MI 5.0 1649
## 5 9 STEFANO LEE ON 5.0 1411
## 6 11 CAMERON WILLIAM MC LEMAN MI 4.5 1712
## 7 13 TORRANCE HENRY JR MI 4.5 1666
## 8 15 ZACHARY JAMES HOUGHTON MI 4.5 1220
## 9 17 RONALD GRZEGORCZYK MI 4.0 1629
## 10 19 DIPANKAR ROY MI 4.0 1564
## 11 21 DINH DANG BUI ON 4.0 1563
## 12 23 ALAN BUI ON 4.0 1363
## 13 25 LOREN SCHWIEBERT MI 3.5 1745
## 14 27 GAURAV GIDWANI MI 3.5 1552
## 15 29 CHIEDOZIE OKORIE MI 3.5 1602
## 16 31 RISHI SHETTY MI 3.5 1494
## 17 33 JADE GE MI 3.5 1449
## 18 35 JOSHUA DAVID LEE MI 3.5 1438
## 19 37 AMIYATOSH PWNANANDAM MI 3.5 980
## 20 39 JOEL R HENDON MI 3.0 1436
## 21 41 KYLE WILLIAM MURPHY MI 3.0 1403
## 22 43 ROBERT GLEN VASEY MI 3.0 1283
## 23 45 DEREK YAN MI 3.0 1242
## 24 47 ERIC WRIGHT MI 2.5 1362
## 25 49 MICHAEL J MARTIN MI 2.5 1291
## 26 51 TEJAS AYYAGARI MI 2.5 1011
## 27 53 JOSE C YBARRA MI 2.0 1393
## 28 55 ALEX KONG MI 2.0 1186
## 29 57 MICHAEL LU MI 2.0 1092
## 30 59 SEAN M MC CORMICK MI 2.0 853
## 31 61 JEZZEL FARKAS ON 1.5 955
## 32 63 THOMAS JOSEPH HOSMER MI 1.0 1175
## PostRating OpponentAvgPreRating
## 1 1817 1605
## 2 1640 1564
## 3 1690 1501
## 4 1673 1372
## 5 1564 1523
## 6 1696 1468
## 7 1662 1498
## 8 1416 1484
## 9 1610 1499
## 10 1570 1426
## 11 1562 1470
## 12 1371 1214
## 13 1681 1363
## 14 1539 1222
## 15 1508 1314
## 16 1444 1260
## 17 1421 1277
## 18 1392 1150
## 19 1077 1385
## 20 1413 1430
## 21 1341 1248
## 22 1244 1107
## 23 1191 1152
## 24 1341 1392
## 25 1259 1286
## 26 1097 1356
## 27 1359 1345
## 28 1163 1406
## 29 1079 1363
## 30 878 1319
## 31 979 1327
## 32 1125 1350Chess_Players_with_Ratings <- fetch(dbSendQuery(conn, "SELECT PlayerNo, PlayerName, PlayerState, TotalPoints, PreRating, PostRating, OpponentAvgPreRating FROM Chess_Players_with_Ratings ORDER BY PlayerNo"))## Warning in .local(conn, statement, ...): Decimal MySQL column 3 imported as
## numericlibrary(DT)
DT::datatable(Chess_Players_with_Ratings, options = list(pagelength=5))