Script for deleting extra rows
조회 수: 1 (최근 30일)
이전 댓글 표시
Hi,
I am an oceanographer ,so I have to deal with large data gaps . My problem was that I need a script or a function that deletes extra rows(present due to missing data ) from my data set plus it would be a lot easier if I could have something that would would delete specific rows that are not equivalent to my given time stamp .. I have Matlab 2013a..
Thank you!
댓글 수: 0
채택된 답변
CAM
2019년 10월 2일
Try this to remove rows with blank Depths:
[~,~,dataIn] = xlsread(fileName, worksheetName);
index = ~cellfun(@isempty, dataIn(:,2)); % The Depth column
dataCleaned = dataIn(index, :);
I am not clear on the second part of your question. Do you mean you have a defined set of time stamps, and you want to see if you can find matches in the incoming data?
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 String Parsing에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!