awesome-data icon indicating copy to clipboard operation
awesome-data copied to clipboard

Big Mac Index

Open rufuspollock opened this issue 9 years ago • 9 comments

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

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

Very straightforward to do :-)

rufuspollock avatar Nov 03 '15 10:11 rufuspollock

@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

zelima avatar Apr 16 '16 07:04 zelima

Great. Remember we would like a chart as well.

rufuspollock avatar Apr 16 '16 08:04 rufuspollock

@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

zelima avatar Apr 18 '16 16:04 zelima

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

rufuspollock avatar Apr 24 '16 10:04 rufuspollock

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.

pdehaye avatar Apr 25 '16 13:04 pdehaye

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.

zelima avatar Apr 25 '16 16:04 zelima

@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

rufuspollock avatar Apr 27 '16 22:04 rufuspollock

@rgrp got it - removing the graph from view.

zelima avatar Apr 29 '16 10:04 zelima

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

anuveyatsu avatar Sep 05 '23 15:09 anuveyatsu