I uploaded the file: owid-energy-data.csv
Great! Let's start by loading the data from the owid-energy-data.csv
file and inspecting its structure to understand what we're working with. I'll display the first few rows of the dataset.
Objective: Examine how global primary energy consumption has evolved over time. Approach: Plot global energy consumption year by year, broken down by energy source (e.g., coal, oil, natural gas, renewables). Analyze growth rates in total energy consumption. Investigate how the share of renewables has changed in the global energy mix.
To address the objective, I will first aggregate the global primary energy consumption data by year and energy source, then plot it to visualize trends. I'll calculate growth rates for total energy consumption and analyze the change in the share of renewables over time. Let's start by preparing and visualizing the data.
The dataset has been successfully loaded. Here are the first few rows of the dataset:
ASEAN (Ember) | 2000 | null | null | null | null | null | null | null | null | 5.87 | 1.55 | null | 569.557 | null | null | null | null | null | 76.03 | null | null | null | null | 20.081 | null | 378.61 | null | 378.61 | null | null | null | null | null | null | null | null | 305.36 | null | null | 80.653 | null | null | null | null | null | 164.26 | null | null | null | null | null | 43.385 | null | 215.64 | null | null | null | null | 50.45 | null | 13.325 | null | null | null | null | null | 73.25 | null | 19.347 | null | null | null | null | null | null | null | 0 | null | 0 | null | null | null | null | null | 65.07 | null | null | null | null | null | 17.187 | null | null | 22.8 | 16.93 | null | null | null | null |
ASEAN (Ember) | 2001 | null | null | null | null | null | null | null | null | 6.46 | 1.596 | null | 567.642 | null | null | null | null | null | 86.26 | null | null | null | null | 21.307 | null | 404.85 | null | 404.85 | null | null | null | null | null | null | null | null | 327.66 | null | null | 80.934 | null | null | null | null | null | 190.41 | null | null | null | null | null | 47.032 | null | 229.81 | null | null | null | null | 54.33 | null | 13.42 | null | null | null | null | null | 77.19 | null | 19.066 | null | null | null | null | null | null | null | 0 | null | 0 | null | null | null | null | null | 50.99 | null | null | null | null | null | 12.595 | null | null | 22.86 | 16.4 | null | null | null | null |
ASEAN (Ember) | 2002 | null | null | null | null | null | null | null | null | 6.62 | 1.528 | null | 570.212 | null | null | null | null | null | 93.43 | null | null | null | null | 21.568 | null | 433.19 | null | 433.19 | null | null | null | null | null | null | null | null | 356.67 | null | null | 82.336 | null | null | null | null | null | 208.92 | null | null | null | null | null | 48.228 | null | 247.01 | null | null | null | null | 53.29 | null | 12.302 | null | null | null | null | null | 76.52 | null | 17.664 | null | null | null | null | null | null | null | 0 | null | 0 | null | null | null | null | null | 54.32 | null | null | null | null | null | 12.54 | null | null | 23.23 | 16.61 | null | null | null | null |
ASEAN (Ember) | 2003 | null | null | null | null | null | null | null | null | 7.45 | 1.626 | null | 574.699 | null | null | null | null | null | 102.01 | null | null | null | null | 22.261 | null | 458.24 | null | 458.24 | null | null | null | null | null | null | null | null | 381.84 | null | null | 83.328 | null | null | null | null | null | 226.51 | null | null | null | null | null | 49.43 | null | 263.35 | null | null | null | null | 53.21 | null | 11.612 | null | null | null | null | null | 76.4 | null | 16.672 | null | null | null | null | null | null | null | 0 | null | 0 | null | null | null | null | null | 53.32 | null | null | null | null | null | 11.636 | null | null | 23.19 | 15.74 | null | null | null | null |
ASEAN (Ember) | 2004 | null | null | null | null | null | null | null | null | 8.4 | 1.692 | null | 581.42 | null | null | null | null | null | 115.01 | null | null | null | null | 23.161 | null | 496.56 | null | 496.56 | null | null | null | null | null | null | null | null | 418.6 | null | null | 84.3 | null | null | null | null | null | 244.16 | null | null | null | null | null | 49.17 | null | 288.71 | null | null | null | null | 52.99 | null | 10.671 | null | null | null | null | null | 77.96 | null | 15.7 | null | null | null | null | null | null | null | 0 | null | 0 | null | null | null | null | null | 59.43 | null | null | null | null | null | 11.968 | null | null | 24.97 | 16.57 | null | null | null | null |
This dataset contains various columns related to energy consumption, production, and other related metrics across different countries and years. If you have any specific analysis or questions in mind, feel free to let me know!
Let's analyze the growth rates and renewable share:
The analysis shows the average annual growth rate of global energy consumption and the change in the share of renewables over time. The renewable share has increased from 11.96% in 1965 to 19.59% in 2022. The plot below illustrates the trend in renewable energy share over the years.
The following sources are missing from your remote server: owid-energy-data.csv.
Files persist for 1 hour after your last activity after which they are deleted. If you recently uploaded these files, please contact team@julius.ai in case there's a bug.
Please try the following: