problem with table / array/cell

Question

venkat ta 2020-6-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/541169-problem-with-table-array-cell

评论： venkat ta 2020-6-3

在 MATLAB Online 中打开

Hi ,

The function is converting table to cell instead of table to array matrix.

I need a simple array vector for each column to plot and to do further calculation

clear all;
close all;
clc;

TXT_FileName='Fundamental + Harmonic distortion components.txt';                          
filedata = readtable(TXT_FileName,'delimiter','\t','readvariablenames',true);
A = table2array(filedata);
array = table2array(filedata(3:end,:));
% row=2;
% A(row,:)=[];
% row=1;
% A(row,:)=[];
Freq = array(:,1);
All_Fun_SPL = array(:,2);
% plot(Freq(:,1),All_Fun_SPL(:,1));

2 个评论
显示无隐藏无

Mohammad Sami 2020-6-3

I think the readtable is not detecting your header rows, you may want to explicitly state how many header rows there are. This causes it import data as cell string rather then as numeric values.

venkat ta 2020-6-3

Totally, 12 col and 6 pairs x y graphs (odd are x and even are y)

请先登录，再进行评论。

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

Answer 1

Stephan 2020-6-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/541169-problem-with-table-array-cell#answer_445463

编辑：Stephan 2020-6-3

在 MATLAB Online 中打开

Your table content is a cell array - Read the Tips section from the documentation. It tells you why and how to deal with it.

cell2mat(table2cell(T))

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

venkat ta 2020-6-3

在 MATLAB Online 中打开

Hi,

The cell2mat makes error like below

Error using cat

Dimensions of arrays being concatenated are not consistent.

Error in cell2mat (line 83)

m{n} = cat(1,c{:,n});

clear all;
close all;
clc;
TXT_FileName='Fundamental + Harmonic distortion components.txt';                          
filedata = readtable(TXT_FileName,'delimiter','\t','readvariablenames',true);
M=cell2mat(table2cell(filedata));