Richard Passett Passett

Interested in Python, automation, and data manipulation/analytics

Passett / SalaryScraper.py

Created June 15, 2021 18:05

Script that scrapes salary data from PeopleFirst. I hard-code in my directory for results, but you will need to add your own

	#Import dependencies
	import requests
	import pandas as pd
	import re
	from datetime import datetime as dt
	from bs4 import BeautifulSoup

	#Create function that scrapes PeopleFirst jobs and filters for salary where the floor is $60k or above
	#or $60k is atleast in the salary range, and puts results in an excel file for us

Passett / ExcelSplitter.py

Created June 14, 2021 15:06

Program that splits Excel files by sheet

	#Import dependencies
	import pandas as pd
	import os
	import re
	import tkinter as tk
	from tkinter import ttk
	from tkinter import filedialog
	from tkinter import messagebox