heatmap.py

import numpy as np
import matplotlib
import matplotlib.pyplot as plt
import datetime
import pandas as pd

# https://matplotlib.org/stable/gallery/images_contours_and_fields/image_annotated_heatmap.html


def heatmap(data, row_labels, col_labels, ax=None,
            cbar_kw={}, cbarlabel="", **kwargs):
    """
    Create a heatmap from a numpy array and two lists of labels.

    Parameters
    ----------
    data
        A 2D numpy array of shape (M, N).
    row_labels
        A list or array of length M with the labels for the rows.
    col_labels
        A list or array of length N with the labels for the columns.
    ax
        A `matplotlib.axes.Axes` instance to which the heatmap is plotted.  If
        not provided, use current axes or create a new one.  Optional.
    cbar_kw
        A dictionary with arguments to `matplotlib.Figure.colorbar`.  Optional.
    cbarlabel
        The label for the colorbar.  Optional.
    **kwargs
        All other arguments are forwarded to `imshow`.
    """

    if not ax:
        ax = plt.gca()

    # Plot the heatmap
    im = ax.imshow(data, **kwargs)

    # Create colorbar
    # cbar = ax.figure.colorbar(im, ax=ax, **cbar_kw)
    # cbar.ax.set_ylabel(cbarlabel, rotation=-90, va="bottom")

    # Show all ticks and label them with the respective list entries.
    ax.set_xticks(np.arange(data.shape[1]), labels=col_labels)
    ax.set_yticks(np.arange(data.shape[0]), labels=row_labels)

    # Let the horizontal axes labeling appear on top.
    ax.tick_params(top=True, bottom=False,
                   labeltop=True, labelbottom=False)

    # Rotate the tick labels and set their alignment.
    plt.setp(ax.get_xticklabels(), ha="right",
             rotation_mode="anchor")

    # Turn spines off and create white grid.
    ax.spines[:].set_visible(False)

    ax.set_xticks(np.arange(data.shape[1]+1)-.5, minor=True)
    ax.set_yticks(np.arange(data.shape[0]+1)-.5, minor=True)
    ax.grid(which="minor", color="w", linestyle='-', linewidth=3)
    ax.tick_params(which="minor", bottom=False, left=False)

    return im


def annotate_heatmap(im, data=None, valfmt="{x:.2f}",
                     textcolors=("black", "white"),
                     threshold=None, **textkw):
    """
    A function to annotate a heatmap.

    Parameters
    ----------
    im
        The AxesImage to be labeled.
    data
        Data used to annotate.  If None, the image's data is used.  Optional.
    valfmt
        The format of the annotations inside the heatmap.  This should either
        use the string format method, e.g. "$ {x:.2f}", or be a
        `matplotlib.ticker.Formatter`.  Optional.
    textcolors
        A pair of colors.  The first is used for values below a threshold,
        the second for those above.  Optional.
    threshold
        Value in data units according to which the colors from textcolors are
        applied.  If None (the default) uses the middle of the colormap as
        separation.  Optional.
    **kwargs
        All other arguments are forwarded to each call to `text` used to create
        the text labels.
    """

    if not isinstance(data, (list, np.ndarray)):
        data = im.get_array()

    # Normalize the threshold to the images color range.
    if threshold is not None:
        threshold = im.norm(threshold)
    else:
        threshold = im.norm(data.max())/2.

    # Set default alignment to center, but allow it to be
    # overwritten by textkw.
    kw = dict(horizontalalignment="center",
              verticalalignment="center")
    kw.update(textkw)

    # Get the formatter in case a string is supplied
    if isinstance(valfmt, str):
        valfmt = matplotlib.ticker.StrMethodFormatter(valfmt)

    # Loop over the data and create a `Text` for each "pixel".
    # Change the text's color depending on the data.
    texts = []
    for i in range(data.shape[0]):
        for j in range(data.shape[1]):
            kw.update(color=textcolors[int(im.norm(data[i, j]) > threshold)])
            text = im.axes.text(j, i, valfmt(data[i, j], None), **kw)
            texts.append(text)

    return texts


today = datetime.date.today()
year = today.year
print(year)

source_file_name = f'crc-cybersecurity-survey-{year}.csv'

questions_df = pd.read_csv(source_file_name)
questions = questions_df[questions_df.columns[0]].tolist()

marks = [1, 2, 3, 4, 5]

answers = np.loadtxt(source_file_name, delimiter=',', skiprows=1, usecols=range(1, 6))
print(answers)
answers_total_number = np.sum(answers, axis=1)
print(answers_total_number[0])
answers_percentage = answers/answers_total_number[0]
print(answers_percentage)

fig, ax = plt.subplots()
# https://matplotlib.org/stable/tutorials/colors/colormaps.html
# YlGn
im = heatmap(answers_percentage, questions, marks, ax=ax, cmap="Greens")
texts = annotate_heatmap(im, valfmt="{x:.0%}")

# Show all ticks and label them with the respective list entries
ax.set_xticks(np.arange(len(marks)), labels=marks)
ax.set_yticks(np.arange(len(questions)), labels=questions)

# Rotate the tick labels and set their alignment.
plt.setp(ax.get_xticklabels(), ha="center",
         rotation_mode="anchor")
# plt.setp(ax.get_yticklabels(), ha="left")

# Loop over data dimensions and create text annotations.
# for i in range(len(questions)):
#     for j in range(len(marks)):
#         text = ax.text(j, i, answers_percentage[i, j],
#                        ha="center", va="center", color="w")

# ax.set_title("Marks from training participants")

fig.set_size_inches(9, 3)
fig.tight_layout()
# plt.show()
plt.savefig(f'crc-cybersecurity-survey-{year}.png', dpi=100)