Open adisidev opened 1 day ago
Could you please elaborate? If Brunei's population is treated "as if the decimal is absent," would it be interpreted as zero? Additionally, why are the trailing decimals treated correctly only for Thailand?
The decimal being absent would mean Brunei's population becomes 451. Our current assumption is that if there is a decimal point at the end followed by 3 numbers, we should treat it as a separator not a decimal. (101.589 --> 101,589, but 70.33 --> 70.33. Similarly, 5.978 --> 5,978)
Currently, the following CSV will not work as expected because Thailand will will become 70.33, whereas we would treat others as if the decimal is absent.
We should either figure out how we can avoid such problems in the future, or we request the input CSV to be a particular format. What are your thoughts @mgastner