Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

progree

(11,463 posts)
5. Oh geez, I clicked on Download Data at the Carbon Monitor and got 25,543 rows of data
Fri Jul 26, 2024, 11:48 PM
Jul 2024

for 3 years worth . carbonmonitor.org

Here is what it looks like for ONE DAY - 84 rows not including the header
country date sector MtCO2 per day
Brazil 01/01/2023 Domestic Aviation 0.0200738
Brazil 01/01/2023 Ground Transport 0.23143
Brazil 01/01/2023 Industry 0.238468
Brazil 01/01/2023 International Aviation 0.0138432
Brazil 01/01/2023 Power 0.0853684
Brazil 01/01/2023 Residential 0.0984519
China 01/01/2023 Domestic Aviation 0.0867145
China 01/01/2023 Ground Transport 2.16809
China 01/01/2023 Industry 12.8764
China 01/01/2023 International Aviation 0.0168365
China 01/01/2023 Power 16.9097
China 01/01/2023 Residential 3.68142
blah blah blah blah for a gazillion rows
WORLD 01/01/2023 Domestic Aviation 0.697971
WORLD 01/01/2023 Ground Transport 14.0947
WORLD 01/01/2023 Industry 28.123
WORLD 01/01/2023 International Aviation 1.3214
WORLD 01/01/2023 Power 36.7724
WORLD 01/01/2023 Residential 15.2654

They don't even bother adding the sectors up.

Anyway, I'll have to brush up on Excel database operations, which I haven't used in at least a decade, and then not very much.

Presumably, for a year of data, I could extract all records with WORLD in column A. And then simply sum up all 6*365=2190 rows of that to get a year total of WORLD, all sectors combined. (Yes, I know about =SUM(range) in Excel). Probably not difficult to do the database extraction part either, maybe later.

There's also a DSUM function in Excel that will sum up all records with a field or fields matching criteria. So I probably won't have to bother with extracting WORLD first.

Latest Discussions»Issue Forums»Environment & Energy»World CO2 emissions may b...»Reply #5