delete specific rows in a table

Question

Carlos Alonso 2021-9-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1455494-delete-specific-rows-in-a-table

评论： Carlos Alonso 2021-9-20

A.xlsx

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

the cyclist 2021-9-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1455494-delete-specific-rows-in-a-table#answer_789784

在 MATLAB Online 中打开

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Carlos Alonso 2021-9-20

Many thanks, very helpful :)

请先登录，再进行评论。

Answer 2

Image Analyst 2021-9-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1455494-delete-specific-rows-in-a-table#answer_789789

在 MATLAB Online 中打开

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