playing with educational data on Quandl

quandl.r

Quandl.auth("") # add your token, which you have to get at http://www.quandl.com/users/edit 
library(devtools)
install_github('R-package','quandl')
require(Quandl)
require(ggplot2)
require(RCurl)

data <- getURL("https://gist.github.com/rpietro/6665635/raw/edb700cc7b2110c3f7dd4d559221f351e17369fd/ed.csv")
ed <- read.csv(data)
head(ed)
qplot(ed$X.5Y.Ago, ed$Level)

# you can also have the data for all indicators for an individual country - see http://goo.gl/zNeb1i for US, and then a time series for each individual variable http://goo.gl/EWgd2F -- this is mind boggling, just too bad that the API won't allow us to get this type of data directly, would have to be scraped I guess

Quandl.search("Education") #searches will only work after you have entered your token -- see above. there doesnt seem to be any global educational datasets, which means we would have to scrape pages if we decide to use Quandl as a source for the observatory

# Education - 
# Code: UKONS/L2PA
# Desc: seasonal_adjustment='SA', base_period='2009', price='CONS', index_period='2009'. The Blue Book is a key annual publication of National Accounts statistics and the essential data source for anyone concerned with macro-economic policies and studies. These National Statistics are produced to high professional standards and released according to the arrangements approved by the UK Statistics Authority.
# Freq: annual
# Cols: Year|Value

# Educational Services Earnings in Alabama
# Code: FRED/ALEEDU
# Desc: Millions of Dollars Not Seasonally Adjusted, Industry based on 2002 North American Industry Classification System (NAICS). Please consult the U.S. Census Bureau (http://www.census.gov/epcd/naics02/naicod02.htm) for additional information about NAICS.
# Freq: quarterly
# Cols: Date|Value

# Educational Services Earnings in Delaware
# Code: FRED/DEEEDU
# Desc: Millions of Dollars Not Seasonally Adjusted, Industry based on 2002 North American Industry Classification System (NAICS). Please consult the U.S. Census Bureau (http://www.census.gov/epcd/naics02/naicod02.htm) for additional information about NAICS.
# Freq: quarterly
# Cols: Date|Value