Format of time series data

You can import time series data into Dataiku DSS in one of two formats:

  • Wide format
  • Long format

Wide format

Time series data is in wide format if you have multiple time series and each distinct time series is in a separate column.

For example, given airline data from the U.S. International Air Passenger and Freight Statistics Report, the dataset consists of data for two air carrier groups — U.S. domestic air carriers and foreign air carriers. This data can be represented in wide format if you have one column representing data for each group (for example, the total number of passengers).

Furthermore, if each time series in this data has multiple dimensions (such as the total number of passengers and the number of passengers carried by charter flights), then you have multiple multivariate time series data. The following figure shows a snippet of this data in wide format.

../_images/timeseries2_wide.png

Long format

Long format is a compact way of representing multiple time series. In long format, values from distinct time series or from different dimensions of the same time series can be stored in the same column. Data in the long format also has an identifier column that provides context for the value in each row.

More commonly, values of the same variable from distinct time series are stored in the same column. Consider the previous example of multiple multivariate time series, the following figure shows a snippet of the data in long format. Notice that the carriergroup column acts as the identifier column for each time series in the data.

../_images/timeseries2_long.png

More generally, any data can be represented with only three columns: one for the timestamp, one for the identifier, and one for values. Applying this convention to the airline data, the identifier (carriergroup) would take one of these four values: charter_foreign, total_foreign, charter_domestic, and total_domestic.

Data conversion

Convert data from long to wide format by using the Pivot processor.

Convert data from wide to long format by using the Fold multiple columns processor or the Fold multiple columns by pattern processor.

The Reshaping Data from Long to Wide Format tutorial shows how to convert data from one format to another.