converting a variable in a table from cell to double

조회 수: 7 (최근 30일)
Salma fathi
Salma fathi 2022년 10월 18일
댓글: Cris LaPierre 2022년 10월 19일
I am trying to read some tables and concatenate them in one big table, but I am getting the following error
Cannot concatenate the table variable 'foE' because it is a cell in one table and a non-cell in another.
attached is the table "t1" that I am trying to read. the type of the variable in the other table is double, so how can I convert foE from cell to double
I am using the following lines to read the data
for kk = 1 : nfiles
fprintf('.......... File - %d of %d\n',kk, nfiles)
fullFileName = fullnames{kk};
t1 = readtable(fullFileName); %t1 stores the table from each file
if kk==1
Iono=t1;
else
Iono=[Iono; t1];
end
  댓글 수: 4
Salma fathi
Salma fathi 2022년 10월 19일
Thanks for your comment, i added the code that I am using to read the data.
Salma fathi
Salma fathi 2022년 10월 19일
@Davide Masiello thank you for your comment, I tried cell2mat and got the following error
Brace indexing is not supported for variables of this type.
Error in cell2mat (line 42)
cellclass = class(c{1});
Error in Read_Split_Iono (line 32)
t1.foE = cell2mat(t1.foE);

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

답변 (1개)

Cris LaPierre
Cris LaPierre 2022년 10월 18일
Your variable is a cell because many of your values are '---'. Try this
t1.foE = str2double(t1.foE);
  댓글 수: 2
Salma fathi
Salma fathi 2022년 10월 19일
I did tried this before and got the folloing error
To assign to or create a variable in a table, the number of rows must match the height of the table.
Cris LaPierre
Cris LaPierre 2022년 10월 19일
That is a separate error, and has more to do with what you are trying to do with the result than the conversion itself. Share the code that corresponds to that error message.

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

카테고리

Help CenterFile Exchange에서 Logical에 대해 자세히 알아보기

제품


릴리스

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by