Data importing made easy

Joannes Vermorel

Swivel is a one-of-kind Web 2.0 application: upload, share and visualize your data. Among all the publicly available datasets, time-series represent probably more than half of the published datasets (estimate based on the 2h that I have spend browsing Swivel, accuracy not guaranteed).

In particular, I have noticed that Digg Daily Statistics for 2006 had been published. Thanks to the PowerShell Forecasting SnapIn, and the following commands

PS docs:\\> add-pssnapin LokadOpenShell
PS docs:\\> connect-lokad 'digg-sample@lokad.com' 'myPassword'
PS docs:\\> Import-CsvToLokad (convert-path 'data\_set\_1002641.csv') -verbose
VERBOSE: Column: front page articles
VERBOSE: Column: total comments
VERBOSE: Column: total diggs
VERBOSE: Column: comments per article
VERBOSE: Column: diggs per article
VERBOSE: Column: stdev comments per article
VERBOSE: Column: stdev diggs per article
VERBOSE: Total rows: 363
VERBOSE: Uploading serie named: front page articles
VERBOSE: Uploading serie named: total comments
VERBOSE: Uploading serie named: total diggs
VERBOSE: Uploading serie named: comments per article
VERBOSE: Uploading serie named: diggs per article
VERBOSE: Uploading serie named: stdev comments per article
VERBOSE: Uploading serie named: stdev diggs per article

I have been able to import the Digg data into a Lokad account. Then, I have created daily forecasting tasks associated to those newly imported time-series from the Lokad account. Finally, I have updated the Tour section of Lokad with the screenshot

For 3 lines PowerShell, the result isn’t bad.