from datetime import datetime

print(f"Date of last update: {datetime.now().strftime('%d.%m.%Y, %H:%M')}")

Date of last update: 28.07.2025, 03:50

%load_ext jupyter_ai_magics

%load_ext autoreload

%autoreload 2

import seaborn as sns
import matplotlib.pyplot as plt

from IPython.display import display, Markdown
from mfnf import MFNF


def md(text):
    display(Markdown(text))


df = MFNF().aggregate_pageviews()

from datetime import datetime


def analyze(df):
    # one_year_ago = datetime.now() - timedelta(days=365)
    # df = df[(df["timestamp"] > one_year_ago) & (df["page_name"] is not None)]
    df["month"] = df["timestamp"].dt.to_period("M").dt.to_timestamp()
    df = df[["month", "views"]].groupby("month").sum()
    df["devices"] = df["views"] / 2.803827

    md("#### Lineplot of estimated devices per month")
    md(
        "Note: On average there are [~2.8 pageviews per device per month](https://github.com/kulla/analytics-mfnf/blob/main/notebooks/reports/2025-07-16-pageviews-per-user-on-wikibooks.ipynb) on the German wikibooks project."
    )
    plt.figure(figsize=(10, 6))
    sns.lineplot(data=df, x=df.index, y="devices")
    plt.title("Estimated devices per month")
    plt.xlabel("Month")
    plt.ylabel("Estimated umber of devices")
    plt.grid(True)
    plt.show()

    md("#### Lineplot of estimated reach in target audience")
    md(
        "Note: Here we use [200.000 students](https://de.statista.com/statistik/daten/studie/181643/umfrage/studienanfaenger-an-hochschulen-nach-faechergruppen/) as an estimate for the number of students with mathematics in the first semester."
    )
    df["reach"] = df["devices"] / 200000
    plt.figure(figsize=(10, 6))
    sns.lineplot(data=df, x=df.index, y="reach")
    plt.title("Estimated reach in target audience")
    plt.xlabel("Month")
    plt.ylabel("Ratio devices / students in first semester")
    plt.grid(True)
    plt.show()


analyze(df.copy())

for book in ["Analysis 1", "Grundlagen der Mathematik", "Lineare Algebra 1"]:
    md(f"### {book}")

    analyze(df[df["book_name"] == book].copy())

Estimation of our impact¶

Utility functions and imports¶

Estimation of impact for whole project¶

Lineplot of estimated devices per month¶

Lineplot of estimated reach in target audience¶

Estimation per book¶

Analysis 1¶

Lineplot of estimated devices per month¶

Lineplot of estimated reach in target audience¶

Grundlagen der Mathematik¶

Lineplot of estimated devices per month¶

Lineplot of estimated reach in target audience¶

Lineare Algebra 1¶

Lineplot of estimated devices per month¶

Lineplot of estimated reach in target audience¶

License of this report¶