Remove repeat values in a text file

Question

Joseff Saunders 2018-12-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/434447-remove-repeat-values-in-a-text-file

评论： Joseff Saunders 2018-12-7

Hello all, below is a section of data from a weather station, the weather station is supposed to record once a minute, however, some have duplicate minute recordings. For me to analyse it I need to remove the duplicate readings, the only way of identifying the duplicate readings is by the minute column (i.e. two recordings from minute 1 etc.) Any ideas as to a solution?

day	month	year	hour	minute	temperature	
1	2017	1	1	1.5	
1	2017	1	1	5.9	
1	2017	1	2	5.4
1	2017	1	3	5.2
1	2017	1	4	5.1
1	2017	1	5	5.5
1	2017	1	5	5.6

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

请先登录，再进行评论。

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

Answer 1

Akira Agata 2018-12-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/434447-remove-repeat-values-in-a-text-file#answer_351063

在 MATLAB Online 中打开

Assuming your data is stored in table variable T

>> T
T =
  7x6 table
    day    month    year    hour    minute    temperature
    ___    _____    ____    ____    ______    ___________
    25       1      2017     1        1           1.5    
    25       1      2017     1        1           5.9    
    25       1      2017     1        2           5.4    
    25       1      2017     1        3           5.2    
    25       1      2017     1        4           5.1    
    25       1      2017     1        5           5.5    
    25       1      2017     1        5           5.6    

Then, unique rows can be simply extracted by using unique function, like:

[~,idx] = unique(T(:,{'day','month','year','hour','minute'}),'rows');
T = T(idx,:);

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

Joseff Saunders 2018-12-7

Thank you this worked well, however the issue I am having now is that some data from particular minutes is missing (i.e. it wasn't recorded in the first place), as there are supposed to be 60 minutes for each hour, is there a way of testing to see which minutes are missing?

请先登录，再进行评论。