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

2 次查看（过去 30 天）

Samuel Ofosu-Yeboah 2022-2-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1641445-matching-two-columns-from-an-imported-table-to-find-the-corresponding-value-in-the-5th-column

评论： 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 个评论
显示无隐藏无

Sebastian Daneli 2022-2-2

You need to specify your question. Can you give an example?

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 2022-2-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1641445-matching-two-columns-from-an-imported-table-to-find-the-corresponding-value-in-the-5th-column#answer_887280

编辑：Enrico Gambini 2022-2-2

在 MATLAB Online 中打开

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