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.