MATLAB Answers

Script for deleting extra rows

2 views (last 30 days)
Ayman Fatima
Ayman Fatima on 2 Oct 2019
Answered: CAM on 2 Oct 2019
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!


Sign in to comment.

Accepted Answer

CAM on 2 Oct 2019
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?


Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by