How do I split a MATLAB table into seperate tables by date?

Question

Bhavishey Thapar 2022-7-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1764685-how-do-i-split-a-matlab-table-into-seperate-tables-by-date

评论： Voss 2022-7-25

I have a table with a datatime and temperature column that I want to split into seperate tables based on date. For example, I want to split the below table into 3 sperate tables because there are 3 different days in the table.

Date Temperature

2022-05-21 12

2021-05-21 19

2022-05-21 24

2022-06-01 21

2022-06-01 22

2022-06-04 25

How do I do this?

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

请先登录，再进行评论。

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

Answer 1

Voss 2022-7-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1764685-how-do-i-split-a-matlab-table-into-seperate-tables-by-date#answer_1012010

在 MATLAB Online 中打开

Here's one way:

t = table( ...
    {'2022-05-21';'2021-05-21';'2022-05-21';'2022-06-01';'2022-06-01';'2022-06-04'}, ...
    [12;19;24;21;22;25], ...
    'VariableNames',{'Date' 'Temperature'})
t = 6×2 table
         Date         Temperature
    ______________    ___________

    {'2022-05-21'}        12     
    {'2021-05-21'}        19     
    {'2022-05-21'}        24     
    {'2022-06-01'}        21     
    {'2022-06-01'}        22     
    {'2022-06-04'}        25     
[uu,~,jj] = unique(t.Date);
nuu = numel(uu);
c = cell(nuu,1);
for ii = 1:nuu
    c{ii} = t(jj == ii,:);
end
c
c = 4×1 cell array
    {1×2 table}
    {2×2 table}
    {2×2 table}
    {1×2 table}
c{:}
ans = 1×2 table
         Date         Temperature
    ______________    ___________

    {'2021-05-21'}        19     
ans = 2×2 table
         Date         Temperature
    ______________    ___________

    {'2022-05-21'}        12     
    {'2022-05-21'}        24     
ans = 2×2 table
         Date         Temperature
    ______________    ___________

    {'2022-06-01'}        21     
    {'2022-06-01'}        22     
ans = 1×2 table
         Date         Temperature
    ______________    ___________

    {'2022-06-04'}        25     

Looks like 4 different dates, but maybe the 2021 is a typo.

2 个评论
显示无隐藏无

Bhavishey Thapar 2022-7-25

Thank you.

Voss 2022-7-25

You're welcome!

请先登录，再进行评论。

Answer 2

Walter Roberson 2022-7-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1764685-how-do-i-split-a-matlab-table-into-seperate-tables-by-date#answer_1012090

在 MATLAB Online 中打开

Thanks to @Voss for inputting the data.

t = table( ...
    {'2022-05-21';'2021-05-21';'2022-05-21';'2022-06-01';'2022-06-01';'2022-06-04'}, ...
    [12;19;24;21;22;25], ...
    'VariableNames',{'Date' 'Temperature'})
t = 6×2 table
         Date         Temperature
    ______________    ___________

    {'2022-05-21'}        12     
    {'2021-05-21'}        19     
    {'2022-05-21'}        24     
    {'2022-06-01'}        21     
    {'2022-06-01'}        22     
    {'2022-06-04'}        25     
G = findgroups(t.Date);
c = splitapply(@(varargin) {table(varargin{:}, 'VariableNames', t.Properties.VariableNames)}, t, G);
c
c = 4×1 cell array
    {1×2 table}
    {2×2 table}
    {2×2 table}
    {1×2 table}