Having problem with indexing my table
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Yanjika O
le 24 Mai 2020
Réponse apportée : Cris LaPierre
le 25 Mai 2020
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 commentaires
Réponse acceptée
Cris LaPierre
le 25 Mai 2020
It looks like you are trying access a subset of data in your table. Take a look at this video from Exploratory Data Analysis with MATLAB.
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!