Efficiently copying values from one table two another in which unique values are columns

Question

Clemens Gersch 2020-3-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513848-efficiently-copying-values-from-one-table-two-another-in-which-unique-values-are-columns

评论： Clemens Gersch 2020-3-30

采纳的回答： Mohammad Sami

AB.mat

在 MATLAB Online 中打开

Hi,

I have a file attached that contains two tables A and B. I would like to put the values from A.volatility into the right column in B. The right column would be the one that has the same number as A.days.

The tricky thing is that for some dates, there is a value for days missing. For instance, there is no combination of '1996-01-04' and 14 days in A. Such missing values should lead to NaN in B.

Right now, I am using two for loops. One that iterates through the Rows of A, one that iterates through the columns of B. That makes the code very slow as my real dataset is much much bigger and I think those two for loops cannot be the most efficient way.

load AB.mat
% Get vector of unique days in B
uniquedays = unique(B.days);
for i=1:size(A,1)
    % Filter B for only rows that have same date as ith row in A
    Row = B(B.date == A.date(i),:);
    for j=2:size(A,1)
	% Find position of fitting value that has same days
        idx = (Row.days == uniquedays(j-1));
        switch sum(idx)
            case 0
                B{i,j} = nan;
            case 1
                B{i,j} = Row.volatility(idx);
            otherwise
                error('blabla');
        end
    end
end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Mohammad Sami 2020-3-30

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513848-efficiently-copying-values-from-one-table-two-another-in-which-unique-values-are-columns#answer_422764

编辑：Mohammad Sami 2020-3-30

在 MATLAB Online 中打开

C = unstack(B,'volatility','days');

The function unstack will do exactly what you are trying to do.

The first column would be all unique date, then there would be columns for every unique days in the table B, containing the value of volatility and NaN if there was no such combination.