Objective2+.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Cleaning: Normalization\n",
    "The purpose of this notebook is to describe the steps taken to clean the given dataset. It starts by normalizing any variation or meaning of the words, <font color='red'>requirement</font> and <font color='red'>process notes</font>. Such variations are deliniated in subsequent sections. Essentially, the steps involve multiple searches and manually-replaces of the variations, thus changing the content of the raw data. There are two points that worth noticing here:\n",
    "\n",
    "1. The raw data in *Job Bulletins* remains intact while cleaned data were generated in a new folder caled *JobBulletins_cleaned*.\n",
    "2. Admittedly, the steps taken here are extremely labor-intensive. However, this was done for a purpose as I learned that it is the best way to get myself familiarized with unstructured data. In particular, **since the source that generated these text file is not known**, we really have no idea on how to retrieve relevant information based on matched pattern. For example, one might attempt to do something such as `job[job.find('REQUIREMENTS/MINIMUM QUALIFICATIONS':job.find('PROCESS NOTES')]` or any similar expressions using regex. Although that this statement may help him retrieve **only** relevant information regarding school type, education majors, etc., this is not guranteed! For instance, I found that in some jobs, the word, PROCESS NOTES, came after the word WHERE TO APPLY, which unarguably causes severe headache later. The only way to avoid this, as far as I realize, is to patiently do some manual data cleaning before any analysis.\n",
    "\n",
    "<font size=4, color='green'> LET'S GET STARTED! </font>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import relevant modules\n",
    "import os                       # interface with the underlying OS\n",
    "import numpy as np              # linear algebra\n",
    "import pandas as pd             # dataframe\n",
    "import re                       # regular expression\n",
    "import matplotlib.pyplot as plt # data visualization\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Define path to look at\n",
    "path = 'CityofLA/Job Bulletins/'\n",
    "\n",
    "# Get a list of all txt files in this path\n",
    "all_jobs = os.listdir(path)\n",
    "all_jobs.sort() # WARNING: this mutates the list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "683\n",
      "683\n",
      "True\n"
     ]
    }
   ],
   "source": [
    "# Do some checks here\n",
    "print(len(all_jobs))      # length should be 683 as manually verified\n",
    "print(len(set(all_jobs))) # see if each file is unique. hopefully 683 as well!\n",
    "print('SYSTEMS ANALYST 1596 102717.txt' in all_jobs) # should be True"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. Normalize variation of the word/meaning of `requirement` as \n",
    "## `REQUIREMENTS/MINIMUM QUALIFICATIONS`\n",
    "Some variations that I found:\n",
    "* REQUIREMENT\n",
    "* REQUIREMENTS\n",
    "* REQUIREMENT/ MINIMUM QUALIFICATION\n",
    "* REQUIREMENT/MINIMUM QUALIFICATIONS\n",
    "* REQUIREMENTS/MINIMUM QUALIFICATIONS\n",
    "* REQUIREMENT:\n",
    "* REQUIREMENTS:\n",
    "\n",
    "Note that they can also come with any combination of redundant whitespaces!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's start with `SYSTEMS ANALYST 1596 102717.txt` to see what approach will work, since we've known so well about it."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "609\n"
     ]
    }
   ],
   "source": [
    "# Find `SYSTEMS ANALYST 1596 102717.txt` (which exists).\n",
    "print(all_jobs.index('SYSTEMS ANALYST 1596 102717.txt'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import this text as string\n",
    "sa_path = path + all_jobs[609]\n",
    "sa = open(sa_path, 'rt').read()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "True\n",
      "True\n",
      "\n",
      "\n",
      "True\n",
      "False\n"
     ]
    }
   ],
   "source": [
    "# Compare these\n",
    "print('REQUIREMENTS/MINIMUM QUALIFICATIONS' in sa)\n",
    "print('REQUIREMENTS' in sa)\n",
    "print()\n",
    "\n",
    "# Versus these\n",
    "print()\n",
    "print('REQUIREMENTS/MINIMUM QUALIFICATIONS' in sa.split('\\n'))\n",
    "print('REQUIREMENTS' in sa.split('\\n'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The \"Compare these\" part can't do an exact lookup; <font size=5, color='red'>thus, well pick the approach in the \"Versus these\" part.</font>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Identify the trouble makers, Round 1.**\n",
    "\n",
    "Save the printouts to a word file called, *TroubleMakers_Type1_1*."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/Job Bulletins/311 DIRECTOR  9206 041814.txt\n",
      "CityofLA/Job Bulletins/ACCOUNTANT 1513 062218.txt\n",
      "CityofLA/Job Bulletins/ACCOUNTING CLERK 1223 071318.txt\n",
      "CityofLA/Job Bulletins/ACCOUNTING RECORDS SUPERVISOR 1119 072718.txt\n",
      "CityofLA/Job Bulletins/ADMINISTRATIVE CLERK 1358 033018 (2).txt\n",
      "CityofLA/Job Bulletins/ADMINISTRATIVE HEARING EXAMINER 9135 100915.txt\n",
      "CityofLA/Job Bulletins/ADVANCE PRACTICE PROVIDER CORRECTIONAL CARE 2325 020808 REV 111214.txt\n",
      "CityofLA/Job Bulletins/AIR CONDITIONING MECHANIC SUPERVISOR 3781 111618 2.txt\n",
      "CityofLA/Job Bulletins/AIRPORT AIDE 1540 081018.txt\n",
      "CityofLA/Job Bulletins/AIRPORT CHIEF INFORMATION SECURITY OFFICER 1404 120415_Modified.txt\n",
      "CityofLA/Job Bulletins/AIRPORT ENGINEER 7256 070618.txt\n",
      "CityofLA/Job Bulletins/AIRPORT GUIDE 0845 042018.txt\n",
      "CityofLA/Job Bulletins/AIRPORT INFORMATION SPECIALIST 1783 121115.txt\n",
      "CityofLA/Job Bulletins/AIRPORT POLICE CAPTAIN 3228 021618.txt\n",
      "CityofLA/Job Bulletins/AIRPORT POLICE LIEUTENANT 3227 091616.txt\n",
      "CityofLA/Job Bulletins/AIRPORT POLICE OFFICER 3225 110906 Rev 060115.txt\n",
      "CityofLA/Job Bulletins/AIRPORT POLICE SPECIALIST 3236 063017 (2).txt\n",
      "CityofLA/Job Bulletins/AIRPORT SUPERINTENDENT OF OPERATIONS 7268 121815 (1).txt\n",
      "CityofLA/Job Bulletins/ANIMAL CARE TECHNICIAN 4310 040116 REV 041416.txt\n",
      "CityofLA/Job Bulletins/ANIMAL CARE TECHNICIAN SUPERVISOR 4313 122118.txt\n",
      "CityofLA/Job Bulletins/APPRENTICE - METAL TRADES 3789 070816.txt\n",
      "CityofLA/Job Bulletins/APPRENTICE MACHINIST 3764 071516.txt\n",
      "CityofLA/Job Bulletins/AQUARIST 2400 050214.txt\n",
      "CityofLA/Job Bulletins/AQUARIUM EDUCATOR 2493 010816.txt\n",
      "CityofLA/Job Bulletins/AQUATIC FACILITY MANAGER 2423 052915 REVISED 060915.txt\n",
      "CityofLA/Job Bulletins/AQUEDUCT AND RESERVOIR KEEPER 5813 063017 (1).txt\n",
      "CityofLA/Job Bulletins/AQUEDUCT AND RESERVOIR SUPERVISOR 5816 091115.txt\n",
      "CityofLA/Job Bulletins/ARCHITECTURAL ASSOCIATE 7926 013114 REV 032916.txt\n",
      "CityofLA/Job Bulletins/ARCHIVIST 1191 020918.txt\n",
      "CityofLA/Job Bulletins/ART CENTER DIRECTOR 2478 053014.txt\n",
      "CityofLA/Job Bulletins/ART INSTRUCTOR 2447 051316.txt\n",
      "CityofLA/Job Bulletins/ASBESTOS SUPERVISOR 3440 012916.txt\n",
      "CityofLA/Job Bulletins/ASPHALT PLANT OPERATOR 4143 102414.txt\n",
      "CityofLA/Job Bulletins/ASPHALT PLANT SUPERVISOR 4145 110317.txt\n",
      "CityofLA/Job Bulletins/ASSISTANT DIRECTOR INFORMATION SYSTEMS 9377 030218.txt\n",
      "CityofLA/Job Bulletins/ASSISTANT INSPECTOR 4208 111315.txt\n",
      "CityofLA/Job Bulletins/ASSISTANT RETIREMENT PLAN MANAGER 9415 050616.txt\n",
      "CityofLA/Job Bulletins/ASSISTANT SIGNAL SYSTEMS ELECTRICIAN 3818 073115_REVISED.txt\n",
      "CityofLA/Job Bulletins/ASSISTANT STREET LIGHTING ELECTRICIAN 3809 072117 REV 080818.txt\n",
      "CityofLA/Job Bulletins/AUDIO VISUAL TECHNICIAN 6147 062014.txt\n",
      "CityofLA/Job Bulletins/AUDITOR 1517 031816 (1).txt\n",
      "CityofLA/Job Bulletins/AUTO BODY REPAIR SUPERVISOR 3706 051515.txt\n",
      "CityofLA/Job Bulletins/AUTO ELECTRICIAN 3707 052215.txt\n",
      "CityofLA/Job Bulletins/AUTOMOTIVE DISPATCHER 3595 102017 revised.txt\n",
      "CityofLA/Job Bulletins/AUTOMOTIVE SUPERVISOR 3714 062416.txt\n",
      "CityofLA/Job Bulletins/AVIONICS SPECIALIST 3565 103114revised.txt\n",
      "CityofLA/Job Bulletins/BENEFITS SPECIALIST 1203 011918.txt\n",
      "CityofLA/Job Bulletins/BOILERMAKER 3735 110714.txt\n",
      "CityofLA/Job Bulletins/BOILERMAKER SUPERVISOR 3737 101714.txt\n",
      "CityofLA/Job Bulletins/BUILDING CIVIL ENGINEER 7244 032318.txt\n",
      "CityofLA/Job Bulletins/BUILDING CONSTRUCTION AND MAINTENANCE SUPERINTENDENT 3124 122818.txt\n",
      "CityofLA/Job Bulletins/BUILDING ELECTRICAL ENGINEER 7543 071516 REV 071816.txt\n",
      "CityofLA/Job Bulletins/BUILDING OPERATING ENGINEER 5923 111618 REV 112818.txt\n",
      "CityofLA/Job Bulletins/BUILDING REPAIR SUPERVISOR 3338 111816.txt\n",
      "CityofLA/Job Bulletins/BUILDING REPAIRER 3333 030218.txt\n",
      "CityofLA/Job Bulletins/BUS OPERATOR 3588 090216.txt\n",
      "CityofLA/Job Bulletins/BUS OPERATOR SUPERVISOR 3589 012216.txt\n",
      "CityofLA/Job Bulletins/CARPENTER SUPERVISOR 3346 051316.txt\n",
      "CityofLA/Job Bulletins/CARPET LAYER 3418 061915.txt\n",
      "CityofLA/Job Bulletins/CEMENT FINISHER SUPERVISOR 3354 120916.txt\n",
      "CityofLA/Job Bulletins/CEMENT FINISHER WORKER 3351 103015.txt\n",
      "CityofLA/Job Bulletins/CHIEF ADMINISTRATIVE ANALYST 1554 062416.txt\n",
      "CityofLA/Job Bulletins/CHIEF AIRPORTS ENGINEER 7274 051515 (1).txt\n",
      "CityofLA/Job Bulletins/CHIEF BUILDING OPERATING ENGINEER 5927 080516.txt\n",
      "CityofLA/Job Bulletins/CHIEF CLERK PERSONNEL 1260 042117.txt\n",
      "CityofLA/Job Bulletins/CHIEF CLERK POLICE 1219 061215.txt\n",
      "CityofLA/Job Bulletins/CHIEF CLERK POLICE 1249 083118.txt\n",
      "CityofLA/Job Bulletins/CHIEF CONSTRUCTION INSPECTOR 7296 122818.txt\n",
      "CityofLA/Job Bulletins/CHIEF CUSTODIAN SUPERVISOR 3182 041015.txt\n",
      "CityofLA/Job Bulletins/CHIEF ELECTRIC PLANT OPERATOR 5237 121115.txt\n",
      "CityofLA/Job Bulletins/CHIEF ENVIRONMENTAL COMPLIANCE INSPECTOR 4289 033018.txt\n",
      "CityofLA/Job Bulletins/CHIEF FINANCIAL OFFICER 9230 041114.txt\n",
      "CityofLA/Job Bulletins/CHIEF HARBOR ENGINEER 9286 112015.txt\n",
      "CityofLA/Job Bulletins/CHIEF INSPECTOR 4254 082517.txt\n",
      "CityofLA/Job Bulletins/CHIEF INTERNAL AUDITOR 1619 090916 (5).txt\n",
      "CityofLA/Job Bulletins/CHIEF MANAGEMENT ANALYST 9182 020918.txt\n",
      "CityofLA/Job Bulletins/CHIEF OF DRAFTING OPERATIONS 7271  042018.txt\n",
      "CityofLA/Job Bulletins/CHIEF OF PARKING ENFORCEMENT OPERATIONS 9180 031618.txt\n",
      "CityofLA/Job Bulletins/CHIEF PARK RANGER 1968 120106 REV 121306.txt\n",
      "CityofLA/Job Bulletins/CHIEF PORT PILOT 5154 031816.txt\n",
      "CityofLA/Job Bulletins/CHIEF STREET SERVICES INVESTIGATOR 4286 2017Revised 11.21.txt\n",
      "CityofLA/Job Bulletins/CHIEF TAX COMPLIANCE OFFICER 1211 041814.txt\n",
      "CityofLA/Job Bulletins/CHIEF TRANSPORTATION INVESTIGATOR 4275 103114.txt\n",
      "CityofLA/Job Bulletins/CIVIL ENGINEER 7237 020918.txt\n",
      "CityofLA/Job Bulletins/CLAIMS AGENT 1767 020317.txt\n",
      "CityofLA/Job Bulletins/COMMERCIAL SERVICE SUPERVISOR  1213 061617.txt\n",
      "CityofLA/Job Bulletins/COMMISSION EXECUTIVE ASSISTANT 9734 092118.txt\n",
      "CityofLA/Job Bulletins/COMMUNICATIONS CABLE SUPERVISOR 3800 051917 REVISED 060117.txt\n",
      "CityofLA/Job Bulletins/COMMUNICATIONS CABLE WORKER 3802 11816.txt\n",
      "CityofLA/Job Bulletins/COMMUNITY AFFAIRS ADVOCATE 2496 111414.txt\n",
      "CityofLA/Job Bulletins/COMMUNITY HOUSING PROGRAMS MANAGER 8500 072018 REV 080918 (2).txt\n",
      "CityofLA/Job Bulletins/CONSTRUCTION AND MAINTENANCE SUPERINTENDENT 3129 082616 REV 090816.txt\n",
      "CityofLA/Job Bulletins/CONSTRUCTION AND MAINTENANCE SUPERVISOR 3127 030416.txt\n",
      "CityofLA/Job Bulletins/CONSTRUCTION ESTIMATOR 3341 070816 REVISED 072116 (1).txt\n",
      "CityofLA/Job Bulletins/CORRECTIONAL NURSE 2317 101615.txt\n",
      "CityofLA/Job Bulletins/CRIMINALIST 2234 030918.txt\n",
      "CityofLA/Job Bulletins/CUSTODIAN SUPERVISOR 3176 042817 051117 REV.txt\n",
      "CityofLA/Job Bulletins/CUSTOMER SERVICE REPRESENTATIVE 1230 020918.txt\n",
      "CityofLA/Job Bulletins/DECK HAND 5131 093016.txt\n",
      "CityofLA/Job Bulletins/DEPARTMENTAL CHIEF ACCOUNTANT 1593 111717 revised 11.21.txt\n",
      "CityofLA/Job Bulletins/DIRECTOR OF HOUSING 1568 062317.txt\n",
      "CityofLA/Job Bulletins/DIRECTOR OF MAINTENANCE AIRPORTS 7270 041516.txt\n",
      "CityofLA/Job Bulletins/DIRECTOR OF POLICE TRANSPORTATION 3722 061915.txt\n",
      "CityofLA/Job Bulletins/DIRECTOR OF PORT CONSTRUCTION AND MAINTENANCE 3123 030416.txt\n",
      "CityofLA/Job Bulletins/ELECTRIC DISTRIBUTION MECHANIC SUPERVISOR 3873 102816.txt\n",
      "CityofLA/Job Bulletins/ELECTRIC SERVICE REPRESENTATIVE 7520 020317.txt\n",
      "CityofLA/Job Bulletins/ELECTRIC TROUBLE DISPATCHER 3828 063017 (1).txt\n",
      "CityofLA/Job Bulletins/ELECTRICAL ENGINEERING DRAFTING TECHNICIAN 7532 113018.txt\n",
      "CityofLA/Job Bulletins/ELECTRICAL INSPECTOR 4221 030218.txt\n",
      "CityofLA/Job Bulletins/ELECTRICAL MECHANIC SUPERVISOR 3835 072216 REVISED 080416.txt\n",
      "CityofLA/Job Bulletins/ELECTRICAL REPAIR SUPERVISOR 3855 092217 (7).txt\n",
      "CityofLA/Job Bulletins/ELEVATOR MECHANIC 3866 012717 REV 080718.txt\n",
      "CityofLA/Job Bulletins/ELEVATOR REPAIR SUPERVISOR 032516 REVISED 040516.txt\n",
      "CityofLA/Job Bulletins/EMERGENCY MEDICAL SERVICES EDUCATOR  2322 110615 REV 112515.txt\n",
      "CityofLA/Job Bulletins/EMS NURSE PRACTITIONER SUPERVISOR 2340 031116 REV 032316 (1).txt\n",
      "CityofLA/Job Bulletins/ENGINEER OF SURVEYS 9486 101615.txt\n",
      "CityofLA/Job Bulletins/ENGINEERING DESIGNER 7217 082517 REV 090717.txt\n",
      "CityofLA/Job Bulletins/ENGINEERING GEOLOGIST 7255 022318.txt\n",
      "CityofLA/Job Bulletins/ENGINEERING GEOLOGIST ASSOCIATE 7253 082517.txt\n",
      "CityofLA/Job Bulletins/ENVIRONMENTAL COMPLIANCE INSPECTOR 4292 080516 REV 081616.txt\n",
      "CityofLA/Job Bulletins/ENVIRONMENTAL ENGINEER  7872 082616 REV 090116.txt\n",
      "CityofLA/Job Bulletins/ENVIRONMENTAL ENGINEERING ASSOCIATE  7871 020113 REV 032916.txt\n",
      "CityofLA/Job Bulletins/ENVIRONMENTAL SPECIALIST 7310 012916.txt\n",
      "CityofLA/Job Bulletins/ENVIRONMENTAL SUPERVISOR 7304 052518 (1).txt\n",
      "CityofLA/Job Bulletins/EQUIPMENT REPAIR SUPERVISOR 3746 012717.txt\n",
      "CityofLA/Job Bulletins/EQUIPMENT SUPERINTENDENT 3750 121914.txt\n",
      "CityofLA/Job Bulletins/EQUIPMENT SUPERVISOR 3527 041318.txt\n",
      "CityofLA/Job Bulletins/EXAMINER OF QUESTIONED DOCUMENTS 3229 120415.txt\n",
      "CityofLA/Job Bulletins/EXECUTIVE ADMINISTRATIVE ASSISTANT 1117 083118.txt\n",
      "CityofLA/Job Bulletins/EXECUTIVE ASSISTANT AIRPORTS 9186 060917 (1).txt\n",
      "CityofLA/Job Bulletins/EXHIBIT PREPARATOR 2444 062416.txt\n",
      "CityofLA/Job Bulletins/FINANCIAL MANAGER 1557 070116 Rev.txt\n",
      "CityofLA/Job Bulletins/FINGERPRINT IDENTIFICATION EXPERT 1157 052915.txt\n",
      "CityofLA/Job Bulletins/FIRE BATTALION CHIEF 2152 030918.txt\n",
      "CityofLA/Job Bulletins/FIRE CAPTAIN 2142 033018.txt\n",
      "CityofLA/Job Bulletins/FIRE HELICOPTER PILOT 3563 081415 REV. 081815.txt\n",
      "CityofLA/Job Bulletins/FIRE INSPECTOR 2128 031717.txt\n",
      "CityofLA/Job Bulletins/FIRE PROTECTION ENGINEERING ASSOCIATE 7978 041318.txt\n",
      "CityofLA/Job Bulletins/FIRE SPECIAL INVESTIGATOR 1632 021216.txt\n",
      "CityofLA/Job Bulletins/FIREARMS EXAMINER 2233 062416.txt\n",
      "CityofLA/Job Bulletins/FIREBOAT MATE 5125 102315 rev110515.txt\n",
      "CityofLA/Job Bulletins/FIREBOAT PILOT 5127 102315 rev110515 (1).txt\n",
      "CityofLA/Job Bulletins/GALLERY ATTENDANT 2442 092515.txt\n",
      "CityofLA/Job Bulletins/GARAGE ASSISTANT 3538 012017.txt\n",
      "CityofLA/Job Bulletins/GARAGE ATTENDANT 3531 013015.txt\n",
      "CityofLA/Job Bulletins/GENERAL AUTOMOTIVE SUPERVISOR 3718 061915.txt\n",
      "CityofLA/Job Bulletins/GENERAL SERVICES MANAGER  9601 042117.txt\n",
      "CityofLA/Job Bulletins/GEOGRAPHIC INFORMATION SYSTEMS CHIEF  7211 030416.txt\n",
      "CityofLA/Job Bulletins/GEOGRAPHIC INFORMATION SYSTEMS SPECIALIST 7213 012414 revised.txt\n",
      "CityofLA/Job Bulletins/GEOTECHNICAL ENGINEER 7239 090718 REV 092018.txt\n",
      "CityofLA/Job Bulletins/GOLF STARTER 2453 121115.txt\n",
      "CityofLA/Job Bulletins/GOLF STARTER SUPERVISOR 2479 120817.txt\n",
      "CityofLA/Job Bulletins/GRAPHICS SUPERVISOR 7935 052617 (4).txt\n",
      "CityofLA/Job Bulletins/HARBOR PLANNING AND ECONOMIC ANALYST 9224 111816 REV 112916.txt\n",
      "CityofLA/Job Bulletins/HEATING AND REFRIGERATION INSPECTOR 4245 121115.txt\n",
      "CityofLA/Job Bulletins/HEAVY DUTY EQUIPMENT MECHANIC 3743 021717.txt\n",
      "CityofLA/Job Bulletins/HELICOPTER MECHANIC 3742 072206 REV 020818.txt\n",
      "CityofLA/Job Bulletins/HELICOPTER MECHANIC SUPERVISOR 3749 121616 REV 122216.txt\n",
      "CityofLA/Job Bulletins/HYDROGRAPHER 7263 012717.txt\n",
      "CityofLA/Job Bulletins/IMPROVEMENT ASSESSOR SUPERVISOR 1564 100215.txt\n",
      "CityofLA/Job Bulletins/INDUSTRIAL AND COMMERCIAL FINANCE OFFICER 9191 rev051515.txt\n",
      "CityofLA/Job Bulletins/INDUSTRIAL CHEMIST 7834 020714.txt\n",
      "CityofLA/Job Bulletins/INFORMATION SYSTEMS MANAGER 1409 090117 (2).txt\n",
      "CityofLA/Job Bulletins/INSTRUMENT MECHANIC SUPERVISOR 3844 051917 final.txt\n",
      "CityofLA/Job Bulletins/INTERNAL AUDITOR 1625 011918.txt\n",
      "CityofLA/Job Bulletins/IRRIGATION SPECIALIST 3913 020615.txt\n",
      "CityofLA/Job Bulletins/LABOR SUPERVISOR 3126 121815.txt\n",
      "CityofLA/Job Bulletins/LABORATORY TECHNICIAN 7854 030416.txt\n",
      "CityofLA/Job Bulletins/LAND SURVEYING ASSISTANT 7283 120817.txt\n",
      "CityofLA/Job Bulletins/LANDSCAPE ARCHITECT 7929 090718.txt\n",
      "CityofLA/Job Bulletins/LANDSCAPE ARCHITECTURAL ASSOCIATE  7933 07222016.txt\n",
      "CityofLA/Job Bulletins/LEGISLATIVE ASSISTANT 1182 091815.txt\n",
      "CityofLA/Job Bulletins/LIBRARIAN 6152 051217 REV 020218.txt\n",
      "CityofLA/Job Bulletins/LIBRARY ASSISTANT 1172 051118 (2).txt\n",
      "CityofLA/Job Bulletins/LICENSED VOCATIONAL NURSE  2332 042415.txt\n",
      "CityofLA/Job Bulletins/LINE MAINTENANCE ASSISTANT 3882 122818.txt\n",
      "CityofLA/Job Bulletins/MACHINIST 3763 061016.txt\n",
      "CityofLA/Job Bulletins/MACHINIST SUPERVISOR 3766 121815.txt\n",
      "CityofLA/Job Bulletins/MANAGEMENT ASSISTANT 1539 032318.txt\n",
      "CityofLA/Job Bulletins/MARINE AQUARIUM PROGRAM DIRECTOR 2403 082517.txt\n",
      "CityofLA/Job Bulletins/MARINE ENVIRONMENTAL MANAGER 9437 060614.txt\n",
      "CityofLA/Job Bulletins/MARINE ENVIRONMENTAL SUPERVISOR 9433 071114 (1).txt\n",
      "CityofLA/Job Bulletins/MATERIALS TESTING TECHNICIAN 7968 081318.txt\n",
      "CityofLA/Job Bulletins/MECHANICAL HELPER 3771 011317.txt\n",
      "CityofLA/Job Bulletins/MECHANICAL REPAIR GENERAL SUPERVISOR 3731 040116 REV 041416.txt\n",
      "CityofLA/Job Bulletins/MECHANICAL REPAIR SUPERVISOR 3795 051818.txt\n",
      "CityofLA/Job Bulletins/MECHANICAL REPAIRER 3773 092118.txt\n",
      "CityofLA/Job Bulletins/METER READER 1611 080715.txt\n",
      "CityofLA/Job Bulletins/MOTOR SWEEPER OPERATOR 3585 031618.txt\n",
      "CityofLA/Job Bulletins/OCCUPATIONAL HEALTH NURSE  2314 020317 REV 022317 (1).txt\n",
      "CityofLA/Job Bulletins/OFFICE ENGINEERING TECHNICIAN 7212 110218.txt\n",
      "CityofLA/Job Bulletins/OFFICE TRAINEE 1101 012017.txt\n",
      "CityofLA/Job Bulletins/PAINTER SUPERVISOR 3426 120514.txt\n",
      "CityofLA/Job Bulletins/PARK SERVICES ATTENDANT 2412 032219.txt\n",
      "CityofLA/Job Bulletins/PARK SERVICES SUPERVISOR 2426 072018.txt\n",
      "CityofLA/Job Bulletins/PARKING ENFORCEMENT MANAGER 9025 021916 rev022516.txt\n",
      "CityofLA/Job Bulletins/PARKING MANAGER 9170 020714.txt\n",
      "CityofLA/Job Bulletins/PARKING METER TECHNICIAN 3738 110615 (1).txt\n",
      "CityofLA/Job Bulletins/PARKING METER TECHNICIAN SUPERVISOR 3757 2017.txt\n",
      "CityofLA/Job Bulletins/PAYROLL ANALYST 1630 031816.txt\n",
      "CityofLA/Job Bulletins/PAYROLL SUPERVISOR 1170 102618.txt\n",
      "CityofLA/Job Bulletins/PERSONNEL DIRECTOR 1714 050418.txt\n",
      "CityofLA/Job Bulletins/PERSONNEL RECORDS SUPERVISOR 1129 041318.txt\n",
      "CityofLA/Job Bulletins/PHOTOGRAPHER 1793 041516.txt\n",
      "CityofLA/Job Bulletins/PILE DRIVER WORKER 3553 041417.txt\n",
      "CityofLA/Job Bulletins/PIPEFITTER SUPERVISOR 3438 081216.txt\n",
      "CityofLA/Job Bulletins/PLUMBER 3443 113018.txt\n",
      "CityofLA/Job Bulletins/POLICE COMMANDER 2251 092917.txt\n",
      "CityofLA/Job Bulletins/POLICE DETECTIVE 2223 033018.txt\n",
      "CityofLA/Job Bulletins/POLICE OFFICER 2214 110906 Rev 060115.txt\n",
      "CityofLA/Job Bulletins/POLICE PERFORMANCE AUDITOR 1627 120216.txt\n",
      "CityofLA/Job Bulletins/POLICE SERGEANT 2227 102116.txt\n",
      "CityofLA/Job Bulletins/POLICE SERVICE REPRESENTATIVE 2207 051316 REV 051716.txt\n",
      "CityofLA/Job Bulletins/POLICE SPECIAL INVESTIGATOR 1640 072018 REV 011019.txt\n",
      "CityofLA/Job Bulletins/POLICE SPECIALIST 2217 110906 Rev 060115.txt\n",
      "CityofLA/Job Bulletins/POLICE SURVEILLANCE SPECIALIST 3687 052215.txt\n",
      "CityofLA/Job Bulletins/POLYGRAPH EXAMINER 2240 121517.txt\n",
      "CityofLA/Job Bulletins/PORT ELECTRICAL MECHANIC 3758 022616.txt\n",
      "CityofLA/Job Bulletins/PORT ELECTRICAL MECHANIC SUPERVISOR 3759 031816.txt\n",
      "CityofLA/Job Bulletins/PORT MAINTENANCE SUPERVISOR 3128 052016 REV 060216.txt\n",
      "CityofLA/Job Bulletins/PORT POLICE CAPTAIN 3224 110416.txt\n",
      "CityofLA/Job Bulletins/PORT POLICE LIEUTENANT 3223 120916.txt\n",
      "CityofLA/Job Bulletins/PORT POLICE OFFICER 3221 110906 Rev 060115.txt\n",
      "CityofLA/Job Bulletins/PORT POLICE SERGEANT 3222 121616.txt\n",
      "CityofLA/Job Bulletins/POWER SHOVEL OPERATOR 3558 062416.txt\n",
      "CityofLA/Job Bulletins/PRE-PRESS OPERATOR 1481 072817 (4).txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL ACCOUNTANT 1525 121517.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL ANIMAL KEEPER 4312 070618.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL CIVIL ENGINEER 9489 022318.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL CIVIL ENGINEERING DRAFTING TECHNICIAN 7219 110218.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL CLERK 1201 021618.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL CLERK POLICE 1152 121815.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL COMMUNICATIONS OPERATOR 1458 072514.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL CONSTRUCTION INSPECTOR 7297 021618.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL DEPUTY CONTROLLER 7260 032814.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL DETENTION OFFICER 3215 101218.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL ELECTRIC TROUBLE DISPATCHER 3830 022616.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL ELECTRICAL ENGINEERING DRAFTING TECHNICIAN 7531 090916 TRACK CHANGES.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL ENVIRONMENTAL ENGINEER 7875 092118.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL GROUNDS MAINTENANCE SUPERVISOR  3147 111315.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL INSPECTOR 4226 061617.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL MECHANICAL ENGINEERING DRAFTING TECHNICIAN 7550 081415.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL PHOTOGRAPHER 1794 040116.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL PROPERTY OFFICER 3210 121517.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL RECREATION SUPERVISOR 2464 021618.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL STOREKEEPER 1839 072718.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL TAX AUDITOR 1524 110416.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL TAX COMPLIANCE OFFICER 1195 030218.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL UTILITY ACCOUNTANT 1589 030218 updated.txt\n",
      "CityofLA/Job Bulletins/PRINCIPAL WORKERS_ COMPENSATION ANALYST 1777 071814.txt\n",
      "CityofLA/Job Bulletins/PRINTING PRESS OPERATOR 1494 092515.txt\n",
      "CityofLA/Job Bulletins/PROPERTY OFFICER 3207 071417 (1).txt\n",
      "CityofLA/Job Bulletins/PROTECTIVE COATING WORKER 3463 082115.txt\n",
      "CityofLA/Job Bulletins/PUBLIC RELATIONS SPECIALIST 1785 012017.txt\n",
      "CityofLA/Job Bulletins/RATES MANAGER 5601 012017.txt\n",
      "CityofLA/Job Bulletins/REAL ESTATE ASSOCIATE 1941 052716.txt\n",
      "CityofLA/Job Bulletins/REAL ESTATE OFFICER 1960 051118.txt\n",
      "CityofLA/Job Bulletins/RECREATION COORDINATOR 2469 091517(1).txt\n",
      "CityofLA/Job Bulletins/RECREATION SUPERVISOR 2460 101416 REVISED 102716.txt\n",
      "CityofLA/Job Bulletins/REFUSE COLLECTION SUPERVISOR 4101 033117.txt\n",
      "CityofLA/Job Bulletins/REHABILITATION PROJECT COORDINATOR 8502 032715.txt\n",
      "CityofLA/Job Bulletins/REINFORCING STEEL WORKER 3483 022318.txt\n",
      "CityofLA/Job Bulletins/REPROGRAPHICS OPERATOR 3162 110615.txt\n",
      "CityofLA/Job Bulletins/REPROGRAPHICS SUPERVISOR  3163 091517.txt\n",
      "CityofLA/Job Bulletins/RETIREMENT PLAN MANAGER 9149 052314 (1).txt\n",
      "CityofLA/Job Bulletins/RISK AND INSURANCE ASSISTANT 1645 072718.txt\n",
      "CityofLA/Job Bulletins/RISK MANAGER 1530 2016 061716_REVISED.txt\n",
      "CityofLA/Job Bulletins/ROOFER 3476 121214.txt\n",
      "CityofLA/Job Bulletins/SAFETY ADMINISTRATOR 1728 101615.txt\n",
      "CityofLA/Job Bulletins/SAFETY ENGINEER 1727 021717.txt\n",
      "CityofLA/Job Bulletins/SAFETY ENGINEER ELEVATORS 4263 112015 REV 120215.txt\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/Job Bulletins/SANITATION SOLID RESOURCES MANAGER 4126 060515.txt\n",
      "CityofLA/Job Bulletins/SECRETARY 1116 030317.txt\n",
      "CityofLA/Job Bulletins/SECRETARY LEGAL  1924 081718.txt\n",
      "CityofLA/Job Bulletins/SECURITY AIDE  3199 090415.txt\n",
      "CityofLA/Job Bulletins/SENIOR ACCOUNTANT 1523 030218.txt\n",
      "CityofLA/Job Bulletins/SENIOR ADMINISTRATIVE CLERK 1368 062918 REV 091718.txt\n",
      "CityofLA/Job Bulletins/SENIOR ANIMAL CONTROL OFFICER 4316 111618.txt\n",
      "CityofLA/Job Bulletins/SENIOR ANIMAL KEEPER 4305 022616.txt\n",
      "CityofLA/Job Bulletins/SENIOR ARCHITECTURAL DRAFTING TECHNICIAN 7208 091418.txt\n",
      "CityofLA/Job Bulletins/SENIOR AUDITOR 1518 102618.txt\n",
      "CityofLA/Job Bulletins/SENIOR AUTOMOTIVE SUPERVISOR 3716 112015.txt\n",
      "CityofLA/Job Bulletins/SENIOR BUILDING INSPECTOR 4213 010816.txt\n",
      "CityofLA/Job Bulletins/SENIOR BUILDING MECHANICAL INSPECTOR 4253 2017 REV (1).txt\n",
      "CityofLA/Job Bulletins/SENIOR BUILDING OPERATING ENGINEER 5925 011615 (1).txt\n",
      "CityofLA/Job Bulletins/SENIOR CARPENTER  3345 081117 REV 082417.txt\n",
      "CityofLA/Job Bulletins/SENIOR CHEMIST 7830 030416.txt\n",
      "CityofLA/Job Bulletins/SENIOR CIVIL ENGINEERING DRAFTING TECHNICIAN 7207 081718.txt\n",
      "CityofLA/Job Bulletins/SENIOR CLAIMS REPRESENTATIVE 1770 070717 (1).txt\n",
      "CityofLA/Job Bulletins/SENIOR COMMUNICATIONS CABLE WORKER 3801 102116 draft.txt\n",
      "CityofLA/Job Bulletins/SENIOR COMMUNICATIONS ELECTRICIAN 3638 030317 (1).txt\n",
      "CityofLA/Job Bulletins/SENIOR COMMUNICATIONS ELECTRICIAN SUPERVISOR 3691 041318.txt\n",
      "CityofLA/Job Bulletins/SENIOR COMMUNICATIONS OPERATOR 1467 122118.txt\n",
      "CityofLA/Job Bulletins/SENIOR COMPUTER OPERATOR 1428 102017.txt\n",
      "CityofLA/Job Bulletins/SENIOR CONSTRUCTION ENGINEER 7289 042514.txt\n",
      "CityofLA/Job Bulletins/SENIOR DATA PROCESSING TECHNICIAN 1139 081117.txt\n",
      "CityofLA/Job Bulletins/SENIOR DETENTION OFFICER 3212 012017.txt\n",
      "CityofLA/Job Bulletins/SENIOR ELECTRIC TROUBLE DISPATCHER 3829 100716.txt\n",
      "CityofLA/Job Bulletins/SENIOR ELECTRICAL ENGINEERING DRAFTING TECHNICIAN 7209 042817 REV 051117.txt\n",
      "CityofLA/Job Bulletins/SENIOR ELECTRICAL INSPECTOR 4223 042718.txt\n",
      "CityofLA/Job Bulletins/SENIOR ELECTRICAL MECHANIC 3834 060217 (2) REVISED.txt\n",
      "CityofLA/Job Bulletins/SENIOR ELECTRICAL MECHANIC SUPERVISOR 3836 080417.txt\n",
      "CityofLA/Job Bulletins/SENIOR ELECTRICAL REPAIR SUPERVISOR 3856 060118.txt\n",
      "CityofLA/Job Bulletins/SENIOR ELECTRICAL TEST TECHNICIAN  7515 092917 REV 101117.txt\n",
      "CityofLA/Job Bulletins/SENIOR ELECTRICIAN  3864 102116 Rev 110216.txt\n",
      "CityofLA/Job Bulletins/SENIOR ENVIRONMENTAL COMPLIANCE INSPECTOR 4293 042916 REV 051916.txt\n",
      "CityofLA/Job Bulletins/SENIOR ENVIRONMENTAL ENGINEER 7874 121815.txt\n",
      "CityofLA/Job Bulletins/SENIOR EQUIPMENT MECHANIC 3712 010518 REV 080718.txt\n",
      "CityofLA/Job Bulletins/SENIOR FIRE PROTECTION ENGINEER 7981 021916 rev022516.txt\n",
      "CityofLA/Job Bulletins/SENIOR FORENSIC PRINT SPECIALIST 2201 090718.txt\n",
      "CityofLA/Job Bulletins/SENIOR GARDENER 3143 121517 (1)revised.txt\n",
      "CityofLA/Job Bulletins/SENIOR HEATING AND REFRIGERATION INSPECTOR 4247 121115.txt\n",
      "CityofLA/Job Bulletins/SENIOR HEAVY DUTY EQUIPMENT MECHANIC 3745 012017.txt\n",
      "CityofLA/Job Bulletins/SENIOR HOUSING INSPECTOR 4244 042718.txt\n",
      "CityofLA/Job Bulletins/SENIOR HYDROGRAPHER 7264 030714.txt\n",
      "CityofLA/Job Bulletins/SENIOR LIBRARIAN 6153 033117.txt\n",
      "CityofLA/Job Bulletins/SENIOR LOAD DISPATCHER 5235 060118.txt\n",
      "CityofLA/Job Bulletins/SENIOR MACHINIST SUPERVISOR 3768 051016.txt\n",
      "CityofLA/Job Bulletins/SENIOR MANAGEMENT ANALYST 9171 040618.txt\n",
      "CityofLA/Job Bulletins/SENIOR MECHANICAL ENGINEERING DRAFTING TECHNICIAN 7210 110416.txt\n",
      "CityofLA/Job Bulletins/SENIOR MECHANICAL REPAIRER 3772 030416.txt\n",
      "CityofLA/Job Bulletins/SENIOR PAINTER 3424 041318.txt\n",
      "CityofLA/Job Bulletins/SENIOR PARK MAINTENANCE SUPERVISOR 3146 101416.txt\n",
      "CityofLA/Job Bulletins/SENIOR PARK RANGER 1967 091815.txt\n",
      "CityofLA/Job Bulletins/SENIOR PARKING ATTENDANT 3529 032417.txt\n",
      "CityofLA/Job Bulletins/SENIOR PHOTOGRAPHER 1795 041516 REVISED 042816.txt\n",
      "CityofLA/Job Bulletins/SENIOR PLUMBER 3444 020516.txt\n",
      "CityofLA/Job Bulletins/SENIOR PLUMBING INSPECTOR 4233 051818.txt\n",
      "CityofLA/Job Bulletins/SENIOR POLICE SERVICE REPRESENTATIVE 2209 020918.txt\n",
      "CityofLA/Job Bulletins/SENIOR PROPERTY OFFICER 3209 012618.txt\n",
      "CityofLA/Job Bulletins/SENIOR RECREATION DIRECTOR 2446 050517 REV 051117.txt\n",
      "CityofLA/Job Bulletins/SENIOR ROOFER 3477 101708 REV 110608.txt\n",
      "CityofLA/Job Bulletins/SENIOR SAFETY ENGINEER ELEVATORS 4264  042718.txt\n",
      "CityofLA/Job Bulletins/SENIOR SECURITY OFFICER 3184 122818.txt\n",
      "CityofLA/Job Bulletins/SENIOR STOREKEEPER 1837 052518.txt\n",
      "CityofLA/Job Bulletins/SENIOR SYSTEMS ANALYST 1597 100617.txt\n",
      "CityofLA/Job Bulletins/SENIOR TITLE EXAMINER 1947 121517.txt\n",
      "CityofLA/Job Bulletins/SENIOR TRAFFIC SUPERVISOR 3218 121517.txt\n",
      "CityofLA/Job Bulletins/SENIOR TRANSPORTATION INVESTIGATOR 4273 070717 (2).txt\n",
      "CityofLA/Job Bulletins/SENIOR UNDERGROUND DISTRIBUTION CONSTRUCTION SUPERVISOR 3815 072817.txt\n",
      "CityofLA/Job Bulletins/SENIOR UTILITY ACCOUNTANT 1521 100716.txt\n",
      "CityofLA/Job Bulletins/SENIOR UTILITY BUYER 1862 052518.txt\n",
      "CityofLA/Job Bulletins/SENIOR UTILITY SERVICES SPECIALIST 3573 113018.txt\n",
      "CityofLA/Job Bulletins/SENIOR UTILITY SERVICES SPECIALIST 3753 121815 (1).txt\n",
      "CityofLA/Job Bulletins/SENIOR WINDOW CLEANER 3174 013114 Rev021314.txt\n",
      "CityofLA/Job Bulletins/SHEET METAL SUPERVISOR 3777 061314.txt\n",
      "CityofLA/Job Bulletins/SHEET METAL WORKER 3775 093016.txt\n",
      "CityofLA/Job Bulletins/SHIFT SUPERINTENDENT WASTEWATER TREATMENT 7242 072415.txt\n",
      "CityofLA/Job Bulletins/SHOPS SUPERINTENDENT 3780 051118.txt\n",
      "CityofLA/Job Bulletins/SIGN PAINTER 3428 121214.txt\n",
      "CityofLA/Job Bulletins/SIGN SHOP SUPERVISOR 3419 030615.txt\n",
      "CityofLA/Job Bulletins/SIGNAL SYSTEMS SUPERINTENDENT 3832 110416.txt\n",
      "CityofLA/Job Bulletins/SIGNAL SYSTEMS SUPERVISOR 3839 092818.txt\n",
      "CityofLA/Job Bulletins/SOCIAL WORKER 2385 102717  revised.txt\n",
      "CityofLA/Job Bulletins/SOLID RESOURCES SUPERINTENDENT 4102 031017 REV 032317 (2).txt\n",
      "CityofLA/Job Bulletins/SPECIAL INVESTIGATOR 0602 042216.txt\n",
      "CityofLA/Job Bulletins/SR CRIME _ INTELLIGENCE ANALYST 2241 011516.txt\n",
      "CityofLA/Job Bulletins/STAFF ASSISTANT TO GENERAL MANAGER WATER AND POWER 9185 032715.txt\n",
      "CityofLA/Job Bulletins/STEAM PLANT MAINTENANCE MECHANIC 5630 0902116.txt\n",
      "CityofLA/Job Bulletins/STEAM PLANT MAINTENANCE SUPERVISOR 3786 033117.txt\n",
      "CityofLA/Job Bulletins/STEAM PLANT OPERATOR 5624 101416.txt\n",
      "CityofLA/Job Bulletins/STORES SUPERVISOR 1866 122917.txt\n",
      "CityofLA/Job Bulletins/STREET LIGHTING CONSTRUCTION AND MAINTENANCE SUPERINTENDENT 3820 051818.txt\n",
      "CityofLA/Job Bulletins/STREET LIGHTING ELECTRICIAN SUPERVISOR 3840 031717.txt\n",
      "CityofLA/Job Bulletins/STREET LIGHTING ENGINEERING ASSOCIATE 7527 101102 REV 032916.txt\n",
      "CityofLA/Job Bulletins/STREET SERVICES GENERAL SUPERINTENDENT 4160 042916.txt\n",
      "CityofLA/Job Bulletins/STREET SERVICES INVESTIGATOR 4283 102315 REV 110315.txt\n",
      "CityofLA/Job Bulletins/STREET SERVICES SUPERVISOR 4152 082815.txt\n",
      "CityofLA/Job Bulletins/STREET SERVICES WORKER 4150 032318.txt\n",
      "CityofLA/Job Bulletins/STREET TREE SUPERINTENDENT 3160 060917.txt\n",
      "CityofLA/Job Bulletins/STRUCTURAL ENGINEER 7956 101918.txt\n",
      "CityofLA/Job Bulletins/STRUCTURAL STEEL FABRICATOR 3793 122316.txt\n",
      "CityofLA/Job Bulletins/STRUCTURAL STEEL FABRICATOR SUPERVISOR 3794 060217.txt\n",
      "CityofLA/Job Bulletins/SUPERINTENDENT OF RECREATION AND PARKS OPERATIONS 2472 012618.txt\n",
      "CityofLA/Job Bulletins/SUPERVISING CRIMINALIST 2235 030416.txt\n",
      "CityofLA/Job Bulletins/SUPERVISING OCCUPATIONAL HEALTH  2315 111414.txt\n",
      "CityofLA/Job Bulletins/SUPERVISING TRANSPORTATION PLANNER 2481 072216.txt\n",
      "CityofLA/Job Bulletins/SUPERVISING WATER SERVICE REPRESENTATIVE 1697 081318.txt\n",
      "CityofLA/Job Bulletins/SURVEY PARTY CHIEF 7286 093016.txt\n",
      "CityofLA/Job Bulletins/SURVEY SUPERVISOR 7287 110918.txt\n",
      "CityofLA/Job Bulletins/SYSTEMS AIDE 1599 070116.txt\n",
      "CityofLA/Job Bulletins/SYSTEMS PROGRAMMER 1455 091616 REV 100416.txt\n",
      "CityofLA/Job Bulletins/TAX COMPLIANCE AIDE 1173 061215 (1).txt\n",
      "CityofLA/Job Bulletins/TAX COMPLIANCE OFFICER 1179 111816.txt\n",
      "CityofLA/Job Bulletins/TILE SETTER 3493 090415.txt\n",
      "CityofLA/Job Bulletins/TITLE EXAMINER 1943 032318 REV 040518.txt\n",
      "CityofLA/Job Bulletins/TRAFFIC MARKING AND SIGN SUPERINTENDENT 3430 032219.txt\n",
      "CityofLA/Job Bulletins/TRAFFIC OFFICER 3214 040116.txt\n",
      "CityofLA/Job Bulletins/TRAFFIC PAINTER AND SIGN POSTER 3421 033117.txt\n",
      "CityofLA/Job Bulletins/TRANSMISSION AND DISTRIBUTION DISTRICT SUPERVISOR 3875 050418 REV 051718.txt\n",
      "CityofLA/Job Bulletins/TRANSPORTATION ENGINEER 7278 092917.txt\n",
      "CityofLA/Job Bulletins/TRANSPORTATION ENGINEERING AIDE 7285 100915.txt\n",
      "CityofLA/Job Bulletins/TRANSPORTATION ENGINEERING ASSOCIATE 7280 072415.txt\n",
      "CityofLA/Job Bulletins/TRANSPORTATION INVESTIGATOR 4271 061016.txt\n",
      "CityofLA/Job Bulletins/TRANSPORTATION PLANNING ASSOCIATE 2480 072018.txt\n",
      "CityofLA/Job Bulletins/TREE SURGEON ASSISTANT 3151 060316.txt\n",
      "CityofLA/Job Bulletins/TRUCK OPERATOR 3583 012618.txt\n",
      "CityofLA/Job Bulletins/UNDERGROUND DISTRIBUTION CONSTRUCTION SUPERVISOR 3814 121418 REV 122718 (1).txt\n",
      "CityofLA/Job Bulletins/UPHOLSTERER 3723 041715.txt\n",
      "CityofLA/Job Bulletins/UTILITIES SERVICE INVESTIGATOR 1631 101615 (1).txt\n",
      "CityofLA/Job Bulletins/UTILITY ACCOUNTANT 1511 092818.txt\n",
      "CityofLA/Job Bulletins/UTILITY ADMINISTRATOR 9105 060217.txt\n",
      "CityofLA/Job Bulletins/UTILITY BUYER 1861 090718.txt\n",
      "CityofLA/Job Bulletins/UTILITY EXECUTIVE SECRETARY 1336 042817 (1).txt\n",
      "CityofLA/Job Bulletins/UTILITY SERVICES SPECIALIST 3755 072117 (1).txt\n",
      "CityofLA/Job Bulletins/VETERINARY TECHNICIAN 2369 020599 REV 120417.txt\n",
      "CityofLA/Job Bulletins/VIDEO TECHNICIAN 6145 012717.txt\n",
      "CityofLA/Job Bulletins/Vocational Worker  DEPARTMENT OF PUBLIC 0 WORKS.txt\n",
      "CityofLA/Job Bulletins/WASTEWATER TREATMENT ELECTRICIAN SUPERVISOR 5613 060515.txt\n",
      "CityofLA/Job Bulletins/WATER BIOLOGIST 7856 120216.txt\n",
      "CityofLA/Job Bulletins/WATER MICROBIOLOGIST  7857 072514 rev073114.txt\n",
      "CityofLA/Job Bulletins/WATER SERVICE REPRESENTATIVE 1693 111717.txt\n",
      "CityofLA/Job Bulletins/WATER SERVICE SUPERVISOR 3930 012717.txt\n",
      "CityofLA/Job Bulletins/WATER TREATMENT OPERATOR 5885 122118.txt\n",
      "CityofLA/Job Bulletins/WATER TREATMENT SUPERVISOR 5887 072018.txt\n",
      "CityofLA/Job Bulletins/WATER UTILITY SUPERINTENDENT 3980 121418.txt\n",
      "CityofLA/Job Bulletins/WATERSHED RESOURCES SPECIALIST  7862 080516 (1).txt\n",
      "CityofLA/Job Bulletins/WATERWORKS ENGINEER 7248 071516 (1).txt\n",
      "CityofLA/Job Bulletins/WATERWORKS MECHANIC SUPERVISOR 3987 051614 (1).txt\n",
      "CityofLA/Job Bulletins/WELDER SUPERVISOR 3798 120817.txt\n",
      "CityofLA/Job Bulletins/WORKERS_ COMPENSATION ANALYST 1774 032417R.txt\n",
      "CityofLA/Job Bulletins/WORKERS_ COMPENSATION CLAIMS ASSISTANT 1775 041114.txt\n",
      "CityofLA/Job Bulletins/X-RAY AND LABORATORY TECHNICIAN 2358 012916.txt\n",
      "CityofLA/Job Bulletins/ZOO CURATOR 4297 040816.txt\n"
     ]
    }
   ],
   "source": [
    "# When I did this at home, it has some UnicodeDecodeError (look at my physical copy)\n",
    "# But when I did this from the computer at school, it didn't. Hmmm...\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Verify if 'REQUIREMENTS/MINIMUM QUALIFICATIONS' in job\n",
    "    if 'REQUIREMENTS/MINIMUM QUALIFICATIONS' not in job.split('\\n'):\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=8>NOTE:</font>\n",
    "\n",
    "This has been one of the weirdest things I've ever seen since learning how to program. This code runs perfectly fine on a PC (I tested it on a desktop at my school) but yields a <font color='red'>UnicdeDecodeError</font>. See this [discussion](https://stackoverflow.com/questions/33114999/python-unicodedecodeerror-on-mac-but-not-on-pc) for further detail. It basically says that there are some weird chracters in the string so Python can't read it. On a PC, it silently ignores the error, while on a Mac, it raises the error and stops the program.\n",
    "\n",
    "Thus, an extra step to clean the data, if you're using MAC, is to detect which file causes the trouble and hopefully, you can manually fix it. Otherwise, we either have to ignore that text file or use try/except.\n",
    "\n",
    "Let's first find what file is causing the decoding trouble."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Which file Python on Mac cannot decode?\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    try:\n",
    "        job      = open(job_path, 'rt').read()\n",
    "    except:\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The file that causes the decoding problem is `POLICE COMMANDER 2251 092917.txt`. Upon opening this file and read through it, we'll see the culprit, rÈsumÈ. Manually find/replace this word with *resume* will fix the problem!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Identify trouble maker, Round 2.**\n",
    "\n",
    "Save the printouts to a word file called, *TroubleMakers_Type1_2*.\n",
    "\n",
    "When this code first ran, there were a couple of files that I missed in Round 1 (human error during manual fix). Hence, I did it again in Round 3 and got the result I wanted."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/JobBulletins_cleaned/Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt\n"
     ]
    }
   ],
   "source": [
    "# Define path to look at\n",
    "path = 'CityofLA/JobBulletins_cleaned/'\n",
    "\n",
    "# Get a list of all txt files in this path\n",
    "all_jobs = os.listdir(path)\n",
    "all_jobs.sort() # WARNING: this mutates the list\n",
    "\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Verify if 'REQUIREMENTS/MINIMUM QUALIFICATIONS' in job\n",
    "    if 'REQUIREMENTS/MINIMUM QUALIFICATIONS' not in job.split('\\n'):\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Identify trouble makers, Round 3.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/JobBulletins_cleaned/Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt\n"
     ]
    }
   ],
   "source": [
    "# Define path to look at\n",
    "path = 'CityofLA/JobBulletins_cleaned/'\n",
    "\n",
    "# Get a list of all txt files in this path\n",
    "all_jobs = os.listdir(path)\n",
    "all_jobs.sort() # WARNING: this mutates the list\n",
    "\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Verify if 'REQUIREMENTS/MINIMUM QUALIFICATIONS' in job\n",
    "    if 'REQUIREMENTS/MINIMUM QUALIFICATIONS' not in job.split('\\n'):\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=5, color='red'> Well done!</font>\n",
    "\n",
    "Note that the job above follow a completely different format from the rest, so for now, we'll ignore it."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2. Normalize `PROCESS NOTES`\n",
    "Some variations that were found:\n",
    "* PROCESS NOTES\n",
    "* PROCESS NOTES:\n",
    "* NOTES\n",
    "* NOTES:\n",
    "* NOTE\n",
    "* NOTE:\n",
    "* Sometimes missing completely. Ex: `POLICE OFFICER 2214 110906 Rev 060115.txt`\n",
    "* Most of the times this key come before WHERE TO APPLY, but there are ocassions it comes after. Ex: `CHIEF CLERK POLICE 1219 061215.txt`\n",
    "And with no exception :(, they can come with any combination of redundant whitespaces."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "True\n",
      "False\n"
     ]
    }
   ],
   "source": [
    "# First, take a look at how this is done with sa\n",
    "print('PROCESS NOTES' in sa.split('\\n'))\n",
    "print('PROCESS' in sa.split('\\n'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It seems good. Thus, we'll stick to this approach.\n",
    "\n",
    "**Identify the trouble makers, Round 1.**\n",
    "\n",
    "Save the printouts to a word file called, *TroubleMakers_Type2_1*.\n",
    "\n",
    "When this code first ran, there were a couple of files that I missed in Round 1 and Round 2 (human error during manual fix). Hence, I did it again in Round 3 and got the result I wanted."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/JobBulletins_cleaned/Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt\n"
     ]
    }
   ],
   "source": [
    "# Define path to look at\n",
    "path = 'CityofLA/JobBulletins_cleaned/'\n",
    "\n",
    "# Get a list of all txt files in this path\n",
    "all_jobs = os.listdir(path)\n",
    "all_jobs.sort() # WARNING: this mutates the list\n",
    "\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Verify if 'REQUIREMENTS/MINIMUM QUALIFICATIONS' in job\n",
    "    if 'PROCESS NOTES' not in job.split('\\n'):\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Identify the trouble makers, Round 2.**\n",
    "\n",
    "Save the printouts to a word file called, *TroubleMakers_Type2_2*."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/JobBulletins_cleaned/Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt\n"
     ]
    }
   ],
   "source": [
    "# Define path to look at\n",
    "path = 'CityofLA/JobBulletins_cleaned/'\n",
    "\n",
    "# Get a list of all txt files in this path\n",
    "all_jobs = os.listdir(path)\n",
    "all_jobs.sort() # WARNING: this mutates the list\n",
    "\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Verify if 'REQUIREMENTS/MINIMUM QUALIFICATIONS' in job\n",
    "    if 'PROCESS NOTES' not in job.split('\\n'):\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Identify the trouble makers, Round 2.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/JobBulletins_cleaned/Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt\n"
     ]
    }
   ],
   "source": [
    "# Define path to look at\n",
    "path = 'CityofLA/JobBulletins_cleaned/'\n",
    "\n",
    "# Get a list of all txt files in this path\n",
    "all_jobs = os.listdir(path)\n",
    "all_jobs.sort() # WARNING: this mutates the list\n",
    "\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Verify if 'REQUIREMENTS/MINIMUM QUALIFICATIONS' in job\n",
    "    if 'PROCESS NOTES' not in job.split('\\n'):\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=5, color='red'> Well done!</font>\n",
    "\n",
    "Again, note that the job above follow a completely different format from the rest, so for now, we'll ignore it."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 3. Normalize the order\n",
    "Most of the jobs have the following order of sections: REQUIREMENTS/MINIMUM QUALIFICATIONS, PROCESS NOTES, WHERE TO APPLY, etc. However, as mentioned in the openning of this notebook, some jobs mess this up: REQUIREMENTS/MINIMUM QUALIFICATIONS, WHERE TO APPLY, PROCESS NOTES, or any incorrect order that we don't know yet. Thus, we need to fix this.\n",
    "\n",
    "Fortunately, we can use a histogram to plot the distributions of the length of extracted texts between REQUIREMENTS/MINIMUM QUALIFICATIONS and PROCESS NOTES. Of course, a removal of `Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt` is first needed."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "False\n",
      "682\n"
     ]
    }
   ],
   "source": [
    "# Remove `Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt` \n",
    "# as it doesn't share the same job description pattern of the City of LA\n",
    "all_jobs.remove('Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt')\n",
    "\n",
    "# Sanity double check\n",
    "print('Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt' in all_jobs) # should be True\n",
    "print(len(all_jobs)) # should be 682"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "682\n"
     ]
    }
   ],
   "source": [
    "# Histogram of length of extracted texts between two key words\n",
    "length_of_extracted_txts = [] # container that holds all strings' lengths\n",
    "\n",
    "for file_name in all_jobs:\n",
    "     # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Use index, not find as a last-ditched attempt to catch any error\n",
    "    txt      = job[job.index('REQUIREMENTS/MINIMUM QUALIFICATIONS'):job.index('PROCESS NOTES')]\n",
    "    # Simplify txt a little bit\n",
    "    txt      = (txt.replace('\\n', ' ')\n",
    "                   .replace(';', ' ')\n",
    "                   .replace(',', ' ')\n",
    "                   .replace('.', ' ')\n",
    "                   .replace(')', ' ')\n",
    "                   .replace('*', ' ')).split()\n",
    "    # Append length to the list\n",
    "    length_of_extracted_txts.append(len(txt))\n",
    "\n",
    "# Verify if length of the list is still 682\n",
    "print(len(length_of_extracted_txts))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAtQAAAEjCAYAAAASUpbMAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAIABJREFUeJzt3Xu89fWc///HMyGEVBeS6pJpIr4jzTWYcSphEsYYchhDDFMNxhiZmRyGxowR4zD8jENoiskhEpliEGrMSCdJKSThUjqhgxLV6/fH+71rXau19177WlfX2ntfj/vttm57r/fn9Hp/Pp/1Wa/P+/P+fFaqCkmSJElrZ6NpByBJkiQtZSbUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkiZgQi1JkiRNYJ0k1Enek+Qf1tG8tk1yVZJb9fdfSfKCdTHvPr/PJtl7Xc1vUkkemuR7vc5/PO14ZpPk/CSPvoWXcbckJyS5MslbbsllLTbrY/1KkqRbxrwJdf+iv6YnOb9I8n9J9kty47RVtV9V/dOY85ozaaiqH1XVplV1/XhVmHN5Byb5z6H5P66qDpt03uvQ64B39jp/anjgNBKtJIcm+ef1ucxuH+BS4E5Vtf/wwB7Xr/vJx8zrm+PMOEkl+a11HXCf965JVt9C8/7sQF1/M1T/90w47xOT/NkE0/6qx3F5ki8nue+Y094nyXVrs9z1JckeSW7o9bsyydlJnjUwfJO+T/1yaH98ycA4v5PkmCRX9Hl8IcmqoWWcO2LZN26XJAclef8sy1yd5I1JMjTtr4Zi+vjA8irJh4eW95Be/rlx6tZjqiRPHJjHpr3s7km+NLTPXjvw/t/SvLYf265K8uMkHxyK6XZJLuuxnNjnvePQOJ/r5Q+ZY12dMrR+3jzzuRneD5N8tE/z2KHlvKeXP2N4OSP2h3sObId5Yx4lySOSHN/XzS+SHJVkh4Hh+yX54ojpfprkYUNlM9vqAUPlI+cxEPvM/jf4ORjen9ZYD0k2SrJ/km/3fefHfZ3uNF9MSf5xYP6/SnLdwPtTh9dvn2b48/XFJL83MPw+fZojh5b/iSQH9P/n3RfnWEcXJdl4qPyjfX0N1u3+SX41NO2vesxXJDk5ycuT3HqO5X00N32Oftb3ox0G1udvBvaXr2bgONPH2SLJwT3mq5N8MwPHs4Hx9k5yWt9+Fyb5r6z5+ZpZzszrpwPTPjXJGb1Ol6Qd7+45sPwP9uVfkeScJH8zS13n3W7z1SnJbYfivKGPM/P+KZPUZzbjtlA/saruCGwHHAT8PfCBMacd2/DOuYHYDjhr2kEsEtsB3665f23oTf3kY+b1gDnGHdti3ff6CeCmVbUpcDhr1n+/KYf3gh7XFsBJwH9MOZ517bxevzsBrwAOTXKvoXF2HNof3wHtSwH4H9p62Q7YGvgc8OUkO08Y1449rt2B5wHDJ0UvGIppr4FhFwK7J7nTQNlzgO/OtpzhunU/A/4puSlZnVFVjxrYZ48E/mlgHi+lnTg/Bditj/Ng4ISh2ewOfK2qZhKR7/Y4AUhyd+D/AZePiHvQvYAnzzPOoO8CN17BTHJb4I+B8xcwj8F5LSjmJLsCxwIfBe4O3Bs4F/jf+b7MR8xrI9q+8bPBONbCeXPsT4PeA+wL/CVwF+A+wGeBPeeLqapeO7DPvBT4ysDyfndE3UZ9vj5L+3wNjn8DsNtQ2aBx9sXhZe8I/B5wG+BxI0b5OTBfA+MLek51D9qx5bnAp+eZ5p96jNsCVwLvGxh2WB+2AjgR+NhAvLcDvgTcrce9GfAq4O1JXjgw3itp+d2BfT7bAe8HnjS8nIHX3fu0O/VxXwzcmbbfvo+2/gHeCQT47b78P2Huz9Sc222+OlXVtYNxAhcDjx0om0nW17Y+Iy2oy0dVXV5VRwNPB/ZOcv++8BtbNJNs2c9qftHPpP4n7cz1Q7Qd4TP9TODvkqzsZyLPT/Ij4EsDZYMJzr2TnJTWEvbpJJv3Zd2sZTC9RTfJHsArgadnoCUzA11IelyvTvLDJBf3M6g792Ezceyd5EdJLk3yqoHlPCit9eOKfob01tnWW5K/SHJuXx9HJ7lHL/8+sP3AOrntQrZHkickOT03XTn4naH18PJ+hnV5ko8l2WRg+N+lnYFekOQFva6/lWQf4FnA3/WYPjOwyJ1HzW+2bT5LzH+QdkZ+ef/7B738UNoX2cxyF9Qqn+TpSc6bSRSSPC6txWZFkpkD5Df7vJ8+s+8k+fu0s9L/SHKXXo9Lkvy8/z/YIrJ5kv/o6+znST6V5A60A/k9ctNZ7j36vnVAku+ntbQdMbPf9nk9u+93lw3uV2sjyZP7dvlFX/c79fL79O0x8zndrr///bQuNb8HvL/H/JYkt0ryzl7/y9PO+Heca9kAVXUd7QB+Y0tUn9c/9G1yaZLDk2zWB58A3GpgfT2wb6v79Wln9sft+/sXJ/noGPMlycOTfL2vi9OSPHRg2IlprVEnpn1uj01ylzHqV/3q0TXA/ecbv/sn4Liq+seq+nlVXVFVbwE+AbxhzHnMF9d3aF+eC0nQr6btr3sBJLkNLeH8yAIXfzRwW+BpC5wO2n53bFX9AKCqLqiq9w+NsyctsZzxn8CzkhsT+D8DjgDmu9LxJuB1sx2PRvgk8Ogkd+zvnwh8DbhszOkHrU3M/wocXFXvrqqrquqyqvpbWqPLQo8Tj6YlA/v3OG61wOnH1o8xzwf2qqrjq+rXVfXLqjqsqt58C8Q02+fr46z5+SrgLcBsV1zH2ReH7Q18hfaZGdV99APAHyR58HyV6Nv4i7Skdfdxvveq6iraCdfNjkVV9Rvgw8D2A/vwnwNbAk/vPQB+XVX/RdsG/5Lk9km2AF4D7FNVR1fV1X28T1XVK+aLCdgFOKeqTujHyyuq6oiquqAP/z3g8J5D3lBV366qo+aqJnNvt3nrNEbMk9RnpLXqQ11VJwGrgYePGLx/H7aCdvbwyjZJPRv4Ea21e9OqetPANI8E7gv84SyLfA5tBd6DdjB6xyzjDcb4OeBfgI/V7C2Zz+2v3WiJ7aa0M6lBDwN2pLWYvCY3XdZ+O/D2qroT7ezliFFxJHkU7QP+NGAr4Ie0DwNVdW/WXCfXzlevgfnuAhxCaxHYAngvcHTWTMqfBuxBa6X5nV5X0k42XkY7uP0Wbf3TYzqYNVtCnzjf/Jhlm4+IeXPgGNr22wJ4K3BMki2q6rlDyx15OXI2VfUx2hffO/rB4QO0VoBLquoRfbQH9HnPnL3fHdicdia+D+3z8B/9/ba0BGpwf/gQcHvgfsBdgbdV1S9prRQXDJzlXgC8hNay9Ujafvtz4N/7etgJeDfw7D5sC2BBrU8z0i7HvYvWUrlFj/FTSTauqnOA1wKHp53RHwa8q6q+Vq1Lzcnc1Jq5P/AE4Hdp+/NdgD/tcc8Xw237uCcOFP8t8Fja5+eewG+At/VhjwCuH1hf36Al2bsODD+Pm/bLRwDHzzffJCuBT9ESj82BV/d1MZg0/ynthHErWqvGX49Rv42S7AXcEfj+fON3j6F9uQ87AnhU1sEVkX4C8vu0FsyF+CA3tQ4+gdbKd+kC53E9bd/6x7VIik4Enp/kZUl2mWX6x7FmQv0D2rFy1/7+2bR6zGfmROFPx4ztl8B/A0/t758z5nJGWVDMfT9dxez7zWNHlM9lb+Ao2snu7Zn9+3VdeDRwblXN1wVvXcU01+dr16HP19uB381Qd5hunH3xRrmphf3w/nrCiJPyK2gncq8frypQVd8HvsnonGo4hjsBzwS+MWLYbWn72U+Bq3rxY4D/qpuu9sz4OO3k5vf6cgv4r3FjHnIK8MAk/5rWWHWHoeEnAm9Ma6Act+vlXNttnDpNYr76jDTJTYkX0L60hv2G9mW1XVX9pqr+p2rOS/gAB/az2WtmGf6hqjqzJy//ADxtHZ1tPwt4a1Wd18/6XgE8Y+jD+I9VdU0/UHwTmEnMfwP8VpIt+1nmiYz2LOCQqjqtJ8yvAH6/f/lP4i+A91bV16vq+mr9wq8FBvvmvaOfcf8M+Aw3tWQ9DfiPqjqrqq4G/nHMZc42v3G3+eOB71XVh6rquqr6CHAOrRVoXC/vrY8zr8H+8C8CHkVrPfhMP2Odyw3Aa6tdHrqmtwYd2c/Or6QdEB8JkGQr2pf8fr1F5DdVdfwc894XeFVVre7b/UDgqX3feirtYHBCH/YPzHMpaZ7lvLOqTu37wcG0lsOZS2XvpB1cT6KdMM61rX9D695wH9pJ8FlVdfEc4783yS9olx//nDUvc+4LHND3l1/15T59oLVu2PHclEA/jHbpcVRCPdd89wY+WVVf7K0gxwLfZs1E5H1V9f1+LPkEc7fu3qvX7xpaYvbCqvr20DhnDe2Pj+zHpjvTulcMu5B2qfhOI4aN66wkvwTOpJ2gDreovXcopuGWzS8D2/Vj0FwJ483qNjT848CvWHh3gg8AL6d97r8KXJSB/pT9ROHqqjp/aLoPAs9J6zKzUT8Rm88NtJa3AxdwEjOznC1pX8zHjDndXPMaJ+Yt+t/Z9psV4y60J11PBj7cv1ePYnRr6jjuNbQf/NGIcbZgdNzrPKYxPl+37sOBG1t0D2J0gjvnvjjCo2iNKUcC/9eX94wR470TuF9aF55xzZZTzXhVPx59B7gVMPiwhmf3YVfTco6nDnwHb8mIddW/+y/vw7cALhojV3v20L7w2T6vc2iNjtvTjquXJnl/b8iBdtw+Evgb4Jwk35mvNX6e7TZOncaxtvUZaZKEemtaP6hh/0prMfl82mXZA0aMM+zHCxj+Q9oHZtwVNpd79PkNzntjWivrjJ8O/H81LSmBdnnrt2k7x8lJnjDOMvpOchlt/U1iO2D/wZ0B2KYvb77Y78Ga63S+9T/f/Mbd5sPrm/5+IevizVW12cDrxgNyVf2C9iV/f9rlovlcMniG2y99vTetK8YVtFbTzfoBfBvgZ1U1b4tttx1w1MC2OZvWqnc3htZ/T+7W5pLyzHJeObQfrKCv036AfD9tnby92iXB2XyW9gXzXtoXy7uSbDrH+PtW1WbAJrSThM+kdTMJbX0dOxDTN2jHmy1mmdfxwCOTbEtrJfwk8Ii0vpIbAWePMd/tgD8bWherGO8zMcoPev3uDBxM+zIddr+h/fH4ajdUX047yRy2Fe0q2y/631E3It2adnIzm/vRWsufAzyU1tI3aN+hmNb4Qur7xIdpfVUfwuytUjer24j5/AMtYb3NHPGuoZrDqmo32lWClwBvGkjYh7t7zPh4H7YfC2g1rqpP0tb388ac5Eu0L9IDaCdovx4aPmq7zbwf3m4LiXnmGDDbfnPJHMufiWFm+XvRTnRnrvQdDjwpA92jFuAHQ/vB0bPEPiruQeskpjE+X7+htRIPehet6+hjhuY13744bG/gmGpdF4pZun30xO5fWEArNbPnVDNe39f/VlX15Koa/C79UD9WbUW7ijbYUHApI9ZVWreIO/fhlwF3m6PBY43lDLxu7ENeVV+tqqdU1Za0Y+UfAn/Xh/2yql5XVTvTjtWfAY7MTd1SZjNyu41Zp3GsVX1ms1YJddqdtFvTzujWUFVXVtX+VbU97azvZUl2nxk8yyznOyvaZuD/bWkfmEtpX7w3fpn0xGfwLH6++V5A+xIenPd1wEXzTEdVfa+qnkk7W30j8IlZLgussYw+zhbAT+Zbxjx+zE0fsJnX7au1+s7nQtbsYrDN0PD51tuaI8+9zQcNr29o63zSdQFAbwX6c9pBbt5uQdy8nvvTuvc8uFpXnpmuIqGt781nOfiPWl8/Bh43tH02qaqf0Nb/jeu8HwRmSzTn82PgNSP2g0/2eW9GO7n4APDP6fcIjIq7f7m8taoeSOvS8wDG6BLRW4O/1GN5dP+i+QnwqBH1v3R4ud1ZtFaX/YDjq+oy2iXL5wAz/djmm++PgfcPDbtDVb1txPLG1k+6Xka7srTHmJN9kd5PecjTgP+pqhto3QHunjXvbdiI9pkYPvEcjumGqvoQcAbtqtdCfZCWPBxVC+hqNiKOz9BOUtbq0abV+j5+mNbqNtMndE9GtApX1eW01vXn05KxhXg1Lfmf9z6Vvm0+Qtvmo5LgHwErh8ruRWutX+OKzkJirnayfiqz7zczJzQ/Yug42lt/N+em/WZvWoK4Ou0ekQ+x9n3ex/FF2hXb35ljnHUZ01yfrxNqqOGgf4b/mdn75M62L96oNy78CfDYtHs+fkq7AfPBGX2vyXtp37N7jhg2PO/tacfc/5lv3LlUu6K4L/CGfoUF2rp6wuBxptuLduJxMi2XC+0q8sSq6mu0myxH9fO+nNbyfCfasW6u+cy23cap0zozV30GLSihTnKn3hL7UeA/q+pbI8Z5QtrNbaFV7Pr+gpaobr+QZXZ/lmSnnni8DvhEP0v9LrBJksenPXLm1ax5wLwIWJnZb0j5CPA3Se7VPywzfa7nfaRXkj9LsqIffH/Ri0c96u/DwPOS7JzWv+lfgK/XzS9nzuXWaY8NmnltTLvjdL8kD05zh74e5jvjg9bP7HlJ7tvX6WuGhi9oO82zzQcdC/x2kj9NsnGSp9NuZFvbfluDMWxCuwnolbSWqK0zcAcz49XpjrTL+79I6+/92pkBVXUhrQX3XWk3L946yUzCfRGwxVCy+h7g9Um26/GtSDJzt/QnaAeDh6XdFPY61v5q0cHAXyVZ1feDTZP8UW66KePfgS9X1QtoX8j/38C0a6yTtMenrer71y+BXzN6O95MXxc7cNMTa94DHJRkmz78rrnpMWsX025KvPFg2pPlE2h3Vc8kDscPvZ9vvocBeyXZPe3mxdv1/+8+Th3m0g/s/8bAPjGP19Bubnttks36sXN/Wt/HA/s436N123hD//xuQuv//XPgtDGX8wbgRWn3DYyt2iXNXRm/u9dcXk178tNY0m463aPvqxuldSH4LeCknhj+P+B/Z5n85cAja56bg4ZVu6fmh4zfl/rNtJPDr48Y9l/ALkme1o9jW9K+8D/W9+NJYv47YN8kf9n3iS2S/CutC9cb+zhfBTZO6/d7237MfxPtRPSnPTl7GK2r08799QDa/jvYmrrR0PfKgm6KH1RVZ9Lu6Tki7cbg2/TP37PSHqU3bkzjmu3z9TRmP8H8AK3BbbeZgrn2xRHT70U7yb/PQB3u28e9Wbenalc2Xsccn42+jR9Fu/fjK7XAe4dGqaozaMfSmUfPHkI7pnw07Xc+bpPk8bSGlldX6+J4Ka3L3nv79/nt+nfcE5P8y3zLTLJbkj9PsqK/vx8tOT+xvz8wrY/6rdO6TbyE1ig6zv0fN9tu49RpjPmudX1mM+6X+GeSXElrAXoV7Way2S6f7UA7e7iKdpPYu6rqK33YG4BXp12OffmYy4Z2JnsorSVkE9rGmDnTeSHtkvZPaEnA4FM/Zm5auCzJqC+oQ/q8T6DdQPIr4K/GjGkPWh/Dq2id559RN+8gT1UdR2sZOZLWMnlvRve5msuxtERv5nVgVZ1C60f9TtqOdS433SQ4p6r6LK0F98t9uq/1QTMtVR8Adurb6WbPxh5hrm0+uNzLaDdB7U+7xPR3wBP6h3lcM08BmXnNTPsGYHW1u+Ovpd048s+56fmtBwKH9TrN1iLyb8DtaB/0E2mPORv0bNrVkXNoSeFLe73OoZ2cndfnfw/aPnE0rRvMlX1+D+7jn0Xr7/1h2j7xc9bcb8dWVf9L+zy8l3Zi911a0lC9ng/rw6Ht249M8pT+/m20/p0/T/ImWuvRoX0+59ESkLla+meeEHIV7TO4f1V9uQ97E22f+FKv///R7pyeaYl7E3BqX18zlyePp53UnDDL+/nmex7tEVj/SNuGP6S1sK+rX4Q9GLhv1rz8+J2h/fGNPZZv065wPIR23PwF7WTviVV1Qh+nerwracef1bSbDJ9YN+9mMFI/DpxCa02d8f6hmP5vlmlPqKqfjho2V91GzOc42v0l47qSdmKympseMfb8qjqZlnB9ZbiFcWBZq6tqZH3GMHOz6ryq6tJ+1WXUsAtox7G/oXXDOJ129W3k1ZyFxNyX+XjaZ/gi2n78VNpj3b7Tx7ma1uq5Z1/u92if3ZmThefQHjl4fFX9dOZFOyY9eOCYuBtrfq/8cpwY57AvraHnYNp2/V6vyzELiGksIz5fP+nL2r3vR6Om+Q3te2BwH5hrXxy2N+0K2E+G6vDvtL64o44zhzG6O9/7+/Hrp7Quk4ezsHuJ5vOvtBPtzfv+sittXzqF1l3mDcDLqurGBpZqXcNeRVsHl9KuhOzDmo/z23vomHBVWkPSz2n76UxO9Jlep3/r021Ea/D6GW1dPxTYc5yrY6O227h1GsPa1mekjD6h1oYk7cklZwK3Had1XtLCpN0A+DXgb6vqP+cee8OV5BDgq1V1yLRjWQzSfqDj88BTBk5WJS1C66rlRktM2rOLb5P2yJ830p6KYTIt3QJ6F689gW0zz53iG7hTaK1B4sYrEE+h/QaA39fSImYL9QYq7WeGf5/WR/Z42iPB5nzskSRJkm7OhFqSJEmagJeQJEmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakmSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNIGNpx2AtJhtueWWtXLlymmHIUlLyqmnnnppVa2YdhzS+mJCLc1h5cqVnHLKKdMOQ5KWlCQ/nHYM0vpklw9JkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkiZgQq0lK8k2Sb6c5OwkZyX5616+eZIvJPle/3uXXp4k70hybpIzkuwy3RpIkqTlwIRaS9l1wP5VdV/gIcCLkuwEHAAcV1U7AMf19wCPA3bor32Ad6//kCVJ0nJjQq0lq6ourKrT+v9XAmcDWwNPAg7rox0G/HH//0nAB6s5EdgsyVbrOWxJkrTMmFBrWUiyEngg8HXgblV1IbSkG7hrH21r4McDk63uZZIkSWvNX0rUkpdkU+BI4KVVdUWSWUcdUVYj5rcPrUsI22677boKc71aecAxU1nu+Qc9firLlSRpmmyh1pKW5Na0ZPrwqvpkL75opitH/3txL18NbDMw+T2BC4bnWVUHV9Wqqlq1YsWKWy54SZK0LJhQa8lKa4r+AHB2Vb11YNDRwN79/72BTw+UP6c/7eMhwOUzXUMkSZLWll0+tJQ9FHg28K0kp/eyVwIHAUckeT7wI2CvPuxYYE/gXOBq4HnrN1xJkrQcmVBryaqqrzK6XzTA7iPGL+BFt2hQkiRpg2OXD0mSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakmSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakmSJGkCJtRaspIckuTiJGcOlH0syen9dX6S03v5yiTXDAx7z/QilyRJy8nG0w5AmsChwDuBD84UVNXTZ/5P8hbg8oHxv19VO6+36CRJ0gbBhFpLVlWdkGTlqGFJAjwNeNT6jEmSJG147PKh5erhwEVV9b2Bsnsl+UaS45M8fFqBSZKk5cUWai1XzwQ+MvD+QmDbqrosye8Cn0pyv6q6YnjCJPsA+wBsu+226yVYSZK0dNlCrWUnycbAnwAfmymrqmur6rL+/6nA94HfHjV9VR1cVauqatWKFSvWR8iSJGkJM6HWcvRo4JyqWj1TkGRFklv1/7cHdgDOm1J8kiRpGTGh1pKV5CPA14Adk6xO8vw+6Bms2d0D4BHAGUm+CXwC2K+qfrb+opUkScuVfai1ZFXVM2cpf+6IsiOBI2/pmCRJ0obHFmpJkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJE/CmREnrzMoDjpnass8/6PFTW7YkacNmC7UkSZI0ARNqSZIkaQIm1JIkSdIETKglSZKkCZhQS5IkSRMwoZYkSZImYEItSZIkTcCEWpIkSZqACbUkSZI0ARNqSZIkaQIm1JIkSdIETKglSZKkCZhQa8lKckiSi5OcOVB2YJKfJDm9v/YcGPaKJOcm+U6SP5xO1JIkabkxodZSdiiwx4jyt1XVzv11LECSnYBnAPfr07wrya3WW6SSJGnZMqHWklVVJwA/G3P0JwEfraprq+oHwLnAg26x4CRJ0gbDhFrL0YuTnNG7hNyll20N/HhgnNW97GaS7JPklCSnXHLJJbd0rJIkaYkzodZy827g3sDOwIXAW3p5Roxbo2ZQVQdX1aqqWrVixYpbJkpJkrRsmFBrWamqi6rq+qq6AXgfN3XrWA1sMzDqPYEL1nd8kiRp+TGh1rKSZKuBt08GZp4AcjTwjCS3TXIvYAfgpPUdnyRJWn42nnYA0tpK8hFgV2DLJKuB1wK7JtmZ1p3jfGBfgKo6K8kRwLeB64AXVdX104hbkiQtLybUWrKq6pkjij8wx/ivB15/y0UkSZI2RHb5kCRJkiZgQi1JkiRNwIRakiRJmoAJtSRJkjQBE2pJkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkiZgQi1JkiRNwIRakiRJmoAJtSRJkjQBE2pJkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkiZgQq1FIcn912KaQ5JcnOTMgbJ/TXJOkjOSHJVks16+Msk1SU7vr/esy/glSdKGy4Rai8V7kpyU5IUzSfAYDgX2GCr7AnD/qvod4LvAKwaGfb+qdu6v/SYPWZIkyYRai0RVPQx4FrANcEqSDyd5zDzTnAD8bKjs81V1XX97InDPWyJeSZKkGSbUWjSq6nvAq4G/Bx4JvKN33/iTtZzlnwOfHXh/ryTfSHJ8kofPNlGSfZKckuSUSy65ZC0XLUmSNhQm1FoUkvxOkrcBZwOPAp5YVfft/79tLeb3KuA64PBedCGwbVU9EHgZ8OEkdxo1bVUdXFWrqmrVihUr1qI2kiRpQ7LxtAOQuncC7wNeWVXXzBRW1QVJXr2QGSXZG3gCsHtVVZ/PtcC1/f9Tk3wf+G3glHUUvyRJ2kCZUGux2BO4pqquB0hogAHiAAAR2UlEQVSyEbBJVV1dVR8adyZJ9qB3GamqqwfKVwA/q6rrk2wP7ACct05rIEmSNkh2+dBi8UXgdgPvb9/LZpXkI8DXgB2TrE7yfFpL9x2BLww9Hu8RwBlJvgl8Ativqn42csaSJEkLYAu1FotNquqqmTdVdVWS2881QVU9c0TxB2YZ90jgyMlClCRJujlbqLVY/DLJLjNvkvwucM0c40uSJC0KtlBrsXgp8PEkF/T3WwFPn2I8kiRJYzGh1qJQVScnuQ+wIxDgnKr6zZTDkiRJmpcJtRaT3wNW0vbLByahqj443ZAkSZLmZkKtRSHJh4B7A6cD1/fiAkyoJUnSomZCrcViFbDTzA+xSJIkLRUm1FoszgTuTvuJ8GVj5QHHTDsESZJ0CzOh1mKxJfDtJCfRfyIcoKr+aHohSZIkzc+EWovFgdMOQJIkaW2YUGtRqKrjk2wH7FBVX+y/kniracclSZI0H38pUYtCkr8APgG8txdtDXxqehFJkiSNx4Rai8WLgIcCVwBU1feAu041IkmSpDGYUGuxuLaqfj3zJsnGtOdQS5IkLWom1Fosjk/ySuB2SR4DfBz4zJRjkiRJmpcJtRaLA4BLgG8B+wLHAq+eakSSJElj8CkfWhSq6gbgff0lSZK0ZJhQa1FI8gNG9Jmuqu2nEI4kSdLYTKi1WKwa+H8TYC9g8/kmSnII8ATg4qq6fy/bHPgYsBI4H3haVf08SYC3A3sCVwPPrarT1mEdJEnSBsg+1FoUquqygddPqurfgEeNMemhwB5DZQcAx1XVDsBx/T3A44Ad+msf4N3rJHhJkrRBs4Vai0KSXQbebkRrsb7jfNNV1QlJVg4VPwnYtf9/GPAV4O97+QerqoATk2yWZKuqunCi4CVJ0gbNhFqLxVsG/r+O3lVjLed1t5kkuaouTDLzAzFbAz8eGG91L1sjoU6yD60Fm2233XYtQ5AkSRsKE2otClW123pYTEYtekQsBwMHA6xatcofl5EkSXMyodaikORlcw2vqrcuYHYXzXTlSLIVcHEvXw1sMzDePYELFhapJEnSmrwpUYvFKuAvaV0wtgb2A3ai9aOety/1kKOBvfv/ewOfHih/TpqHAJfbf1qSJE3KFmotFlsCu1TVlQBJDgQ+XlUvmGuiJB+h3YC4ZZLVwGuBg4Ajkjwf+BHtEXzQfn1xT+Bc2mPznrfuqyFJkjY0JtRaLLYFfj3w/te050jPqaqeOcug3UeMW8CL1iY4SZKk2ZhQa7H4EHBSkqNoNwo+GfjgdEOSJEmanwm1FoWqen2SzwIP70XPq6pvTDMmSZKkcXhTohaT2wNXVNXbgdVJ7jXtgCRJkuZjQq1FIclrab9m+IpedGvgP6cXkSRJ0nhMqLVYPBn4I+CXAFV1AQt/XJ4kSdJ6Z0KtxeLX/SkcBZDkDlOOR5IkaSwm1FosjkjyXmCzJH8BfBF435RjkiRJmpdP+dCiUFVvTvIY4ApgR+A1VfWFKYelJWTlAcdMZbnnH/T4qSxXkrR4mFBr6pLcCvjvqno0YBItSZKWFLt8aOqq6nrg6iR3nnYskiRJC2ULtRaLXwHfSvIF+pM+AKrqJdMLSZIkaX4m1FosjukvSZKkJcWEWlOVZNuq+lFVHTbtWCRJktaGfag1bZ+a+SfJkdMMRJIkaW2YUGvaMvD/9lOLQpIkaS2ZUGvaapb/JUmSlgT7UGvaHpDkClpL9e36//T3VVV3ml5okiRJ8zOh1lRV1a3W9TyT7Ah8bKBoe+A1wGbAXwCX9PJXVtWx63r5kiRpw2JCrWWnqr4D7Aw3/grjT4CjgOcBb6uqN08xPEmStMzYh1rL3e7A96vqh9MORJIkLU8m1FrungF8ZOD9i5OckeSQJHcZNUGSfZKckuSUSy65ZNQokiRJNzKh1rKV5DbAHwEf70XvBu5N6w5yIfCWUdNV1cFVtaqqVq1YsWK9xCpJkpYuE2otZ48DTquqiwCq6qKqur6qbgDeBzxoqtFJkqRlwYRay9kzGejukWSrgWFPBs5c7xFJkqRlx6d8aFlKcnvgMcC+A8VvSrIz7Qdkzh8aJkmStFZMqLUsVdXVwBZDZc+eUjiSJGkZs8uHJEmSNAETakmSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakmSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNIGNpx2AdEtJcj5wJXA9cF1VrUqyOfAxYCVwPvC0qvr5tGLU0rfygGOmtuzzD3r81JYtSbqJLdRa7narqp2ralV/fwBwXFXtABzX30uSJK01E2ptaJ4EHNb/Pwz44ynGIkmSlgETai1nBXw+yalJ9ulld6uqCwH637sOT5RknySnJDnlkksuWY/hSpKkpcg+1FrOHlpVFyS5K/CFJOeMM1FVHQwcDLBq1aq6JQOUJElLny3UWraq6oL+92LgKOBBwEVJtgLofy+eXoSSJGk5MKHWspTkDknuOPM/8FjgTOBoYO8+2t7Ap6cToSRJWi7s8qHl6m7AUUmg7ecfrqrPJTkZOCLJ84EfAXtNMUZJkrQMmFBrWaqq84AHjCi/DNh9/UckSZKWK7t8SJIkSRMwoZYkSZImYEItSZIkTcCEWpIkSZqACbUkSZI0ARNqSZIkaQIm1JIkSdIETKglSZKkCZhQS5IkSRMwoZYkSZImYEItSZIkTcCEWpIkSZqACbUkSZI0ARNqSZIkaQIm1JIkSdIETKglSZKkCWw87QAkSWtn5QHHTGW55x/0+KksV5IWK1uotewk2SbJl5OcneSsJH/dyw9M8pMkp/fXntOOVZIkLX22UGs5ug7Yv6pOS3JH4NQkX+jD3lZVb55ibJIkaZkxodayU1UXAhf2/69Mcjaw9XSjkiRJy5VdPrSsJVkJPBD4ei96cZIzkhyS5C6zTLNPklOSnHLJJZesp0glSdJSZUKtZSvJpsCRwEur6grg3cC9gZ1pLdhvGTVdVR1cVauqatWKFSvWW7ySJGlpMqHWspTk1rRk+vCq+iRAVV1UVddX1Q3A+4AHTTNGSZK0PJhQa9lJEuADwNlV9daB8q0GRnsycOb6jk2SJC0/3pSo5eihwLOBbyU5vZe9Enhmkp2BAs4H9p1OeJIkaTkxodayU1VfBTJi0LHrOxZJkrT82eVDkiRJmoAJtSRJkjQBE2pJkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkibgc6glSQuy8oBjprbs8w96/NSWLUmzsYVakiRJmoAt1JKkJWNareO2jEuaiy3UkiRJ0gRMqCVJkqQJmFBLkiRJE7APtSRJ8/DJJpLmYgu1JEmSNAETakmSJGkCJtTa4CTZI8l3kpyb5IBpxyNJkpY2+1Brg5LkVsC/A48BVgMnJzm6qr493cgkaTSfvS0tfrZQa0PzIODcqjqvqn4NfBR40pRjkiRJS5gJtTY0WwM/Hni/updJkiStFbt8aEOTEWW1xgjJPsA+/e1VSb4zwfK2BC6dYPqlwDouD9ZxeVhndcwbJ5p8u3URg7RUmFBrQ7Ma2Gbg/T2BCwZHqKqDgYPXxcKSnFJVq9bFvBYr67g8WMflYUOoo7QY2eVDG5qTgR2S3CvJbYBnAEdPOSZJkrSE2UKtDUpVXZfkxcB/A7cCDqmqs6YcliRJWsJMqLXBqapjgWPX0+LWSdeRRc46Lg/WcXnYEOooLTqpqvnHkiRJkjSSfaglSZKkCZhQS7eA5frz5knOT/KtJKcnOaWXbZ7kC0m+1//eZdpxLkSSQ5JcnOTMgbKRdUrzjr5dz0iyy/QiH98sdTwwyU/6tjw9yZ4Dw17R6/idJH84nagXJsk2Sb6c5OwkZyX5616+bLblHHVcVttSWopMqKV1bODnzR8H7AQ8M8lO041qndqtqnYeeDTXAcBxVbUDcFx/v5QcCuwxVDZbnR4H7NBf+wDvXk8xTupQbl5HgLf1bblzv7eAvq8+A7hfn+ZdfZ9e7K4D9q+q+wIPAV7U67KctuVsdYTltS2lJceEWlr3NrSfN38ScFj//zDgj6cYy4JV1QnAz4aKZ6vTk4APVnMisFmSrdZPpGtvljrO5knAR6vq2qr6AXAubZ9e1Krqwqo6rf9/JXA27VdQl822nKOOs1mS21JaikyopXVvOf+8eQGfT3Jq/0VJgLtV1YXQvvCBu04tunVntjott2374t7d4ZCBrjpLvo5JVgIPBL7OMt2WQ3WEZbotpaXChFpa9+b9efMl7KFVtQvtcvmLkjxi2gGtZ8tp274buDewM3Ah8JZevqTrmGRT4EjgpVV1xVyjjihbEvUcUcdluS2lpcSEWlr35v1586Wqqi7ofy8GjqJdPr5o5lJ5/3vx9CJcZ2ar07LZtlV1UVVdX1U3AO/jpq4AS7aOSW5NSzQPr6pP9uJltS1H1XE5bktpqTGhlta9Zfnz5knukOSOM/8DjwXOpNVt7z7a3sCnpxPhOjVbnY4GntOfEPEQ4PKZ7gRLzVB/4SfTtiW0Oj4jyW2T3It2095J6zu+hUoS4APA2VX11oFBy2ZbzlbH5bYtpaXIX0qU1rFl/PPmdwOOat/pbAx8uKo+l+Rk4Igkzwd+BOw1xRgXLMlHgF2BLZOsBl4LHMToOh0L7Em7uetq4HnrPeC1MEsdd02yM60LwPnAvgBVdVaSI4Bv054q8aKqun4acS/QQ4FnA99KcnoveyXLa1vOVsdnLrNtKS05/lKiJEmSNAG7fEiSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakkaIclVt/D8n5vkHgPvz0+y5TpexkuSnJ3k8IGyP0xyen9dleQ7/f8PrsX8d0myx7qMWZKWIp9DLUnT8VzaD3Dckr9c90LgcVX1g5mCqvpv2jPSSfIV4OVVdcpazn8X4P7A5yaMU5KWNFuoJWlMSVYkOTLJyf310F5+YJJDknwlyXlJXjIwzT8kOSfJF5J8JMnLkzwVWAUc3luHb9dH/6skpyX5VpL79OkfOdCi/I2ZX6sciutlSc7sr5f2svcA2wNHJ/mbMeu3cZK3JjkpyRlJXtDL90oyk4RvneS7SbYDXgM8q8f21CSPSvLN/v60/ouakrTs2UItSeN7O/C2qvpqkm1pLb337cPuA+wG3BH4TpJ3Aw8AngI8kHa8PQ04tao+0X9N88bW4f4LlJdW1S5JXgi8HHhB//uiqvrfJJsCvxoMKMnv0n7l78FAgK8nOb6q9uvdMXarqkvHrN8+wMVV9aAktwVOTPL5qvp4kqck2Q94EvCqqvphktcB96+qmST+s8A+VfX1UbFK0nJlQi1J43s0sFNPfgHuNNBifExVXQtcm+Ri2k+1Pwz4dFVdA5DkM/PM/5P976nAn/T//xd4a+8H/cmqWj00zcOAo6rql30ZnwQeDnxjLer3WOC+SZ7R398Z2IH2k90vonVROaGqPj7L9P8L/FuSDwNHVtUt2g9dkhYLE2pJGt9GwO/PJMgzeoJ97UDR9bTja1iYmXnMTE9VHZTkGGBPWovxo6vqnMHFL3AZcwnwwqo6bsSwe/a47p4kVVXDI1TVPyc5Gng8cHKSXavqe+swPklalOxDLUnj+zzw4pk3SXaeZ/yvAk9MsknvAvH4gWFX0rqHzCnJvavqW1X1RuAUWteSQScAf5zk9r3P8pOB/5m/KiP9N/DCJBv3Ze+Y5HZJbg0cAjwNOA/461F16LGeUVVvoLWQ77iWcUjSkmILtSSNdvskg90r3gq8BPj3JGfQjp8nAPvNNoOqOrm32H4T+CEtIb68Dz4UeE+Sa4DfnyOOlybZjdY6/G3gs0PLOC3JocBJvej9VbU23T0A3gtsC5zeW90vpvWZfgVwXFX9X5KzgJOSHAt8CfjbJN8AXg/snuThwA3AGbQTEEla9jLiqp0kaR1JsmlVXZXk9rQEfJ+qOm3acUmS1h1bqCXplnVwkp2ATYDDTKYlafmxhVqSJEmagDclSpIkSRMwoZYkSZImYEItSZIkTcCEWpIkSZqACbUkSZI0ARNqSZIkaQL/PwLC9zbwDfF0AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.hist(length_of_extracted_txts)\n",
    "plt.suptitle('Distributions of Lengths of Extracted Texts' + \n",
    "             ' Between REQUIREMENTS/MINIMUM QUALIFICATIONS AND PROCESS NOTES')\n",
    "plt.xlabel('Lengths of Texts')\n",
    "plt.ylabel('Frequency')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Oops! Looks like we have quite a few jobs with the order of sections messed up. Now, we can use the logic described in part 1 (or 2) to catch these jobs. Let's assume that the requirement section for a job can't be greater than or equal to 150 words."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Identify the trouble makers, Round 1.**\n",
    "\n",
    "Save the printouts to a word file called, *TroubleMakers_Type3_1*."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/JobBulletins_cleaned/311 DIRECTOR  9206 041814.txt\n",
      "CityofLA/JobBulletins_cleaned/ARTS ASSOCIATE 2454 072117 REV 072817.txt\n",
      "CityofLA/JobBulletins_cleaned/ARTS MANAGER 2455 092818.txt\n",
      "CityofLA/JobBulletins_cleaned/ASSISTANT INSPECTOR 4208 111315.txt\n",
      "CityofLA/JobBulletins_cleaned/AVIONICS SPECIALIST 3565 103114revised.txt\n",
      "CityofLA/JobBulletins_cleaned/CONSTRUCTION INSPECTOR 7291 042117.txt\n",
      "CityofLA/JobBulletins_cleaned/DATABASE ARCHITECT 1470 083118.txt\n",
      "CityofLA/JobBulletins_cleaned/DETENTION OFFICER 3211 113018.txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRIC DISTRIBUTION MECHANIC 3879 040717.txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRIC STATION OPERATOR  5224 070717 (3).txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRICAL CRAFT HELPER 3799 092818.txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRICAL MECHANIC 3841 012017.txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRICAL REPAIRER 3853 122917 updated.txt\n",
      "CityofLA/JobBulletins_cleaned/EMERGENCY MANAGEMENT COORDINATOR 1702 102618.txt\n",
      "CityofLA/JobBulletins_cleaned/EMS ADVANCED PROVIDER 2341 111618 REV 122018.txt\n",
      "CityofLA/JobBulletins_cleaned/EMS NURSE PRACTITIONER SUPERVISOR 2340 031116 REV 032316 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/ENVIRONMENTAL AFFAIRS OFFICER 7320 061518.txt\n",
      "CityofLA/JobBulletins_cleaned/ENVIRONMENTAL SPECIALIST 7310 012916.txt\n",
      "CityofLA/JobBulletins_cleaned/EQUIPMENT SPECIALIST 3734 111717 revised 11.21.txt\n",
      "CityofLA/JobBulletins_cleaned/FINANCIAL MANAGER 1557 070116 Rev.txt\n",
      "CityofLA/JobBulletins_cleaned/FIRE ASSISTANT CHIEF 2166 011218.txt\n",
      "CityofLA/JobBulletins_cleaned/FIRE BATTALION CHIEF 2152 030918.txt\n",
      "CityofLA/JobBulletins_cleaned/FISCAL SYSTEMS SPECIALIST 1555 101918.txt\n",
      "CityofLA/JobBulletins_cleaned/HOUSING INSPECTOR 4243 070618 REV 010819.txt\n",
      "CityofLA/JobBulletins_cleaned/INSTRUMENT MECHANIC 3843 060818 2.txt\n",
      "CityofLA/JobBulletins_cleaned/MANAGEMENT ANALYST 9184 092118.txt\n",
      "CityofLA/JobBulletins_cleaned/PARK RANGER 1966 072718 REV 073118 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/POLICE OFFICER 2214 110906 Rev 060115.txt\n",
      "CityofLA/JobBulletins_cleaned/PORT PILOT 5151 081817 REV 090717.txt\n",
      "CityofLA/JobBulletins_cleaned/PRE-PRESS OPERATOR 1481 072817 (4).txt\n",
      "CityofLA/JobBulletins_cleaned/PROPERTY MANAGER 1964 090916 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/PUBLIC INFORMATION DIRECTOR 1800 030317.txt\n",
      "CityofLA/JobBulletins_cleaned/REAL ESTATE ASSOCIATE 1941 052716.txt\n",
      "CityofLA/JobBulletins_cleaned/REFUSE COLLECTION TRUCK OPERATOR 021717.txt\n",
      "CityofLA/JobBulletins_cleaned/SANITATION WASTEWATER MANAGER 4128 090916.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR HOUSING INVESTIGATOR 8517 020317 REVISED 021617.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR REAL ESTATE OFFICER 1961 0413018 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/STEAM PLANT ASSISTANT 5622 051118 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/SYSTEMS ANALYST 1596 102717.txt\n",
      "CityofLA/JobBulletins_cleaned/SYSTEMS PROGRAMMER 1455 091616 REV 100416.txt\n",
      "CityofLA/JobBulletins_cleaned/UTILITY SERVICES MANAGER 9106 110416.txt\n",
      "CityofLA/JobBulletins_cleaned/WASTEWATER TREATMENT ELECTRICIAN 5615 060812 REV 011218.txt\n"
     ]
    }
   ],
   "source": [
    "# Catch jobs with sections' order messing up\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Print out jobs that have more than 150 words in their requirement sections\n",
    "    txt      = job[job.index('REQUIREMENTS/MINIMUM QUALIFICATIONS'):job.index('PROCESS NOTES')]\n",
    "    txt      = (txt.replace('\\n', ' ')\n",
    "                   .replace(';', ' ')\n",
    "                   .replace(',', ' ')\n",
    "                   .replace('.', ' ')\n",
    "                   .replace(')', ' ') # add '(' and ':' if wish\n",
    "                   .replace('*', ' ')).split()\n",
    "    if len(txt) >= 150:\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Great, let's have a look at these ones...\n",
    "\n",
    "Here are the found culprits:\n",
    "* ENVIRONMENTAL COMPLIANCE INSPECTOR 4292 080516 REV 081616.txt\n",
    "* FIRE CAPTAIN 2142 033018.txt\n",
    "* GEOGRAPHIC INFORMATION SYSTEMS SUPERVISOR 7214 031717 REV 033017.txt\n",
    "* STEAM PLANT ASSISTANT 5622 051118 (1).txt. This job actually had two requirements! A lookup in the actual pdf file showed that the first `REQUIREMENTS/MINIMUM QUALIFICATIONS` was a typo and it should have been `SPECIAL INFORMATION`.\n",
    "\n",
    "Let's rerun the code in our histogram one more time, just to make sure!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "682\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAtQAAAEjCAYAAAASUpbMAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAIABJREFUeJzt3Xu89fWc///HMyGEVBeS6pJpIr4jzTWYcSphEsYYchhDDFMNxhiZmRyGxowR4zD8jENoiskhEpliEGrMSCdJKSThUjqhgxLV6/fH+71rXau19177WlfX2ntfj/vttm57r/fn9Hp/Pp/1Wa/P+/P+fFaqCkmSJElrZ6NpByBJkiQtZSbUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkiZgQi1JkiRNYJ0k1Enek+Qf1tG8tk1yVZJb9fdfSfKCdTHvPr/PJtl7Xc1vUkkemuR7vc5/PO14ZpPk/CSPvoWXcbckJyS5MslbbsllLTbrY/1KkqRbxrwJdf+iv6YnOb9I8n9J9kty47RVtV9V/dOY85ozaaiqH1XVplV1/XhVmHN5Byb5z6H5P66qDpt03uvQ64B39jp/anjgNBKtJIcm+ef1ucxuH+BS4E5Vtf/wwB7Xr/vJx8zrm+PMOEkl+a11HXCf965JVt9C8/7sQF1/M1T/90w47xOT/NkE0/6qx3F5ki8nue+Y094nyXVrs9z1JckeSW7o9bsyydlJnjUwfJO+T/1yaH98ycA4v5PkmCRX9Hl8IcmqoWWcO2LZN26XJAclef8sy1yd5I1JMjTtr4Zi+vjA8irJh4eW95Be/rlx6tZjqiRPHJjHpr3s7km+NLTPXjvw/t/SvLYf265K8uMkHxyK6XZJLuuxnNjnvePQOJ/r5Q+ZY12dMrR+3jzzuRneD5N8tE/z2KHlvKeXP2N4OSP2h3sObId5Yx4lySOSHN/XzS+SHJVkh4Hh+yX54ojpfprkYUNlM9vqAUPlI+cxEPvM/jf4ORjen9ZYD0k2SrJ/km/3fefHfZ3uNF9MSf5xYP6/SnLdwPtTh9dvn2b48/XFJL83MPw+fZojh5b/iSQH9P/n3RfnWEcXJdl4qPyjfX0N1u3+SX41NO2vesxXJDk5ycuT3HqO5X00N32Oftb3ox0G1udvBvaXr2bgONPH2SLJwT3mq5N8MwPHs4Hx9k5yWt9+Fyb5r6z5+ZpZzszrpwPTPjXJGb1Ol6Qd7+45sPwP9uVfkeScJH8zS13n3W7z1SnJbYfivKGPM/P+KZPUZzbjtlA/saruCGwHHAT8PfCBMacd2/DOuYHYDjhr2kEsEtsB3665f23oTf3kY+b1gDnGHdti3ff6CeCmVbUpcDhr1n+/KYf3gh7XFsBJwH9MOZ517bxevzsBrwAOTXKvoXF2HNof3wHtSwH4H9p62Q7YGvgc8OUkO08Y1449rt2B5wHDJ0UvGIppr4FhFwK7J7nTQNlzgO/OtpzhunU/A/4puSlZnVFVjxrYZ48E/mlgHi+lnTg/Bditj/Ng4ISh2ewOfK2qZhKR7/Y4AUhyd+D/AZePiHvQvYAnzzPOoO8CN17BTHJb4I+B8xcwj8F5LSjmJLsCxwIfBe4O3Bs4F/jf+b7MR8xrI9q+8bPBONbCeXPsT4PeA+wL/CVwF+A+wGeBPeeLqapeO7DPvBT4ysDyfndE3UZ9vj5L+3wNjn8DsNtQ2aBx9sXhZe8I/B5wG+BxI0b5OTBfA+MLek51D9qx5bnAp+eZ5p96jNsCVwLvGxh2WB+2AjgR+NhAvLcDvgTcrce9GfAq4O1JXjgw3itp+d2BfT7bAe8HnjS8nIHX3fu0O/VxXwzcmbbfvo+2/gHeCQT47b78P2Huz9Sc222+OlXVtYNxAhcDjx0om0nW17Y+Iy2oy0dVXV5VRwNPB/ZOcv++8BtbNJNs2c9qftHPpP4n7cz1Q7Qd4TP9TODvkqzsZyLPT/Ij4EsDZYMJzr2TnJTWEvbpJJv3Zd2sZTC9RTfJHsArgadnoCUzA11IelyvTvLDJBf3M6g792Ezceyd5EdJLk3yqoHlPCit9eOKfob01tnWW5K/SHJuXx9HJ7lHL/8+sP3AOrntQrZHkickOT03XTn4naH18PJ+hnV5ko8l2WRg+N+lnYFekOQFva6/lWQf4FnA3/WYPjOwyJ1HzW+2bT5LzH+QdkZ+ef/7B738UNoX2cxyF9Qqn+TpSc6bSRSSPC6txWZFkpkD5Df7vJ8+s+8k+fu0s9L/SHKXXo9Lkvy8/z/YIrJ5kv/o6+znST6V5A60A/k9ctNZ7j36vnVAku+ntbQdMbPf9nk9u+93lw3uV2sjyZP7dvlFX/c79fL79O0x8zndrr///bQuNb8HvL/H/JYkt0ryzl7/y9PO+Heca9kAVXUd7QB+Y0tUn9c/9G1yaZLDk2zWB58A3GpgfT2wb6v79Wln9sft+/sXJ/noGPMlycOTfL2vi9OSPHRg2IlprVEnpn1uj01ylzHqV/3q0TXA/ecbv/sn4Liq+seq+nlVXVFVbwE+AbxhzHnMF9d3aF+eC0nQr6btr3sBJLkNLeH8yAIXfzRwW+BpC5wO2n53bFX9AKCqLqiq9w+NsyctsZzxn8CzkhsT+D8DjgDmu9LxJuB1sx2PRvgk8Ogkd+zvnwh8DbhszOkHrU3M/wocXFXvrqqrquqyqvpbWqPLQo8Tj6YlA/v3OG61wOnH1o8xzwf2qqrjq+rXVfXLqjqsqt58C8Q02+fr46z5+SrgLcBsV1zH2ReH7Q18hfaZGdV99APAHyR58HyV6Nv4i7Skdfdxvveq6iraCdfNjkVV9Rvgw8D2A/vwnwNbAk/vPQB+XVX/RdsG/5Lk9km2AF4D7FNVR1fV1X28T1XVK+aLCdgFOKeqTujHyyuq6oiquqAP/z3g8J5D3lBV366qo+aqJnNvt3nrNEbMk9RnpLXqQ11VJwGrgYePGLx/H7aCdvbwyjZJPRv4Ea21e9OqetPANI8E7gv84SyLfA5tBd6DdjB6xyzjDcb4OeBfgI/V7C2Zz+2v3WiJ7aa0M6lBDwN2pLWYvCY3XdZ+O/D2qroT7ezliFFxJHkU7QP+NGAr4Ie0DwNVdW/WXCfXzlevgfnuAhxCaxHYAngvcHTWTMqfBuxBa6X5nV5X0k42XkY7uP0Wbf3TYzqYNVtCnzjf/Jhlm4+IeXPgGNr22wJ4K3BMki2q6rlDyx15OXI2VfUx2hffO/rB4QO0VoBLquoRfbQH9HnPnL3fHdicdia+D+3z8B/9/ba0BGpwf/gQcHvgfsBdgbdV1S9prRQXDJzlXgC8hNay9Ujafvtz4N/7etgJeDfw7D5sC2BBrU8z0i7HvYvWUrlFj/FTSTauqnOA1wKHp53RHwa8q6q+Vq1Lzcnc1Jq5P/AE4Hdp+/NdgD/tcc8Xw237uCcOFP8t8Fja5+eewG+At/VhjwCuH1hf36Al2bsODD+Pm/bLRwDHzzffJCuBT9ESj82BV/d1MZg0/ynthHErWqvGX49Rv42S7AXcEfj+fON3j6F9uQ87AnhU1sEVkX4C8vu0FsyF+CA3tQ4+gdbKd+kC53E9bd/6x7VIik4Enp/kZUl2mWX6x7FmQv0D2rFy1/7+2bR6zGfmROFPx4ztl8B/A0/t758z5nJGWVDMfT9dxez7zWNHlM9lb+Ao2snu7Zn9+3VdeDRwblXN1wVvXcU01+dr16HP19uB381Qd5hunH3xRrmphf3w/nrCiJPyK2gncq8frypQVd8HvsnonGo4hjsBzwS+MWLYbWn72U+Bq3rxY4D/qpuu9sz4OO3k5vf6cgv4r3FjHnIK8MAk/5rWWHWHoeEnAm9Ma6Act+vlXNttnDpNYr76jDTJTYkX0L60hv2G9mW1XVX9pqr+p2rOS/gAB/az2WtmGf6hqjqzJy//ADxtHZ1tPwt4a1Wd18/6XgE8Y+jD+I9VdU0/UHwTmEnMfwP8VpIt+1nmiYz2LOCQqjqtJ8yvAH6/f/lP4i+A91bV16vq+mr9wq8FBvvmvaOfcf8M+Aw3tWQ9DfiPqjqrqq4G/nHMZc42v3G3+eOB71XVh6rquqr6CHAOrRVoXC/vrY8zr8H+8C8CHkVrPfhMP2Odyw3Aa6tdHrqmtwYd2c/Or6QdEB8JkGQr2pf8fr1F5DdVdfwc894XeFVVre7b/UDgqX3feirtYHBCH/YPzHMpaZ7lvLOqTu37wcG0lsOZS2XvpB1cT6KdMM61rX9D695wH9pJ8FlVdfEc4783yS9olx//nDUvc+4LHND3l1/15T59oLVu2PHclEA/jHbpcVRCPdd89wY+WVVf7K0gxwLfZs1E5H1V9f1+LPkEc7fu3qvX7xpaYvbCqvr20DhnDe2Pj+zHpjvTulcMu5B2qfhOI4aN66wkvwTOpJ2gDreovXcopuGWzS8D2/Vj0FwJ483qNjT848CvWHh3gg8AL6d97r8KXJSB/pT9ROHqqjp/aLoPAs9J6zKzUT8Rm88NtJa3AxdwEjOznC1pX8zHjDndXPMaJ+Yt+t/Z9psV4y60J11PBj7cv1ePYnRr6jjuNbQf/NGIcbZgdNzrPKYxPl+37sOBG1t0D2J0gjvnvjjCo2iNKUcC/9eX94wR470TuF9aF55xzZZTzXhVPx59B7gVMPiwhmf3YVfTco6nDnwHb8mIddW/+y/vw7cALhojV3v20L7w2T6vc2iNjtvTjquXJnl/b8iBdtw+Evgb4Jwk35mvNX6e7TZOncaxtvUZaZKEemtaP6hh/0prMfl82mXZA0aMM+zHCxj+Q9oHZtwVNpd79PkNzntjWivrjJ8O/H81LSmBdnnrt2k7x8lJnjDOMvpOchlt/U1iO2D/wZ0B2KYvb77Y78Ga63S+9T/f/Mbd5sPrm/5+IevizVW12cDrxgNyVf2C9iV/f9rlovlcMniG2y99vTetK8YVtFbTzfoBfBvgZ1U1b4tttx1w1MC2OZvWqnc3htZ/T+7W5pLyzHJeObQfrKCv036AfD9tnby92iXB2XyW9gXzXtoXy7uSbDrH+PtW1WbAJrSThM+kdTMJbX0dOxDTN2jHmy1mmdfxwCOTbEtrJfwk8Ii0vpIbAWePMd/tgD8bWherGO8zMcoPev3uDBxM+zIddr+h/fH4ajdUX047yRy2Fe0q2y/631E3It2adnIzm/vRWsufAzyU1tI3aN+hmNb4Qur7xIdpfVUfwuytUjer24j5/AMtYb3NHPGuoZrDqmo32lWClwBvGkjYh7t7zPh4H7YfC2g1rqpP0tb388ac5Eu0L9IDaCdovx4aPmq7zbwf3m4LiXnmGDDbfnPJHMufiWFm+XvRTnRnrvQdDjwpA92jFuAHQ/vB0bPEPiruQeskpjE+X7+htRIPehet6+hjhuY13744bG/gmGpdF4pZun30xO5fWEArNbPnVDNe39f/VlX15Koa/C79UD9WbUW7ijbYUHApI9ZVWreIO/fhlwF3m6PBY43lDLxu7ENeVV+tqqdU1Za0Y+UfAn/Xh/2yql5XVTvTjtWfAY7MTd1SZjNyu41Zp3GsVX1ms1YJddqdtFvTzujWUFVXVtX+VbU97azvZUl2nxk8yyznOyvaZuD/bWkfmEtpX7w3fpn0xGfwLH6++V5A+xIenPd1wEXzTEdVfa+qnkk7W30j8IlZLgussYw+zhbAT+Zbxjx+zE0fsJnX7au1+s7nQtbsYrDN0PD51tuaI8+9zQcNr29o63zSdQFAbwX6c9pBbt5uQdy8nvvTuvc8uFpXnpmuIqGt781nOfiPWl8/Bh43tH02qaqf0Nb/jeu8HwRmSzTn82PgNSP2g0/2eW9GO7n4APDP6fcIjIq7f7m8taoeSOvS8wDG6BLRW4O/1GN5dP+i+QnwqBH1v3R4ud1ZtFaX/YDjq+oy2iXL5wAz/djmm++PgfcPDbtDVb1txPLG1k+6Xka7srTHmJN9kd5PecjTgP+pqhto3QHunjXvbdiI9pkYPvEcjumGqvoQcAbtqtdCfZCWPBxVC+hqNiKOz9BOUtbq0abV+j5+mNbqNtMndE9GtApX1eW01vXn05KxhXg1Lfmf9z6Vvm0+Qtvmo5LgHwErh8ruRWutX+OKzkJirnayfiqz7zczJzQ/Yug42lt/N+em/WZvWoK4Ou0ekQ+x9n3ex/FF2hXb35ljnHUZ01yfrxNqqOGgf4b/mdn75M62L96oNy78CfDYtHs+fkq7AfPBGX2vyXtp37N7jhg2PO/tacfc/5lv3LlUu6K4L/CGfoUF2rp6wuBxptuLduJxMi2XC+0q8sSq6mu0myxH9fO+nNbyfCfasW6u+cy23cap0zozV30GLSihTnKn3hL7UeA/q+pbI8Z5QtrNbaFV7Pr+gpaobr+QZXZ/lmSnnni8DvhEP0v9LrBJksenPXLm1ax5wLwIWJnZb0j5CPA3Se7VPywzfa7nfaRXkj9LsqIffH/Ri0c96u/DwPOS7JzWv+lfgK/XzS9nzuXWaY8NmnltTLvjdL8kD05zh74e5jvjg9bP7HlJ7tvX6WuGhi9oO82zzQcdC/x2kj9NsnGSp9NuZFvbfluDMWxCuwnolbSWqK0zcAcz49XpjrTL+79I6+/92pkBVXUhrQX3XWk3L946yUzCfRGwxVCy+h7g9Um26/GtSDJzt/QnaAeDh6XdFPY61v5q0cHAXyVZ1feDTZP8UW66KePfgS9X1QtoX8j/38C0a6yTtMenrer71y+BXzN6O95MXxc7cNMTa94DHJRkmz78rrnpMWsX025KvPFg2pPlE2h3Vc8kDscPvZ9vvocBeyXZPe3mxdv1/+8+Th3m0g/s/8bAPjGP19Bubnttks36sXN/Wt/HA/s436N123hD//xuQuv//XPgtDGX8wbgRWn3DYyt2iXNXRm/u9dcXk178tNY0m463aPvqxuldSH4LeCknhj+P+B/Z5n85cAja56bg4ZVu6fmh4zfl/rNtJPDr48Y9l/ALkme1o9jW9K+8D/W9+NJYv47YN8kf9n3iS2S/CutC9cb+zhfBTZO6/d7237MfxPtRPSnPTl7GK2r08799QDa/jvYmrrR0PfKgm6KH1RVZ9Lu6Tki7cbg2/TP37PSHqU3bkzjmu3z9TRmP8H8AK3BbbeZgrn2xRHT70U7yb/PQB3u28e9Wbenalc2Xsccn42+jR9Fu/fjK7XAe4dGqaozaMfSmUfPHkI7pnw07Xc+bpPk8bSGlldX6+J4Ka3L3nv79/nt+nfcE5P8y3zLTLJbkj9PsqK/vx8tOT+xvz8wrY/6rdO6TbyE1ig6zv0fN9tu49RpjPmudX1mM+6X+GeSXElrAXoV7Way2S6f7UA7e7iKdpPYu6rqK33YG4BXp12OffmYy4Z2JnsorSVkE9rGmDnTeSHtkvZPaEnA4FM/Zm5auCzJqC+oQ/q8T6DdQPIr4K/GjGkPWh/Dq2id559RN+8gT1UdR2sZOZLWMnlvRve5msuxtERv5nVgVZ1C60f9TtqOdS433SQ4p6r6LK0F98t9uq/1QTMtVR8Adurb6WbPxh5hrm0+uNzLaDdB7U+7xPR3wBP6h3lcM08BmXnNTPsGYHW1u+Ovpd048s+56fmtBwKH9TrN1iLyb8DtaB/0E2mPORv0bNrVkXNoSeFLe73OoZ2cndfnfw/aPnE0rRvMlX1+D+7jn0Xr7/1h2j7xc9bcb8dWVf9L+zy8l3Zi911a0lC9ng/rw6Ht249M8pT+/m20/p0/T/ImWuvRoX0+59ESkLla+meeEHIV7TO4f1V9uQ97E22f+FKv///R7pyeaYl7E3BqX18zlyePp53UnDDL+/nmex7tEVj/SNuGP6S1sK+rX4Q9GLhv1rz8+J2h/fGNPZZv065wPIR23PwF7WTviVV1Qh+nerwracef1bSbDJ9YN+9mMFI/DpxCa02d8f6hmP5vlmlPqKqfjho2V91GzOc42v0l47qSdmKympseMfb8qjqZlnB9ZbiFcWBZq6tqZH3GMHOz6ryq6tJ+1WXUsAtox7G/oXXDOJ129W3k1ZyFxNyX+XjaZ/gi2n78VNpj3b7Tx7ma1uq5Z1/u92if3ZmThefQHjl4fFX9dOZFOyY9eOCYuBtrfq/8cpwY57AvraHnYNp2/V6vyzELiGksIz5fP+nL2r3vR6Om+Q3te2BwH5hrXxy2N+0K2E+G6vDvtL64o44zhzG6O9/7+/Hrp7Quk4ezsHuJ5vOvtBPtzfv+sittXzqF1l3mDcDLqurGBpZqXcNeRVsHl9KuhOzDmo/z23vomHBVWkPSz2n76UxO9Jlep3/r021Ea/D6GW1dPxTYc5yrY6O227h1GsPa1mekjD6h1oYk7cklZwK3Had1XtLCpN0A+DXgb6vqP+cee8OV5BDgq1V1yLRjWQzSfqDj88BTBk5WJS1C66rlRktM2rOLb5P2yJ830p6KYTIt3QJ6F689gW0zz53iG7hTaK1B4sYrEE+h/QaA39fSImYL9QYq7WeGf5/WR/Z42iPB5nzskSRJkm7OhFqSJEmagJeQJEmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakmSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNIGNpx2AtJhtueWWtXLlymmHIUlLyqmnnnppVa2YdhzS+mJCLc1h5cqVnHLKKdMOQ5KWlCQ/nHYM0vpklw9JkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkiZgQq0lK8k2Sb6c5OwkZyX5616+eZIvJPle/3uXXp4k70hybpIzkuwy3RpIkqTlwIRaS9l1wP5VdV/gIcCLkuwEHAAcV1U7AMf19wCPA3bor32Ad6//kCVJ0nJjQq0lq6ourKrT+v9XAmcDWwNPAg7rox0G/HH//0nAB6s5EdgsyVbrOWxJkrTMmFBrWUiyEngg8HXgblV1IbSkG7hrH21r4McDk63uZZIkSWvNX0rUkpdkU+BI4KVVdUWSWUcdUVYj5rcPrUsI22677boKc71aecAxU1nu+Qc9firLlSRpmmyh1pKW5Na0ZPrwqvpkL75opitH/3txL18NbDMw+T2BC4bnWVUHV9Wqqlq1YsWKWy54SZK0LJhQa8lKa4r+AHB2Vb11YNDRwN79/72BTw+UP6c/7eMhwOUzXUMkSZLWll0+tJQ9FHg28K0kp/eyVwIHAUckeT7wI2CvPuxYYE/gXOBq4HnrN1xJkrQcmVBryaqqrzK6XzTA7iPGL+BFt2hQkiRpg2OXD0mSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakmSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakmSJGkCJtRaspIckuTiJGcOlH0syen9dX6S03v5yiTXDAx7z/QilyRJy8nG0w5AmsChwDuBD84UVNXTZ/5P8hbg8oHxv19VO6+36CRJ0gbBhFpLVlWdkGTlqGFJAjwNeNT6jEmSJG147PKh5erhwEVV9b2Bsnsl+UaS45M8fFqBSZKk5cUWai1XzwQ+MvD+QmDbqrosye8Cn0pyv6q6YnjCJPsA+wBsu+226yVYSZK0dNlCrWUnycbAnwAfmymrqmur6rL+/6nA94HfHjV9VR1cVauqatWKFSvWR8iSJGkJM6HWcvRo4JyqWj1TkGRFklv1/7cHdgDOm1J8kiRpGTGh1pKV5CPA14Adk6xO8vw+6Bms2d0D4BHAGUm+CXwC2K+qfrb+opUkScuVfai1ZFXVM2cpf+6IsiOBI2/pmCRJ0obHFmpJkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJE/CmREnrzMoDjpnass8/6PFTW7YkacNmC7UkSZI0ARNqSZIkaQIm1JIkSdIETKglSZKkCZhQS5IkSRMwoZYkSZImYEItSZIkTcCEWpIkSZqACbUkSZI0ARNqSZIkaQIm1JIkSdIETKglSZKkCZhQa8lKckiSi5OcOVB2YJKfJDm9v/YcGPaKJOcm+U6SP5xO1JIkabkxodZSdiiwx4jyt1XVzv11LECSnYBnAPfr07wrya3WW6SSJGnZMqHWklVVJwA/G3P0JwEfraprq+oHwLnAg26x4CRJ0gbDhFrL0YuTnNG7hNyll20N/HhgnNW97GaS7JPklCSnXHLJJbd0rJIkaYkzodZy827g3sDOwIXAW3p5Roxbo2ZQVQdX1aqqWrVixYpbJkpJkrRsmFBrWamqi6rq+qq6AXgfN3XrWA1sMzDqPYEL1nd8kiRp+TGh1rKSZKuBt08GZp4AcjTwjCS3TXIvYAfgpPUdnyRJWn42nnYA0tpK8hFgV2DLJKuB1wK7JtmZ1p3jfGBfgKo6K8kRwLeB64AXVdX104hbkiQtLybUWrKq6pkjij8wx/ivB15/y0UkSZI2RHb5kCRJkiZgQi1JkiRNwIRakiRJmoAJtSRJkjQBE2pJkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkiZgQi1JkiRNwIRakiRJmoAJtSRJkjQBE2pJkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkiZgQq1FIcn912KaQ5JcnOTMgbJ/TXJOkjOSHJVks16+Msk1SU7vr/esy/glSdKGy4Rai8V7kpyU5IUzSfAYDgX2GCr7AnD/qvod4LvAKwaGfb+qdu6v/SYPWZIkyYRai0RVPQx4FrANcEqSDyd5zDzTnAD8bKjs81V1XX97InDPWyJeSZKkGSbUWjSq6nvAq4G/Bx4JvKN33/iTtZzlnwOfHXh/ryTfSHJ8kofPNlGSfZKckuSUSy65ZC0XLUmSNhQm1FoUkvxOkrcBZwOPAp5YVfft/79tLeb3KuA64PBedCGwbVU9EHgZ8OEkdxo1bVUdXFWrqmrVihUr1qI2kiRpQ7LxtAOQuncC7wNeWVXXzBRW1QVJXr2QGSXZG3gCsHtVVZ/PtcC1/f9Tk3wf+G3glHUUvyRJ2kCZUGux2BO4pqquB0hogAHiAAAR2UlEQVSyEbBJVV1dVR8adyZJ9qB3GamqqwfKVwA/q6rrk2wP7ACct05rIEmSNkh2+dBi8UXgdgPvb9/LZpXkI8DXgB2TrE7yfFpL9x2BLww9Hu8RwBlJvgl8Ativqn42csaSJEkLYAu1FotNquqqmTdVdVWS2881QVU9c0TxB2YZ90jgyMlClCRJujlbqLVY/DLJLjNvkvwucM0c40uSJC0KtlBrsXgp8PEkF/T3WwFPn2I8kiRJYzGh1qJQVScnuQ+wIxDgnKr6zZTDkiRJmpcJtRaT3wNW0vbLByahqj443ZAkSZLmZkKtRSHJh4B7A6cD1/fiAkyoJUnSomZCrcViFbDTzA+xSJIkLRUm1FoszgTuTvuJ8GVj5QHHTDsESZJ0CzOh1mKxJfDtJCfRfyIcoKr+aHohSZIkzc+EWovFgdMOQJIkaW2YUGtRqKrjk2wH7FBVX+y/kniracclSZI0H38pUYtCkr8APgG8txdtDXxqehFJkiSNx4Rai8WLgIcCVwBU1feAu041IkmSpDGYUGuxuLaqfj3zJsnGtOdQS5IkLWom1Fosjk/ySuB2SR4DfBz4zJRjkiRJmpcJtRaLA4BLgG8B+wLHAq+eakSSJElj8CkfWhSq6gbgff0lSZK0ZJhQa1FI8gNG9Jmuqu2nEI4kSdLYTKi1WKwa+H8TYC9g8/kmSnII8ATg4qq6fy/bHPgYsBI4H3haVf08SYC3A3sCVwPPrarT1mEdJEnSBsg+1FoUquqygddPqurfgEeNMemhwB5DZQcAx1XVDsBx/T3A44Ad+msf4N3rJHhJkrRBs4Vai0KSXQbebkRrsb7jfNNV1QlJVg4VPwnYtf9/GPAV4O97+QerqoATk2yWZKuqunCi4CVJ0gbNhFqLxVsG/r+O3lVjLed1t5kkuaouTDLzAzFbAz8eGG91L1sjoU6yD60Fm2233XYtQ5AkSRsKE2otClW123pYTEYtekQsBwMHA6xatcofl5EkSXMyodaikORlcw2vqrcuYHYXzXTlSLIVcHEvXw1sMzDePYELFhapJEnSmrwpUYvFKuAvaV0wtgb2A3ai9aOety/1kKOBvfv/ewOfHih/TpqHAJfbf1qSJE3KFmotFlsCu1TVlQBJDgQ+XlUvmGuiJB+h3YC4ZZLVwGuBg4Ajkjwf+BHtEXzQfn1xT+Bc2mPznrfuqyFJkjY0JtRaLLYFfj3w/te050jPqaqeOcug3UeMW8CL1iY4SZKk2ZhQa7H4EHBSkqNoNwo+GfjgdEOSJEmanwm1FoWqen2SzwIP70XPq6pvTDMmSZKkcXhTohaT2wNXVNXbgdVJ7jXtgCRJkuZjQq1FIclrab9m+IpedGvgP6cXkSRJ0nhMqLVYPBn4I+CXAFV1AQt/XJ4kSdJ6Z0KtxeLX/SkcBZDkDlOOR5IkaSwm1FosjkjyXmCzJH8BfBF435RjkiRJmpdP+dCiUFVvTvIY4ApgR+A1VfWFKYelJWTlAcdMZbnnH/T4qSxXkrR4mFBr6pLcCvjvqno0YBItSZKWFLt8aOqq6nrg6iR3nnYskiRJC2ULtRaLXwHfSvIF+pM+AKrqJdMLSZIkaX4m1FosjukvSZKkJcWEWlOVZNuq+lFVHTbtWCRJktaGfag1bZ+a+SfJkdMMRJIkaW2YUGvaMvD/9lOLQpIkaS2ZUGvaapb/JUmSlgT7UGvaHpDkClpL9e36//T3VVV3ml5okiRJ8zOh1lRV1a3W9TyT7Ah8bKBoe+A1wGbAXwCX9PJXVtWx63r5kiRpw2JCrWWnqr4D7Aw3/grjT4CjgOcBb6uqN08xPEmStMzYh1rL3e7A96vqh9MORJIkLU8m1FrungF8ZOD9i5OckeSQJHcZNUGSfZKckuSUSy65ZNQokiRJNzKh1rKV5DbAHwEf70XvBu5N6w5yIfCWUdNV1cFVtaqqVq1YsWK9xCpJkpYuE2otZ48DTquqiwCq6qKqur6qbgDeBzxoqtFJkqRlwYRay9kzGejukWSrgWFPBs5c7xFJkqRlx6d8aFlKcnvgMcC+A8VvSrIz7Qdkzh8aJkmStFZMqLUsVdXVwBZDZc+eUjiSJGkZs8uHJEmSNAETakmSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakmSJGkCJtSSJEnSBEyoJUmSpAmYUEuSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNIGNpx2AdEtJcj5wJXA9cF1VrUqyOfAxYCVwPvC0qvr5tGLU0rfygGOmtuzzD3r81JYtSbqJLdRa7narqp2ralV/fwBwXFXtABzX30uSJK01E2ptaJ4EHNb/Pwz44ynGIkmSlgETai1nBXw+yalJ9ulld6uqCwH637sOT5RknySnJDnlkksuWY/hSpKkpcg+1FrOHlpVFyS5K/CFJOeMM1FVHQwcDLBq1aq6JQOUJElLny3UWraq6oL+92LgKOBBwEVJtgLofy+eXoSSJGk5MKHWspTkDknuOPM/8FjgTOBoYO8+2t7Ap6cToSRJWi7s8qHl6m7AUUmg7ecfrqrPJTkZOCLJ84EfAXtNMUZJkrQMmFBrWaqq84AHjCi/DNh9/UckSZKWK7t8SJIkSRMwoZYkSZImYEItSZIkTcCEWpIkSZqACbUkSZI0ARNqSZIkaQIm1JIkSdIETKglSZKkCZhQS5IkSRMwoZYkSZImYEItSZIkTcCEWpIkSZqACbUkSZI0ARNqSZIkaQIm1JIkSdIETKglSZKkCWw87QAkSWtn5QHHTGW55x/0+KksV5IWK1uotewk2SbJl5OcneSsJH/dyw9M8pMkp/fXntOOVZIkLX22UGs5ug7Yv6pOS3JH4NQkX+jD3lZVb55ibJIkaZkxodayU1UXAhf2/69Mcjaw9XSjkiRJy5VdPrSsJVkJPBD4ei96cZIzkhyS5C6zTLNPklOSnHLJJZesp0glSdJSZUKtZSvJpsCRwEur6grg3cC9gZ1pLdhvGTVdVR1cVauqatWKFSvWW7ySJGlpMqHWspTk1rRk+vCq+iRAVV1UVddX1Q3A+4AHTTNGSZK0PJhQa9lJEuADwNlV9daB8q0GRnsycOb6jk2SJC0/3pSo5eihwLOBbyU5vZe9Enhmkp2BAs4H9p1OeJIkaTkxodayU1VfBTJi0LHrOxZJkrT82eVDkiRJmoAJtSRJkjQBE2pJkiRpAibUkiRJ0gRMqCVJkqQJmFBLkiRJEzChliRJkibgc6glSQuy8oBjprbs8w96/NSWLUmzsYVakiRJmoAt1JKkJWNareO2jEuaiy3UkiRJ0gRMqCVJkqQJmFBLkiRJE7APtSRJ8/DJJpLmYgu1JEmSNAETakmSJGkCJtTa4CTZI8l3kpyb5IBpxyNJkpY2+1Brg5LkVsC/A48BVgMnJzm6qr493cgkaTSfvS0tfrZQa0PzIODcqjqvqn4NfBR40pRjkiRJS5gJtTY0WwM/Hni/updJkiStFbt8aEOTEWW1xgjJPsA+/e1VSb4zwfK2BC6dYPqlwDouD9ZxeVhndcwbJ5p8u3URg7RUmFBrQ7Ma2Gbg/T2BCwZHqKqDgYPXxcKSnFJVq9bFvBYr67g8WMflYUOoo7QY2eVDG5qTgR2S3CvJbYBnAEdPOSZJkrSE2UKtDUpVXZfkxcB/A7cCDqmqs6YcliRJWsJMqLXBqapjgWPX0+LWSdeRRc46Lg/WcXnYEOooLTqpqvnHkiRJkjSSfaglSZKkCZhQS7eA5frz5knOT/KtJKcnOaWXbZ7kC0m+1//eZdpxLkSSQ5JcnOTMgbKRdUrzjr5dz0iyy/QiH98sdTwwyU/6tjw9yZ4Dw17R6/idJH84nagXJsk2Sb6c5OwkZyX5616+bLblHHVcVttSWopMqKV1bODnzR8H7AQ8M8lO041qndqtqnYeeDTXAcBxVbUDcFx/v5QcCuwxVDZbnR4H7NBf+wDvXk8xTupQbl5HgLf1bblzv7eAvq8+A7hfn+ZdfZ9e7K4D9q+q+wIPAV7U67KctuVsdYTltS2lJceEWlr3NrSfN38ScFj//zDgj6cYy4JV1QnAz4aKZ6vTk4APVnMisFmSrdZPpGtvljrO5knAR6vq2qr6AXAubZ9e1Krqwqo6rf9/JXA27VdQl822nKOOs1mS21JaikyopXVvOf+8eQGfT3Jq/0VJgLtV1YXQvvCBu04tunVntjott2374t7d4ZCBrjpLvo5JVgIPBL7OMt2WQ3WEZbotpaXChFpa9+b9efMl7KFVtQvtcvmLkjxi2gGtZ8tp274buDewM3Ah8JZevqTrmGRT4EjgpVV1xVyjjihbEvUcUcdluS2lpcSEWlr35v1586Wqqi7ofy8GjqJdPr5o5lJ5/3vx9CJcZ2ar07LZtlV1UVVdX1U3AO/jpq4AS7aOSW5NSzQPr6pP9uJltS1H1XE5bktpqTGhlta9Zfnz5knukOSOM/8DjwXOpNVt7z7a3sCnpxPhOjVbnY4GntOfEPEQ4PKZ7gRLzVB/4SfTtiW0Oj4jyW2T3It2095J6zu+hUoS4APA2VX11oFBy2ZbzlbH5bYtpaXIX0qU1rFl/PPmdwOOat/pbAx8uKo+l+Rk4Igkzwd+BOw1xRgXLMlHgF2BLZOsBl4LHMToOh0L7Em7uetq4HnrPeC1MEsdd02yM60LwPnAvgBVdVaSI4Bv054q8aKqun4acS/QQ4FnA99KcnoveyXLa1vOVsdnLrNtKS05/lKiJEmSNAG7fEiSJEkTMKGWJEmSJmBCLUmSJE3AhFqSJEmagAm1JEmSNAETakkaIclVt/D8n5vkHgPvz0+y5TpexkuSnJ3k8IGyP0xyen9dleQ7/f8PrsX8d0myx7qMWZKWIp9DLUnT8VzaD3Dckr9c90LgcVX1g5mCqvpv2jPSSfIV4OVVdcpazn8X4P7A5yaMU5KWNFuoJWlMSVYkOTLJyf310F5+YJJDknwlyXlJXjIwzT8kOSfJF5J8JMnLkzwVWAUc3luHb9dH/6skpyX5VpL79OkfOdCi/I2ZX6sciutlSc7sr5f2svcA2wNHJ/mbMeu3cZK3JjkpyRlJXtDL90oyk4RvneS7SbYDXgM8q8f21CSPSvLN/v60/ouakrTs2UItSeN7O/C2qvpqkm1pLb337cPuA+wG3BH4TpJ3Aw8AngI8kHa8PQ04tao+0X9N88bW4f4LlJdW1S5JXgi8HHhB//uiqvrfJJsCvxoMKMnv0n7l78FAgK8nOb6q9uvdMXarqkvHrN8+wMVV9aAktwVOTPL5qvp4kqck2Q94EvCqqvphktcB96+qmST+s8A+VfX1UbFK0nJlQi1J43s0sFNPfgHuNNBifExVXQtcm+Ri2k+1Pwz4dFVdA5DkM/PM/5P976nAn/T//xd4a+8H/cmqWj00zcOAo6rql30ZnwQeDnxjLer3WOC+SZ7R398Z2IH2k90vonVROaGqPj7L9P8L/FuSDwNHVtUt2g9dkhYLE2pJGt9GwO/PJMgzeoJ97UDR9bTja1iYmXnMTE9VHZTkGGBPWovxo6vqnMHFL3AZcwnwwqo6bsSwe/a47p4kVVXDI1TVPyc5Gng8cHKSXavqe+swPklalOxDLUnj+zzw4pk3SXaeZ/yvAk9MsknvAvH4gWFX0rqHzCnJvavqW1X1RuAUWteSQScAf5zk9r3P8pOB/5m/KiP9N/DCJBv3Ze+Y5HZJbg0cAjwNOA/461F16LGeUVVvoLWQ77iWcUjSkmILtSSNdvskg90r3gq8BPj3JGfQjp8nAPvNNoOqOrm32H4T+CEtIb68Dz4UeE+Sa4DfnyOOlybZjdY6/G3gs0PLOC3JocBJvej9VbU23T0A3gtsC5zeW90vpvWZfgVwXFX9X5KzgJOSHAt8CfjbJN8AXg/snuThwA3AGbQTEEla9jLiqp0kaR1JsmlVXZXk9rQEfJ+qOm3acUmS1h1bqCXplnVwkp2ATYDDTKYlafmxhVqSJEmagDclSpIkSRMwoZYkSZImYEItSZIkTcCEWpIkSZqACbUkSZI0ARNqSZIkaQL/PwLC9zbwDfF0AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Histogram of length of extracted texts between two key words\n",
    "length_of_extracted_txts = [] # container that holds all strings' lengths\n",
    "\n",
    "for file_name in all_jobs:\n",
    "     # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Use index, not find as a last-ditched attempt to catch any error\n",
    "    txt      = job[job.index('REQUIREMENTS/MINIMUM QUALIFICATIONS'):job.index('PROCESS NOTES')]\n",
    "    # Simplify txt a little bit\n",
    "    txt      = (txt.replace('\\n', ' ')\n",
    "                   .replace(';', ' ')\n",
    "                   .replace(',', ' ')\n",
    "                   .replace('.', ' ')\n",
    "                   .replace(')', ' ')\n",
    "                   .replace('*', ' ')).split()\n",
    "    # Append length to the list\n",
    "    length_of_extracted_txts.append(len(txt))\n",
    "\n",
    "# Verify if length of the list is still 682\n",
    "print(len(length_of_extracted_txts))\n",
    "\n",
    "plt.hist(length_of_extracted_txts)\n",
    "plt.suptitle('Distributions of Lengths of Extracted Texts' + \n",
    "             ' Between REQUIREMENTS/MINIMUM QUALIFICATIONS AND PROCESS NOTES')\n",
    "plt.xlabel('Lengths of Texts')\n",
    "plt.ylabel('Frequency')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "While fixing files, I realized that some of the jobs have the following mess-up order: REQUIREMENTS/MINIMUM QUALIFICATIONS, SELECTIVE CERTIFICATION/WHERE TO APPLY, PROCESS NOTES. Thus, we can use this as a final check for the quality of our data by catching the jobs that have the word, SELECTIVE or WHERE, in the *extracted* text."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Identify the trouble makers, Round 2.**\n",
    "\n",
    "Save the printouts to a word file called, *TroubleMakers_Type3_2*."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Re-catch jobs with sections' order messing up: these jobs will have the word \n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Print out jobs that have more SELECTIVE or WHERE in the extracted text\n",
    "    txt      = job[job.index('REQUIREMENTS/MINIMUM QUALIFICATIONS'):job.index('PROCESS NOTES')]\n",
    "    txt      = (txt.replace('\\n', ' ')\n",
    "                   .replace(';', ' ')\n",
    "                   .replace(',', ' ')\n",
    "                   .replace('.', ' ')\n",
    "                   .replace(')', ' ') # add '(' and ':' if wish\n",
    "                   .replace('*', ' ')).split()\n",
    "    if ('SELECTIVE' in txt) or ('WHERE' in txt):\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Here's the final culprit found:\n",
    "* CHIEF STREET SERVICES INVESTIGATOR 4286 2017Revised 11.21.txt"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 4. Normalize itemizers\n",
    "\n",
    "Some jobs, such as ACCOUNTING RECORDS SUPERVISOR 1119 072718.txt, don't have an itemizer in the front. We wish to look at them and manually add itemizers, such as 1."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Identify the trouble makers, Round 1.**\n",
    "\n",
    "Save the printouts to a word file called, *TroubleMakers_Type4_1*."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/JobBulletins_cleaned/311 DIRECTOR  9206 041814.txt\n",
      "CityofLA/JobBulletins_cleaned/ACCOUNTANT 1513 062218.txt\n",
      "CityofLA/JobBulletins_cleaned/ACCOUNTING CLERK 1223 071318.txt\n",
      "CityofLA/JobBulletins_cleaned/ACCOUNTING RECORDS SUPERVISOR 1119 072718.txt\n",
      "CityofLA/JobBulletins_cleaned/ADMINISTRATIVE ANALYST 1590 060118.txt\n",
      "CityofLA/JobBulletins_cleaned/ADMINISTRATIVE CLERK 1358 033018 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/ADMINISTRATIVE HEARING EXAMINER 9135 100915.txt\n",
      "CityofLA/JobBulletins_cleaned/ADVANCE PRACTICE PROVIDER CORRECTIONAL CARE 2325 020808 REV 111214.txt\n",
      "CityofLA/JobBulletins_cleaned/AIR CONDITIONING MECHANIC 3774 041417.txt\n",
      "CityofLA/JobBulletins_cleaned/AIR CONDITIONING MECHANIC SUPERVISOR 3781 111618 2.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT AIDE 1540 081018.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT CHIEF INFORMATION SECURITY OFFICER 1404 120415_Modified.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT ENGINEER 7256 070618.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT GUIDE 0845 042018.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT INFORMATION SPECIALIST 1783 121115.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT LABOR RELATIONS ADVOCATE 9210 020119.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT MANAGER 7260 120216.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT POLICE CAPTAIN 3228 021618.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT POLICE LIEUTENANT 3227 091616.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT POLICE OFFICER 3225 110906 Rev 060115.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT POLICE SPECIALIST 3236 063017 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT SUPERINTENDENT OF OPERATIONS 7268 121815 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORTS MAINTENANCE SUPERINTENDENT 3331 021518.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORTS MAINTENANCE SUPERVISOR 3336 111618.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORTS PUBLIC AND COMMUNITY RELATIONS DIRECTOR 1788 120817.txt\n",
      "CityofLA/JobBulletins_cleaned/ANIMAL CARE ASSISTANT 4323 020119.txt\n",
      "CityofLA/JobBulletins_cleaned/ANIMAL CARE TECHNICIAN 4310 040116 REV 041416.txt\n",
      "CityofLA/JobBulletins_cleaned/ANIMAL CARE TECHNICIAN SUPERVISOR 4313 122118.txt\n",
      "CityofLA/JobBulletins_cleaned/ANIMAL CONTROL OFFICER  4311 061518.txt\n",
      "CityofLA/JobBulletins_cleaned/ANIMAL KEEPER 4304 083118.txt\n",
      "CityofLA/JobBulletins_cleaned/APPARATUS OPERATOR 2121 071417 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/APPLICATIONS PROGRAMMER 1429 062918.txt\n",
      "CityofLA/JobBulletins_cleaned/APPRENTICE - METAL TRADES 3789 070816.txt\n",
      "CityofLA/JobBulletins_cleaned/APPRENTICE MACHINIST 3764 071516.txt\n",
      "CityofLA/JobBulletins_cleaned/AQUARIST 2400 050214.txt\n",
      "CityofLA/JobBulletins_cleaned/AQUARIUM EDUCATOR 2493 010816.txt\n",
      "CityofLA/JobBulletins_cleaned/AQUATIC DIRECTOR 2419  082517 REV 0090717.txt\n",
      "CityofLA/JobBulletins_cleaned/AQUATIC FACILITY MANAGER 2423 052915 REVISED 060915.txt\n"
     ]
    },
    {
     "ename": "IndexError",
     "evalue": "string index out of range",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mIndexError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-26-7836534fd9fe>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m     13\u001b[0m     \u001b[0;31m# Print out jobs that don't have itemizers in the requirement section\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     14\u001b[0m     \u001b[0mtxt\u001b[0m      \u001b[0;34m=\u001b[0m \u001b[0mjob\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mjob\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'REQUIREMENTS/MINIMUM QUALIFICATIONS'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0mjob\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'PROCESS NOTES'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 15\u001b[0;31m     \u001b[0mdigits_as_str\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0msentence\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0msentence\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mtxt\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'.'\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0msentence\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0misdigit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     16\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mu\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;36m0\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     17\u001b[0m         \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mjob_path\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-26-7836534fd9fe>\u001b[0m in \u001b[0;36m<listcomp>\u001b[0;34m(.0)\u001b[0m\n\u001b[1;32m     13\u001b[0m     \u001b[0;31m# Print out jobs that don't have itemizers in the requirement section\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     14\u001b[0m     \u001b[0mtxt\u001b[0m      \u001b[0;34m=\u001b[0m \u001b[0mjob\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mjob\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'REQUIREMENTS/MINIMUM QUALIFICATIONS'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0mjob\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'PROCESS NOTES'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 15\u001b[0;31m     \u001b[0mdigits_as_str\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0msentence\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0msentence\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mtxt\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'.'\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mif\u001b[0m \u001b[0msentence\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0misdigit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     16\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mu\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;36m0\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     17\u001b[0m         \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mjob_path\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mIndexError\u001b[0m: string index out of range"
     ]
    }
   ],
   "source": [
    "# Define path to look at\n",
    "path = 'CityofLA/JobBulletins_cleaned/'\n",
    "\n",
    "# Get a list of all txt files in this path\n",
    "all_jobs = os.listdir(path)\n",
    "all_jobs.sort() # WARNING: this mutates the list\n",
    "\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    # Print out jobs that don't have itemizers in the requirement section\n",
    "    txt      = job[job.index('REQUIREMENTS/MINIMUM QUALIFICATIONS'):job.index('PROCESS NOTES')]\n",
    "    digits_as_str = [sentence[-1] for sentence in txt.split('.') if sentence[-1].isdigit()]\n",
    "    if len(u) == 0:\n",
    "        print(job_path)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Oops, the above code yields error <font color='red'>IndexError </font>, so let's switch to try/except."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/JobBulletins_cleaned/ACCOUNTANT 1513 062218.txt\n",
      "CityofLA/JobBulletins_cleaned/ACCOUNTING CLERK 1223 071318.txt\n",
      "CityofLA/JobBulletins_cleaned/ACCOUNTING RECORDS SUPERVISOR 1119 072718.txt\n",
      "CityofLA/JobBulletins_cleaned/ADMINISTRATIVE CLERK 1358 033018 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/AIR CONDITIONING MECHANIC SUPERVISOR 3781 111618 2.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT AIDE 1540 081018.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT GUIDE 0845 042018.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT POLICE CAPTAIN 3228 021618.txt\n",
      "CityofLA/JobBulletins_cleaned/AIRPORT POLICE LIEUTENANT 3227 091616.txt\n",
      "CityofLA/JobBulletins_cleaned/ANIMAL CARE TECHNICIAN SUPERVISOR 4313 122118.txt\n",
      "CityofLA/JobBulletins_cleaned/AQUATIC FACILITY MANAGER 2423 052915 REVISED 060915.txt\n",
      "##########################################################\n",
      "CityofLA/JobBulletins_cleaned/AQUEDUCT AND RESERVOIR KEEPER 5813 063017 (1).txt\n",
      "##########################################################\n",
      "CityofLA/JobBulletins_cleaned/AQUEDUCT AND RESERVOIR SUPERVISOR 5816 091115.txt\n",
      "CityofLA/JobBulletins_cleaned/ASBESTOS SUPERVISOR 3440 012916.txt\n",
      "CityofLA/JobBulletins_cleaned/ASSISTANT DIRECTOR INFORMATION SYSTEMS 9377 030218.txt\n",
      "CityofLA/JobBulletins_cleaned/ASSISTANT STREET LIGHTING ELECTRICIAN 3809 072117 REV 080818.txt\n",
      "CityofLA/JobBulletins_cleaned/AUTO BODY REPAIR SUPERVISOR 3706 051515.txt\n",
      "CityofLA/JobBulletins_cleaned/AUTOMOTIVE DISPATCHER 3595 102017 revised.txt\n",
      "CityofLA/JobBulletins_cleaned/AUTOMOTIVE SUPERVISOR 3714 062416.txt\n",
      "CityofLA/JobBulletins_cleaned/BENEFITS SPECIALIST 1203 011918.txt\n",
      "CityofLA/JobBulletins_cleaned/BUILDING CIVIL ENGINEER 7244 032318.txt\n",
      "CityofLA/JobBulletins_cleaned/BUILDING CONSTRUCTION AND MAINTENANCE SUPERINTENDENT 3124 122818.txt\n",
      "CityofLA/JobBulletins_cleaned/BUILDING OPERATING ENGINEER 5923 111618 REV 112818.txt\n",
      "CityofLA/JobBulletins_cleaned/BUILDING REPAIR SUPERVISOR 3338 111816.txt\n",
      "CityofLA/JobBulletins_cleaned/BUILDING REPAIRER 3333 030218.txt\n",
      "CityofLA/JobBulletins_cleaned/CARPENTER SUPERVISOR 3346 051316.txt\n",
      "CityofLA/JobBulletins_cleaned/CEMENT FINISHER SUPERVISOR 3354 120916.txt\n",
      "CityofLA/JobBulletins_cleaned/CHEMIST  7833 102017.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF BUILDING OPERATING ENGINEER 5927 080516.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF CLERK 1253 012017.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF CLERK PERSONNEL 1260 042117.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF CLERK POLICE 1219 061215.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF CLERK POLICE 1249 083118.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF CONSTRUCTION INSPECTOR 7296 122818.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF ELECTRIC PLANT OPERATOR 5237 121115.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF ENVIRONMENTAL COMPLIANCE INSPECTOR 4289 033018.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF HARBOR ENGINEER 9286 112015.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF MANAGEMENT ANALYST 9182 020918.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF OF DRAFTING OPERATIONS 7271  042018.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF PARK RANGER 1968 120106 REV 121306.txt\n",
      "CityofLA/JobBulletins_cleaned/CHIEF TRANSPORTATION INVESTIGATOR 4275 103114.txt\n",
      "CityofLA/JobBulletins_cleaned/CIVIL ENGINEER 7237 020918.txt\n",
      "CityofLA/JobBulletins_cleaned/CLAIMS AGENT 1767 020317.txt\n",
      "CityofLA/JobBulletins_cleaned/COMMERCIAL SERVICE SUPERVISOR  1213 061617.txt\n",
      "CityofLA/JobBulletins_cleaned/COMMISSION EXECUTIVE ASSISTANT 9734 092118.txt\n",
      "CityofLA/JobBulletins_cleaned/COMMUNICATIONS CABLE SUPERVISOR 3800 051917 REVISED 060117.txt\n",
      "CityofLA/JobBulletins_cleaned/COMMUNICATIONS CABLE WORKER 3802 11816.txt\n",
      "CityofLA/JobBulletins_cleaned/COMMUNITY HOUSING PROGRAMS MANAGER 8500 072018 REV 080918 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/CONSTRUCTION AND MAINTENANCE SUPERINTENDENT 3129 082616 REV 090816.txt\n",
      "CityofLA/JobBulletins_cleaned/CRIMINALIST 2234 030918.txt\n",
      "##########################################################\n",
      "CityofLA/JobBulletins_cleaned/CUSTODIAL SERVICES ASSISTANT 3149 012017.txt\n",
      "##########################################################\n",
      "CityofLA/JobBulletins_cleaned/CUSTOMER SERVICE REPRESENTATIVE 1230 020918.txt\n",
      "CityofLA/JobBulletins_cleaned/DECK HAND 5131 093016.txt\n",
      "CityofLA/JobBulletins_cleaned/DEPARTMENTAL CHIEF ACCOUNTANT 1593 111717 revised 11.21.txt\n",
      "CityofLA/JobBulletins_cleaned/DIRECTOR OF HOUSING 1568 062317.txt\n",
      "CityofLA/JobBulletins_cleaned/DIRECTOR OF MAINTENANCE AIRPORTS 7270 041516.txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRIC DISTRIBUTION MECHANIC SUPERVISOR 3873 102816.txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRIC SERVICE REPRESENTATIVE 020317.txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRIC TROUBLE DISPATCHER 3828 063017 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRICAL MECHANIC SUPERVISOR 3835 072216 REVISED 080416.txt\n",
      "CityofLA/JobBulletins_cleaned/ELECTRICAL REPAIR SUPERVISOR 3855 092217 (7).txt\n",
      "CityofLA/JobBulletins_cleaned/ELEVATOR MECHANIC 3866 012717 REV 080718.txt\n",
      "CityofLA/JobBulletins_cleaned/ENGINEERING DESIGNER 7217 082517 REV 090717.txt\n",
      "CityofLA/JobBulletins_cleaned/ENGINEERING GEOLOGIST 7255 022318.txt\n",
      "CityofLA/JobBulletins_cleaned/ENGINEERING GEOLOGIST ASSOCIATE 7253 082517.txt\n",
      "CityofLA/JobBulletins_cleaned/ENVIRONMENTAL ENGINEER  7872 082616 REV 090116.txt\n",
      "CityofLA/JobBulletins_cleaned/EQUIPMENT REPAIR SUPERVISOR 3746 012717.txt\n",
      "CityofLA/JobBulletins_cleaned/EQUIPMENT SUPERINTENDENT 3750 121914.txt\n",
      "CityofLA/JobBulletins_cleaned/EQUIPMENT SUPERVISOR 3527 041318.txt\n",
      "CityofLA/JobBulletins_cleaned/EXAMINER OF QUESTIONED DOCUMENTS 3229 120415.txt\n",
      "CityofLA/JobBulletins_cleaned/EXECUTIVE ADMINISTRATIVE ASSISTANT 1117 083118.txt\n",
      "CityofLA/JobBulletins_cleaned/EXECUTIVE ASSISTANT AIRPORTS 9186 060917 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/EXHIBIT PREPARATOR 2444 062416.txt\n",
      "CityofLA/JobBulletins_cleaned/GALLERY ATTENDANT 2442 092515.txt\n",
      "CityofLA/JobBulletins_cleaned/GARAGE ATTENDANT 3531 013015.txt\n",
      "CityofLA/JobBulletins_cleaned/GENERAL AUTOMOTIVE SUPERVISOR 3718 061915.txt\n",
      "CityofLA/JobBulletins_cleaned/GENERAL SERVICES MANAGER  9601 042117.txt\n",
      "CityofLA/JobBulletins_cleaned/GEOGRAPHIC INFORMATION SYSTEMS CHIEF  7211 030416.txt\n",
      "CityofLA/JobBulletins_cleaned/GOLF STARTER SUPERVISOR 2479 120817.txt\n",
      "CityofLA/JobBulletins_cleaned/GRAPHICS SUPERVISOR 7935 052617 (4).txt\n",
      "CityofLA/JobBulletins_cleaned/HEATING AND REFRIGERATION INSPECTOR 4245 121115.txt\n",
      "CityofLA/JobBulletins_cleaned/HELICOPTER MECHANIC SUPERVISOR 3749 121616 REV 122216.txt\n",
      "CityofLA/JobBulletins_cleaned/HYDROGRAPHER 7263 012717.txt\n",
      "CityofLA/JobBulletins_cleaned/INDUSTRIAL CHEMIST 7834 020714.txt\n",
      "CityofLA/JobBulletins_cleaned/INFORMATION SYSTEMS MANAGER 1409 090117 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/INSTRUMENT MECHANIC SUPERVISOR 3844 051917 final.txt\n",
      "CityofLA/JobBulletins_cleaned/INTERNAL AUDITOR 1625 011918.txt\n",
      "CityofLA/JobBulletins_cleaned/LANDSCAPE ARCHITECT 7929 090718.txt\n",
      "CityofLA/JobBulletins_cleaned/LEGISLATIVE ASSISTANT 1182 091815.txt\n",
      "CityofLA/JobBulletins_cleaned/LIBRARIAN 6152 051217 REV 020218.txt\n",
      "CityofLA/JobBulletins_cleaned/LIBRARY ASSISTANT 1172 051118 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/LINE MAINTENANCE ASSISTANT 3882 122818.txt\n",
      "CityofLA/JobBulletins_cleaned/MACHINIST SUPERVISOR 3766 121815.txt\n",
      "CityofLA/JobBulletins_cleaned/MANAGEMENT ASSISTANT 1539 032318.txt\n",
      "CityofLA/JobBulletins_cleaned/MARINE ENVIRONMENTAL MANAGER 9437 060614.txt\n",
      "CityofLA/JobBulletins_cleaned/MATERIALS TESTING TECHNICIAN 7968 081318.txt\n",
      "CityofLA/JobBulletins_cleaned/MECHANICAL REPAIR GENERAL SUPERVISOR 3731 040116 REV 041416.txt\n",
      "CityofLA/JobBulletins_cleaned/MECHANICAL REPAIR SUPERVISOR 3795 051818.txt\n",
      "CityofLA/JobBulletins_cleaned/MECHANICAL REPAIRER 3773 092118.txt\n",
      "CityofLA/JobBulletins_cleaned/METER READER 1611 080715.txt\n",
      "CityofLA/JobBulletins_cleaned/OFFICE ENGINEERING TECHNICIAN 7212 110218.txt\n",
      "CityofLA/JobBulletins_cleaned/PAINTER SUPERVISOR 3426 120514.txt\n",
      "CityofLA/JobBulletins_cleaned/PARK SERVICES ATTENDANT 2412 032219.txt\n",
      "CityofLA/JobBulletins_cleaned/PARK SERVICES SUPERVISOR 2426 072018.txt\n",
      "CityofLA/JobBulletins_cleaned/PARKING METER TECHNICIAN 3738 110615 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/PARKING METER TECHNICIAN SUPERVISOR 3757 2017.txt\n",
      "CityofLA/JobBulletins_cleaned/PAYROLL SUPERVISOR 1170 102618.txt\n",
      "CityofLA/JobBulletins_cleaned/PERSONNEL DIRECTOR 1714 050418.txt\n",
      "CityofLA/JobBulletins_cleaned/PERSONNEL RECORDS SUPERVISOR 1129 041318.txt\n",
      "CityofLA/JobBulletins_cleaned/PHOTOGRAPHER 1793 041516.txt\n",
      "CityofLA/JobBulletins_cleaned/PILE DRIVER WORKER 3553 041417.txt\n",
      "CityofLA/JobBulletins_cleaned/PIPEFITTER SUPERVISOR 3438 081216.txt\n",
      "CityofLA/JobBulletins_cleaned/POLICE PERFORMANCE AUDITOR 1627 120216.txt\n",
      "CityofLA/JobBulletins_cleaned/PORT ELECTRICAL MECHANIC SUPERVISOR 3759 031816.txt\n",
      "CityofLA/JobBulletins_cleaned/PORT POLICE CAPTAIN 3224 110416.txt\n",
      "CityofLA/JobBulletins_cleaned/PORT POLICE LIEUTENANT 3223 120916.txt\n",
      "CityofLA/JobBulletins_cleaned/PORT POLICE SERGEANT 3222 121616.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL ACCOUNTANT 1525 121517.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL ANIMAL KEEPER 4312 070618.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL CIVIL ENGINEER 9489 022318.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL CIVIL ENGINEERING DRAFTING TECHNICIAN 7219 110218.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL CLERK 1201 021618.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL COMMUNICATIONS OPERATOR 1458 072514.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL CONSTRUCTION INSPECTOR 7297 021618.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL DETENTION OFFICER 3215 101218.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL ELECTRICAL ENGINEERING DRAFTING TECHNICIAN 7531 090916 TRACK CHANGES.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL INSPECTOR 4226 061617.txt\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CityofLA/JobBulletins_cleaned/PRINCIPAL MECHANICAL ENGINEERING DRAFTING TECHNICIAN 7550 081415.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL PROPERTY OFFICER 3210 121517.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL RECREATION SUPERVISOR 2464 021618.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL SECURITY OFFICER 3200 110218.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL STOREKEEPER 1839 072718.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL TAX AUDITOR 1524 110416.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL TAX COMPLIANCE OFFICER 1195 030218.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL UTILITY ACCOUNTANT 1589 030218 updated.txt\n",
      "CityofLA/JobBulletins_cleaned/PRINCIPAL WORKERS_ COMPENSATION ANALYST 1777 071814.txt\n",
      "CityofLA/JobBulletins_cleaned/PROCUREMENT SUPERVISOR 1852 050517.txt\n",
      "CityofLA/JobBulletins_cleaned/PROPERTY OFFICER 3207 071417 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/PUBLIC RELATIONS SPECIALIST 1785 012017.txt\n",
      "CityofLA/JobBulletins_cleaned/RATES MANAGER 5601 012017.txt\n",
      "CityofLA/JobBulletins_cleaned/RECREATION SUPERVISOR 2460 101416 REVISED 102716.txt\n",
      "CityofLA/JobBulletins_cleaned/REFUSE COLLECTION SUPERVISOR 4101 033117.txt\n",
      "CityofLA/JobBulletins_cleaned/REHABILITATION PROJECT COORDINATOR 8502 032715.txt\n",
      "CityofLA/JobBulletins_cleaned/REINFORCING STEEL WORKER 3483 022318.txt\n",
      "CityofLA/JobBulletins_cleaned/REPROGRAPHICS OPERATOR 3162 110615.txt\n",
      "CityofLA/JobBulletins_cleaned/REPROGRAPHICS SUPERVISOR  3163 091517.txt\n",
      "CityofLA/JobBulletins_cleaned/RISK AND INSURANCE ASSISTANT 1645 072718.txt\n",
      "CityofLA/JobBulletins_cleaned/SAFETY ENGINEER 1727 021717.txt\n",
      "CityofLA/JobBulletins_cleaned/SAFETY ENGINEER ELEVATORS 4263 112015 REV 120215.txt\n",
      "CityofLA/JobBulletins_cleaned/SECRETARY 1116 030317.txt\n",
      "CityofLA/JobBulletins_cleaned/SECRETARY LEGAL  1924 081718.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ACCOUNTANT 1523 030218.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ADMINISTRATIVE CLERK 1368 062918 REV 091718.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ANIMAL CONTROL OFFICER 4316 111618.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ANIMAL KEEPER 4305 022616.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ARCHITECTURAL DRAFTING TECHNICIAN 7208 091418.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR AUDITOR 1518 102618.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR AUTOMOTIVE SUPERVISOR 3716 112015.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR BUILDING INSPECTOR 4213 010816.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR BUILDING MECHANICAL INSPECTOR 4253 2017 REV (1).txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR CARPENTER  3345 081117 REV 082417.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR CHEMIST 7830 030416.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR CIVIL ENGINEERING DRAFTING TECHNICIAN 7207 081718.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR CLAIMS REPRESENTATIVE 1770 070717 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR COMMUNICATIONS CABLE WORKER 3801 102116 draft.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR COMMUNICATIONS ELECTRICIAN 3638 030317 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR COMMUNICATIONS ELECTRICIAN SUPERVISOR 3691 041318.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR COMMUNICATIONS OPERATOR 1467 122118.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR DATA PROCESSING TECHNICIAN 1139 081117.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR DETENTION OFFICER 3212 012017.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ELECTRIC SERVICE REPRESENTATIVE 7521 092917 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ELECTRIC TROUBLE DISPATCHER 3829 100716.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ELECTRICAL ENGINEERING DRAFTING TECHNICIAN 7209 042817 REV 051117.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ELECTRICAL MECHANIC SUPERVISOR 3836 080417.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ELECTRICAL REPAIR SUPERVISOR 3856 060118.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ELECTRICAL TEST TECHNICIAN  7515 092917 REV 101117.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ELECTRICIAN  3864 102116 Rev 110216.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ENVIRONMENTAL COMPLIANCE INSPECTOR 4293 042916 REV 051916.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR EQUIPMENT MECHANIC 3712 010518 REV 080718.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR EXAMINER OF QUESTIONED DOCUMENTS 3231 072216 REVISED 072716.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR FORENSIC PRINT SPECIALIST 2201 090718.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR HEAVY DUTY EQUIPMENT MECHANIC 3745 012017.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR HYDROGRAPHER 7264 030714.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR LIBRARIAN 6153 033117.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR MACHINIST SUPERVISOR 3768 051016.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR MANAGEMENT ANALYST 9171 040618.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR MECHANICAL ENGINEERING DRAFTING TECHNICIAN 7210 110416.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR MECHANICAL REPAIRER 3772 030416.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR PAINTER 3424 041318.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR PARK MAINTENANCE SUPERVISOR 3146 101416.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR PARK RANGER 1967 091815.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR PARKING ATTENDANT 3529 032417.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR POLICE SERVICE REPRESENTATIVE 2209 020918.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR PORT ELECTRICAL MECHANIC 3847 072916 REV 081116 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR PROPERTY OFFICER 3209 012618.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR RECREATION DIRECTOR 2446 050517 REV 051117.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR ROOFER 3477 101708 REV 110608.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR SAFETY ENGINEER ELEVATORS 4264  042718.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR SECURITY OFFICER 3184 122818.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR STOREKEEPER 1837 052518.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR SYSTEMS ANALYST 1597 100617.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR TITLE EXAMINER 1947 121517.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR TRAFFIC SUPERVISOR 3218 121517.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR TRANSPORTATION INVESTIGATOR 4273 070717 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR UNDERGROUND DISTRIBUTION CONSTRUCTION SUPERVISOR 3815 072817.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR UTILITY ACCOUNTANT 1521 100716.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR UTILITY BUYER 1862 052518.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR UTILITY SERVICES SPECIALIST 3573 113018.txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR UTILITY SERVICES SPECIALIST 3753 121815 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/SENIOR WINDOW CLEANER 3174 013114 Rev021314.txt\n",
      "CityofLA/JobBulletins_cleaned/SHEET METAL SUPERVISOR 3777 061314.txt\n",
      "CityofLA/JobBulletins_cleaned/SHOPS SUPERINTENDENT 3780 051118.txt\n",
      "CityofLA/JobBulletins_cleaned/SIGN SHOP SUPERVISOR 3419 030615.txt\n",
      "CityofLA/JobBulletins_cleaned/SIGNAL SYSTEMS SUPERINTENDENT 3832 110416.txt\n",
      "CityofLA/JobBulletins_cleaned/SIGNAL SYSTEMS SUPERVISOR 3839 092818.txt\n",
      "CityofLA/JobBulletins_cleaned/SOCIAL WORKER 2385 102717  revised.txt\n",
      "CityofLA/JobBulletins_cleaned/SOLID RESOURCES SUPERINTENDENT 4102 031017 REV 032317 (2).txt\n",
      "CityofLA/JobBulletins_cleaned/SOLID WASTE DISPOSAL SUPERINTENDENT 4108 020218.txt\n",
      "CityofLA/JobBulletins_cleaned/SPECIAL INVESTIGATOR 0602 042216.txt\n",
      "CityofLA/JobBulletins_cleaned/SR CRIME _ INTELLIGENCE ANALYST 2241 011516.txt\n",
      "CityofLA/JobBulletins_cleaned/STEAM PLANT MAINTENANCE MECHANIC 5630 0902116.txt\n",
      "CityofLA/JobBulletins_cleaned/STEAM PLANT MAINTENANCE SUPERVISOR 3786 033117.txt\n",
      "CityofLA/JobBulletins_cleaned/STEAM PLANT OPERATOR 5624 101416.txt\n",
      "CityofLA/JobBulletins_cleaned/STREET LIGHTING CONSTRUCTION AND MAINTENANCE SUPERINTENDENT 3820 051818.txt\n",
      "CityofLA/JobBulletins_cleaned/STREET LIGHTING ELECTRICIAN SUPERVISOR 3840 031717.txt\n",
      "CityofLA/JobBulletins_cleaned/STREET SERVICES SUPERVISOR 4152 082815.txt\n",
      "CityofLA/JobBulletins_cleaned/STREET SERVICES WORKER 4150 032318.txt\n",
      "CityofLA/JobBulletins_cleaned/STREET TREE SUPERINTENDENT 3160 060917.txt\n",
      "CityofLA/JobBulletins_cleaned/STRUCTURAL ENGINEER 7956 101918.txt\n",
      "CityofLA/JobBulletins_cleaned/STRUCTURAL STEEL FABRICATOR 3793 122316.txt\n",
      "CityofLA/JobBulletins_cleaned/STRUCTURAL STEEL FABRICATOR SUPERVISOR 3794 060217.txt\n",
      "CityofLA/JobBulletins_cleaned/SUPERVISING CRIMINALIST 2235 030416.txt\n",
      "CityofLA/JobBulletins_cleaned/SUPERVISING TRANSPORTATION PLANNER 2481 072216.txt\n",
      "CityofLA/JobBulletins_cleaned/SUPERVISING WATER SERVICE REPRESENTATIVE 1697 081318.txt\n",
      "CityofLA/JobBulletins_cleaned/SURVEY PARTY CHIEF 7286 093016.txt\n",
      "CityofLA/JobBulletins_cleaned/SURVEY SUPERVISOR 7287 110918.txt\n",
      "CityofLA/JobBulletins_cleaned/TAX COMPLIANCE AIDE 1173 061215 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/TITLE EXAMINER 1943 032318 REV 040518.txt\n",
      "CityofLA/JobBulletins_cleaned/TRAFFIC MARKING AND SIGN SUPERINTENDENT 3430 032219.txt\n",
      "CityofLA/JobBulletins_cleaned/TRAFFIC PAINTER AND SIGN POSTER 3421 033117.txt\n",
      "CityofLA/JobBulletins_cleaned/TRANSMISSION AND DISTRIBUTION DISTRICT SUPERVISOR 3875 050418 REV 051718.txt\n",
      "CityofLA/JobBulletins_cleaned/TREE SURGEON ASSISTANT 3151 060316.txt\n",
      "CityofLA/JobBulletins_cleaned/UNDERGROUND DISTRIBUTION CONSTRUCTION SUPERVISOR 3814 121418 REV 122718 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/UPHOLSTERER 3723 041715.txt\n",
      "CityofLA/JobBulletins_cleaned/UTILITY ACCOUNTANT 1511 092818.txt\n",
      "CityofLA/JobBulletins_cleaned/UTILITY ADMINISTRATOR 9105 060217.txt\n",
      "CityofLA/JobBulletins_cleaned/UTILITY BUYER 1861 090718.txt\n",
      "CityofLA/JobBulletins_cleaned/UTILITY EXECUTIVE SECRETARY 1336 042817 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/UTILITY SERVICES SPECIALIST 3755 072117 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/VETERINARY TECHNICIAN 2369 020599 REV 120417.txt\n",
      "CityofLA/JobBulletins_cleaned/VIDEO PRODUCTION COORDINATOR 1802 012717.txt\n",
      "CityofLA/JobBulletins_cleaned/VIDEO TECHNICIAN 6145 012717.txt\n",
      "##########################################################\n",
      "CityofLA/JobBulletins_cleaned/Vocational Worker  DEPARTMENT OF PUBLIC WORKS.txt\n",
      "##########################################################\n",
      "CityofLA/JobBulletins_cleaned/WATER BIOLOGIST 7856 120216.txt\n",
      "CityofLA/JobBulletins_cleaned/WATER SERVICE REPRESENTATIVE 1693 111717.txt\n",
      "CityofLA/JobBulletins_cleaned/WATER SERVICE SUPERVISOR 3930 012717.txt\n",
      "CityofLA/JobBulletins_cleaned/WATER TREATMENT OPERATOR 5885 122118.txt\n",
      "CityofLA/JobBulletins_cleaned/WATER TREATMENT SUPERVISOR 5887 072018.txt\n",
      "CityofLA/JobBulletins_cleaned/WATER UTILITY SUPERINTENDENT 3980 121418.txt\n",
      "CityofLA/JobBulletins_cleaned/WATERWORKS MECHANIC SUPERVISOR 3987 051614 (1).txt\n",
      "CityofLA/JobBulletins_cleaned/WELDER SUPERVISOR 3798 120817.txt\n",
      "CityofLA/JobBulletins_cleaned/WORKERS_ COMPENSATION CLAIMS ASSISTANT 1775 041114.txt\n"
     ]
    }
   ],
   "source": [
    "# Define path to look at\n",
    "path = 'CityofLA/JobBulletins_cleaned/'\n",
    "\n",
    "# Get a list of all txt files in this path\n",
    "all_jobs = os.listdir(path)\n",
    "all_jobs.sort() # WARNING: this mutates the list\n",
    "\n",
    "for file_name in all_jobs:\n",
    "    # Find path\n",
    "    job_path = path + file_name\n",
    "    # Read in job as string based on job_path\n",
    "    job      = open(job_path, 'rt').read()\n",
    "    try:\n",
    "        # Print out jobs that don't have itemizers in the requirement section\n",
    "        txt      = job[job.index('REQUIREMENTS/MINIMUM QUALIFICATIONS'):job.index('PROCESS NOTES')]\n",
    "        digits_as_str = [sentence[-1] for sentence in txt.split('.') if sentence[-1].isdigit()]\n",
    "        if len(digits_as_str) == 0:\n",
    "            print(job_path)\n",
    "    except:\n",
    "        print('##########################################################')\n",
    "        print(job_path)\n",
    "        print('##########################################################')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'REQUIREMENTS/MINIMUM QUALIFICATIONS\\n\\n1. Two years of full-time paid experience with water systems facilities in construction, maintenance, or operations; or\\n2. Two years of full-time paid experience operating or maintaining large irrigation systems.\\n\\n'"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Search logic\n",
    "\n",
    "i = all_jobs.index('AQUEDUCT AND RESERVOIR KEEPER 5813 063017 (1).txt')\n",
    "\n",
    "p = path + all_jobs[i]\n",
    "j = open(p, 'rt').read()\n",
    "t = j[j.index('REQUIREMENTS/MINIMUM QUALIFICATIONS'):j.index('PROCESS NOTES')]\n",
    "t"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'AQUEDUCT AND RESERVOIR KEEPER       \\nClass Code:       5813\\nOpen Date:  06-30-17\\n(Exam Open to All, including Current City Employees)\\nANNUAL SALARY\\n\\n$55,415 to $68,841; $61,491 to $76,379; $64,352 to $79,949 \\n\\nNOTES:  \\n\\n1. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf.\\n2. The current salary range is subject to change. You may confirm the starting salary with the hiring department before accepting a job offer.\\n3. Candidates from the eligible list are normally appointed to vacancies in the lower pay grade position.\\n\\nDUTIES\\n\\nAn Aqueduct and Reservoir Keeper patrols and inspects a reservoir, a section of an aqueduct, or water shed to locate actual or potentially unsafe or unsanitary conditions; operates gates and valves as instructed to control the flow of water; monitors pressure, flow and various alarm systems; operates remote valves through electrical control panels; and maintains reservoir grounds.\\n\\nVACANCIES\\n\\nIt is expected that most appointments made from the eligible list resulting from this examination will be to positions that are located in the Owens Valley near Bishop, Independence, and Lone Pine, California and Antelope Valley near Mojave, California.\\n\\nPROCESS NOTES\\n\\nSome positions in the Owens Valley may require at least one year of data entry experience.\\n\\nREQUIREMENTS/MINIMUM QUALIFICATIONS\\n\\n1. Two years of full-time paid experience with water systems facilities in construction, maintenance, or operations; or\\n2. Two years of full-time paid experience operating or maintaining large irrigation systems.\\n\\nPROCESS NOTES \\t\\n\\n1. Applicants who lack six months or less of the above experience may file for this examination.  However, they cannot be appointed until the full experience requirement is met.\\n2. Some positions may require a valid California driver\\'s license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI).\\n3. Candidates must possess and maintain the physical stamina and agility to be able to climb ladders, walk on top of pipelines and work in cramped and confined spaces.\\n\\nWHERE TO APPLY\\n\\nApplications will only be accepted on-line. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the \"Apply\" icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity  for Open Competitive Examinations and at https://www.governmentjobs.com/careers/lacity/promotionaljobs for Promotional Examinations. \\n\\n\\nNOTE:\\n\\n Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter.\\n\\nAPPLICATION DEADLINE\\n\\nApplications must be received by THURSDAY, JULY 13, 2017.\\n\\n\\n\\nIn accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the written test in the following order: 1) Los Angeles City Promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs in the order that applications were received. Applications submitted during the filing period will be kept on file for two years from June 30, 2017 in the event that additional applicants need to be tested to meet hiring needs.\\n\\nSELECTION PROCESS\\n\\nAfter meeting minimum qualifications, and in accordance with Rule 4.2, candidates will be scheduled for the following:\\n\\nExamination Weight:  Written Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .100%\\n\\nThis examination will consist entirely of a written test comprised of multiple-choice questions, in which candidates may be examined for knowledge of:  operation, function, and nomenclature of equipment including gates, screen systems, pumps, drainage systems, irrigation systems, tower gates, and related equipment and facilities  elementary hydraulics theory involving the flow and storage of water as well as techniques for measuring water flow and pressure stage capacity;  procedures for reading and interpreting various instruments such as flow meters, manometers, staff gauges, pressure gauges, and miscellaneous weather gauges;  elementary mathematics such as basic algebra, adding, subtracting, multiplying, dividing, and measurement and unit conversion;  safety procedures and practices including first aid, accident prevention, firefighting techniques, safe driving and boating techniques, applicable Cal/OSHA and DWP safety laws, rules, and lock out and tag out procedures supervision including planning and directing the work of subordinates and providing instructions techniques for relating effectively to the public; and the ability to: complete and maintain logs and records; and other necessary skills, knowledge and abilities; ability to read and interpret prints for piping system.\\n\\nCandidates will be notified later by e-mail of the time and location of the written test, which will be administered in a single half-day session on SATURDAY, SEPTEMBER 9, 2017 in Los Angeles and Bishop, California.  \\n\\nNOTES:\\n\\n1.   This examination is based on a validation study, and as provided by Civil Service Commission Rule 4.20, the written test will not be subject to candidate inspection.\\n2.    As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and, upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application.  The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf. \\n3.     Applications are accepted subject to review to ensure that minimum qualifications are met.  Candidates may be disqualified at any time if it is determined they do not possess the minimum qualifications stated on this bulletin.\\n4.     The promotional list will ordinarily be used ahead of the open competitive list.  However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding seniority credit at the rate of 0.25 of a point for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates.  \\n5.     A final average score of 70% is required to be placed on the eligible list.\\n6.     In conjunction with Civil Service rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates.\\n7.     In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22 and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list.\\n\\nNOTICE:\\n\\nIf you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment.  Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position.\\n\\nTHIS EXAMINATION IS TO BE GIVEN BOTH ON AN\\nINTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS\\n\\nThe City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome.\\nClass Code 5813 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 06-30-17 \\n\\nAN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER\\n\\n'"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "j.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}