How can I convert cell to a timetable?

Question

Ashfaq Ahmed 2023-3-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1934779-how-can-i-convert-cell-to-a-timetable

编辑： Walter Roberson 2023-3-24

BUOY_DATA.mat

Hi all, I have a table that is consists of both double (temperature, salinity) and cell array (sampling time). But I want to convert the table into a time timetable making sure that the time column is no longer a cell array, rather it is in a datetime format = YY:MM:DD HH:MM:SS.

I have attached the .mat file. Can anyone please help?

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2023-3-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1934779-how-can-i-convert-cell-to-a-timetable#answer_1200454

编辑：Walter Roberson 2023-3-24

在 MATLAB Online 中打开

times = datetime(YourCell{:,4}, 'InputFormat', "yyyy-MM-dd'T'hh:mm:ss'Z'", 'TimeZone', 'GMT');
data = table2timetable(cell2table(YourCell(:,[1:3,5:end])), 'RowTimes', times);