How to create a Heatmap in Excel using Python
📄 Description:
In this video, you'll learn how to create a beautiful and informative Seaborn Heatmap directly in Excel using Python. We use the average monthly temperatures in New York City from 2015 to 2024 — visualized with just a few lines of Python code.
You’ll learn how to:
✅ Load data from Excel into a Pandas DataFrame
✅ Create a base Seaborn Heatmap
✅ Customize your heatmap
✅ Use ChatGPT to customize your graph
This is a great example of how you to use Python’s powerful visualization in Excel.
Python in Excel availability
Check the following link for the latest availability: https://support.microsoft.com/en-us/o...
⏱️ Timestamps / Chapters:
00:00 Introduction
00:14 Loading the data into Pandas from Excel to create the heatmap
01:21 Creating a basic Seaborn heatmap
02:04 Customizing annotations
02:34 Using ChatGPT to locate other arguments for customizing the heatmap
📁 Download the Excel dataset used in this tutorial: https://drive.google.com/uc?export=do...