Copying colums from table to a new table

55 views (last 30 days)
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.

Accepted Answer

Adam Danz
Adam Danz on 30 Jun 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};
  1 Comment
Mat P
Mat P on 30 Jun 2020
Thank you! I think I manage to do just what I want with this

Sign in to comment.

More Answers (1)

SC on 30 Jun 2020
Hey, This link might help you:
go to 'Table with Multiple Data Types' in the above link
  1 Comment
Mat P
Mat P on 30 Jun 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

Sign in to comment.


Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!