delete specific rows in a table

Hi guys, I need your help.

See attached table. I would like to delete the rows in which the first column (time) have a decimal number in it (keep only those rows where the time is an integer number)

After that I would like to delete the rows where the time is repeated and keep only the first one. For example, if there are 3 rows with time 5, we should only keep the top row.

Any help with that?

Many thanks

Answer 1

[the cyclist]

I believe this does what you want. Note that this file doesn't have any repeated integer times. So, you don't need the second step.

% Read in the Excel file
A = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/741684/A.xlsx'); % You can just use 'A.xlsx' here

% Identify the rows that have exact integer time
keepIntegerTimeIndex = logical(abs(A{:,1}==round(A{:,1})));

% Keep only those rows
A = A(keepIntegerTimeIndex,:);

% Verify that there are only unique integer times:
length(A{:,1}) == length(unique(A{:,1}))

ans = logical
   1

[Carlos Alonso]

Many thanks, very helpful :)

Answer 2

[Image Analyst]

Try this:

allData = readmatrix('A.xlsx');
times = allData(:, 1);
% Find out where time is a pure integer
goodRows = times - round(times) == 0;
% Extract good rows
times = times(goodRows);
allData = allData(goodRows, :);

[Image Analyst]

Basically same as the Cyclist. I was working on mine while he was uploading his.