The following line is causing inconsistencies between the sector names from the concordance excel file (productTaypeName) and the filtered sector_of_IO list. this is because there are sector names that have brackets with numbers and brakcets without. The split function cuases the issue. E.g:
"Wood and products of wood and cork (except furniture); articles of straw and plaiting materials (20)"
becomes:
"Wood and products of wood and cork"
can be fixed by replacing the following line:
cleaning up exiobase sector names
[i.split(' (')[0] if re.findall(r'\d', i) else i for i in self.sectors_of_IO]
with:
cleaning up exiobase sector names
self.sectors_of_IO = [re.sub(r' (\d\d)', '', i) for i in self.sectors_of_IO]
The following line is causing inconsistencies between the sector names from the concordance excel file (productTaypeName) and the filtered sector_of_IO list. this is because there are sector names that have brackets with numbers and brakcets without. The split function cuases the issue. E.g:
"Wood and products of wood and cork (except furniture); articles of straw and plaiting materials (20)" becomes: "Wood and products of wood and cork"
can be fixed by replacing the following line:
cleaning up exiobase sector names
[i.split(' (')[0] if re.findall(r'\d', i) else i for i in self.sectors_of_IO]
with:
cleaning up exiobase sector names
self.sectors_of_IO = [re.sub(r' (\d\d)', '', i) for i in self.sectors_of_IO]