Script for deleting extra rows
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
CAM
il 2 Ott 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?
0 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su String Parsing in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!