Remove repeat values in a text file
조회 수: 5 (최근 30일)
이전 댓글 표시
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
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
댓글 수: 0
채택된 답변
Akira Agata
2018년 12월 7일
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개)
ahmed nebli
2018년 12월 7일
i suggest you need to write an if condition on the minute vector exemple : if minute(n-1) == minute(n) then you delete the row n from the table.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Weather and Atmospheric Science에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!