Data importing made easy

Published on by 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

 GetFile.aspx

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

Categories: technical, time series, tips Tags: