// description of your code here
import os
import csv
os.chdir('Desktop')
cwd = os.getcwd()
open_file = open('pdfpub08', 'r')
c = csv.writer(open("salaries.csv", "wb"))
for line in open_file:
institution = line[0]
last_name = line[10:24]
first_name = line[25:35]
middle_initial = line[36]
epa_or_spa = line[49]
status = line[52]
year_hired = line[55:59]
month_hired = line[59:61]
termination_code = line[67]
state_sal = line[70:76]
nonstate_sal = line[76:82]
academic_rank = line[92]
year_of_rank = line[93:97]
month_of_rank = line[97:99]
is_paid_different = line[136]
year_in_state_service = line[140:142]
month_in_state_service = line[142:144]
is_teaching_research = line[161]
grand_total = line[82:88]
total_sal = int(state_sal) + int(nonstate_sal)
last_name = last_name.replace(' ', ' ')
first_name = first_name.replace(' ', ' ')
last_name = last_name.replace(' ', ' ')
first_name = first_name.replace(' ', ' ')
last_name = last_name.replace(' ', ' ')
first_name = first_name.replace(' ', ' ')
last_name = last_name.replace(' ', ' ')
first_name = first_name.replace(' ', ' ')
last_name = last_name.replace(' ', '')
first_name = first_name.replace(' ', '')
if institution == 'A':
institution = "Appalachian State"
if institution == 'B':
institution = "East Carolina"
if institution == 'C':
institution = "Elizabeth City State"
if institution == 'D':
institution = "Fayetteville State"
if institution == 'E':
institution = "N.C. A&T State"
if institution == 'F':
institution = "East Carolina"
if institution == 'G':
institution = "UNC School of the Arts"
if institution == 'H':
institution = "N.C. State"
if institution == 'I':
institution = 'UNC-Pembroke'
if institution == 'J':
institution = "UNC-Asheville"
if institution == 'K':
institution = "UNC-Chapel Hill"
if institution == 'L':
institution = "UNC-Charlotte"
if institution == 'M':
institution = "UNC-Greensboro"
if institution == 'N':
institution = "UNC-Wilmington"
if institution == 'O':
institution = "Western Carolina"
if institution == 'P':
institution = "Winston-Salem State"
if institution == 'S':
institution = "N.C. School of Science and Math"
if epa_or_spa == 'E':
epa_or_spa = 'Exempt'
if epa_or_spa == 'S':
epa_or_spa = 'SPA'
if epa_or_spa == 'G':
epa_or_spa = 'Graduate Assistant'
if termination_code == '0':
termination_code = 'Currently employed'
if termination_code == '1':
termination_code = 'Resigned'
if termination_code == '2':
termination_code = 'Retired'
if termination_code == '3':
termination_code = 'Dismissed or terminated'
if termination_code == '4':
termination_code = 'Deceased'
if termination_code == '5':
termination_code = 'Non-reappointment'
if termination_code == '6':
termination_code = 'Laid off (EPA only)'
if termination_code == '7':
termination_code = 'Other'
if termination_code == 'P':
termination_code = 'Terminated after phased retirement'
if academic_rank == '1':
academic_rank = 'Professor'
if academic_rank == '2':
academic_rank = 'Associate Professor'
if academic_rank == '3':
academic_rank = 'Assistant Professor'
if academic_rank == '4':
academic_rank = 'Instructor'
if academic_rank == '5':
academic_rank = 'Lecturer'
if academic_rank == '6':
academic_rank = 'Other'
if is_paid_different == 'T':
is_paid_different = 'T-grade salary'
if is_paid_different == 'F':
is_paid_different = 'Flat-rate salary'
if is_paid_different == 'A':
is_paid_different = 'Salary is above range'
if is_paid_different == 'B':
is_paid_different = 'Salary is below range'
if is_teaching_research == '0':
is_teaching_research = 'Not a teacher/researcher'
if is_teaching_research == '1':
is_teaching_research = 'Half-time teacher/researcher'
if is_teaching_research == '2':
is_teaching_research = 'Full-time teacher/researcher'
c.writerow([institution, last_name, first_name, middle_initial, epa_or_spa, year_hired, month_hired, termination_code, state_sal, nonstate_sal, grand_total, academic_rank, year_of_rank, month_of_rank, is_paid_different, year_in_state_service, month_in_state_service, is_teaching_research])acheter viagra en suisseacheter viagra en belgique// description of code here
cialis venteacheter cialis en france