月の予定表のテンプレ(祝日情報付き)

make_schedule_table.py

import pandas as pd
import japandas as jpd
import datetime
import tabulate


def make_schedule_table(start_date):
    end_date = jpd.to_datetime(start_date) + pd.offsets.MonthEnd(1)
    df = pd.DataFrame(dict(date=jpd.date_range(start_date, end_date)))
    weekdays = dict(enumerate("月火水木金土日"))
    df["weekday"] = df.date.dt.weekday.map(weekdays)
    df["date"] = df.date.dt.date

    holiday_calender = jpd.JapaneseHolidayCalendar()
    rules = holiday_calender.rules
    holidays = pd.DataFrame(dict(holiday_name=list(map(lambda r: r.name, rules)),
                                             date=list(map(lambda r: datetime.date(r.year, r.month, r.day), rules))))
    df = df.merge(holidays, on="date", how="left")
    df["note"] = ""
    print(tabulate.tabulate(df, headers="keys", tablefmt="pipe", missingval="", showindex=False))

make_schedule_table("2017年1月1日")