Borrar filtros
Borrar filtros

Merge a timedate table with a normal table

3 visualizaciones (últimos 30 días)
Tiago Dias
Tiago Dias el 6 de Feb. de 2018
Comentada: Tiago Dias el 8 de Feb. de 2018
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 comentarios
dpb
dpb el 6 de Feb. de 2018
See
doc timetable2table
Tiago Dias
Tiago Dias el 8 de Feb. de 2018
Editada: Tiago Dias el 8 de Feb. de 2018
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)

Iniciar sesión para comentar.

Respuestas (1)

Peter Perkins
Peter Perkins el 6 de Feb. de 2018
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 comentarios
Guillaume
Guillaume el 8 de Feb. de 2018
You're obviously using a version that predates the introduction of timetables, which require at least R2016b.
Tiago Dias
Tiago Dias el 8 de Feb. de 2018
oh ok, will try on the 2016b, thanks for your input

Iniciar sesión para comentar.

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by