creative_financial_staffing_db

Database of Creative Financial Staffing's jobs

What is this repository?

This repository displays the Python code for downloading all current jobs from Creative Financial Staffing, a leading, employee-owned staffing firm founded by CPA firms (according to this page) and doing the following:

cfs_with_class.py

• Storing the job data in an sqlite3 database. The job data include the following:
  • Job ID
  • Job Title
  • Job URL
  • Job Industry
  • City
  • State
  • Postal Code
  • Salary Range (Low)
  • Salary Range (High)
  • Hourly Range (Low)
  • Hourly Range (High)
  • Date Posted
  • Job Description
• Updating (i.e., adding new jobs and deleting jobs that are no longer on the website) the sqlite3 database.

lat_lng.py

• Using Google's Places API (making Find Place requests) to retrieve the latitude and longitude based on each job's city, state, and zip code.

basic_map.py

• Plotting the latitude and longitude on a map and displaying the map.

Screenshots

• sqlite3 database (using SQLiteStudio)
• Output from basic_map.py
• Find HTTP 404s (i.e., links to jobs that are no longer valid)
• Find errors within the job description or job's metadata
  • Salary irregularities
  • Invalid postal codes

What else could we do?

• Find misspellings in job descriptions.
• Generate thematic, interactive maps and host them online (e.g., a dashboard).
• Analyze the text in job descriptions, extracting metrics such as the most frequently used words.