From the course: Practical Python for Time Series Analysis

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Create heat map visualizations

Create heat map visualizations

- [Instructor] Pivot table for heat maps. Another type of visualization that you can develop through aggregating the information is the heat matrix, where you can rank based on a column. In this case, the average of energy generation in California for each one of the technologies throughout the months. In this case, you observe that natural gas is the king in the chart, followed by the solar power, which is normal given the sunny state of California. At the same time, we see that during summer months, solar energy is more significant. While in the rest, it is not that much. Precisely in January, when there is not a lot of solar energy, the natural gas has one of the highest at almost 15. To develop this nice visualization, first we will start with loading the raw dataset, selecting the specific columns that we will work with. Technology, energy, and the abbreviation, which is tech, and also the period. Then we'll calculate…

Contents