How can I extract a specific row from a table?

Hi all!

Suppose I have a table with two column (i.e., Date and Temperature) like this -

Please note that every date has multiple temperature assign to it. Now, I have another array that has three dates -

How can I extract these three days from the previous table with all the associated temperature? I mean, I want a matrix that will have these three dates with all the temperatures. Thus, 9 columns.

I have attached the DateToFind.mat file in this question. Can any one please help?

Answer 1

[Voss]

load DateToFind

result = T(ismember(T.Date,Date_to_find),:)

result = 9×2 table
        Date        Temperature
    ____________    ___________

    {'1/1/2021'}         1     
    {'1/1/2021'}         2     
    {'1/1/2021'}         3     
    {'4/1/2021'}        10     
    {'4/1/2021'}        11     
    {'4/1/2021'}        12     
    {'5/1/2021'}        13     
    {'5/1/2021'}        14     
    {'5/1/2021'}        15     

Then, if you want those temperatures in a matrix with 9 columns:

result = result.Temperature.'

result = 1×9

1 2 3 10 11 12 13 14 15

[Ashfaq Ahmed]

Hi @Voss ! Yes, that helps! Thanks a ton.

[Voss]

You're welcome!