As part of a case assignment, I was asked to put together a data visualization model known as a correlation heatmap matrix in order to be able to identify some of the main correlations occuring between events. For this, I found some helpful resources and after compiling all of the data into an excel spreadsheet I was able to produce the heatmap matrix. The process was relatively easy & straightforward to follow, so I decided to put together this helpful little guide for anyone who wishes to put together a similar model to the one shown above!
Note: In order to be able to follow this guide, make sure you have Jupyter Notebook setup and able to run with Python.
First, make sure to place all of your data into columns into excel spreadsheet with the first row containing the columns names:
Next, create & open a new jupyter notebook, and begin typing and running the following lines as follows:
-
Next, read in your Excel file and use the .head() function to check if the output is correct:
-
Lastly, use the following lines and voilà, you have your heatmap!
- Anaconda
- Jupyter Notebook
- GitHub
- GitHub Desktop
- Credit goes to RegenerativeToday for the helpful video tutorial I used in generating this heatmap!