Concatenating multiple tables in a cell array

조회 수: 15 (최근 30일)
Daniel Abraham
Daniel Abraham 2021년 7월 19일
댓글: Daniel Abraham 2021년 7월 27일
Hello Everyone, I have a cell array with hundreds of tables in it, It's a 1165x1 cell array. The first 499 are empty cells but the rest have tables in them. from T{500} to T{end}
Most of the tables are 20x153 tables but some of them have different amount of columns (I have identified about 10 out of the 500) which have columns ranging from 130 to 157 columns. Is there a way I could concatenate vertically all the tables in the cell array with 20x153 dimensions ignoring these outliers?
Thank you.
  댓글 수: 2
Walter Roberson
Walter Roberson 2021년 7월 19일
The entries that have fewer than 153 columns: you want to ignore those entries completely, right?
The entries that have more than 153 columns: do you want to ignore those entries completely, or do you want the first 153 columns of them to be used?
Daniel Abraham
Daniel Abraham 2021년 7월 19일
Well I was actually looking for an easy way out haha,I think I’d prefer the second option if it’s possible.

댓글을 달려면 로그인하십시오.

채택된 답변

Walter Roberson
Walter Roberson 2021년 7월 19일
mask = cellfun(@(c) size(c,2) == 153, T);
Tfull = vertcat(T{mask});
  댓글 수: 8
Walter Roberson
Walter Roberson 2021년 7월 27일
That code does not download from OneDrive to local disk, but if possible you would really rather read from local disk than from OneDrive. The performance loss for reading from OneDrive can be substantial. Even just starting by copying the files to local drive can improve performance a lot.
Daniel Abraham
Daniel Abraham 2021년 7월 27일
I see, thanks a lot, I appreciate your suggestions

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Large Files and Big Data에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by