How to extract data from one column using the data from the two other columns

Question

Claire 2020-12-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/676733-how-to-extract-data-from-one-column-using-the-data-from-the-two-other-columns

评论： dpb 2020-12-4

I have data with 3 columns, A B and C. A contains serial dates, and B contains data that corresponds to the serial date in column A. in column C, I have a much shorter column of select serial dates that I have to have the correspoding data for from column B. Is there a way to use column C to search column B and extract only the data that corresponds to the dates in column C?

Column A is all of the serial dates, column B is the soil moisture retrieved on that serial date in column A, and column C are the select serial dates that I need column B values for; so I want to be able to make an array of the column B values that correspond to the selected column C serial dates.

I have having problems putting this question into words properly, so if I was unclear i apologize and I can try to elaborate. Thank you!

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

请先登录，再进行评论。

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

Answer 1

dpb 2020-12-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/676733-how-to-extract-data-from-one-column-using-the-data-from-the-two-other-columns#answer_564653

在 MATLAB Online 中打开

res=B(ismember(A,C));

2 个评论
显示无隐藏无

Claire 2020-12-4

编辑：Claire 2020-12-4

Hello, thanks for your help! this worked, but it returned far less values than i expected

i think it is only when the rows of A and C are adjacent and equal each other. in column C, i am missing a lot of datetimes that are present in A, so the datetimes in C are not organized or aligned with column A. sorry for not being clear about that!

is it possible to do this same process, but with any values of C that match those in A, regardless of whether or not the same dates are in the same row?