Copying colums from table to a new table

44 visualizaciones (últimos 30 días)
Mat P
Mat P el 30 de Jun. de 2020
Comentada: Mat P el 30 de Jun. de 2020
I am struggling with a quite simple issue:
I have multiple different sized tables, and i would like to copy last columns of every (time)table to a new table that i have not defined. That doesn't work because the length are different in every column. The excessive values in some columns could be set as "Nan"s or just removed. IS there a easy way to do this? The only method that comes to my mind is to create an excel .csv file with zeros, but my tables are very large.

Respuesta aceptada

Adam Danz
Adam Danz el 30 de Jun. de 2020
Follow the demo; see inline comments for details.
% Create 3 timetables of different heights
dt = datetime(2000,1,1,0,0,0) + minutes(0:30:5000)';
TT1 = timetable(dt(1:100),rand(100,1));
TT2 = timetable(dt(1:85),rand(85,1));
TT3 = timetable(dt, rand(size(dt)));
% List all timetables in a cell array named "allTT"
allTT = {TT1, TT2, TT3};
% Get heights of all timetables
heights = cellfun(@height, allTT);
% Loop through each timetable and move the last column into
% the table T; use NaNs as fillers.
T = array2table(nan(max(heights), numel(allTT))); % You may want to name your variables here.
for i = 1:numel(allTT)
T{1:heights(i),i} = allTT{i}{:,end};
end
  1 comentario
Mat P
Mat P el 30 de Jun. de 2020
Thank you! I think I manage to do just what I want with this

Iniciar sesión para comentar.

Más respuestas (1)

SC
SC el 30 de Jun. de 2020
Hey, This link might help you:
go to 'Table with Multiple Data Types' in the above link
  1 comentario
Mat P
Mat P el 30 de Jun. de 2020
Thank you for the answer. I don't think that i can use that. My goal is to copy these columns to new timetable, but i can't do that because the lengths are different. And that doesn't allow me to add extra zeros to the end of smaller tables, to make them all equal sized

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