Generating cadCAD style data

cadcad_gen.py

import numpy as np
import pandas as pd
import hvplot.pandas

labels = list('ABC')
states = 4
xs = 100

df = pd.DataFrame({'x': len(labels)*states*list(range(xs)), 'label': [l for l in labels for _ in range(states*xs)], 'State': len(labels)*[s for s in list(range(states)) for _ in range(xs)], 'Value': 0.52+np.random.rand(len(labels)*states*xs)})

df['Value'] = df.groupby(['label', 'State']).cumprod()['Value']

df

# Observe
df.hvplot(x='x', y='Value', by='label', groupby='State')

df.hvplot(x='x', y='Value', by='State', groupby='label')

df.hvplot(x='x', y='Value', by='label', row='State', shared_axes=False)

See here for inspiration: https://discourse.holoviz.org/t/hvplot-row-not-working/6621