'Unable to concatenate the table variables 'Var1' and 'Var2', because their types are cell and double.' why this error is showing?

41 次查看（过去 30 天）
Rajkumar
Rajkumar 2023-3-18
评论： F 2024-9-13
clear all;
clc;
%read X sample
ix1 = readtable("x_sample_01.dat",'ReadVariableNames',false);
x1 = table2array(ix1);

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

回答（1 个）

Walter Roberson
Walter Roberson 2023-3-18
Your file contains a mix of text and numeric. What result are you expecting when you ask to convert it to a single array?
  6 个评论
显示 4更早的评论
Walter Roberson
Walter Roberson 2023-8-25
Ran in:
The case where there are empty columns get converted to doubles and filled with NaN -- no problem with table2array()
headerlines = {'Var1', 'Var2'};
Var1 = cell(2,1);
Var2 = [11; 22];
top = headerlines;
bottom = [Var1, num2cell(Var2)];
C = [top; bottom]
C = 3×2 cell array
{'Var1' } {'Var2'} {0×0 double} {[ 11]} {0×0 double} {[ 22]}
writecell(C, 'temp_table.xlsx');
ix1 = readtable('temp_table.xlsx')
ix1 = 2×2 table
Var1 Var2 ____ ____ NaN 11 NaN 22
x1 = table2array(ix1)
x1 = 2×2
NaN 11 NaN 22
writecell(C, 'temp_table.csv');
dbtype temp_table.csv
1 Var1,Var2 2 ,11 3 ,22

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Measurements and Feature Extraction 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by