MATLAB: Select rows in a table given two conditions

Question

Hello everyone. I have the following table named TAB1:

Description Year Value

'Steam Coal EU' 2045 78.5000000000000

'Steam Coal EU' 2050 80

'Steam Coal EU' 2055 81.5000000000000

'CO2' 2015 7.62553571428572

'CO2' 2020 8.87000000000000

'CO2' 2025 19.2558584219015

I`m searching for a way to get the Value of CO2 and 2020 (8.87000000000000). My original table is way bigger and might be completed later, so hard coding like TAB1{4,3} is not what i`m searching.

I have the following approach:

TAB1{strcmp(TAB1,'CO2'),'Value'})

This gives me all values with CO2 on the left – but i just want the second value. Can someone help? Thanks a lot.

Answer 1

I'm not conviced that your TAB1 is actually a table.

If it is:

TAB1.Value(strcmp(TAB1.Description, 'CO2') & TAB1.Year == 2020)

Note that if you're using strings instead of char arrays in the Description variable, then you can use == instead of strcmp:

TAB1.Value(TAB1.Description == "CO2" & TAB1.Year == 2020)