Return a value in csv data at a specific point

6 Ansichten (letzte 30 Tage)
Jack Lakeman
Jack Lakeman am 17 Feb. 2023
Beantwortet: Star Strider am 20 Feb. 2023
Hiya there,
I've got CSV data containing 2 columns . Colum 1 is Distance and column 2 is Depth.
Im wanting a simple code to find what the Depth value is at Distance = 5945
Thanks in advance
  1 Kommentar
Mathieu NOE
Mathieu NOE am 17 Feb. 2023
hello
have you started a code ?
have data (csv) file to share ?

Melden Sie sich an, um zu kommentieren.

Antworten (2)

Krishna
Krishna am 20 Feb. 2023
You can use the following link to get an idea of how to work with .csv files in MATLAB.
Use the find function mentioned in the doc to get the Depth value at Distance = 5945 after extracting values from csv file using readtable.

Star Strider
Star Strider am 20 Feb. 2023
Try this —
T1 = array2table([sort(randi(1E+4, 12,1)) rand(12,1)*1E+3], 'VariableNames',{'Distance','Depth'})
T1 = 12×2 table
Distance Depth ________ ______ 387 660.72 948 177.47 1063 750.46 2557 800.03 3207 812.46 4697 215.64 5233 797.51 6848 324.8 7895 438.41 8677 808.11 8851 328.27 9910 651.15
Dep = interp1(T1.Distance, T1.Depth, 5945)
Dep = 589.1087
figure
plot(T1.Distance, T1.Depth, 'DisplayName','Data')
hold on
plot(5945, Dep, 'rs', 'DisplayName','Interpolated Value')
hold off
grid
xlabel('Distance')
ylabel('Depth')
xline(5945, ':k', 'Distance = 5945')
The reverse is just as straightforward (‘Distance’ as a funciton of ‘Depth’), however one extra step is involved.
.

Kategorien

Mehr zu Programming 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!

Translated by