How to extract rows from a table?
218 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Lucas Acuna Scafati
el 18 de Feb. de 2020
Comentada: Lucas Acuna Scafati
el 20 de Feb. de 2020
I am having trouble extracting certain values from a table and putting them in another table. This is the code i have so far but for the extracted values it creates a 0 x 4 table when it should be a 4x4 table.
for d = Tbl.ECF
if any (Tbl.ECF > 1.06) && any(Tbl.ECF < .94) %Looks for any dot with standard deviation above 1%
ExtractedECF = Tbl(Tbl.ECF > 1.06 & Tbl.ECF < .96,:); % Extracts dot mentioned in previous line and puts it in a new table
Tbl(Tbl.ECF > 1.06,:) = []; % Deletes Row with dot above 1%
Tbl(Tbl.ECF < .94,:) = []; % Deletes Row with dot above 1%
else
end
end
How can should I fix this problem and is there a more effective way to writing this code? Thank you, I am very new to MATLAB
1 comentario
the cyclist
el 18 de Feb. de 2020
It would be helpful if you uploaded the table in MAT file, using the paper clip symbol.
Respuestas (1)
Jacob Wood
el 18 de Feb. de 2020
Lucas,
Matlab can be very good at working with tables and indexing like this. One of the most powerful concepts in Matlab is logical indexing which can be used to quickly select subsets of data based on your defined conditions.
An example of doing this with Matlab and tables would be something like:
% Make a table
a = [1 3 4 6]';
b = [11 13 14 16]';
Tbl1 = table(a,b);
idx = Tbl1.a > 2 & Tbl1.a<5; %find what rows this is true
Tbl2 = Tbl1(idx,:); %pick out those rows (and all the columns) from Tbl1 and put them in a new table
disp(Tbl2) %show new table
1 comentario
Ver también
Categorías
Más información sobre Tables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!