sample script to map into mysql

import os
from os.path import join, dirname
import sys
import csv

def start_import():
    project_path = join(os.path.dirname(__file__), '../' 'database')
    sys.path.append(project_path)
    platforms = {}
    with open('graphite.csv') as csvfile:
        reader = csv.DictReader(csvfile)
        for row in reader:
            contact_json = {}
            formatted_lead_json = {}
            if row.get("company",None) == None or row.get("company",None) == "":
                continue
           
            formatted_lead_json["contacts"] = []

            formatted_lead_json["account_name"] = row.get("company",None)
            formatted_lead_json["website"] = row.get("url",None)
            formatted_lead_json["account_type"] = "EdTech"
            formatted_lead_json["category"] = row.get("type",None)
            formatted_lead_json["data_source_url"] = row.get("data_source_url","")
            formatted_lead_json["data_source"] = row.get("data_source","")
            formatted_lead_json["subjects"] = row.get("subjects","") #.split(";")
            formatted_lead_json["skills"] = row.get("skills","")
            formatted_lead_json["average_rating"] = row.get("average_rating","")
            formatted_lead_json["price"] = row.get("price","")
            formatted_lead_json["grade"] = row.get("grades","") #.split(";")
            formatted_lead_json["platforms"] = row.get("platforms","") #.split(";")
            formatted_lead_json["purpose"] = row.get("purpose","") #.split(";")


if __name__=="__main__":
    start_import()