Parsing variable in table

Question

Inna Pelloso 2022-11-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1853203-parsing-variable-in-table

评论： Star Strider 2022-11-17

采纳的回答： Star Strider

Hi,

I have a 3x1 table, with one variable, timestamp:

timestamp

2021-02-01 09:00:00

2021-02-01 09:01:00

2021-02-01 09:02:00

How can I parse this to create a 3x2 table, with two variables, date and time:

date time

2021-02-01 09:00:00

2021-02-01 09:01:00

2021-02-01 09:02:00

Any help would be appreciated!

IP

2 个评论
显示无隐藏无

Stephen23 2022-11-17

编辑：Stephen23 2022-11-17

Note that changing the FORMAT does not changes the actual date/time values stored in the DATETIME object, it only changes how the DATETIME object looks when displayed or converted to text.

If you actually want to have the data consist only of the date and time values separately, then use DATESHIFT and TIMEOFDAY.

Inna Pelloso 2022-11-17

Thank you for your help, Stephen! I really appreciate it!

Inna

请先登录，再进行评论。

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

Answer 1

Star Strider 2022-11-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1853203-parsing-variable-in-table#answer_1102053

编辑：Star Strider 2022-11-17

在 MATLAB Online 中打开

Try something like this —

T1 = table(datetime(['2021-02-01 09:00:00'
           '2021-02-01 09:01:00'
           '2021-02-01 09:02:00']), 'VariableNames',{'timestamp'})
T1 = 3×1 table
         timestamp      
    ____________________

    01-Feb-2021 09:00:00
    01-Feb-2021 09:01:00
    01-Feb-2021 09:02:00
date = T1.timestamp;
time = T1.timestamp;
date.Format = 'yyyy-MM-dd';
time.Format = 'HH:mm:ss';
T1 = addvars(T1,date,time);
T1 = removevars(T1,'timestamp')
T1 = 3×2 table
       date         time  
    __________    ________

    2021-02-01    09:00:00
    2021-02-01    09:01:00
    2021-02-01    09:02:00

There may also be other ways to do this.

EDIT — (17 Nov 2022 at 13:16)

I was not certain what you wanted.

Try this —

T1 = table(datetime(['2021-02-01 09:00:00'
           '2021-02-01 09:01:00'
           '2021-02-01 09:02:00']), 'VariableNames',{'timestamp'})
T1 = 3×1 table
         timestamp      
    ____________________

    01-Feb-2021 09:00:00
    01-Feb-2021 09:01:00
    01-Feb-2021 09:02:00
[y,m,d] = ymd(T1.timestamp);                    % Year, Month, Day Only
date = datetime([y,m,d]);                       % Convert Back To 'datetime'
time = timeofday(T1.timestamp);                 % Time Of Day Only
T1 = addvars(T1,date,time);
T1 = removevars(T1,'timestamp')
T1 = 3×2 table
       date          time  
    ___________    ________

    01-Feb-2021    09:00:00
    01-Feb-2021    09:01:00
    01-Feb-2021    09:02:00