vcard_gen_inital.py

import csv

VCF_TEXT = ''

with open('./Final Year Bioscope Form.csv', mode='r') as csv_file:
    csv_reader = csv.DictReader(csv_file)
    lines_read = 0
    for row in csv_reader:
        if lines_read > 0:
            VCF_TEXT += ("BEGIN:VCARD\n"
            "VERSION:3.0\n" +
            "N:{}\n".format(row['Name'].replace(',', '')) +
            "FN:{}\n".format(row['Name'].replace(',', '')) +
            "NICKNAME:{}\n".format(row['Nickname']) +
            "NOTE:{}\n".format(row['Philosophy of Life']) +
            "X-TWITTER:{}\n".format(row['Twitter Handle']) +
            "TEL;WORK;VOICE:{}\n".format(row['Phone Number']) +
            "BDAY:{}\n".format(row['Date of Birth']) +
            "CATEGORIES:University of Lagos,CellBiology and Genetics,Helicase 18\n" +
            "END:VCARD\n")
        lines_read += 1

with open('Final Year Bioscope Form.vcf', 'w+') as vcf_file:
    vcf_file.write(VCF_TEXT)