filtering a cell array with date serial number
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
I have two cell arrays. Cell array one is a column that has a serial date number in every row and only one column. cell array two consists of many individual matrix tables which have a serial date number in column one whilst the other columns have other values. i want to filter cell array two in such a way that it only displays the rows in every individual matrix that contains the serial date number in cell array one.
0 comentarios
Respuestas (1)
Walter Roberson
el 27 de Sept. de 2015
Under the assumption that you want to filter down to the entries that match any of the dates in the first matrix (instead of wanting to produce one set of matrices for the matches for the first entry, another set for the matches for the second set, and so on):
targetvals = cell2mat(CellArray1);
Subsets = cellfun(@(C) C(ismember(cell2mat(C),targetvals),:), CellArray2, 'Uniform', 0);
3 comentarios
Walter Roberson
el 1 de Oct. de 2015
matches = ismember(MATRIX2(:,1), MATRIX1);
NewMATRIX2 = MATRIX2(matches,:);
Ver también
Categorías
Más información sobre Loops and Conditional Statements 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!