Convert datetime into seperate columns

Question

Yoni Verhaegen -WE-1718- 2020-7-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/570490-convert-datetime-into-seperate-columns

编辑： Brittany Scheid 2020-7-25

seawatertemp_westhinder.csv

I have a CSV table that I load in Matlab and looks as follows (see below). I would like to separate the datetime column into separate values in the form of a double array, with 1 column for 'year', 1 column for 'month', and 1 column for 'day', something like:

2020  |  07  |  20
2020  |  07  |  20

The hour is not important. How can I do this? I attach the CSV file which can be loaded as:

seawatertemp_westhinder = readtable('seawatertemp_westhinder.csv');

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

请先登录，再进行评论。

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

Answer 1

Brittany Scheid 2020-7-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/570490-convert-datetime-into-seperate-columns#answer_470803

编辑：Brittany Scheid 2020-7-25

在 MATLAB Online 中打开

In one line to get a double array:

[y,m,d] = ymd(seawatertemp_westhinder.times); 
[y,m,d]
% Add to table
seawatertemp_westhinder.year= y
seawatertemp_westhinder.month = m
seawatertemp_westhinder.day= d