[OpenSpending] Problem creating models

Mon Feb 24 13:14:38 UTC 2014

Thank you Tryggvi, 

So that is "the invisible man is in your spreadsheet, messing with your
data", that the school of data was about! 

Regards 

Le 24.02.2014 12:57, Tryggvi Björgvinsson a écrit : 

> Hi,
> 
> Including the openspending-dev mailing list as well.
> 
> On mán 24.feb 2014 12:18, tinto.jean at titinto.net wrote: 
> 
>> I have a problems to create models corresponding to this dataset :http://africaopendata.org/storage/f/2014-02-24T01%3A23%3A19.890Z/budget-2011-ohg-depenses.csv [1]. 
>> The time column for exemple, the error is : "Column 'Annee' does not exist in source data."
> 
> In your csv file some of the headers have a preceding whitespace. For example Annee which your csv names ' Annee' (notice the whitespace before the A).
> 
> You have the same problem with:
> 
> * ' Description article'
> * ' Description article'
> * ' Chapitre'
> 
> Try to remove the whitespace for these four columns and see if that works for you.
> 
> -- 
> 
> Tryggvi Björgvinsson 
> 
> Technical Lead, OpenSpending 
> 
> The Open Knowledge Foundation [4] 
> 
> _Empowering through Open Knowledge_ 
> 
> http://okfn.org/ [5] | @okfn [6] | OKF on Facebook [7] | Blog [8] | Newsletter [9] 
> 
> _______________________________________________
> openspending mailing list
> openspending at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/openspending [2]
> Unsubscribe: https://lists.okfn.org/mailman/options/openspending [3]

the Invisible Man is in your spreadsheet, messing with your data - See
more at:
http://schoolofdata.org/handbook/courses/data-cleaning-invisible-man-in-spreadsheets/#sthash.98iwkvx4.dpuf

Links:
------
[1]
http://africaopendata.org/storage/f/2014-02-24T01%3A23%3A19.890Z/budget-2011-ohg-depenses.csv
[2] https://lists.okfn.org/mailman/listinfo/openspending
[3] https://lists.okfn.org/mailman/options/openspending
[4] http://okfn.org
[5] http://okfn.org/
[6] http://twitter.com/OKFN
[7] https://facebook.com/OKFNetwork
[8] http://blog.okfn.org/
[9] http://okfn.org/about/newsletter
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending/attachments/20140224/e41919b9/attachment-0002.html>