How can i interpolate this data?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Gabriel Luca Pugliese Borges
il 19 Apr 2022
Commentato: Star Strider
il 19 Apr 2022
Greetings to you all.
I'm trying to analise some data from an ADCP (Acoustic Doppler Current Profiler). For that, i must process the data.
My matrix works on this way:
Each Row has intensity values
Each column has a certain height in relation to the bottom of the water column.
example:
0 NaN 0.5 0.3 0.7 0.9
0 NaN 0.7 0.4 0.5 0.8
0 NaN 0.9 0.1 0.4 0.5
0 NaN 1.0 0.4 0.3 0.2
The second column is equivalent a 1m height from the bottom and the instrument has not registered those values because of an error. I want to interpolate them.
Appreciate any kind of help.
0 Commenti
Risposta accettata
Star Strider
il 19 Apr 2022
A = [0 NaN 0.5 0.3 0.7 0.9
0 NaN 0.7 0.4 0.5 0.8
0 NaN 0.9 0.1 0.4 0.5
0 NaN 1.0 0.4 0.3 0.2];
B = fillmissing(A, 'linear', 2)
The fillmissing function was introduced in R2016b.
.
4 Commenti
Star Strider
il 19 Apr 2022
I was away doing other things for a few minutes.
I thought of a more efficient way to do this, as well as being able to do more than one page in one operation —
A = [0 NaN 0.5 0.3 0.7 0.9
0 NaN 0.7 0.4 0.5 0.8
0 NaN 0.9 0.1 0.4 0.5
0 NaN 1.0 0.4 0.3 0.2];
A = cat(3, A, A.*(1+randn(size(A))/100))
B = A; % Copy 'A' To 'B'
B(:,2,:) = mean(B(:,[1 3],:),2) % Column 2 Is The Mean Of Colums 1 & 3
The second ‘page’ or ‘A’ is a slightly altered version of the first page to demonstrate that this works, providing that a linear interpolation is desired, and the column 2 of every page is the NaN column.
.
Più risposte (1)
Keegan Carvalho
il 19 Apr 2022
Modificato: Keegan Carvalho
il 19 Apr 2022
I'd assume "fillmissing" function would be best since you want to inteprolate the data row-wise (and this is not gridded interpolation).
Try this:
mydata = [0 NaN 0.5 0.3 0.7 0.9
0 NaN 0.7 0.4 0.5 0.8
0 NaN 0.9 0.1 0.4 0.5
0 NaN 1.0 0.4 0.3 0.2];
mydata=fillmissing(mydata,"linear",2)
% linear is one of the inteprolation methods you can use. There are others like spline, nearest, etc.
% 2 means inteprolation of data in each row of mydata. 1 - column
Hope this helps!
1 Commento
Vedere anche
Categorie
Scopri di più su Earth and Planetary Science 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!