The Risk Heatmap Generator is a Python script that reads an Excel file containing risk data and generates a heatmap visualization based on the provided risks. The heatmap represents the risks on a 10x10 grid, with colors indicating the level of risk.
- Reads risk data from an Excel file
- Generates a heatmap visualization based on risk levels
- Allows customization of color gradient, labels, and scale
- Supports exporting the heatmap as PNG, JPEG, TIFF, or PDF
- Python 3.x
- pandas
- matplotlib
- openpyxl
-
Clone the repository or download the script file (
risk-heatmap.py
). -
Install the required dependencies using pip:
pip install pandas matplotlib openpyxl
-
Prepare an Excel file with the risk data. The file should have the following columns:
Likelihood
: The likelihood of the risk occurrence (numeric value between 1 and 10)Impact
: The impact of the risk (numeric value between 1 and 10)
-
Run the script with the following command:
python risk-heatmap.py path/to/excel-file.xlsx
-
Follow the prompts to select the desired file format (PNG, JPEG, TIFF, or PDF).
-
The script will generate a heatmap visualization based on the risk data and save it as an image file.