Select table data by Date

2 次查看（过去 30 天）
Inna Pelloso
Inna Pelloso 2021-10-28
编辑： C B 2021-10-28
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

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

采纳的回答

C B
C B 2021-10-28
编辑：C B 2021-10-28
Ran in:
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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by