How to extract sequences from a table?
4 ビュー (過去 30 日間)
古いコメントを表示
Hi All,
I am adapting the example by Mathworks, Sequence Classification using Deep Learning,, to work with my own problem.
I have the raw data coming in as a table, and I'm wondering is there a way to split this up into sequences, based on the values in one column, rather than an arbitrary number of rows down?
My table looks like this:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1462492/image.jpeg)
What I would like to do is to convert this to a cellarray, of various double arrays (from this picture above it will be x cells each with 2*y double arrays, however, the real table has a few more columns, so it's just an extension of this).
Many thanks,
James
4 件のコメント
the cyclist
2023 年 8 月 22 日
Can you upload the data, or a small representative sample? You can use the paper clip icon in the INSERT section of the toolbar.
採用された回答
Matt J
2023 年 8 月 22 日
編集済み: Matt J
2023 年 8 月 22 日
Calling your table T,
out = splitapply(@(x){x} , T{:,[1:10,12:end]},findgroups(T.tradeDate))
6 件のコメント
Dyuman Joshi
2023 年 8 月 22 日
"Was there something wrong with the format of the dates?"
The format hid additional information of the datetime values.
The dates might look identical, but the values for hour, minute and seconds were different for the same day. You can check that by using hms.
So, to make the data uniform, all the dates have been shifted to the start of the respective days i.e. 00:00:00
参考
カテゴリ
Help Center および File Exchange で Data Type Conversion についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!