How to extract sequences from a table?

Question

0 个投票

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:

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 个评论
显示 2更早的评论隐藏 2更早的评论

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.

James McBrearty 2023-8-22

FCTable.mat

So, FCTable is attached.

What I would like is a cell array, where each cell element corresponds to a specific date (I don't need the date), and the contents of each cell would be the double array for each date.

Thanks

请先登录，再进行评论。

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

Follow Question

Answer 1

Matt J 2023-8-22

编辑：Matt J 2023-8-22

在 MATLAB Online 中打开

1 个投票

Calling your table T,

out = splitapply(@(x){x} , T{:,[1:10,12:end]},findgroups(T.tradeDate))

6 个评论
显示 4更早的评论隐藏 4更早的评论

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

James McBrearty 2023-8-22

Thanks for this - I did convert the dateformat to 'dd/mm/uuuu', and I was hoping that would change them all to be uniform. At least now I know how to use dateshift in the future. Again, thanks so much.

请先登录，再进行评论。

Answer 2

Matt J 2023-8-22

编辑：Matt J 2023-8-22

在 MATLAB Online 中打开

0 个投票

FCTable.mat

Another option, using varfun:

load FCTable
T=FCTable;
T.tradeDate=dateshift(FCTable.tradeDate,'start','day') ;
out = varfun(@(x) x,  T,'Grouping', 'tradeDate','Output','cell')
out = 51×2 cell array
    {46×1 double}    {46×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}
    {48×1 double}    {48×1 double}

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

James McBrearty 2023-8-22

That is a great answer too, but the other one is preferred, having a X times 1 cell array.

Thanks

请先登录，再进行评论。

How to extract sequences from a table?

4 个评论
显示 2更早的评论隐藏 2更早的评论

采纳的回答

6 个评论
显示 4更早的评论隐藏 4更早的评论

更多回答（1 个）

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

类别

产品

版本

标签

Community Treasure Hunt

How to extract sequences from a table?

4 个评论 显示 2更早的评论 隐藏 2更早的评论

采纳的回答

6 个评论 显示 4更早的评论 隐藏 4更早的评论

更多回答（1 个）

1 个评论 显示 -1更早的评论 隐藏 -1更早的评论

类别

产品

版本

标签

另请参阅

Community Treasure Hunt

4 个评论
显示 2更早的评论隐藏 2更早的评论

6 个评论
显示 4更早的评论隐藏 4更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论