Pyplan is a No-code / Low-code platform designed for users with no programming knowledge, so it allows many data manipulation and processing tasks without coding.
One of Pyplan’s objectives is to provide transparency to the calculation logic, allowing not only to navigate through the calculation process to conceptually understand its flow, but also to select to execute and visualize the results of each step. This visualization can be in the form of a table or a graph.
When navigating the influence diagram you can select any node, execute it and visualize its result.
By clicking on the green node with the title “Data” we will see the following:
To run the node, click on the evaluation icon indicated in the video. After the node is executed, a table will appear as shown in the video
Maximize the table to fully utilize screen space. This is especially useful for handling large datasets or detailed information.
We access the fields of this data table
Where we can see each field and measure of the Table, the type of field (Numeric # or Text T), and the grouping function that will be executed if necessary (Sum, Max, Min, Average or Count).
By dragging the “Years” field to the columns box and after defining the Average as the aggregation function of the “atp ranking” field, drag it to the “Measures” box, we will obtain a table as shown in the following image:
This table describes the evolution over time of the average annual ranking of “Roger Federer”. Any field can be displayed as a Column or Row causing the grouping of the corresponding displayed measures.
Clicking on settings displays the data table formatting alternatives. They are grouped into: General, Data, Styles, Index sync and Scenarios.
The reader can investigate the configuration options grouped under General and Data on their own.
The Styles section groups table style configurations with a particular behavior that provides flexibility and consists of the following:
A first section headed by “Apply to” indicates the target of the configuration set below. By default this target is “All” which means that whatever is set below will apply to the entire table. In this particular case we could set with the integer format to the whole table.
In the same way we could establish a particular format for a specific condition of some dimension. In this case, for example, define with green background the results that correspond to the “Grass” surface.
It is possible to establish formats based on particular conditions of the table values. To do so, the conditions and formatting must be added as shown
The option to format the table with a heatmap appears by scrolling down among the style options.
The table display with a Progress Bar format can be configured as shown in the figure below:
Clicking on the graph section switches the view from table to chart. Whenever the selected chart type allows it, Pyplan automatically assigns fields from the table to the chart.
There are multiple types of graphs that can be configured as alternatives for data visualization as shown in the following figure. Each type of chart has its sub-types and depending on this choice, the properties that must be indicated to allow the construction of the chart are defined.
Pyplan allows through the user interface the configuration of the most frequently used parameters of each type of chart. However, there are many other chart properties that can be defined from the code of each display element.
To access customizing the visualization code, you must click on the icon and then choose Show component code.
Once this is done, and after moving the Code switch from Default to Custom, we can start modifying the behavior code of the graphical display.
A complete guide to the configurable properties of each plot can be found here: Plotly Express Documentation