Reshape matrix (panel data)
显示 更早的评论
I have a matrix with N individual stocks with up to T observations each. The matrix has four columns: column one describes time, ranging from 1:T, column two describes the individual from 1 to N, column three describes weight of individual i at time t, and column four describes price of individual i at time t. (The data is downloaded from CRSP into Stata, but I'd like to apply MatLab for the next step of the analysis)
The thing is that not all individuals has observations from 1 through T, but may start at t=10, or end at t=T-k (for some number k).
If I had observations for all individual at all times, I would've used B=reshape(data,T,4*N).
Does anybody have any suggestion for how to deal with this problem?
2 个评论
Azzi Abdelmalek
2013-11-5
To make your question clear, just give a numeric example, and show what you are expecting as result. It's not important to know if your variable is a speed or a flow.
Thomas Leirvik
2013-11-5
采纳的回答
Kelly Kearney
2013-11-5
0 个投票
3 个评论
Thomas Leirvik
2013-11-5
Kelly Kearney
2013-11-5
Using your example from above:
a = [1 1 0.5 3; 2 1 0.25 2; 1 2 0.5 10; 2 2 0.5 11; 2 3 0.25 6];
[row, col, price] = vec2grid(a(:,[1 2 4]));
[row, col, weight] = vec2grid(a(:,[1 2 3]));
>> [weight price]
ans =
Columns 1 through 5
0.5 0.5 NaN 3 10
0.25 0.5 0.25 2 11
Column 6
NaN
6
Looks like your B, except using NaN instead of 0 as a placeholder, which is a quick fix.
B = [weight price];
B(isnan(B)) = 0;
Thomas Leirvik
2013-11-5
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
