#your_djangoproject_home="C:/Users/Stephen/Documents/GitHub/purf/"
import sys, os
sys.path.append(your_djangoproject_home)
os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'
from purf_app.models import Professor, Project, Rating
import csv
profdataReader = csv.reader(open(csv_filepathname), dialect='excel-tab')
projdataReader = csv.reader(open(csv_filepathname2), dialect='excel-tab')
ratdataReader = csv.reader(open(csv_filepathname3), dialect='excel-tab')
for i,row in enumerate(profdataReader):
prof = Professor()
prof.netid = row[0]
prof.title = row[2]
prof.office = row[6]
prof.phone = row[7]
prof.research_areas = row[9]
prof.research_topics = row[10]
prof.research_links = row[11]
prof.description = row[13]
prof.full = row[14]
prof.name = row[1]
prof.department = row[3]
prof.email = row[5]
prof.image = row[4]
prof.website_link = row[12]
