r5atom / saturday-datascience Goto Github PK

When a lot is not sold at auction the price is set to zero. It is better to use a different placeholder for unsold lots. Probably best to make these price values NaN.

[1] https://www.domeinenrz.nl/domeinenrz_nl/47ca2005219f7c09927fd0e3c454813a.php

Occasionally lots are a combination of multiple items. For instance a truck and trailer. Currently only the first item is added to the data. The remainder will be stored in the raw text field.

Solving this might be tricky, because the additional items (e.g. the trailer) belongs to a lot that already has an item (e.g. the truck). Indexing of the dataframe assumes there is only one item.

Giving registration (kenteken=) to rdw Gekentekende_voertuigen api [1] returns approval codes (typegoedkeuringsnummer, uitvoering and variant). These can be used to query the EEG Voertuigtypegoedkeuring api [2] by mapping:

This in return, returns pointers to other api's that can also be queried with the above fields and other information can be retrieved.

[1] https://opendata.rdw.nl/Voertuigen/Open-Data-RDW-Gekentekende_voertuigen/m9d7-ebf2 Gekentekende_voertuigen
[2] https://opendata.rdw.nl/Typegoedkeuring/Open-Data-RDW-EEG-Voertuigtypegoedkeuring/55kv-xf7m EEG Voertuigtypegoedkeuring

For example.
https://opendata.rdw.nl/resource/m9d7-ebf2.json?kenteken=61LTZ6
returns

[
  {
    "kenteken": "61LTZ6",
    "voertuigsoort": "Personenauto",
    ...
    "typegoedkeuringsnummer": "e1*2007/46*0275*02",
    "variant": "VL31",
    "uitvoering": "5A",
    ...
  }
]

Then querying
https://opendata.rdw.nl/resource/55kv-xf7m.json?typegoedkeuringsnummer=e1*2007/46*0275*02
returns

[
  {
    "eu_type_goedkeuringssleutel": "e1*07/46*0275*02",
    "landcode_eeg_typegoedkeuring": "e1",
    ...
    "typegoedkeuringsnummer": "e1*2007/46*0275*02",
    "api_basisgegevens_eeg_uitvoering": "https://opendata.rdw.nl/Voertuigen/Open-Data-RDW-Basisgegevens-EEG-Uitvoering/wx3j-69ie",
    "api_as_gegevens_eeg_uitvoering": "https://opendata.rdw.nl/Voertuigen/Open-Data-RDW-AS-Gegevens-EEG-Uitvoering/ahsi-8uyu",
    "api_carrosserie_uitvoering": ..,
    "api_..
    ...
}
]

This gives access to additional api's that can be queried with fields from [1] and [2]:
https://opendata.rdw.nl/resource/wx3j-69ie.json?eu_type_goedkeuringssleutel=e1*07/46*0275*02&eeg_variantcode=VL31&eeg_uitvoeringscode=5A
https://opendata.rdw.nl/resource/r7cw-67gs.json?eu_type_goedkeuringssleutel=e1*07/46*0275*02&eeg_variantcode=VL31&eeg_uitvoeringscode=5A
... etc. returns extra information

    ...
    "max_constructie_snelheid_ondergrens": "202",
    ...
    "aantal_versnellingen_ondergrens": "6",
    ...
    "type_versnellingsbak": "H"
    ...

In the readme file some relative links (e.g. ../code/file-name) are not working and produce a 404 error.

./code/add-rdw-info-to-drz.ipynb currently queries RDW one-by-one, but by using SoQL type queries, all registrations can be retrieved with one call.

It should be something like this

http://opendata.rdw.nl/resource/m9d7-ebf2.json?$where=kenteken in('23NPSB', '63SFFG')