cant find import data

[ElvisKwameOfori123]

I dont know if it logical to calculate it and which approach to use

Extract the exports data (total fob) for different regions (which will be imports to other regions)

Y matrix provides final demand, which includes exports from one region to another.

Imports to EU (Exports from ROW to EU)

imports_eu = Y.loc[rest_of_world, 'Exports: Total (fob)'][eu_regions].sum()

Imports to Ireland (Exports from ROW and EU to Ireland)

imports_ie = Y.loc[rest_of_world + eu_regions, 'Exports: Total (fob)'][['IE']].sum()

Imports to ROW (Exports from EU and Ireland to ROW)

imports_row = Y.loc[eu_regions + ['IE'], 'Exports: Total (fob)'][rest_of_world].sum()

Print the imports

print("Total Imports for EU (fob):", imports_eu)
print("Total Imports for Ireland (fob):", imports_ie)
print("Total Imports for Rest of the World (fob):", imports_row)

or this

Get total domestic production (Z matrix provides inter-sectoral supply)

domestic_production = exio3.Z.sum(axis=1)

Get exports from region to other regions (Y matrix provides final demand, including exports)

exports = exio3.Y.loc[region, 'Exports: Total (fob)']

Get domestic final demand (household consumption, government spending, etc.)

domestic_demand = exio3.Y.loc[region, ['Final consumption expenditure by households', 'Final consumption expenditure by government']].sum(axis=1)

Calculate imports for the region

derived_imports = domestic_production - domestic_demand - exports

print("Derived Imports for the region:", derived_imports)