Compare the migration table of a value between two datasets.
Generate a standard waterfall chart between two datasets.
| name | optional | description |
|---|---|---|
| input | ❎ | structured data in one of the supported file formats: xlsx, csv, shp (ESRI Shape) |
| key | ☑️ | (see notes) field(s) unique to each record. If left blank, the row index will be used. Usually used when comparing block models by blockid. |
| group | ❎ | the field which will be used to create the migration groups. Usually the lithology. |
| value | ☑️ | the sum field for the table. If blank the table will be a count of records. Usually length or volume. |
| condition | ❎ | python syntax expression to restrict both datasets. Ex.: length >= 4.0. Usually left blank. |
| output_matrix | ☑️ | path to save the migration matrix in xlsx format. |
| output_records | ☑️ | path to save a raw table with all matched records. Usefull to debug. Usually left blank. |
If both datasets do not have the same number of records, the key parameter will be required.
In case of block models, the script bm_flag_ijk can be used to create a suitable key.
| distribution | status |
|---|---|
 |
✔ |
 |
✔ |
 |
❌ |
Any question or problem contact:
- paulo.ernesto
Apache 2.0
Copyright 
Vale 2023