| Name | Description | Source | Update |
|---|---|---|---|
| 1.Coal phase-out timeline | Country’s pledges on coal phase-out (already coal-free, by 2030, by 2040, by 2050, or no pledge) | Our World in Data based on Powering Past Coal Alliance; Ember Climate; Beyond Coal EU; Bloomberg Coal Countdown and other sources | Latest data: 2021 |
| 2.Share of coal in electricity | Country’s %share of coal in total electricity production (1985-2021) | Our World in Data based on BP Statistical Review of World Energy & Ember | Latest data: 2021 |
| 3.Electricity production by source | Country’s electricity production (TWh) by different sources (1985-2021) | Our World in Data based on BP Statistical Review of World Energy & Ember | Latest data: 2021 |
| 4.JETP South Africa | Financial support from Just Energy Transition Partnership to South Africa | UNFCCC COP26 Updates on JETP | Latest data: 2022 |
| 5.Public investment in energy | Global renewable energy finance flows by technology, region, donor, financial instrument and financial institution/agency | IRENA Renewable Energy Finance Flows | Latest data: 2020 |
| 6.Coal project finance | Global coal project financing and details | Global Coal Project Finance Tracker, Global Energy Monitor | Latest data: 2022 |
Final Project: Data Cleaning
Project topic: Energy Transition / Just Transition / Coal Phase-out
The initial purpose of the analysis is to understand global trends in financing for a just energy transition.
Specific questions will be developed based on the availability of data.
Data Source
Data Clean
- First, load all the data frames, and here is a list of their variables:
- Coal phase-out timeline
[1] "Coal_Exit_Timeline" "Coal_Free_Year" "Country_Code"
[4] "Country_Name" - Share of coal in electricity
[1] "Coal_share" "Country_Code" "Name" "Year" - Electricity production by source
[1] "Country_Code"
[2] "Country_Name"
[3] "Electricity from bioenergy (TWh) (zero filled)"
[4] "Electricity from coal (TWh)"
[5] "Electricity from gas (TWh)"
[6] "Electricity from hydro (TWh)"
[7] "Electricity from nuclear (TWh)"
[8] "Electricity from oil (TWh)"
[9] "Electricity from solar (TWh)"
[10] "Electricity from wind (TWh)"
[11] "Other renewables excluding bioenergy (TWh) (zero filled)"
[12] "Year" - JETP South Africa
[1] "Commercial Loans" "Concessional loans"
[3] "Grants/Technical Assistance" "Guarantees"
[5] "total (source)" "US$ millions" - Public investment in energy
[1] "Agency" "Amount (2020 USD million)"
[3] "Category" "Country/Area"
[5] "Donor" "Finance Group"
[7] "Finance Type" "ISO-code"
[9] "Project" "Reference Date"
[11] "Region" "Source"
[13] "Sub-technology" "Technology"
[15] "Year" - Coal project finance
[1] "Accuracy" "Advisor"
[3] "All Finance This Plant" "BoilerMFR"
[5] "Capacity (MW)" "Chinese Name"
[7] "Close Date" "Close Year"
[9] "Coal source" "Coal type"
[11] "Combustion technology" "Country"
[13] "Domestic/International" "EPC Company"
[15] "Equipment (GENMFR)" "Financier"
[17] "Financier Country" "Financier Public or Private"
[19] "Financier Type" "Financing Status"
[21] "Insurance" "Latitude"
[23] "Local area (taluk, county)" "Location"
[25] "Longitude" "Major area (prefecture, district)"
[27] "Operating Year" "Other names"
[29] "Owner" "Parent"
[31] "Planned Retire" "Plant"
[33] "Plant status" "Region"
[35] "RETIRED" "Subnational unit (province, state)"
[37] "This Financier's Total Share" "This Financier's Unit Share"
[39] "Tracker ID" "TrackerLOC"
[41] "TurbMFR" "Type of Finance"
[43] "Unit" "Units Included"
[45] "Wiki page" - These data frames are already in long format.