problem to concatenate table due to "cell and non cell" error
33 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hello,
I have a script that reads 2 TXT files to two tables (one is significantly larger than the other). then I add both table the columb 'detector' to the 4th column (both tables structure is identicle, and supposed to be the same types of variable to all columns). for some reason I'm getting this error : "Cannot concatenate the table variable 'detector' because it is a cell in one table and a non-cell in another."
the script works fine with smaller files.
is matlab chaneging the type of the variable due to the size?
this is the script:
Ge_table = readtable(hpge_file); %
Ge_table.Properties.VariableNames = {'time_stamp', 'energy','time_adjusted'};
scint_table = readtable(pmt_file); %
scint_table.Properties.VariableNames = {'time_stamp', 'energy','time_adjusted'};
Ge_table(:,4) = {1};
Ge_table.Properties.VariableNames{4} = 'detector';
scint_table(:,4) = {0};
scint_table.Properties.VariableNames{4} = 'detector';
coince_table = vertcat(Ge_table, scint_table);
Thanks!
4 Kommentare
Adam Danz
am 18 Mai 2020
Hmmm.... but the variableNames being assigned only contain 3 values which would throw an error.
Perhaps we aren't seeing the full code.
Akzeptierte Antwort
Adam Danz
am 18 Mai 2020
Bearbeitet: Adam Danz
am 18 Mai 2020
One possibility is that the cell / non-cell mismatch is being caused by a different column in the table.
Here are two ways you can quickly see if there's any mismatches in variable types between two columns.
1) look at the first few rows of each table.
head(Ge_table)
head(scint_table)
If you're unsure what to look for, leave a comment that contains the content of those two outputs.
2) Look at the variable classes for each column, for each table. Do they match?
GeTblClasses = varfun(@class,Ge_table,'OutputFormat','cell');
scintTblClasses = varfun(@class,scint_table,'OutputFormat','cell');
14 Kommentare
Weitere Antworten (1)
Gabor
am 20 Mai 2021
I would add to check the missmatching table variables by comparing them by for eg.:
class(Table1.Column_name(1))
class(Table2.Column_name(1))
1 Kommentar
Adam Danz
am 20 Mai 2021
That's what step 2 does in my answer except it checks the class of all columns in the table rather than just the first column.
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!