Having problem with indexing my table
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Yanjika O
il 24 Mag 2020
Risposto: Cris LaPierre
il 25 Mag 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 Commenti
Risposta accettata
Cris LaPierre
il 25 Mag 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Data Import from MATLAB in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!