Generates a CSV-like output for rooms in Google Calendar's "Browse resources" pane

rooms.py

import json
import sys
import re

# intended usage: cat rooms.json | python rooms.py
#          ...or: pbpaste | python rooms.py | pbcopy
if __name__ == "__main__":
    # detects string ##FL in the room title, if present
    fl = r"(\d+)FL"
    with sys.stdin as inp:
        rooms = json.loads(inp.read())

    # output: (floor num), Room Title, Room Calendar ID (in base64)
    print(
        *(
            f'{re.search(fl, room["title"]).group(1) if re.search(fl, room["title"]) else ""},"{room["title"]}","{room["did"]}"'
            for room in rooms
        ),
        sep="\n",
    )