From stacked data to time series
Posted: Mon Sep 26, 2016 3:13 am
Hello,
I've imported the dataset http://data.ssb.no/api/v0/dataset/166324.csv?lang=no as stacked data, and since there are four variables they get the cross-section id's 1 to 4. I want to split these four series into four time series with individual names, and therefore I have two questions:
1. How do you change the crossid names from 1-4 to string variable names (as in a pooled data set I saw in this forum they GDP variable was divided into FRA, ENG etc)?
2. Is it possible to divide the stacked data into four series with individual names?
Thank you in advance for any help or guidance.
Regards,
Kari
I've imported the dataset http://data.ssb.no/api/v0/dataset/166324.csv?lang=no as stacked data, and since there are four variables they get the cross-section id's 1 to 4. I want to split these four series into four time series with individual names, and therefore I have two questions:
1. How do you change the crossid names from 1-4 to string variable names (as in a pooled data set I saw in this forum they GDP variable was divided into FRA, ENG etc)?
2. Is it possible to divide the stacked data into four series with individual names?
Thank you in advance for any help or guidance.
Regards,
Kari