stack data from excel
Posted: Tue Mar 10, 2015 1:57 am
hi,
i have a lot of data in excel format, in each sheet one variable across 230 individuals, for 82 variables (so 82 sheets).
I need to reshape these data into one big panel, stacking the data. Currently i'm trying to use pagestack but i don't manage to make it work.
So here is what i am doing:
first i import the data, putting a variable in each page:
pageload(page=x_11350) "data.xlsx" range="x_11350"
pageload(page=x_11110) "data.xlsx" range="x_11110"
and the workfile looks like the attached. Now i would have to import 82 pages and then stack them across the ids (b1, b2, etc). and with each series having the X_11350 etch name, Ideally in one new page.... not sure i'm being clear.
If you have any other ideas as to to how solve this problem, i would be very greatful.
Many thanks
Michela
i have a lot of data in excel format, in each sheet one variable across 230 individuals, for 82 variables (so 82 sheets).
I need to reshape these data into one big panel, stacking the data. Currently i'm trying to use pagestack but i don't manage to make it work.
So here is what i am doing:
first i import the data, putting a variable in each page:
pageload(page=x_11350) "data.xlsx" range="x_11350"
pageload(page=x_11110) "data.xlsx" range="x_11110"
and the workfile looks like the attached. Now i would have to import 82 pages and then stack them across the ids (b1, b2, etc). and with each series having the X_11350 etch name, Ideally in one new page.... not sure i'm being clear.
If you have any other ideas as to to how solve this problem, i would be very greatful.
Many thanks
Michela