Stock data processing
Outline of the video
- First show you how you can start to work on a file and then discuss in which format the data needs to be.
- Example: Buildings by building material 1960-2019 in Finland
- The stock data processing template has 8 columns. Going through them one by one to explain what they are.
- Different from the flow data processing is that start and end date columns aren’t there. This is because those aren’t needed for stock, as it stays for more than a year in the system.
- Back to the example, formatting the data after copying it from the source.
- Unfortunately the unit is not in tonnes, but instead buildings in numbers.
- We will just use it to show how the data can be arranged based on the info from the source.
- This is an example of a chaotic file. In this case, it is best to go to the original source and try to get the comma separated values in a better shape. However, in this case the source does not exist or is not given, which underlines the importance of providing it, always.
- Rather unusual “stock” example to demonstrate the processing, dairy products.
- The “Type of dairy product” column can be used as segments.
- And as always, correct EMP codes need to be looked up.