How can I convert cell to a timetable?

20 ビュー (過去 30 日間)
Ashfaq Ahmed
Ashfaq Ahmed 2023 年 3 月 24 日
編集済み: Walter Roberson 2023 年 3 月 24 日
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?

採用された回答

Walter Roberson
Walter Roberson 2023 年 3 月 24 日
編集済み: Walter Roberson 2023 年 3 月 24 日
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);

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeData Type Conversion についてさらに検索

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by