research: socio-economic data available directly via R Quandl

[bbest]

Hi @jules32 and @katlongo ,

Quandl is an R package and website mega repository with access to MANY dataset Collections such as Economic Indicators and datasets like World Governance Indicators or WorldBank GDP. WOW!!!

Bumped into this here which mentioned others:

• WDI: World Development indicators
• pwt: Penn World Table
• CRAN Task View: Computational Econometrics

[bbest]

Check out tutorial here:

https://www.datacamp.com/courses/how-to-work-with-quandl-in-r

[jules32]

Hi @bbest and @katlongo,

I've done the Quandl tutorial and it is super easy to access all these data.

As I update the files on layers_global, I'll check to see if this is a good way to go--so far I've found there to be limitations with Quandl data. For example: with the WHO / UNICEF Joint Monitoring Program for Water Supply and Sanitation:

• data are only available through 2010; the WHO/UNICEF website has data through 2012
• data are downloaded separately by country, but I could easily make a loop to pull these all in.
  • side note: there are 452 individual files for each country which is much more than the 226 available on the WHO/UNICEF website -- but also suspicious since the US state department says http://www.state.gov/s/inr/rls/4250.htm there are only 195 recognized countries in the world, including inland countries.

Anyways, just wanted to share.

Cheers, Julie

On Mon, Jul 14, 2014 at 8:26 PM, Ben Best notifications@github.com wrote:

Check out tutorial here:

https://www.datacamp.com/courses/how-to-work-with-quandl-in-r

— Reply to this email directly or view it on GitHub https://github.com/OHI-Science/ohicore/issues/163#issuecomment-48986514.

Julia Stewart Lowndes, PhD Project Scientist, Ocean Health Index http://www.oceanhealthindex.org National Center for Ecological Analysis and Synthesis (NCEAS http://www.nceas.ucsb.edu) University of California, Santa Barbara 735 State Street, Suite 300 Santa Barbara, CA, 93101, USA Phone: 1-805-893-7523

[bbest]

Thanks for exploring this Julie. Too bad it's not as easy or straightforward as hoped. Best to stick with your existing methods which can scrape the latest, authoritative data.

On Tue, Jul 15, 2014 at 4:42 PM, jules32 notifications@github.com wrote:

Hi @bbest and @katlongo,

I've done the Quandl tutorial and it is super easy to access all these data.

As I update the files on layers_global, I'll check to see if this is a good way to go--so far I've found there to be limitations with Quandl data. For example: with the WHO / UNICEF Joint Monitoring Program for Water Supply and Sanitation:

• data are only available through 2010; the WHO/UNICEF website has data through 2012
• data are downloaded separately by country, but I could easily make a loop to pull these all in.
• side note: there are 452 individual files for each country which is much more than the 226 available on the WHO/UNICEF website -- but also suspicious since the US state department says http://www.state.gov/s/inr/rls/4250.htm there are only 195 recognized countries in the world, including inland countries.

Anyways, just wanted to share.

Cheers, Julie

On Mon, Jul 14, 2014 at 8:26 PM, Ben Best notifications@github.com wrote:

Check out tutorial here:

https://www.datacamp.com/courses/how-to-work-with-quandl-in-r

— Reply to this email directly or view it on GitHub https://github.com/OHI-Science/ohicore/issues/163#issuecomment-48986514.

Julia Stewart Lowndes, PhD Project Scientist, Ocean Health Index http://www.oceanhealthindex.org National Center for Ecological Analysis and Synthesis (NCEAS http://www.nceas.ucsb.edu) University of California, Santa Barbara 735 State Street, Suite 300 Santa Barbara, CA, 93101, USA Phone: 1-805-893-7523

— Reply to this email directly or view it on GitHub https://github.com/OHI-Science/ohicore/issues/163#issuecomment-49107357.