Outline of the video

• Focusing on an example in the biomass sector in Porto
• example: Hectares of agricultural area used in Porto by Composition of the agricultural surface area used. This example is a bit too broad to showcase.
• other example: Hectares of permanent crops in Porto by Type
• Clean up the file: unmerge cells, remove columns that don’t have any information. Note: If you do these types of actions, you can refer in the processing section of data quality that there are more data on other types of crops, but that there are no production values for them or that they were 0 in that year.
• Conversion from hectare to tonnes, for which we need the yield in Porto or in Portugal in general
• M8:44, FAO data section
• M10:18, convert the CSV data into columns
• FAO recorded this yield data for almonds and grapes in hg/ha, hectograms per hectare (100 grams)
• The mass in kg can then be derived from the hectare values that exist for Porto.

Note: Actually the wrong code was used for almonds. Although you can also make almond oil, they are NOT oil-bearing crops, but instead considered nuts, see here.
If you are unsure about what a material is considered as and grouped under, then you can always check the FAO grouping, which was also used for the flow diagrams.