csv_reader.py

import csv
import sys

if len(sys.argv) is not 2:
    print("Filename argument required")
    exit(1)
else:
    customers_dict = dict()
    with open(sys.argv[1], 'r', newline='') as csv_file:
        # skip the first line
        next(csv_file)
        csv_reader = csv.reader(csv_file, delimiter=',')
        for row in csv_reader:
            # make email the key for the dict
            customers_dict[row[0]] = dict(
                name = f"{row[2]}, {row[1]}",
                fullname = row[3],
                position = row[4],
                department = row[5],
                # just choose one of them here for simplicity
                phone = row[7],
                address = f"{row[10]}, {row[11]}, {row[12]} {row[13]}"
            )
    print(customers_dict)

input.csv

csv reader example using a microsoft provided csv