survey.py

import csv


def format_name(response):
    email_address = response['Email Address']
    name = email_address.split('@')[0].replace('.', ' ').title()
    return "%s (%s)" % (name, response['What is your role?'])


def response_id(field_index, response):
    return 'response%s.%s' % (field_index, response['Email Address'])


def anchor(field_index, response):
    return ("<a name='%s'></a>" % response_id(field_index, response))


def permalink(field_index, response):
    return "[🔗](#%s)" % response_id(field_index, response)


with open('responses.csv') as responsefile:
    reader = csv.DictReader(responsefile)
    responses = list(reader)
    for field_index, fieldname in enumerate(reader.fieldnames[4:]):
        print("# " + fieldname)
        for response in responses:
            if response[fieldname]:
                print(anchor(field_index, response))
                print(permalink(field_index, response))
                print(
                    format_name(response) + ": " + response[fieldname] + '\n')