/// <summary> /// Grouped Bar Chart Data. /// </summary> /// <param name="Headers"></param> /// <param name="Values"></param> /// <param name="Domain"></param> /// <returns name="Data">Grouped Bar Chart Data object</returns> public static GroupedBarChartData Data( List <string> Headers, List <List <object> > Values, [DefaultArgumentAttribute("Charts.MiscNodes.GetNull()")] Domain Domain) { List <DataPoint2> dataPoints = new List <DataPoint2>(); foreach (List <object> subList in Values) { DataPoint2 dataPoint = new DataPoint2(); dataPoint.Name = subList[0].ToString(); Dictionary <string, double> values = new Dictionary <string, double>(); for (int i = 1; i < subList.Count(); i++) { values.Add(Headers[i], Convert.ToDouble(subList[i])); } dataPoint.Values = values; dataPoints.Add(dataPoint); } GroupedBarChartData data = new GroupedBarChartData(); data.Data = dataPoints; data.Domain = Domain; return(data); }
public static List <DataPoint2> Data2FromTree(List <string> headers, GH_Structure <GH_String> values) { List <DataPoint2> dataPoints = new List <DataPoint2>(); for (int i = 0; i < values.Branches.Count; i++) { DataPoint2 dataPoint = new DataPoint2(); dataPoint.Name = values.Branches[i][0].Value; Dictionary <string, double> dict = new Dictionary <string, double>(); for (int j = 1; j < values.Branches[i].Count; j++) { try { dict.Add(headers[j], Convert.ToDouble(values.Branches[i][j].Value)); } catch { dict.Add(headers[j], 0); } } dataPoint.Values = dict; dataPoints.Add(dataPoint); } return(dataPoints); }
public static List <DataPoint2> Data2FromCSV(string _filePath) { List <DataPoint2> dataPoints = new List <DataPoint2>(); using (CsvReader csv = new CsvReader(new StreamReader(_filePath), true)) { int fieldCount = csv.FieldCount; string[] headers = csv.GetFieldHeaders(); while (csv.ReadNextRecord()) { DataPoint2 dataPoint = new DataPoint2(); dataPoint.Name = csv[0]; Dictionary <string, double> dict = new Dictionary <string, double>(); for (int i = 1; i < fieldCount; i++) { try { dict.Add(headers[i], Convert.ToDouble(csv[i])); } catch { dict.Add(headers[i], 0); } } dataPoint.Values = dict; dataPoints.Add(dataPoint); } } return(dataPoints); }
/// <summary> /// Create a list of data point 2s from a CSV path. /// </summary> /// <param name="filePath"></param> /// <returns></returns> public static List <DataPoint2> Data2FromCsv(string filePath) { var dataPoints = new List <DataPoint2>(); using (var csv = new CsvReader(new StreamReader(filePath), true)) { var fieldCount = csv.FieldCount; var headers = csv.GetFieldHeaders(); while (csv.ReadNextRecord()) { var dataPoint = new DataPoint2 { Name = csv[0] }; var dict = new Dictionary <string, double>(); for (var i = 1; i < fieldCount; i++) { try { dict.Add(headers[i], Convert.ToDouble(csv[i])); } catch { dict.Add(headers[i], 0); } } dataPoint.Values = dict; dataPoints.Add(dataPoint); } } return(dataPoints); }
public List <DataPoint2> RevenueDay() { List <DataPoint2> dataPoints3 = new List <DataPoint2>(); for (int DayCounter = 0; DayCounter > -1000; DayCounter--) { var price = _context.History.Where(x => x.DateCreated.ToShortDateString() == DateTime.Now.AddDays(DayCounter).ToShortDateString()).Sum(y => y.Price); DataPoint2 z = new DataPoint2(price, DateTime.Now.AddDays(DayCounter).ToShortDateString()); dataPoints3.Add(z); } return(dataPoints3); }
public List <DataPoint2> RevenueYear() { List <DataPoint2> dataPoints5 = new List <DataPoint2>(); for (int YearCounter = 0; YearCounter > -100; YearCounter--) { decimal price = 0; DateTime time = DateTime.Now.AddYears(YearCounter); foreach (var item in _context.History.Where(x => x.DateCreated.Year == time.Year).Select(x => x.Price)) { price += item; } DataPoint2 z = new DataPoint2(price, time.Year.ToString()); dataPoints5.Add(z); } return(dataPoints5); }
public List <DataPoint2> RevenueMonth() { List <DataPoint2> dataPoints4 = new List <DataPoint2>(); for (int MonthCounter = 0; MonthCounter > -1000; MonthCounter--) { decimal price = 0; DateTime time = DateTime.Now.AddMonths(MonthCounter); foreach (var item in _context.History.Where(x => x.DateCreated.Month == time.Month && x.DateCreated.Year == time.Year).Select(x => x.Price)) { price += item; } DataPoint2 z = new DataPoint2(price, time.Month.ToString() + "-" + time.Year.ToString()); dataPoints4.Add(z); } return(dataPoints4); }
/// <summary> /// Create List of DataPoint2 from List of values and headers. /// </summary> /// <param name="headers"></param> /// <param name="values"></param> /// <returns></returns> public static List <DataPoint2> Data2FromList(List <string> headers, List <List <object> > values) { var dataPoints = new List <DataPoint2>(); foreach (var subList in values) { var dataPoint = new DataPoint2 { Name = subList[0].ToString() }; var dict = new Dictionary <string, double>(); for (var i = 1; i < subList.Count; i++) { dict.Add(headers[i], Convert.ToDouble(subList[i])); } dataPoint.Values = dict; dataPoints.Add(dataPoint); } return(dataPoints); }
/// <summary> /// Data. /// </summary> /// <param name="Headers">Header values.</param> /// <param name="Values">Data values.</param> /// <returns name="Data">Data</returns> public static ScatterPlotMatrixData Data( List <string> Headers, List <List <object> > Values) { List <DataPoint2> dataPoints = new List <DataPoint2>(); foreach (List <object> subList in Values) { DataPoint2 dataPoint = new DataPoint2(); dataPoint.Name = subList[0].ToString(); Dictionary <string, double> values = new Dictionary <string, double>(); for (int i = 1; i < subList.Count(); i++) { values.Add(Headers[i], Convert.ToDouble(subList[i])); } dataPoint.Values = values; dataPoints.Add(dataPoint); } ScatterPlotMatrixData data = new ScatterPlotMatrixData(); data.Data = dataPoints; return(data); }