dev notes

software development craftsmanship


Due to the covid 19 outbreak springer is launching a global program to support learning worldwilde.

Harish Narayanan build a small python project to build a static website from the springer provided excel files. The result looks interesting, because you can use the book links, without having excel installed.

The script looks as following:

rt pandas as pd
from jinja2 import Environment, FileSystemLoader

books_df = pd.read_excel("./input/Free+English+textbooks.xlsx")
grouped_books_df = books_df.groupby(["English Package Name"])

loader = FileSystemLoader(searchpath="./templates/")
env = Environment(loader=loader)
template = env.get_template("index.html")

grouped_books = {}

for group, books in grouped_books_df:
    grouped_books[group] = []
        for book in books.iterrows():

                  rendered_template = template.render(grouped_books=grouped_books)

with open("index.html", "w") as f:

Just a few lines of python and an excel sheet looks much nicer.