Borrar filtros
Borrar filtros

Combing the data in two rows in a table

1 visualización (últimos 30 días)
John Doe
John Doe el 25 de En. de 2020
Comentada: John Doe el 27 de En. de 2020
Hello everyone!
I hope you're doing well.
I have a question relating to combing data from two rows in a table. I want to form a single row depending on the data present. For example, if the data is repeated i want it to be mentioned once, if it's not repeated i want it to be combined. I also have a start and an end time for both my rows that I want to have them as a continuation.
Just to make things clearer, I've attached what I need help in and I've also attached how I want the results to look like (I did it manually).
If more information is needed, please let me know. I'd b grateful for any sort of guidance.
Thank you!!
  2 comentarios
Mohammad Sami
Mohammad Sami el 26 de En. de 2020
Editada: Mohammad Sami el 26 de En. de 2020
Have you tried using unique ?
[~,rows_you_want_to_keep] = unique(var(:,{'Col1' 'Col2'}),'rows');
% change Col1 Col2 ... to columns you want to check duplicates for
uniq_tab = var(rows_you_want_to_keep,:);
John Doe
John Doe el 27 de En. de 2020
It doesn't work :/ I'm trying to write if conditions around it but it isn't very elegant

Iniciar sesión para comentar.

Respuestas (0)

Categorías

Más información sobre Matrices and Arrays 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!

Translated by