How to match two matrices based on two keys?

Question

Mohamed Nedal 2020-1-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/499712-how-to-match-two-matrices-based-on-two-keys

回答： Hiro Yoshino 2020-1-10

matlab.mat

在 MATLAB Online 中打开

Hello everyone,

Kindly find the attached file. I would like to know how to match these matrices based on two keys rather than one key?

I tried this code and for only one key (time).

xCOL = {'DOY','UT','lat','long'}; 
yCOL = {'DOY','UT','pf_30Mev','pf_60Mev'}; 
for i = 1:length(X) 
    X = array2table(X,'VariableNames',xCOL); 
    Y = array2table(Y,'VariableNames',yCOL); 
    output = innerjoin(X,Y,'LeftKeys','UT','RightKeys','Hour'); 
    writetable(output, 'Matched.xlsx', 'Sheet', i); 
end 

The 1st column represents the day of year (DOY) and the 2nd column represents the time in hours.

I want to find the rows at which both the day and time of X and Y are the same.

Can you please tell me how?

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

请先登录，再进行评论。

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

Answer 1

Hiro Yoshino 2020-1-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/499712-how-to-match-two-matrices-based-on-two-keys#answer_409534

在 MATLAB Online 中打开

You should read this first of all.

The script below worked for me where "DOY" and "UT" were used as keys:

load("matlab.mat");
xCOL = {'DOY','UT','lat','long'}; 
yCOL = {'DOY','UT','pf_30Mev','pf_60Mev'}; 
X = array2table(X,'VariableNames',xCOL); 
Y = array2table(Y,'VariableNames',yCOL); 
output = innerjoin(X, Y,'Keys',[1 2]);