owid / co2-data

Data on CO2 and greenhouse gas emissions by Our World in Data
https://ourworldindata.org/co2-and-other-greenhouse-gas-emissions
639 stars 217 forks source link

known quantity not filled in #11

Closed mister-elliott closed 3 years ago

mister-elliott commented 3 years ago

owid_co2-data.csv

I don't understand this. The co2_growth_prct is shown as ,, for 1952, even though it must be 0, according to the co2 value for 1951 and 1952. same happens for 1953 to 1954. I would expect empty values ,, to mean NULL or unknown, but not 0 (zero).

iso_code,country,year,co2,co2_growth_prct,co2_growth_abs,consumption_co2,trade_co2,trade_co2_share,co2_per_capita,consumption_co2_per_capita,share_global_co2,cumulative_co2,share_global_cumulative_co2,co2_per_gdp,consumption_co2_per_gdp,co2_per_unit_energy,cement_co2,coal_co2,flaring_co2,gas_co2,oil_co2,other_industry_co2,cement_co2_per_capita,coal_co2_per_capita,flaring_co2_per_capita,gas_co2_per_capita,oil_co2_per_capita,other_co2_per_capita,share_global_coal_co2,share_global_oil_co2,share_global_gas_co2,share_global_flaring_co2,share_global_cement_co2,cumulative_coal_co2,cumulative_oil_co2,cumulative_gas_co2,cumulative_flaring_co2,cumulative_cement_co2,share_global_cumulative_coal_co2,share_global_cumulative_oil_co2,share_global_cumulative_gas_co2,share_global_cumulative_flaring_co2,share_global_cumulative_cement_co2,total_ghg,ghg_per_capita,methane,methane_per_capita,nitrous_oxide,nitrous_oxide_per_capita,primary_energy_consumption,energy_per_capita,energy_per_gdp,population,gdp AFG,Afghanistan,1949,0.015,,,,,,0.002,,0,0.015,0,,,,,0.015,,,,,,0.002,,,,,0,,,,,0.015,,,,,0,,,,,,,,,,,,,,7663783, AFG,Afghanistan,1950,0.084,475,0.07,,,,0.011,,0.001,0.099,0,0.004,,,,0.021,,,0.063,,,0.003,,,0.008,,0.001,0.004,,,,0.036,0.063,,,,0,0,,,,,,,,,,,,,7752000,19494799360 AFG,Afghanistan,1951,0.092,8.696,0.007,,,,0.012,,0.001,0.191,0,0.005,,,,0.026,,,0.066,,,0.003,,,0.008,,0.001,0.004,,,,0.061,0.129,,,,0,0,,,,,,,,,,,,,7840000,20063848448 AFG,Afghanistan,1952,0.092,,,,,,0.012,,0.001,0.282,0,0.004,,,,0.032,,,0.06,,,0.004,,,0.008,,0.001,0.003,,,,0.093,0.189,,,,0,0.001,,,,,,,,,,,,,7936000,20742350848 AFG,Afghanistan,1953,0.106,16,0.015,,,,0.013,,0.002,0.388,0,0.005,,,,0.038,,,0.068,,,0.005,,,0.008,,0.001,0.003,,,,0.131,0.257,,,,0,0.001,,,,,,,,,,,,,8040000,22015463424 AFG,Afghanistan,1954,0.106,,,,,,0.013,,0.002,0.495,0,0.005,,,,0.043,,,0.064,,,0.005,,,0.008,,0.001,0.003,,,,0.174,0.321,,,,0,0.001,,,,,,,,,,,,,8151000,22483329024 AFG,Afghanistan,1955,0.154,44.828,0.048,,,,0.019,,0.002,0.649,0,0.007,,,,0.062,,,0.092,,,0.008,,,0.011,,0.001,0.004,,,,0.236,0.413,,,,0,0.001,,,,,,,,,,,,,8271000,22929889280 ....

edomt commented 3 years ago

Possible related to #16 — at least the data already looks like this in our grapher dataset, so the issue is further upstream.