Plot editor function

The user can start the plot editor on the project page with organization admin or organization member access:

Open

Possible source types

• Project metadata

• Custom source:

  • CSV

  • TSV

  • Parquet

Plot types

The plot type depends on the selected column types.    

1. If X column type is numeric:

   1. If Y column is None then the plot is a column, bar, pie, line, or area chart, with counts, possibly colored.

   2. If Y column is numeric then the plot is a scatter plot, possibly colored.

   3. If Y column is categorical then the plot is a horizontal boxplot, possibly colored.

2.  If X column type is categorical:

   1. If Y column is numeric then the plot is a vertical boxplot, possibly colored.

   2. If Y column is categorical then the plot is a heatmap.

      1. If Color column is None then the heatmap is colored by counts.

      2. If Color column is numeric then the heatmap is colored by col_color.

      3. If Color column is categorical then an error is raised.

   3. If Y column is None then the plot is a column, bar, pie, line, or area chart with counts, possibly colored.   

3. If X column type is date/datetime

   1. If Y column is None then the plot is a column, bar, pie, line, or area chart, with counts, possibly colored.

   2. If Y column is numeric then the plot is a vertical boxplot, possibly colored.

   3. If Y column is categorical then the plot is a heatmap.

4. If X column type is neither numeric nor categorical nor date/datetime then an error is raised.

Scatter plot

Open

Horizontal boxplot

Vertical boxplot

Bar chart

Heatmap

Pie chart

Line chart

Area chart

Bar chart

Stacked bar chart

Column types

The metadata columns will be categorized based on these criteria:

Possible column types:

Numeric

According to these criteria:

1. The column can be converted into float

2. The column has at least 3 unique values

3. The column has at least 10% of the rows with a value that is not null

Categorical

According to these criteria:

1. The column can be converted into string

2. The column has less than 20 unique values

3. The column has at least 2 unique values

4. The column has at least 10% of the rows with a value that is not null

5. The column is not a numeric

Date/Datetime

According to these criteria:

1. Dates and datetimes should have the following format: YYYY./-MM./-DD and DD./-MM./-YYYY HH:MM:SS