Worksheet

The Worksheet is a simple 2D dataframe-type structure for holding data for graphing. Essentially it comprises one or more named Series of data, each of which has any number of numerically-indexed data points.

The structure is similar to that accepted by most common graphing tools, and to dataframe formats e.g. from numpy.

Each Series has a label, and optionally a color. Each data point index optionally has a label and/or a color.

AWTS parses CSV data into Worksheet form in both the CLI tool and in the dashboard modules. The CLI tool and API endpoints all accept CSV data and/or structured worksheet data in serialized JSON form.

The examples below list structural forms for worksheet data that can be successfully parsed.

The general principle is that CSV structures should parse intuitively, such that the data should be easy to produce by your automations and result in the 'obvious' choice for graphing structure.

Where there is ambiguity (e.g. in the case of multiple series, with both series and datapoint labels), the longer dimension is chosen as the series. I.e. if there are 10 rows and 5 columns when the Series will be chosen vertically.

CSV structures

Vertical

The vertical form is most similar to pandas-style dataframes. It parses to a single Series of data points. The header row is optional, and if present is used as a label for the Series.

Data
1
3
5
2
3
1
6
3
1

Horizontal

Horizontally oriented data is also accepted, and also parses to a single Series of multiple data points.

Data,1,3,5,2,3,1,6,3,1,3,4,5,1,1

Double-vertical

SPX,NQ
23,21
24,22
26,20
29,24
26,22

Double-horizontal

SPX,23,25,22,20,25,27
NQ,19,22,23,26,23,24

With data point labels

Horizontal

,Jan,Feb,Mar,Apr,May,Jun
SPX,23,25,22,20,25,27
NQ,19,22,23,26,23,24

Vertical

,SPX,NQ
Jan,23,21
Feb,24,22
Mar,26,20
Apr,29,24
May,26,22