Split date variable of a table into 3 variables year month and day

Question

Thomas Vescovini 2019-7-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/471881-split-date-variable-of-a-table-into-3-variables-year-month-and-day

评论： Adam Danz 2019-7-18

Hi, I have table with 3 variables (date, latitude, longitude) where the first variable is the date (dd/mm/yyyy) and I want the create a table with 5 variables with the following schema :

year month day latitude longitude

2002 01 01 xxx xxx

I didn't find out how to use datenum and datevec the right way...

Thank you,

TV

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

请先登录，再进行评论。

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

Answer 1

Adam Danz 2019-7-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/471881-split-date-variable-of-a-table-into-3-variables-year-month-and-day#answer_383677

在 MATLAB Online 中打开

"I have table with 3 variables (date, latitude, longitude) where the first variable is the date (dd/mm/yyyy)"

% Create example table
T = table(datestr(round(now()-(0:5))','dd/mm/yyyy'),rand(6,1)*100, rand(6,1)*100, ...
    'VariableName', {'date','latitude','longitude'}); 

"I want the create a table with 5 variables with the following schema..."

% parse dates
[y,m,d] = datevec(T.date, 'dd/mm/yyyy'); 
Tdate = table(y,m,d,'VariableName',{'year','month','day'}); 
% Create new table
Tnew = [Tdate,T(:,{'latitude','longitude'})]; 

Result

Tnew =
  6×5 table
    year    month    day    latitude    longitude
    ____    _____    ___    ________    _________
    2019      7      18      84.565      40.058  
    2019      7      17      44.594      91.371  
    2019      7      16      54.392      67.381  
    2019      7      15       75.07      39.048  
    2019      7      14      89.192      41.376  
    2019      7      13      58.357      70.361  