How to create a contour plot of e.g. air temperature

[jkittner]

I was wondering how to make a contourplot working. I was able to create this in python but I have a hard time translating this to the homeassistant card.

I think one challenge is to extract the day and hour and somehow perform the pivot - any ideas appreciated!

I get this plot:

From this code:

def _plot_thermopleths(data: pd.DataFrame, fname: str) -> None:
    data['day'] = data.index.day
    data['hour'] = data.index.hour
    data['date'] = data.index.date
    df = data.pivot_table(
        index='hour',
        columns='date',
        values='lufttempmittel',
    )

    fig = go.Figure(
        data=go.Contour(
            z=df.values,
            x=df.columns.values,
            y=df.index.values,
            colorscale='Spectral',
            connectgaps=True,
            reversescale=True,
            colorbar={
                'title': {
                    'side': 'right',
                    'text': 'Lufttemperatur (°C)',
                },
                'nticks': 24,
                'ticks': 'outside',
                'ticklen': 5,
                'tickwidth': 1,
                'showticklabels': True,
                'tickangle': 0,
                'tickfont_size': 12,
            },
            contours={
                'showlabels': True,
                'labelfont': {'size': 14},
            },
        ),
    )

    fig.update_traces(ncontours=24, selector={'type': 'contour'})
    fig.update_layout(
        margin={'l': 0, 'r': 0, 'b': 0, 't': 0},
        yaxis={
            'tickmode': 'linear',
            'tick0': 1,
            'dtick': 2,
        },
        font={'size': 15},
        yaxis_title='Stunde des Tages (UTC+1)',
    )

    fig.write_image(
        os.path.join(
            'data_dir', f'thermopleths_{fname}.png',
        ), scale=4,
    )