Skip to content
2 min read · Tags: excel grouping regression plotting pipe

BW #92: Climate disaster costs

Get better at: Working with Excel files, grouping, linear regression, and plotting

BW #92: Climate disaster costs

[Like many others, I've been getting active on BlueSky. Follow me there, at https://bsky.app/@lernerpython.com!]

COP 29 (https://unfccc.int/cop29/about-cop29), the annual UN conference on climate change, earlier on Monday of this week in Baku, Azerbaijan. Representatives from countries around the world have all come together to discuss progress toward reducing the rate of climate change, which is wreaking havoc all over the world.

Not coincidentally, the International Chamber of Commerce, representing businesses from all over the world, released a report on November 7th called, "The economist cost of extreme weather events." Their report, downloadable from https://iccwbo.org/news-publications/policies-reports/new-report-extreme-weather-events-cost-economy-2-trillion-over-the-last-decade/, shows that climate change isn't just a scientific or political issue, but a business one as well, one which is costing companies (and individuals and governments) quite a bit.

This report was based, at least in part, on information at EM-DAT (https://www.emdat.be/), which dubs itself "The international disaster database"). To get their data, you'll need to register (for free) for the site, and then get it from https://public.emdat.be/data, choosing both classifications (ecological and technological) and all regions of the world, and from all years 2000 - 2024.

The data dictionary for this information is at https://doc.emdat.be/docs/data-structure-and-content/emdat-public-table/ .

Data and seven questions

This week, I have seven tasks and questions for you. I'll be back tomorrow with my solutions.

The learning goals for this week include: Reading Excel data, grouping, linear regression, and plotting.

Here are this week's questions: