Ismember as a condition?

Question

Daphne PARLIARI 2020-1-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502745-ismember-as-a-condition

评论： Daphne PARLIARI 2020-1-30

Hello guys.

I am trying to achieve something easy I think, but I don't know the correct way.

I have two tables, let's say WRF and Obs, that contain hourly values of several variables. What I want to do is calculate things and produce graphs, for the dates that both tables have data.

Eg, WRF contains data from 1/7/2019 to 30/9/2019 and Obs from 31/3/2019 to 30/9/2019.

I tried

ismatch = ismember(Obs.Hourly_DATE, WRF.Date);

which returns 0s kai 1s. How do I take one step further and use the 1s to calculate the things I want?

Thank you in advance!

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

Mohammad Sami 2020-1-30

编辑：Mohammad Sami 2020-1-30

Ok the innerjoin should then correctly merge the two tables together on the common datetime values. Do verify the newtable created before using it further.

Daphne PARLIARI 2020-1-30

编辑：Daphne PARLIARI 2020-1-30

Something goes wrong... Attached please find the Obs table, the WRF table and newtable.

Newtable is far too long. I think the problem is that I have to consider columns Time, also (for both tables, WRF and Obs).

请先登录，再进行评论。

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

Answer 1

Mohammad Sami 2020-1-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502745-ismember-as-a-condition#answer_412823

在 MATLAB Online 中打开

Yes needed to combine with the time column.

load Obs.mat
load WRF.mat
WRF_Data.Date = WRF_Data.Date + duration(hour(WRF_Data.Time),minute(WRF_Data.Time),0)
Obs_Data.Hourly_DATE + duration(string(Obs_Data.Time),'InputFormat','hh:mm');
newtable = innerjoin(Obs_Data,WRF_Data,'LeftKeys','Hourly_DATE','RightKeys','Date');

2 个评论
显示无隐藏无

Daphne PARLIARI 2020-1-30

Works fine with a mistake though:

In newtable, column Time_WRF_Data is in datetime format and it appears 00:00 in all rows....

Daphne PARLIARI 2020-1-30

在 MATLAB Online 中打开

The mistake I mentioned above is easily corrected this way:

WRF_Data.Date = WRF_Data.Date + duration(hour(WRF_Data.Time),minute(WRF_Data.Time),0);
Obs_Data.Hourly_DATE = Obs_Data.Hourly_DATE + duration(string(Obs_Data.Time),'InputFormat','hh:mm');
All_Data = innerjoin(Obs_Data,WRF_Data,'LeftKeys','Hourly_DATE','RightKeys','Date');