Skip to content

Workflow Overview

PyIndexGUI enforces a strict, sequential data pipeline. Each tab consumes the output of the previous one, so you generally work left-to-right:

flowchart LR
    A[Data Import] --> B[Aggregation]
    B --> C[Panel Balancing]
    C --> D[Index Calculation]
    D --> E[Export]
Step Tab Purpose
1 Data Import Load a file, map columns, standardize types.
2 Aggregation Collapse observations into regular time periods.
3 Panel Balancing Build a complete, balanced product-period panel.
4 Index Calculation Compute bilateral and/or multilateral indices.
5 Export Save results to CSV or Excel.

Tab navigation & prerequisites

Tabs are gated: you cannot move to a later stage until its predecessor has produced output. For example:

  • You cannot Aggregate until columns have been standardized.
  • You cannot compute Indices until the panel has been balanced.
  • You cannot Export until at least one index has been calculated.

If you re-run an earlier step (e.g. re-standardize with a different mapping), all downstream results are automatically invalidated and you must repeat the affected steps.

The Info tab is always available

The Info tab has no prerequisites — you can open it at any time, even on a fresh launch with no data loaded.