Merge a timedate table with a normal table
조회 수: 3 (최근 30일)
이전 댓글 표시
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
답변 (1개)
Peter Perkins
2018년 2월 6일
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.
댓글 수: 5
Guillaume
2018년 2월 8일
You're obviously using a version that predates the introduction of timetables, which require at least R2016b.
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!