Friday, January 4, 2013

Always check the data

Here some agricultural production statistics for Angola (source: XLS download from FAO/CountryStat):

image 

I am sure the harvest of 2011 was not that abundant.

Looks like an import problem. This is the XLS file. Also available is CSV data. That shows:

image

All other production data are coded as integers, but here we have a number with a decimal comma (and many more digits than warranted). Decimal commas/decimal points are always a point of contention.

PS: Crops are denoted in Portuguese (Horticolas=vegetables) as Angola was once a Portuguese colony.

PS2. I dropped a note to Countrystats support about this.

1 comment:

  1. CSV, my love! How many hours have I wasted on these problems...

    ReplyDelete