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