Extracting datas based on date from two datasets

2 次查看（过去 30 天）

Sonisa 2016-9-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305074-extracting-datas-based-on-date-from-two-datasets

评论： mizuki 2016-10-2

I have two set sets of data where one is 93*2 and other is 609*2. I want to match up the date and extract two different sets of data based on that date. I try this way,

%Retrieve unique sampling period
period = unique(date_LFMC,'rows');
%Build subs for accumarray
[~, subs] = ismember(date_LFMC, period, 'rows');
%Perform accumarray to average FMC
LFMC_avg = period; 
LFMC_avg(:,2) = accumarray(subs, Livemoisture_JFSP,[],@nanmean); % 93*2 
%Retrieve unique date
period = unique(DateSM,'rows');
%Build subs for accumarray
[~, subs] = ismember(DateSM, period, 'rows');%609*2 
%Perform accumarray to calculate average FAW
FAW_avg = period; 
FAW_avg(:,2) = accumarray(subs, FAW40,[],@nanmean);
%Assign FAW to each LFMC sample
Data_avg(:,4) = LFMC_avg(:,2);
for i = 1:size(LFMC_avg,1);
    for i2 = 1:size(FAW_avg,1)
        if Data_avg(i,2) == FAW_avg(i2,1);
            Data_avg(i,4) = FAW_avg(i2,2);
        end
    end
end

I get one sets of data but with another, I am just getting zero. let me know where I did wrong?

Sonisa

4 个评论
显示 2更早的评论隐藏 2更早的评论

dpb 2016-9-29

Have you used the debugger and stepped through your script to see where it goes wrong? Do so and report the symptoms; don't rely on somebody else to do all your debugging for you...