---

from openpyxl import load_workbook


a = load_workbook("census.xlsx")
b = a["Жители"]

c = []
d = []
e = []
f = {}

for g in range(2, b.max_row + 1):
    h = b.cell(g, 3).value
    i = b.cell(g, 4).value
    j = b.cell(g, 5).value

    if h is None or i is None or j is None:
        continue

    c.append(i)
    d.append(j)
    e.append(h)

    if h not in f:
        f[h] = 0
    f[h] += 1

g = max(f, key=f.get)
h = len(c)

i = a["Статистика"] if "Статистика" in a.sheetnames else a.create_sheet(
    "Статистика")

j = [
    "Максимальный возраст",
    "Средний возраст",
    "Максимальный рост",
    "Средний рост",
    "Титульная раса (код)",
    "Процент титульной расы"
]

k = [
    max(c),
    round(sum(c) / h, 2),
    max(d),
    round(sum(d) / h, 2),
    g,
    round(f[g] / h * 100, 2)
]

for l1 in range(6):
    i.cell(l1 + 1, 1).value = j[l1]
    i.cell(l1 + 1, 2).value = k[l1]

a.save("statistics.xlsx")