Meta columns with 'false' instead of 0

[byersiiasa]

In reproducing the iconics table - some values have been set to false instead of 0.

Set 1:

• Columns: ['Carbon Sequestration|CCS|Fossil in year of net zero, Mt CO2/yr', 'Carbon Sequestration|CCS|Fossil in 2050, Mt CO2/yr']
• mod-scen:
  • REMIND-MAgPIE 2.1-4.2
  • EN_NPi2020_200f
  • EN_NPi2020_300f
  • EN_NPi2020_400
  • EN_NPi2020_400f
  • EN_NPi2020_500
  • EN_NPi2020_600

Set 2:

• Columns: ['Final Energy|Residential and Commercial|Fossil|Share in year of net zero, %', 'Final Energy|Residential and Commercial|Fossil|Share in 2050, %']
• mod-scen:
  • REMIND 3.2 def_300_withICEPhOP def_500_withICEPhOP def_800_withICEPhOP def_bioLim12_300_withICEPhOP def_bioLim12_500_withICEPhOP def_bioLim12_800_withICEPhOP def_bioLim7p5_300_withICEPhOP def_bioLim7p5_500_withICEPhOP def_bioLim7p5_800_withICEPhOP flex_300_withICEPhOP flex_500_withICEPhOP flex_800_withICEPhOP flex_bioLim12_300_withICEPhOP flex_bioLim12_500_withICEPhOP flex_bioLim12_800_withICEPhOP flex_bioLim7p5_300_withICEPhOP flex_bioLim7p5_500_withICEPhOP flex_bioLim7p5_800_withICEPhOP NZero_bioLim12_withICEPhOP NZero_bioLim7p5_withICEPhOP NZero_withICEPhOP rigid_300_withICEPhOP rigid_500_withICEPhOP rigid_800_withICEPhOP rigid_bioLim12_300_withICEPhOP rigid_bioLim12_500_withICEPhOP rigid_bioLim12_800_withICEPhOP rigid_bioLim7p5_300_withICEPhOP rigid_bioLim7p5_500_withICEPhOP rigid_bioLim7p5_800_withICEPhOP

[danielhuppmann]

Is this in xlsx files that are available for download or via the pyam API?

[byersiiasa]

in the pyam API - haven't checked the excel files

See queries here

import pyam
instance = 'eu-climate-advisory-board'

# Set 1
metacols = ['Carbon Sequestration|CCS|Fossil in year of net zero, Mt CO2/yr', 
'Carbon Sequestration|CCS|Fossil in 2050, Mt CO2/yr']
df1 =  pyam.read_iiasa(instance,
                        model='REMIND-MAgPIE 2.1-4.2',
                        scenario=[
                                    'EN_NPi2020_200f',
                                    'EN_NPi2020_300f',
                                    'EN_NPi2020_400',
                                    'EN_NPi2020_400f',
                                    'EN_NPi2020_500',
                                    'EN_NPi2020_600'
                                ],
                        variable='Diagnostics|Harmonized|Emissions|CO2',
                       region='EU27', meta=True)

df1.meta[metacols]

# Set 2
metacols = ['Final Energy|Residential and Commercial|Fossil|Share in year of net zero, %', 
'Final Energy|Residential and Commercial|Fossil|Share in 2050, %']
df2 =  pyam.read_iiasa(instance,
                        model='REMIND 3.2',
                        scenario=[
                                    'def_300_withICEPhOP',
                                    'def_500_withICEPhOP',
                                    'def_800_withICEPhOP',
                                    'def_bioLim12_300_withICEPhOP',
                                    'def_bioLim12_500_withICEPhOP',
                                    'def_bioLim12_800_withICEPhOP',
                                    'def_bioLim7p5_300_withICEPhOP',
                                    'def_bioLim7p5_500_withICEPhOP',
                                    'def_bioLim7p5_800_withICEPhOP',
                                    'flex_300_withICEPhOP',
                                    'flex_500_withICEPhOP',
                                    'flex_800_withICEPhOP',
                                    'flex_bioLim12_300_withICEPhOP',
                                    'flex_bioLim12_500_withICEPhOP',
                                    'flex_bioLim12_800_withICEPhOP',
                                    'flex_bioLim7p5_300_withICEPhOP',
                                    'flex_bioLim7p5_500_withICEPhOP',
                                    'flex_bioLim7p5_800_withICEPhOP',
                                    'NZero_bioLim12_withICEPhOP',
                                    'NZero_bioLim7p5_withICEPhOP',
                                    'NZero_withICEPhOP',
                                    'rigid_300_withICEPhOP',
                                    'rigid_500_withICEPhOP',
                                    'rigid_800_withICEPhOP',
                                    'rigid_bioLim12_300_withICEPhOP',
                                    'rigid_bioLim12_500_withICEPhOP',
                                    'rigid_bioLim12_800_withICEPhOP',
                                    'rigid_bioLim7p5_300_withICEPhOP',
                                    'rigid_bioLim7p5_500_withICEPhOP',
                                    'rigid_bioLim7p5_800_withICEPhOP'
                                ],
                        variable='Diagnostics|Harmonized|Emissions|CO2',
                       region='EU27', meta=True)

df2.meta[metacols]