mario.Database.calc_trades_content#

db.calc_trades_content(...) calculates the indicator content embodied in region-by-region trade.

Accepted indicator values are:

  • one row from Satellite account

  • one row from Factor of production

  • "total value added"

Use method='direct' for direct coefficients only, 'total' for direct plus upstream effects, or 'upstream' for the indirect share only.

Use breakdown=True to return contributor-level content tables instead of a collapsed Region-by-Region total. In that case MARIO keeps the trade pair while decomposing the content across the contributing production nodes. Summing the breakdown over contributor levels reconstructs the corresponding collapsed db.calc_trades_content(...) result for the same method.

For IOT tables, MARIO uses e and v for direct content, and f and m for total content. With breakdown=True, MARIO uses the direct row itself for method='direct' and the exploded matrices f_ex or m_ex for 'total' and 'upstream'.

For Isard SUT tables, MARIO uses commodity-side coefficients and multipliers: ec and vc for direct content, and fc and mc for total content. With breakdown=True, MARIO uses commodity-side exploded totals built from fc_ex and mc_ex.

For Chenery-Moses SUT tables, commodity trade is aggregated from S and the content weights are taken from the activity side instead: ea and va for direct content, and fa and ma for total content. Because that trade is stored as one supply-side flow matrix, MARIO currently supports only the aggregate case with intermediate=True, final=True and aggregate=True.

item, scenario, clusters, clusters_direction, intermediate, final, aggregate and total behave like they do in db.calc_trades(...).

When breakdown=True, Region clustering still applies to the trade axes, but plotting and total=True are not currently supported.

Use show_plot=True to also build and display a region-by-region heatmap while still returning the trade-content matrix.

When more than one scenario is plotted together, MARIO builds one animated heatmap with a scenario slider.

Use save_plot=... to write that heatmap to HTML or image files. The older path=... argument is still accepted as a backward-compatible alias. When save_plot is provided, MARIO saves the plot without displaying it.

Use title=... to override the heatmap title. The heatmap colorbar uses the unit of the selected indicator.

Database.calc_trades_content(indicator, item=None, scenario='baseline', method='total', breakdown=False, clusters=None, clusters_direction='both', intermediate=True, final=True, aggregate=True, total=False, show_plot=False, save_plot=None, path=False, auto_open=False, title=None)#

Calculate region-by-region embodied trade content for one indicator.

Parameters:

  • indicator – Satellite-account row, factor-of-production row, or "total value added".

  • item – Sector or commodity label to aggregate by region. When omitted, MARIO aggregates all sectors or commodities only if they share one common unit of measure.

  • scenario – Scenario to analyse.

  • method – Trade-content accounting mode. Use "direct" for direct coefficients only, "total" for direct plus upstream effects, or "upstream" for the indirect share only.

  • breakdown – When True, return a contributor-level decomposition instead of collapsing all contributors into one region-by-region total. The rows then carry a MultiIndex (origin region, contributor...).

  • clusters – Optional Region aggregation preset or mapping applied before totals.

  • clusters_direction – Select which axis should receive Region aggregation when clusters is provided. Use "origin" to aggregate only rows, "destination" to aggregate only columns, or "both" for the default square aggregation.

  • intermediate – When True, include intermediate transactions. This uses Z for IOT tables and U for SUT tables.

  • final – When True, include final-demand transactions. This uses Y for IOT tables and Yc for SUT tables.

  • aggregate – When True and both intermediate and final are enabled, return their sum as one trade-content matrix. Use aggregate=False to keep the two components separate.

  • total – When True, add a Total row and a Total column.

  • show_plot – When True, build and display a region-by-region heatmap for the calculated trade content.

  • save_plot – Optional HTML or image output path for the heatmap. When provided, MARIO writes the plot to this path.

  • path – Backward-compatible alias for save_plot.

  • auto_open – When True, automatically open the saved heatmap HTML.

  • title – Optional title for the heatmap.

Returns:

Region-by-region trade-content matrix for one scenario, or a dictionary {scenario: matrix} when more than one scenario is requested. With breakdown=True, MARIO returns contributor-level content tables instead of collapsed trade totals.

Return type:

pandas.DataFrame | dict