How can I extract a specific row from a table?

6 views (last 30 days)
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?

Accepted Answer

Voss
Voss on 6 Feb 2023
Edited: Voss on 6 Feb 2023
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

More Answers (0)

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!