vertically concatenate two tables with different types of data
31 次查看(过去 30 天)
显示 更早的评论
I have two tables with the same variables that I want to concatenate vertically.
The problem is that table1 has one of the Variables as double but table2 has the same Variable with cell values, see image
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1448077/image.png)
Columns 126 and 128 have the same name in both tables but different type of data which does not allow me to use the following code:
table1 =vertcat(table1, table2);
The error message I'm getting is this one:
Error using tabular/vertcat
Cannot concatenate the table variable 'ACA500300_' because it is a cell in one table and a non-cell in another.
I appreciate any help.
2 个评论
采纳的回答
Sugandhi
2023-8-21
Hi Galo,
I understand that you want to vertically concatenate two tables with the same variables and different types of data.
The error message you are receiving indicates that you cannot concatenate the table variable 'ACA500300_' because it is a cell in one table and a non-cell in another. To resolve this issue, you can convert the cell values in 'table2' to the double data type before concatenating the tables. Here's an example of how you can achieve this:
% Assuming table1 and table2 are your original tables
% Convert the cell values in table2 to double
table2.ACA500300_ = cell2mat(table2.ACA500300_);
% Concatenate the tables vertically
combinedTable = [table1; table2];
In the above code, 'cell2mat' is used to convert the cell values in the 'ACA500300_' column of 'table2' to the double data type. Then, the tables are concatenated vertically using the square bracket notation '[table1; table2]', and the result is stored in the 'combinedTable' variable.
Make sure that the cell values in 'table2' can be converted to doubles. If there are non-numeric values or missing values in the cells, the conversion may result in an error.
For more understanding, kindly go through following links:
cell2mat:
0 个评论
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!