Borrar filtros
Borrar filtros

comparing two matrix element simultaneously and adding third column

1 visualización (últimos 30 días)
N/A
N/A el 5 de Jul. de 2019
Comentada: N/A el 7 de Jul. de 2019
whenever the elemnts in column 1 and 3 both are repeated elsewhere in matrix then only third column should get added up
e.g
A=
18 18 1
17 20 2
18 18 1
17 25 2
19 17 3
18 18 1
19 17 3
then answer should be
18 18 1
17 20 2
18 18 2
17 25 2
19 17 3
18 18 3
19 17 6

Respuesta aceptada

KSSV
KSSV el 5 de Jul. de 2019
A = [ 18 18 1
17 20 2
18 18 1
17 25 2
19 17 3
18 18 1
19 17 3] ;
[c,ia,ib] = unique(A(:,1:2),'rows') ;
B = A ;
% [c,ia,ib] = unique(A(:,3)) ;
for i = 1:length(c)
B(ib==i,3) = cumsum(A(ib==i,3)) ;
end
B
  1 comentario
N/A
N/A el 7 de Jul. de 2019
thank you KSSV this works absolutely fine but since my actual matrix is going to be 3x11870 i want that the unique elements and their cumulative sum should be stored separately otherwise it would be too difficult to find them can you tell me how that will work thanks in advance.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Matrix Indexing en Help Center y File Exchange.

Productos


Versión

R2018a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by