EPFL-ENAC / hobel-iaqdb

https://iaqdb-dev.epfl.ch/
GNU General Public License v3.0
0 stars 0 forks source link

[FEATURE] <accepting both long and wide formats for IAQ data> #20

Open Botato12 opened 3 weeks ago

Botato12 commented 3 weeks ago

The air quality data related to individual VOCs or biocontaminants can come in either long or wide format, depending on the lab performing analysis. It will be a great relief for the contributors if we can accept both formats. Here are two examples.

Typical long format looks like this: image Every individual pollutant takes a row, with name and concentration in separate columns. Sometimes there can be an additional column of CAS number and another column of concentration in a different unit.

Typical wide format looks like this: image Every individual pollutant takes a column, with unit stored in a separate column. If CAS number is also available, it will be in the header (e.g., the 2nd row following pollutant name).

Botato12 commented 3 weeks ago

Screenshot 2024-09-26 at 10 05 30 long format

Botato12 commented 3 weeks ago

Screenshot 2024-10-29 at 16 02 22 wide format