How can i interpolate this data?
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Gabriel Luca Pugliese Borges
am 19 Apr. 2022
Kommentiert: Star Strider
am 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 Kommentare
Akzeptierte Antwort
Star Strider
am 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 Kommentare
Star Strider
am 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.
.
Weitere Antworten (1)
Keegan Carvalho
am 19 Apr. 2022
Bearbeitet: Keegan Carvalho
am 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 Kommentar
Gabriel Luca Pugliese Borges
am 19 Apr. 2022
Bearbeitet: Gabriel Luca Pugliese Borges
am 19 Apr. 2022
Siehe auch
Kategorien
Mehr zu Earth and Planetary Science finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!