problem with table / array/cell

10 次查看（过去 30 天）
venkat ta
venkat ta 2020-6-3
评论： venkat ta 2020-6-3
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
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
venkat ta 2020-6-3
Totally, 12 col and 6 pairs x y graphs (odd are x and even are y)

请先登录，再进行评论。

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

回答（1 个）

Stephan
Stephan 2020-6-3
编辑：Stephan 2020-6-3
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 个评论
venkat ta
venkat ta 2020-6-3
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));

请先登录，再进行评论。

类别

在 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