/*0-id,1-year,2-gender,3-tid,4-mid,5-player1,6-player2,7-country1,8-country2,9-round, * 10- firstServe1,11 -firstServe2,12- ace1, 13- ace2, 14- double1, 15- double2, 16- firstPointWon1, 17- firstPointWon2, * 18- secPointWon1, 19-secPointWon2, 20-fastServe1, 21-fastServe2, 22-avgFirstServe1, 23-avgFirstServe2, 24-avgSecServe1, 25-avgSecServe2, * 26-break1, 27-break2, 28-return1, 29-return2, 30-total1, 31-total2, * 32-winner1, 33-winner2, 34-error1, 35-error2, 36- net1, 37-net2*/ public static List <FlatNode> ReadData(string path) { var result = new List <FlatNode>(); var lines = System.IO.File.ReadAllLines(path); for (var i = 1; i < lines.Length; i++) { var d = lines[i].Split(','); var temp = new FlatNode { Id = Convert.ToInt32(d[0]), Year = Convert.ToInt32(d[1]), WinnerName = d[5], LoserName = d[6], Round = Convert.ToInt32(d[9]), Match = new MatchData( Array.ConvertAll(new string[] { "0" + d[10].Trim('%'), "0" + d[16].Trim('%'), "0" + d[18].Trim('%'), "0" + d[26].Trim('%'), "0" + d[28].Trim('%'), "0" + d[36].Trim('%') }, int.Parse), Array.ConvertAll(new string[] { "0" + d[11].Trim('%'), "0" + d[17].Trim('%'), "0" + d[19].Trim('%'), "0" + d[27].Trim('%'), "0" + d[29].Trim('%'), "0" + d[37].Trim('%') }, int.Parse)), Donut = new DonutData(Convert.ToInt32("0" + d[12]), Convert.ToInt32("0" + d[13]), Convert.ToInt32("0" + d[30]), Convert.ToInt32("0" + d[31]), Convert.ToInt32("0" + d[32]), Convert.ToInt32("0" + d[33]), Convert.ToInt32("0" + d[34]), Convert.ToInt32("0" + d[35])) }; result.Add(temp); } return(result); }
protected void Page_Load(object sender, EventArgs e) { //UtilityLocal.TransformFile(@"c:\users\avimalch\documents\visual studio 2015\Projects\AWAssignment1\WebApp\data\class_click.csv", // @"c:\users\avimalch\documents\visual studio 2015\Projects\AWAssignment1\WebApp\data\class_click_transformed.csv"); //UtilityLocal.CleanTransformedFile(@"c:\users\avimalch\documents\visual studio 2015\Projects\AWAssignment1\WebApp\data\class_click_transformed.csv", @"c:\users\avimalch\documents\visual studio 2015\Projects\AWAssignment1\WebApp\data\class_click_transformed_cleaned.csv"); var dirPath = @"C:\Users\avimalch\DVAssignment2\WebApp\data"; for (var year = 2003; year <= 2013; year++) { var flatNodes = FlatNode.ReadData(dirPath + @"\USOpenR.csv"); Node.BuildNodes(null, flatNodes, year, year == 2005 ? 5 :7); var json = new JavaScriptSerializer().Serialize(Node.Root); //File.WriteAllText(dirPath+@"\"+year+".json", json); Testdiv.InnerHtml = json; } //printData(Node.Root); }