Datasets
To get more information about datasets and how to explore them click here.
Creating a dataset
To create a dataset you need to upload a CSV following certain rules. This process will be entirely from the Dataset Editor view. You can access it from the Front-end or by clicking here.
If you access from the Front-end, you need to choose the repository in which you are going to be uploading data. In this case, it is "My Public Repo". Then, you click on the blue button that says "Upload CSV". Now, you will be redirected to the Dataset Editor view. The data that you want to upload needs to follow this structure (we will make this more flexible in the future):
- First column should be country. You can put anything there, but if you put countries they can be used in the maps engine.
- Second column should be year, on the format YYYY-MM-DD. Both country and year are mandatory and the pair should not be repeated.
- Then one column for each variable.
Once you upload the CSV file, you can select the target repository, the name of the dataset, and pair each variable from the file to a variable name in the Dataset.
Transformations
When exploring a dataset, you can see the list of transformations made to it. We call transformations to data that has been modified in order to make comparisons, make it more useful and more.
The most common ones in economics and finances are:
- Seasonally adjusted: a statistical technique that attempts to measure and remove the influences of predictable seasonal patterns. When it says sa_orig, it means we did not make to transformation, we took it from the source.
- Constant prices: a way of measuring the real change in output. A year is chosen as the base year.
- Cumulative sum: used to display the total sum of data as it grows with time. It could be 3 months or 12 months, for example.
- Year over Year/Month over Month: comparisons between figures according to chosen frecuency.
- % GDP: enabling a ratio in order to make comparisons.
