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.

file.content <- readLines("https://raw.githubusercontent.com/hovig/MSDS_CUNY/master/Data607/Project1/tournamentinfo.txt", warn = FALSE)
Size Length
File 17642 Bytes 196 Rows


Write into a csv file: 
# Option 1: file saved to local path when running rmd file
write.table(df, file = "Project 1 - Data 607.csv", sep = ",", col.names = T, row.names = F, quote = FALSE)

# Option 2: copy and paste below into a csv file
write.csv(df, row.names = F, quote = FALSE)
## Name,State,Points,Prerating,Opponent_Avg_Rating
## GARY HUA, ON,6.0,1794,1605
## DAKSHESH DARURI, MI,6.0,1553,1469
## ADITYA BAJAJ, MI,6.0,1384,1563
## PATRICK H SCHILLING, MI,5.5,1716,1573
## HANSHI ZUO, MI,5.5,1655,1500
## HANSEN SONG, OH,5.0,1686,1518
## GARY DEE SWATHELL, MI,5.0,1649,1372
## EZEKIEL HOUGHTON, MI,5.0,1641,1468
## STEFANO LEE, ON,5.0,1411,1523
## ANVIT RAO, MI,5.0,1365,1554
## CAMERON WILLIAM MC LEMAN, MI,4.5,1712,1467
## KENNETH J TACK, MI,4.5,1663,1506
## TORRANCE HENRY JR, MI,4.5,1666,1497
## BRADLEY SHAW, MI,4.5,1610,1515
## ZACHARY JAMES HOUGHTON, MI,4.5,1220,1483
## MIKE NIKITIN, MI,4.0,1604,1385
## RONALD GRZEGORCZYK, MI,4.0,1629,1498
## DAVID SUNDEEN, MI,4.0,1600,1480
## DIPANKAR ROY, MI,4.0,1564,1426
## JASON ZHENG, MI,4.0,1595,1410
## DINH DANG BUI, ON,4.0,1563,1470
## EUGENE L MCCLURE, MI,4.0,1555,1300
## ALAN BUI, ON,4.0,1363,1213
## MICHAEL R ALDRICH, MI,4.0,1229,1357
## LOREN SCHWIEBERT, MI,3.5,1745,1363
## MAX ZHU, ON,3.5,1579,1506
## GAURAV GIDWANI, MI,3.5,1552,1221
## SOFIA ADINA STANESCUBELLU, MI,3.5,1507,1591
## CHIEDOZIE OKORIE, MI,3.5,1602,1313
## GEORGE AVERY JONES, ON,3.5,1522,1144
## RISHI SHETTY, MI,3.5,1494,1259
## JOSHUA PHILIP MATHEWS, ON,3.5,1441,1378
## JADE GE, MI,3.5,1449,1276
## MICHAEL JEFFERY THOMAS, MI,3.5,1399,1375
## JOSHUA DAVID LEE, MI,3.5,1438,1149
## SIDDHARTH JHA, MI,3.5,1355,1388
## AMIYATOSH PWNANANDAM, MI,3.5, 980,1384
## BRIAN LIU, MI,3.0,1423,1539
## JOEL R HENDON, MI,3.0,1436,1429
## FOREST ZHANG, MI,3.0,1348,1390
## KYLE WILLIAM MURPHY, MI,3.0,1403,1248
## JARED GE, MI,3.0,1332,1149
## ROBERT GLEN VASEY, MI,3.0,1283,1106
## JUSTIN D SCHILLING, MI,3.0,1199,1327
## DEREK YAN, MI,3.0,1242,1152
## JACOB ALEXANDER LAVALLEY, MI,3.0, 377,1357
## ERIC WRIGHT, MI,2.5,1362,1392
## DANIEL KHAIN, MI,2.5,1382,1355
## MICHAEL J MARTIN, MI,2.5,1291,1285
## SHIVAM JHA, MI,2.5,1056,1296
## TEJAS AYYAGARI, MI,2.5,1011,1356
## ETHAN GUO, MI,2.5, 935,1494
## JOSE C YBARRA, MI,2.0,1393,1345
## LARRY HODGE, MI,2.0,1270,1206
## ALEX KONG, MI,2.0,1186,1406
## MARISA RICCI, MI,2.0,1153,1414
## MICHAEL LU, MI,2.0,1092,1363
## VIRAJ MOHILE, MI,2.0, 917,1391
## SEAN M MC CORMICK, MI,2.0, 853,1319
## JULIA SHEN, MI,1.5, 967,1330
## JEZZEL FARKAS, ON,1.5, 955,1327
## ASHWIN BALAJI, MI,1.0,1530,1186
## THOMAS JOSEPH HOSMER, MI,1.0,1175,1350
## BEN LI, MI,1.0,1163,1263
A copy of this csv file is available at github.