/*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);
}
