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