Merge a timedate table with a normal table

Question

Tiago Dias 2018-2-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/381065-merge-a-timedate-table-with-a-normal-table

评论： Tiago Dias 2018-2-8

Hi, I got a timedate table 5x2 and another table 5x2, and I want to place in 1st column the time date and 2nd and 3rd the rest.

Tablenew = [novo_tempo_laboratorio novo_variavel_laboratorio];

The Tablenew gives me an error because the two types of tables that I want to merge are from different types.

load('Processo.mat');
Laboratorio = readtable('Laboratório.xlsx','Sheet','Laboratorio','Range','A1:D3');
save Laboratorio.mat Laboratorio
load('Laboratorio.mat');
tempo_processo = Processo{:,1};
variavel_processo = Processo{:,2};
% tempo_laboratorio = Laboratorio{:,1:2:end};
% variavel_laboratorio = Laboratorio{:,2:2:end};
[n,m] = size(Laboratorio);
ind_aux=[];
A=zeros(length(tempo_processo),1+m/2);
for j = 1:m/2
    for i = 1:length(tempo_processo)
        ind_aux = find(Laboratorio{:,2*j-1}==tempo_processo(i,1))  
        if  ~isempty(ind_aux)
            novo_tempo_laboratorio(i,j) = tempo_processo(i,1);
            novo_variavel_laboratorio(i,j) = Laboratorio(ind_aux,2*j); 
        else % Não existe registo para o tempo_processo(i)
            novo_tempo_laboratorio(i,j) = tempo_processo(i,1);
            novo_variavel_laboratorio{i,j} = NaN;
        end
    ind_aux=[];
    end
end

Thanks for your time!

2 个评论
显示无隐藏无

dpb 2018-2-6

在 MATLAB Online 中打开

See

doc timetable2table

Tiago Dias 2018-2-8

编辑：Tiago Dias 2018-2-8

在 MATLAB Online 中打开

Undefined function or variable 'timetable'.

I saw this example but for me i got an error because it says undefined function or variable

   Time = datetime({'2015-12-18';'2015-12-19';'2015-12-20'});
    Temp = [37.3;39.1;42.3];
    Pressure = [29.4;29.6;30.0];
    Precip = [0.1;0.9;0.0];
    TT = timetable(Time,Temp,Pressure,Precip);
    T = timetable2table(TT)

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2018-2-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/381065-merge-a-timedate-table-with-a-normal-table#answer_303748

You are trying to concatenate a 5x2 datetime array with a 5x2 table. You do not have a timetable and a table. As dpb says, I imagine you want table2timetable, but it's not at all clear what you want to do with two time vectors.