Matching two columns from an imported table to find the corresponding value in the 5th column.

1 次查看（过去 30 天）
Samuel Ofosu-Yeboah
评论： Samuel Ofosu-Yeboah 2022-2-2
I have a 401 x 12 table that was imported from excel into matlab. I want a function that returns a value from the 5th column when I give two values from the first two columns.
  2 个评论
Samuel Ofosu-Yeboah
Samuel Ofosu-Yeboah 2022-2-2
Alright. Sure.
The table has headings as Temperature, Pressure, Density, Internal energy, and Enthalpy as shown below. I want a function that takes a particular temperature and pressure to return the corresponding Enthalpy. Lets say, in the function I put 360 as temperature and 175.5 as density and it returns 2608 as enthalpy.
Hope this is much clearer. Thanks

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Enrico Gambini
Enrico Gambini 2022-2-2
编辑：Enrico Gambini 2022-2-2
One method to extract what you want could be
temp=input("Insert temperature: \n"); %here you insert the parameters in the command window
%Otherwise you can do manually from the code
temp=360; %you can change it
Then you can create your function code file
function enthalpy=find_enthalpy(temp)
idx=find((Table.Temperature(:)==temp); %i called "Table" your table from excel
enthalpy=Table.Enthalpy(idx);
fprintf("The enthalpy is :",enthalpy); %not necessary
end
From your script, or directly from command window you can call the function
enthalpy=find_enthalpy(temp)
Let me know if works
  5 个评论
显示 3更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by