import datetime import re import japanize_matplotlib import matplotlib.pyplot as plt import pandas as pd JST = datetime.timezone(datetime.timedelta(hours=+9)) dt_now = datetime.datetime.now(JST).replace(tzinfo=None) url = f"http://xxxxxxxxxx/kafun/{dt_now.year}-{dt_now.month}.html" url data = pd.read_html(url)[1].values columns = [ re.sub("\s", "", "_".join([x] if x == y else [x, y])) for x, y in zip(*data[0:2]) ] columns columns[0] = "day" columns[1] = "曜日" df0 = pd.DataFrame(data[2:-2], columns=columns) df0["date"] = pd.to_datetime( pd.DataFrame(df0["day"]).assign(year=dt_now.year, month=dt_now.month) ) df0.drop(["day", "曜日"], axis=1, inplace=True) df0.set_index("date", inplace=True) df1 = df0.astype(float) df1 df1.plot.bar(figsize=(20, 20), subplots=True, layout=(5, 4), sharex=True, sharey=True)