Weekly cost by component

[betatim]

Instead of posting screenshots to twitter, I thought I'd store the weekly snippet here :)

categories = data.groupby(['date', 'category', 'line_item']).sum()['cost'].reset_index()
categories = categories.groupby(['date', 'category']).sum().reset_index()

weekly = (categories.replace(np.nan, 0)
          .groupby(['category']).resample("W", on='date').sum().reset_index())


alt.Chart(data=weekly, width=width).mark_line(clip=True).encode(
    x=alt.X('date', axis=alt.Axis(title='Date (weeks)')),
    y=alt.Y('cost',
            axis=alt.Axis(title='Cost (USD)'),
            scale=alt.Scale(domain=(0, 1000))),
    color="category"
)

[choldgraf]

nice! want to update the notebook? Or leave it in issue form?

[betatim]

I think we should get https://twitter.com/antarcticdesign/status/1116618370319675393 to send us his code (by picture or real code) :)

[choldgraf]

yeah I agree, those are purdy plots :-)