Clear Filters
Clear Filters

Select table data by Date

5 views (last 30 days)
Inna Pelloso
Inna Pelloso on 28 Oct 2021
Edited: C B on 28 Oct 2021
Hi,
I have a table, where the frist column is the date, and second column is a variable.
''2021-Jan-04'' -0.1581
''2021-Jan-04'' 0.0692
''2021-Jan-04'' 0
''2021-Jan-05'' -0.5150
''2021-Jan-05'' 0.2119
How can I select data in the second columb, by the date in the first colume?
Any help would be appreciated!
Inna

Accepted Answer

C B
C B on 28 Oct 2021
Edited: C B on 28 Oct 2021
dates = [datetime('today'); datetime('Yesterday') ;datetime('tomorrow')];
data = [-0.1 ; 0 ;0.1];
T = table(dates,data)
T = 3×2 table
dates data ___________ ____ 28-Oct-2021 -0.1 27-Oct-2021 0 29-Oct-2021 0.1
FindDate = '27-Oct-2021';
[val,index] = min(abs((datenum(T.dates)-datenum(FindDate))));
T.data(index)
ans = 0
FindDate = '29-Oct-2021';
[val,index] = min(abs((datenum(T.dates)-datenum(FindDate))));
T.data(index)
ans = 0.1000
FindDate = '28-Oct-2021';
[val,index] = min(abs((datenum(T.dates)-datenum(FindDate))));
T.data(index)
ans = -0.1000

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!