Projekt_​3_​tests

1) Read Single JSON-File

1) Read location JSON-file and visualize it on map

2) Read my local knime.log file from local workspace

2) Read 10 Test JSON-Files

3) Fixing main data

1. Read All JSON-Files

2. Fix vehicle_type_id by removing "DER:VehicleType:"

3. Fix station_id by removing "DER:Station:"

4. Parse Milliseconds-Timestamp into UNIX Timestamp

5. Change vehicle_type_id to lower case

6. Fix model description of renault_megan_etech by adding "e" to "renault_megane_etech" and change "_kw" to "kw"

7. Remove single line with "vw"

8. GroupBy are just to check results of current node

2) Live Data Requests (currently doesn't work due to server issues -> Response:502)

1) Live Data MockUps

1.1) Check if URLs are working

3) Occurrence overview of different vehicle_type_ids

3) Change table in preparation for Bagging and Boosting algorithms

1. Pivot the column with vehicle types to get normalized table structure for ML methods

2. Reduce original table in preparation for join with pivot table

3. Add the rows without any vehicle type count via left outer join

4. Replace missing values with 0

5. Add total_vehicles, total_vw, total_mg and total_renault to table

6. Replace station_id with real name of station

1) Gerade (18.12.25) herausgefunden, dass es 418 Stationen in location_info.json gibt, aber im Hauptdatensatz nur 383 vorhanden sind. Davon stimmen 73 nicht überein.

Die fehlenden sollten, wenn möglich, noch im Datensatz ergänzt werden.

Data Processing

Live Requests

Debug / Visualization

Probleme / In Arbeit

2) All wrong

2b) Add live data to dataset

Aufgabe 3