main.py

from http.server import HTTPServer, SimpleHTTPRequestHandler
from jinja2 import Environment, FileSystemLoader, select_autoescape
import datetime
import pandas as pd
import collections
import argparse

parser = argparse.ArgumentParser(description='Для запуска сайта винодельни введите путь до файла-каталога вина как аргумент')
parser.add_argument('path', help='Введите путь до файла-каталога вин:')
args = parser.parse_args()


env = Environment(
    loader=FileSystemLoader('.'),
    autoescape=select_autoescape(['html']),
    trim_blocks=True,
    lstrip_blocks=True
)

template = env.get_template('template.html')


today = datetime.date.today().year
foundation_year = 1920
company_age = today - foundation_year
last_digit = company_age % 10
if last_digit == 1 and company_age != 11:
    company_age_years = f'{company_age} год'
elif last_digit in (2, 3, 4) and (company_age < 12 or company_age > 19):
    company_age_years = f'{company_age} года'
else:
    company_age_years = f'{company_age} лет'


wines = pd.read_excel(args.path, keep_default_na=False).to_dict(orient='records')
wine_assortment = collections.defaultdict(list)
for bottle in wines:
    wine_assortment[bottle['Категория']].append(bottle)


rendered_page = template.render(company_age_years=company_age_years,
                                wines=sorted(wine_assortment.items()))

with open('index.html', 'w', encoding="utf8") as file:
    file.write(rendered_page)

server = HTTPServer(('0.0.0.0', 8000), SimpleHTTPRequestHandler)
server.serve_forever()