What is a Quantitative Time Series?

A quantitative time series data set is one that contains temporal data; data that has a time value associated with it. The typical result is that you can see in a chart how this data changes over time. In your source file, dates and values must be in columns.

The first row of your dataset must be used to set a field name for each column. In the example below, Website visitors and Date are the field names. The subsequent rows contain your data. If you are using CSV and TSV, every column must be separated by a semi-colon (”;”), a comma (”,”) or a tabulation mark.

Example of a good dataset (will work with MisoData):

Website visitors Date
2158 2013-06-01
8060 2013-06-02
4709 2013-06-03
1259 2013-06-04
1059 2013-06-05
2267 2013-06-06
4579 2013-06-07

Example of a bad dataset

This will not work with MisoData:

Country 2013-06-01 2013-06-02 2013-06-03
Belgique 402 447 489
Bulgarie 444 455 457
If your dataset output is like the one in the second example, it will not work with MisoData directly. However, it is simple to reformat it so that it will work by using a spreadsheet program to transpose your data. For example, in Excel, start by selecting and copying your entire data range. Click on a new location in your sheet, then go to “Edit > Paste Special” and select the Transpose check box. Click OK, and Excel will transpose the column and row labels and data. Your dataset is now MisoData compliant.

Supported date format patterns

All major date formats used by Microsoft Excel are supported. Most commonly used are the following international format:

  • full date YYYY-MM-DD (i.e. 1997-07-16), four-digit year, two-digit month and two-digit day.

  • full date & time YYYY-MM-DD hh:mm:ss (i.e. 2013-05-15 19:20:30), two digits for hours, minutes & seconds, 24h format (no AM/PM allowed).

Full list of supported date formats:
'Y' i.e. 2003
'F' i.e. December
'M' i.e. Dec
'Y m' i.e. 2003-12
'm d' i.e. 12-31
'd m' i.e. 31-12
'd M' i.e. 31 Dec
'M Y' i.e. Dec 2003
'M y' i.e. Dec 03
'F Y' i.e. December 2003
'F y' i.e. December 03
'd F' i.e. 31 December
'm d Y' i.e. 12-31-2003
'm d y' i.e. 12-31-03
'd m Y' i.e. 31-12-2003
'd m y' i.e. 31-12-03
'Y m d' i.e. 2003-12-31
'y m d' i.e. 03-12-31
'd F Y' i.e. 31 December 2003
'd F y' i.e. 31 December 03
'd M Y' i.e. 31-12-2003
'd M y' i.e. 31-12-03
'F d Y' i.e. December 31 2003
'F d y' i.e. December 31 03
'l d F Y' i.e. Monday 31 December 2003
'l d F y' i.e. Monday 31 December 03
'l d M Y' i.e. Monday 31 12 2003
'l d M y' i.e. Monday 31 12 03
'm d Y H i s' i.e. 12-31-2003 22:50:23
'm d Y h i s a' i.e. 12-31-2003 10:50:23 pm
'm d Y H i' i.e. 12-31-2003 22:50
'm d Y h i a' i.e. 12-31-2003 10:50 pm
'm d y H i s' i.e. 12-31-03 22:50:23
'm d y h i s a' i.e. 12-31-03 10:50:23 pm
'm d y H i' i.e. 12-31-03 22:50
'm d y h i a' i.e. 12-31-03 10:50 pm
'd m Y H i s' i.e. 31-12-2003 22:50:23
'd m Y h i s a' i.e. 31-12-2003 10:50:23 pm
'd m Y H i' i.e. 31-12-2003 22:50
'd m Y h i a' i.e. 31-12-2003 10:50 pm
'd m y H i s' i.e. 31-12-2003 22:50:23
'd m y h i s a' i.e. 31-12-03 10:50:23 pm
'd m y H i' i.e. 31-12-03 22:50
'd m y h i a' i.e. 31-12-03 10:50 pm
'Y m d H i s' i.e. 2003-12-31 22:50:23
'Y m d h i s a' i.e. 2003-12-31 10:50:23 pm
'Y m d H i' i.e. 2003-12-31 22:50
'Y m d H i O' i.e. 2003-12-31 22:50 +0000
'Y m d h i a' i.e. 2003-12-31 10:50 pm
'y m d H i s' i.e. 2003-12-31 22:50:23
'y m d h i s a' i.e. 2003-12-31 10:50:23 pm
'y m d H i' i.e. 2003-12-31 22:50
'y m d H i a' i.e. 2003-12-31 22:50 pm
'D d M Y H i s O' i.e. Mon 31-12-2003 22:50 23 +0000

A quantitative Time-series MisoData needs a year to work properly, so by default we add the current year to your file.

If you get an error message when you attempt to upload your file, please review the possible changes you may need to make to you file for it to work correctly.

Feedback and Knowledge Base