{"id":10576,"date":"2023-12-26T19:19:11","date_gmt":"2023-12-27T00:19:11","guid":{"rendered":"https:\/\/www.rushworth.us\/lisa\/?p=10576"},"modified":"2023-12-26T19:19:11","modified_gmt":"2023-12-27T00:19:11","slug":"python-code-creating-title-images","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=10576","title":{"rendered":"Python Code — Creating Title Images"},"content":{"rendered":"\n

Instead of allowing YouTube to randomly pick a frame to use as the preview image, I have always made a title image for the Township meetings I post to YouTube. At first, this was a manual (and thus time consuming for a lot of videos). In the interim, I have created a script that generates the color gradient background and overlays text including the meeting type and date. <\/p>\n\n\n

\n# Valid meeting types: "TrusteeRegular",  "TrusteeSpecial", "TrusteeEmer", "TrusteeHearing", "BZAReg", "BZAHearing", "ZCReg", "ZCHearing"\nstrMeetingListSpreadsheet = 'MeetingList.xlsx'\n\nfrom PIL import Image, ImageDraw, ImageFont\nimport pandas as pd\n\nBLACK= (0,0,0)\nWHITE = (255,255,255)\n\nTRUSTEE_COLOR_PALETTE = [(156,12,12), (92,7,7), (0,0,0)]\nBZA_COLOR_PALETTE = [(253,139,1), (91,51,0), (0,0,0)]\nZC_COLOR_PALETTE = [(24,113,56), (8,41,20), (0,0,0)]\nMISC_COLOR_PALETTE = [(175,28,195), (55,9,61), (0,0,0)]\n\nobjFontMeetingTitle = ImageFont.truetype("\/usr\/share\/fonts\/liberation-sans\/LiberationSans-Regular.ttf",115)\nobjFontMeetingTopic = ImageFont.truetype("\/usr\/share\/fonts\/liberation-sans\/LiberationSans-Regular.ttf",115)\nobjFontMeetingDate = ImageFont.truetype("\/usr\/share\/fonts\/liberation-sans\/LiberationSans-Italic.ttf",95)\n\nclass Point(object):\n    def __init__(self, x, y):\n        self.x, self.y = x, y\n\nclass Rect(object):\n    def __init__(self, x1, y1, x2, y2):\n        minx, maxx = (x1,x2) if x1 < x2 else (x2,x1)\n        miny, maxy = (y1,y2) if y1 < y2 else (y2,y1)\n        self.min = Point(minx, miny)\n        self.max = Point(maxx, maxy)\n\n    width  = property(lambda self: self.max.x - self.min.x)\n    height = property(lambda self: self.max.y - self.min.y)\n\ndef gradient_color(minval, maxval, val, color_palette):\n    """ Computes intermediate RGB color of a value in the range of minval\n        to maxval (inclusive) based on a color_palette representing the range.\n    """\n    max_index = len(color_palette)-1\n    delta = maxval - minval\n    if delta == 0:\n        delta = 1\n    v = float(val-minval) \/ delta * max_index\n    i1, i2 = int(v), min(int(v)+1, max_index)\n    (r1, g1, b1), (r2, g2, b2) = color_palette[i1], color_palette[i2]\n    f = v - i1\n    return int(r1 + f*(r2-r1)), int(g1 + f*(g2-g1)), int(b1 + f*(b2-b1))\n\ndef horz_gradient(draw, rect, color_func, color_palette):\n    minval, maxval = 1, len(color_palette)\n    delta = maxval - minval\n    width = float(rect.width)  # Cache.\n    for x in range(rect.min.x, rect.max.x+1):\n        f = (x - rect.min.x) \/ width\n        val = minval + f * delta\n        color = color_func(minval, maxval, val, color_palette)\n        draw.line([(x, rect.min.y), (x, rect.max.y)], fill=color)\n\ndef vert_gradient(draw, rect, color_func, color_palette):\n    minval, maxval = 1, len(color_palette)\n    delta = maxval - minval\n    height = float(rect.height)  # Cache.\n    for y in range(rect.min.y, rect.max.y+1):\n        f = (y - rect.min.y) \/ height\n        val = minval + f * delta\n        color = color_func(minval, maxval, val, color_palette)\n        draw.line([(rect.min.x, y), (rect.max.x, y)], fill=color)\n\n\nif __name__ == '__main__':\n    df = pd.read_excel(strMeetingListSpreadsheet, sheet_name="Sheet1")\n\n    df = df.reset_index()  # make sure indexes pair with number of rows\n\n    for index, row in df.iterrows():\n        strGraphicName = f"{row['Date'].strftime('%Y%d%m')}-{row['Type']}.png"\n        strMeetingType = row['Type']\n\n        # Draw a three color horizontal gradient.\n        region = Rect(0, 0, 1920, 1080)\n        width, height = region.max.x+1, region.max.y+1\n        image = Image.new("RGB", (width, height), BLACK)\n        draw = ImageDraw.Draw(image)\n\n        # Add meeting title\n        if strMeetingType == "TrusteeRegular":\n            horz_gradient(draw, region, gradient_color, TRUSTEE_COLOR_PALETTE)\n            draw.text((1670, 525),"Trustee Regular Meeting",WHITE,font=objFontMeetingTopic, anchor="rm")\n        elif strMeetingType == "TrusteeSpecial":\n            horz_gradient(draw, region, gradient_color, TRUSTEE_COLOR_PALETTE)\n            draw.text((1670, 525),"Trustee Special Meeting",WHITE,font=objFontMeetingTopic, anchor="rm")\n        elif strMeetingType == "TrusteeEmer":\n            horz_gradient(draw, region, gradient_color, TRUSTEE_COLOR_PALETTE)\n            draw.text((1670, 525),"Trustee Emergency Meeting",WHITE,font=objFontMeetingTopic, anchor="rm")\n        elif strMeetingType == "TrusteeHearing":\n            horz_gradient(draw, region, gradient_color, TRUSTEE_COLOR_PALETTE)\n            draw.text((1670, 525),"Trustee Public Hearing",WHITE,font=objFontMeetingTopic, anchor="rm")\n        elif strMeetingType == "BZAReg":\n            horz_gradient(draw, region, gradient_color, BZA_COLOR_PALETTE)\n            draw.text((1670, 525),"BZA Regular Meeting",WHITE,font=objFontMeetingTopic, anchor="rm")\n        elif strMeetingType == "BZAHearing":\n            horz_gradient(draw, region, gradient_color, BZA_COLOR_PALETTE)\n            draw.text((1670, 525),"BZA Public Hearing",WHITE,font=objFontMeetingTopic, anchor="rm")\n        elif strMeetingType == "ZCReg":\n            horz_gradient(draw, region, gradient_color, ZC_COLOR_PALETTE)\n            draw.text((1670, 525),"Zoning Commission Meeting",WHITE,font=objFontMeetingTopic, anchor="rm")\n        elif strMeetingType == "ZCHearing":\n            horz_gradient(draw, region, gradient_color, ZC_COLOR_PALETTE)\n            draw.text((1670, 525),"Zoning Commission Hearing",WHITE,font=objFontMeetingTopic, anchor="rm")\n        else:\n            horz_gradient(draw, region, gradient_color, MISC_COLOR_PALETTE)\n            draw.text((1670, 525),"Township Meeting",WHITE,font=objFontMeetingTopic, anchor="rm")\n\n        # Add township and date\n        draw.text((1070, 225),"Hinckley Township",WHITE,font=objFontMeetingTitle, anchor="rm")\n        draw.text((1770, 825),row['Date'].strftime('%B %d, %Y'),WHITE,font=objFontMeetingDate, anchor="rm")\n\n        image.save(strGraphicName, "PNG")\n        print(f"image saved as {strGraphicName}")\n\n\n<\/pre><\/div>\n\n\n
I have an Excel file which contains the meeting type code, a long meeting title that is used as the second line of the image, a date (and a MeetingDate that I use in my concat formulae that create the title and description for YouTube). To use an Excel date in concat, you need to use a TEXT formula with the text formatting string. <\/p>\n\n\n\n
\n
\"\"<\/a><\/figure>\n<\/figure>\n\n\n\n
This allows me to have a consistent preview image for all of our postings without actually making<\/em> dozens of files by hand. <\/p>\n\n\n\n
\"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"
Instead of allowing YouTube to randomly pick a frame to use as the preview image, I have always made a title image for the Township meetings I post to YouTube. At first, this was a manual (and thus time consuming for a lot of videos). In the interim, I have created a script that generates …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1945],"tags":[1947,1946,664],"class_list":["post-10576","post","type-post","status-publish","format-standard","hentry","category-python","tag-pandas","tag-pillow","tag-python"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10576"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10576\/revisions"}],"predecessor-version":[{"id":10579,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10576\/revisions\/10579"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}