aggregate.sql
The aggregation has to be done multiple times to be able to do the average calculation of motorpower, weight and emissions correctly. The reason for this is, that not all, sometime more than half of a specific unique key combination don't have values in the corresponding data fields. To do the average calculation correctly we need to only aggregate and calculate over rows where the specified data field is not empty while keeping track of the "number of cars with data/total number of cars" number, named "_coverage". After the calculations we once again aggregate all the tables. The details to those calculations can be found within this file.
Es gibt noch keine Darstellungen/Views für diese Ressource
Zitieren als
Benjamin Stephan (2024). aggregate.sql (from Datenanalyse des EEA-Datensatzes "CO2-Emissionen von Personenkraftwagen") [Data set resource]. Greenpeace e.V..
https://daten.greenpeace.de/dataset/datenanalyse-des-eea-datensatzes-co2-emissionen-von-personenkraftwagen/resource/e268e90f-0487-4c3b-ba9b-1be50de45faa
Retrieved: 02:19 08 Sep 2024 (UTC)
Zusätzliche Informationen
Feld | Wert |
---|---|
Daten wurden zuletzt aktualisiert | 7. Februar 2024 |
Metadaten zuletzt aktualisiert | 7. Februar 2024 |
Erstellt | unbekannt |
Format | sql |
Lizenz | CC BY-NC 4.0 LIZENZVERTRAG |
Erstellt | vor 7 Monaten |
Media type | text/plain |
Size | 6.703 |
Datastore active | False |
Has views | False |
Id | e268e90f-0487-4c3b-ba9b-1be50de45faa |
Package id | 0a63d003-3bd1-4933-b044-9439a526c2fa |
Position | 0 |
Resource type | regular |
State | active |
Url type | upload |
Mimetype | |
Typ | Regular |
Schema |