An R package for building Google's Data Sets Publication Language (DSPL) metadata files used in Public Data Explorer.
Features:
Reads tab, csv, xls and xlsx from a folder.
Identifies data types and distinguishes between dimensional and metric concepts.
Identifies dimensional data tabs.
Auto generates conceps id.
Auto data sorting on dimensional (no time) concepts.
Prints XML and csv files to upload to Public Data Explorer.
Some bug trackers before final printing XML.
Builds ZIP file containing CSV and XML files.
So you don't need to mess with the XML coding at all!
library(googlePublicData) # This path has some csv files that we will use data.path <-try(paste(.libPaths()[1],'/googlePublicData/data',sep=''), silent=T) data.path # The dspl function looks for csv files in that paths, and analyzes them mydspl <- dspl(path=data.path, sep=";") # If we wanted to write the zip file... ready to be uploaded to # http://publicdata.google.com # dspl(path=data.path, sep=";", output= "mydspl.zip") # Printing the data mydspl # Summary of the dspl class object summary(mydspl)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.