altair: recipe

Don't forget to first have your dataframe ready when you make charts with altair.

import pathlib
import pandas as pd
import altair as alt

df = pd.read_csv("content/data/birthdays.csv")

def clean_dataset(dataf):
    return (dataf
            .assign(date = lambda d: pd.to_datetime(d['date']))
            .assign(yday = lambda d: d['date'].dt.dayofyear)
            .drop(columns=['Unnamed: 0'])
            .groupby(['date', 'wday', 'yday'])
            .agg(births = ('births', 'sum'), month=('month', 'first'))
            .reset_index()
            .head(1000))

plot_df = df.pipe(clean_dataset)

The code for the plot is listed below;

(alt.Chart(plot_df)
  .mark_point(color='black')
  .encode(x='yday', y='births')
  .properties(width=600, height=300)
  .interactive())