How to combine columns from large dataset to datetime with correct vector or doublestring?

Question

Callie 2023-11-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2046030-how-to-combine-columns-from-large-dataset-to-datetime-with-correct-vector-or-doublestring

评论： Star Strider 2023-11-12

I am trying to combine date and time so that I can plot discharge over time. Year, month, day, and hour (in minutes) are in different columns. I have tried several this including

Date=datetime(dataTable(:,3:5))+hours(data(:,8));

and get errors. For this it says

Input data must be a numeric array, a string array, a cell array containing character vectors, or a char matrix.

Any suggestions?

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2023-11-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2046030-how-to-combine-columns-from-large-dataset-to-datetime-with-correct-vector-or-doublestring#answer_1351150

在 MATLAB Online 中打开

Use curly brackets {} instead of parentheses when referring to numbered table variables —

Date=datetime(dataTable{:,3:5})+hours(dataTable{:,8});

dataTable = table(rand(2,1),rand(2,1),[2023;2023],[11;11],[10;11],rand(2,1),rand(2,1),[11;13])
dataTable = 2×8 table
     Var1        Var2      Var3    Var4    Var5     Var6       Var7      Var8
    _______    ________    ____    ____    ____    _______    _______    ____

    0.21309    0.038666    2023     11      10     0.32764    0.77161     11 
    0.22024    0.052536    2023     11      11     0.70769    0.31238     13 
Date=datetime(dataTable{:,3:5})+hours(dataTable{:,8})
Date = 2×1 datetime array
   10-Nov-2023 11:00:00
   11-Nov-2023 13:00:00