search

vergauwenthomas / MetObs_toolkit

A toolkit for using non-traditional meteorological observations
https://vergauwenthomas.github.io/MetObs_toolkit/
MIT License
14 stars 5 forks source link

Automatic detection of decimal/thousand seperators #474

Open vergauwenthomas opened 1 month ago

vergauwenthomas commented 1 month ago

Problem: @spuynen cannot use coordinates because the latitude is incorrectly read in (5095584 instead of 50.95584).

What is going on: @spuynen found that . is used for both thousands as decimal splitter. He uses windows and excel. Formatting (without opening) to UTF8 did not fix the issue.

Solution: Tricky, since this is specific to OS (and even laptop language settings i think). Further research into this topic is needed.

vergauwenthomas commented 1 month ago

Here is how excel saves it:

ID;Vlinder;lon;lat;stad;benaming;school;sponsor;Network 31;vlinder75;5495661;5096518;Genk;Ref;nvt;HBS;Vlinder 32;vlinder76;5499444;5096486;Genk;Garden;nvt;HBS;Vlinder 33;vlinder77;5499120;5096503;Genk;Playground;nvt;HBS;Vlinder 34;vlinder78;5499504;5096498;Genk;Tree;nvt;HBS;Vlinder

vergauwenthomas commented 4 weeks ago

One solution can be to include the reading of excel files directly, in the hope that the formatting of the numeric values are in the metadata.