public List <Duodata <string, int> > BoxPNeighbourhood() { try { Table tablechain = DataprocessingInitialisation.BikeBox; tablechain = new CountOnColumnElement("Deelgem.", tablechain); StringTable table = tablechain.GetTable(); List <string> uniqueIDs, amounts; uniqueIDs = table.GetColumn("Deelgem."); amounts = table.GetColumn("Amount"); Duodata <string, int> toadd; List <Duodata <string, int> > toreturn = new List <Duodata <string, int> >(); for (int i = 0; i < uniqueIDs.Count; i++) { toadd = new Duodata <string, int>(uniqueIDs[i], int.Parse(amounts[i])); toreturn.Add(toadd); } return(toreturn); } catch (Exception e) { Scene.SceneManager.getAScene("TestScene").SetParaMeters(e.GetType().ToString() + "\n"); Scene.SceneManager.getAScene("TestScene").SetParaMeters(e.Message + " ... " + e.StackTrace + "\n"); List <Duodata <string, int> > temp = new List <Duodata <string, int> >(); temp.Add(new Duodata <string, int>("Error", 10)); return(temp); } }
public List <Duodata <string, int> > TheftPMonth() { Table tablechain = DataprocessingInitialisation.BikeTheft; Scene.SceneManager.getAScene("TestScene").SetParaMeters(tablechain.GetTable().Columns["Kennisname"].Count.ToString() + " default \n"); tablechain = new MakePerMonth("Kennisname", tablechain); Scene.SceneManager.getAScene("TestScene").SetParaMeters(tablechain.GetTable().Columns["Kennisname"].Count.ToString() + " mademonth \n"); tablechain = new CountOnColumnElement("Kennisname", tablechain); Scene.SceneManager.getAScene("TestScene").SetParaMeters(tablechain.GetTable().Columns["Kennisname"].Count.ToString() + " countedonelement \n"); StringTable table = tablechain.GetTable(); List <string> uniqueIDs, amounts; uniqueIDs = table.GetColumn("Kennisname"); amounts = table.GetColumn("Amount"); Duodata <string, int> toadd; List <Duodata <string, int> > toreturn = new List <Duodata <string, int> >(); for (int i = 0; i < uniqueIDs.Count; i++) { toadd = new Duodata <string, int>(uniqueIDs[i], int.Parse(amounts[i])); toreturn.Add(toadd); } return(toreturn); }
public override StringTable GetTable() { StringTable temp = SavedTable.GetTable(); List <string> columntocount = temp.GetColumn(NameColumn); StringTable newtable = new StringTable(); newtable.NewColumn(NameColumn); newtable.NewColumn("Amount"); List <string> uniquellabels = new List <string>(); List <int> amounts = new List <int>(); for (int i = 0; i < columntocount.Count; i++) { if (uniquellabels.Contains(columntocount[i])) { amounts[uniquellabels.IndexOf(columntocount[i])] += 1; } else { uniquellabels.Add(columntocount[i]); amounts.Add(1); } } foreach (string i in uniquellabels) { newtable.AddValueToColumn(NameColumn, i); } foreach (int i in amounts) { newtable.AddValueToColumn("Amount", i.ToString()); } return(newtable); }
public List <Duodata <string, int> > TheftPColour() { Table tablechain = DataprocessingInitialisation.BikeTheft; tablechain = new FilterOnly("object", "FIETS", tablechain); tablechain = new CountOnColumnElement("kleur", tablechain); StringTable table = tablechain.GetTable(); List <string> uniqueIDs, amounts; uniqueIDs = table.GetColumn("kleur"); amounts = table.GetColumn("Amount"); Duodata <string, int> toadd; List <Duodata <string, int> > toreturn = new List <Duodata <string, int> >(); for (int i = 0; i < uniqueIDs.Count; i++) { toadd = new Duodata <string, int>(uniqueIDs[i], int.Parse(amounts[i])); toreturn.Add(toadd); } return(toreturn); }
public List <Duodata <string, int> > TheftPMonthInNeighbourhood(string Neighbourhood) { Table tablechain = DataprocessingInitialisation.BikeTheft; tablechain = new MakePerMonth("Kennisname", tablechain); tablechain = new FilterOnly("Werkgebied", Neighbourhood, tablechain); tablechain = new CountOnColumnElement("Kennisname", tablechain); StringTable table = tablechain.GetTable(); List <string> uniqueIDs, amounts; uniqueIDs = table.GetColumn("Kennisname"); amounts = table.GetColumn("Amount"); Duodata <string, int> toadd; List <Duodata <string, int> > toreturn = new List <Duodata <string, int> >(); for (int i = 0; i < uniqueIDs.Count; i++) { toadd = new Duodata <string, int>(uniqueIDs[i], int.Parse(amounts[i])); toreturn.Add(toadd); } return(toreturn); }
public override StringTable GetTable() { StringTable temp = SavedTable.GetTable(); List <String> Column = temp.GetColumn(NameColumn); List <int> Toremove = new List <int>(); for (int i = 0; i < Column.Count; i++) { if (Column[i] == FieldContent) { Toremove.Add(i); } } int amountofitems = Column.Count - 1; for (int i = amountofitems; i >= 0; i--) { Column.RemoveAt(Toremove[i]); } return(temp); }