search

datasets / awesome-data

Curated list of quality open datasets
https://datahub.io/collections
797 stars 101 forks source link

Big Mac Index #122

Open rufuspollock opened 9 years ago

rufuspollock commented 9 years ago

http://www.economist.com/content/big-mac-index

http://infographics.economist.com/2015/databank/BMfile2000-Jul2015.xls

Very straightforward to do :-)

zelima commented 8 years ago

@rgrp I'll take this one.

Output: big-mac-index.csv

preview

Country,Date,Local price,Dollar ex,Dollar price,Dollar ppp,Dollar valuation
Argentina,2000-04-01,2.50,1.00,2.50,1.00,-0.40
Argentina,2001-04-01,2.50,1.00,2.50,0.98,-1.57
...
Argentina,2015-01-01,28,9.14,3.07,5.85,-36.01
Australia,2000-04-01,2.59,1.68,1.54,1.03,-38.58
rufuspollock commented 8 years ago

Great. Remember we would like a chart as well.

zelima commented 8 years ago

@rgrp please review validation link: http://data.okfn.org/tools/validate?url=https%3A%2F%2Fgithub.com%2Fzelima%2Fbig-mac-index view link: http://data.okfn.org/tools/view?url=https%3A%2F%2Fgithub.com%2Fzelima%2Fbig-mac-index Repository: https://github.com/zelima/big-mac-index

rufuspollock commented 8 years ago

@pdehaye can you cast your eye and see if this looks good?

pdehaye commented 8 years ago

This generally looks good, but the graph is suboptimal. This does not link prices at different times for the same country together (country against country, as time evolves), which would be the most immediately accessible presentation.

zelima commented 8 years ago

To link price with different time periods, we have to divide datapackage. So there will be different CSV files for each country. Right now, any other combination for x and y axis makes graph unreadable.

rufuspollock commented 8 years ago

@zelima i think this is one where you cannot do a graph without pivoting so for now i would not do a graph. The need for things like pivoting is why we need to switch to new "View" support - see https://discuss.okfn.org/t/data-packages-views-graphs-maps-tables-etc/2667

zelima commented 8 years ago

@rgrp got it - removing the graph from view.

anuveyatsu commented 1 year ago

Hi @zelima hope you're doing great! 😄 It would be great if you could move this dataset from your own account to this org? https://github.com/zelima/big-mac-index