vertically concatenate two tables with different types of data

23 次查看（过去 30 天）
Galo
Galo 2023-8-2
回答： Sugandhi 2023-8-21
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
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 个评论
Dyuman Joshi
Dyuman Joshi 2023-8-2
You can convert the data which is not a cell to a cell and then join them.
Stephen23
Stephen23 2023-8-2
编辑：Stephen23 2023-8-2
You could convert the data using e.g. CONVERTVARS or similar.
But the best solution would be to import the data properly in the first place, e.g. by defining the TreatAsMissing option when calling READTABLE.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Sugandhi
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:
https://www.mathworks.com/help/matlab/ref/cell2mat.html?&s_tid=srchtitle_support_results_1_cell2mat

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by