Combing the data in two rows in a table

John Doe

2020 1 25

0 个回答

1 次查看（30 天）

0 个投票

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 个评论
显示无隐藏无

Mohammad Sami 2020-1-26

编辑：Mohammad Sami 2020-1-26

在 MATLAB Online 中打开

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,:);