In [23]:
from os import getcwd
from pathlib import Path
src_path = (Path(getcwd()) / '..' / 'data' / 'wrangled' / 'combined.csv').resolve()
In [31]:
import pandas as pd
In [33]:
df = pd.read_csv(src_path, dtype=object)
In [44]:
pd.pivot_table(df, index=['Lic Type'], columns=['yearmonth'], aggfunc=len, values='year')
Out[44]:
In [ ]: