Borrar filtros
Borrar filtros

Return a value in csv data at a specific point

3 visualizaciones (últimos 30 días)
Jack Lakeman
Jack Lakeman el 17 de Feb. de 2023
Respondida: Star Strider el 20 de Feb. de 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 comentario
Mathieu NOE
Mathieu NOE el 17 de Feb. de 2023
hello
have you started a code ?
have data (csv) file to share ?

Iniciar sesión para comentar.

Respuestas (2)

Krishna
Krishna el 20 de Feb. de 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 el 20 de Feb. de 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.
.

Categorías

Más información sobre Programming en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by