Having problem with indexing my table

Question

0 个投票

Hi,

I have imported a column from excel file. And wanted to refer several parts of it by indexing.

S=readtable('safe_1.xlsx','Sheet','safe_1','Range','K1:K23026');
s=table({'CS1';'CS2';'CS3'},S([3500:4010; 4500:5010; 6000:6510]));

The reason I want to use above table command is that I want to apply same function with those several parts of S table as follows:

% Apply Function to Groups Within Variables
% Compute the group-wise means of variables in a table, A, and return them as rows in a table, B. 
% Create a table where one variable defines groups. 
A = table({'test2';'test1';'test2';'test3';'test1'},...
    [0.71;-2.05;-0.35;-0.82;1.57],[0.23;0.12;-0.18;0.23;0.41])
% Define the anonymous function to find the mean of an input. 
func = @mean;
% func uses an existing MATLAB® function to define the operation. 
% Apply the function to each group of data defined by Var1. 
B = varfun(func,A,'GroupingVariables','Var1')
% B contains a variable called GroupCount to indicate the number of entries from table A in that group.

Please give me your recommendations.

Thank you in advance.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Image Analyst 2020-5-24

What indices? Of A or S or s?

Can you attach safe_1.xlsx?

Yanjika O 2020-5-24

编辑：Yanjika O 2020-5-24

在 MATLAB Online 中打开

safe_1.xlsx

I wanted to look data in S to look like A.

I had returned this error after I try to extract datas from S

Subscripting a table using linear indexing (one subscript) or multidimensional indexing (three or more subscripts) is not supported. Use a row subscript and a variable subscript.

请先登录，再进行评论。

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

Follow Question