from pathlib import Path
import pandas as pd
import numpy as np
import seaborn as sns
DATA_DIR = Path("../data/03_secondary/")
data_files = [path for d in DATA_DIR.glob('*/') for path in d.glob('*.feather')]
len(data_files)
76
pd.options.display.max_columns = 50
pd.options.display.max_colwidth = 150
pd.options.display.html.use_mathjax = False
%time df = pd.concat([pd.read_feather(f) for f in data_files], ignore_index=True)
CPU times: user 1.54 s, sys: 460 ms, total: 2 s
Wall time: 1.84 s
pd.options.display.max_rows = 100

Convenience

df['annual'] = df.salary_hours == 2000
df['weekly'] = df.salary_hours == 40
df['daily'] = df.salary_hours == 8
df['hourly'] = df.salary_hours == 1
sum(df.annual), sum(df.weekly), sum(df.daily), sum(df.hourly)
(6471, 141, 2494, 4702)

Fix up salary_min being zero

Take a range of e.g. \$0 - \$30,000 as simply \$30,000

zero_salary = df.salary_min <= 0
df["salary_low"] = df["salary_min"].astype("float")
df.loc[zero_salary, "salary_low"] = df["salary_max"].astype("float")
df.loc[df["salary_low"] <= 0, "salary_low"] = np.nan
df["salary_hi"] = df["salary_max"].astype(float)
df.loc[zero_salary, "salary_hi"] = np.nan
df["salary_valid"] = ~df["salary_low"].isna()

Check salary ranges

df['pct_salary_range'] = (2 * (df.salary_hi - df.salary_low) / (df.salary_hi + df.salary_low))
sns.displot(df, x='pct_salary_range', log=True)
<seaborn.axisgrid.FacetGrid at 0x7f2bcb47df70>

These are a mix of data and parsing errors mainly.

df[df.pct_salary_range < 0].sort_values("pct_salary_range", ascending=False).T
63599 56453 64389 51887 24311 12435 15939 14756 66978 65907 56155 57303 64093 65883 57174 64504 57089 65941 30645 60969 66461 59159 68619 52477 30451 ... 63103 68120 38574 51715 18651 12004 53780 61361 39699 60780 54663 70478 69884 4234 2043 2048 4231 9747 9748 9749 9753 724 714 24953 68286
title Estates/Litigation Lawyer *Exclusively Listed with Legal People* Insurance/Transport Lawyer (3 years Plus exp.) Estates/Litigation Lawyer *Exclusively Listed with Legal People* Planning & Environment Lawyer Legal Personal Assistant - Rare 1 on 1 Role! Contracts Administrator Contracts Administrator Contracts Administrator Senior 12D Designer. Big projects? Civil Engineer - Principal. $177-162K. Admired team leader? Senior Structural Engineer Senior Communications Specialist Principal Structural Engineer. $157-142K. Senior Civil Engineer - Roads Senior Structural Engineer $147-129K Civil Drafter - Mid Level - Urban Development Civil Associate $167-144K Senior Tax Accountant Quantity Surveyor Commercial Contractor, Tauranga Senior Accountant $87-72K Civil Engineer. Urban Infrastructure Structural Principal $187-152k Road Designers 12D Full-Stack Mobile Developer Project Coordinator / Project Administrator ... Intermediate Accountant - Top 50 Chartered Accounting firm - Sydney CBD AUDITOR - TOP 50 FIRM - SYDNEY CBD - $70-90K Management Accountant Outreach Librarian Senior Project Manager Senior Project Manager Senior Civil Engineer - Land and Urban Development Portfolio Senior Practice Leader Management Consultant/ Head, Operations Excellence Finance Manager - Insurance - Decision support role Senior Executive Assistant Early Childhood Educator Early Childhood Educator Strategy and Assets Coordinator Strategy and Assets Coordinator Strategy and Assets Coordinator Strategy and Assets Coordinator Strategy and Assets Coordinator Strategy and Assets Coordinator Strategy and Assets Coordinator Strategy and Assets Coordinator Strategy and Assets Coordinator Strategy and Assets Coordinator Partner Support Officer OSHC Educator
description About our client... Our client is a prestigious commercial law firm located in stunning offices, located in the heart of public transport, gyms an... Are you a talented Legal Personal Assistant wanting “that something extra” in your role?    If so, this role will certainly appeal.    About the ... About the Company\nEstablished over 40 years ago this highly respected builder who are highly regarded throughout Queensland are looking to add a ... About the Company\nEstablished over 40 years ago this highly respected builder who are highly regarded throughout Queensland are looking to add a ... About the Company\nEstablished over 40 years ago this highly respected builder who are highly regarded throughout Queensland are looking to add a ... We are seeking a seeking a QS  to become part of the cohesive and professional team within this well recognized regional commercial contractor. Th... Are you ready to make the move into an inspiring team without the political road blocks that will allow you to drive innovation? Currently we have... Are you a Project Coordinator / Project Administrator with incredible service & delivery skills, wanting to join one of the fastest growing & inno... ... Management Accountant\n\nPart Time - 30.5 hours per week\nSalary $78.3K to $85.2K (Band 6) + 9.5% Super\nLocation - Broadford\n\nMitchell Shire Co... One of Australia’s leading research & teaching universities Vibrant campus life with a strong sense of community & inclusion Enjoy a career that m... Senior Project Manager - Roads\nOur Client:\nOur client is a state-wide Government organisation within the Transport sector who have expressed int... Senior Project Manager - Roads\nOur Client:\nOur client is a state-wide Government organisation within the Transport sector who have expressed int... Join us! This consultancy works with some of the Australia's largest property developers. They commit to world's best practise. They are at the le... Back in 1952, The Sorbent Paper Company proudly transformed the Australian outhouse routine from an unpleasant chore into something a little more ... One of Australia’s leading research & teaching universities Vibrant campus life with a strong sense of community & inclusion Enjoy a career that m... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... About the region\n\nGunnedah Shire is one of Australia’s richest agricultural regions and a vibrant, warm and friendly town surrounded by the expa... Position Number: 000014846 The HSS ICT team seeks to support our customers in providing excellent health care through the delivery of key services...
uri https://www.seek.com.au/job/37438702 https://www.seek.com.au/job/37059637 https://www.seek.com.au/job/37438542 https://www.seek.com.au/job/36028216 https://www.seek.com.au/job/39973604 https://www.cgcrecruitment.com/job/contracts-administrator-100/ https://www.cgcrecruitment.com/job/contracts-administrator-100/ https://www.cgcrecruitment.com/job/contracts-administrator-100/ https://www.seek.com.au/job/37211440 https://www.seek.com.au/job/37210798 https://www.seek.com.au/job/37059579 https://www.seek.co.nz/job/37345166 https://www.seek.co.nz/job/37434420 https://www.seek.com.au/job/37211332 https://www.seek.co.nz/job/37348386 https://www.seek.com.au/job/37436882 https://www.seek.co.nz/job/37348385 https://www.seek.com.au/job/37211069 https://www.seek.co.nz/job/40268139 https://www.seek.com.au/job/36498238 https://www.seek.com.au/job/37211330 https://www.seek.co.nz/job/37764568 https://www.seek.com.au/job/37597834 https://www.seek.com.au/job/36211544 https://www.seek.com.au/job/39893421 ... https://www.seek.com.au/job/36787246 https://www.seek.com.au/job/37599445 https://www.seek.com.au/job/50986299?type=standout https://www.seek.com.au/job/36028198 https://www.cgcrecruitment.com/job/senior-project-manager-38/ https://www.cgcrecruitment.com/job/senior-project-manager-38/ https://www.seek.com.au/job/36227119 https://www.seek.com.au/job/36496454 https://www.seek.com.au/job/41210489?type=standard https://www.seek.com.au/job/36553978 https://www.seek.com.au/job/36034007 https://www.seek.com.au/job/37564377 https://www.seek.com.au/job/37564376 https://www.davidsonwp.com/job/100562133328616/strategy-and-assets-coordinator-2/ https://www.davidsonwp.com/job/100562133328616/strategy-and-assets-coordinator-2/ https://www.davidsonwp.com/job/100562133328624/strategy-and-assets-coordinator-4/ https://www.davidsonwp.com/job/100562133328618/strategy-and-assets-coordinator-3/ https://www.davidsonwp.com/job/100562133328615/strategy-and-assets-coordinator-1/ https://www.davidsonwp.com/job/100562133328618/strategy-and-assets-coordinator-3/ https://www.davidsonwp.com/job/100562133328616/strategy-and-assets-coordinator-2/ https://www.davidsonwp.com/job/100562133328624/strategy-and-assets-coordinator-4/ https://www.davidsonwp.com/job/100562133328615/strategy-and-assets-coordinator-1/ https://www.davidsonwp.com/job/100562133327736/strategy-and-assets-coordinator/ https://www.seek.com.au/job/40070099 https://www.seek.com.au/job/37600652
view_date 2018-10-11 00:51:57 2018-08-27 01:09:54 2018-10-11 00:52:33 2018-04-20 03:52:38 2019-09-19 10:15:08 2020-07-06 02:01:01+00:00 2020-09-30 11:44:39+00:00 2020-04-01 22:04:58+00:00 2018-09-13 01:02:12 2018-09-13 01:26:44 2018-08-27 01:08:03 2018-09-29 02:44:03 2018-10-11 01:58:43 2018-09-13 01:22:15 2018-09-29 02:48:49 2018-10-11 01:10:25 2018-09-29 02:43:25 2018-09-13 01:19:44 2019-10-29 12:48:48 2018-06-19 02:17:02 2018-09-13 01:23:09 2018-11-21 03:27:05 2018-10-31 02:33:55 2018-05-14 01:32:59 2019-09-09 10:02:29 ... 2018-07-24 09:28:52 2018-10-31 02:11:16 2020-12-04 04:10:07+00:00 2018-04-20 03:55:55 2020-10-23 19:04:10+00:00 2020-05-29 12:52:08+00:00 2018-05-16 03:36:36 2018-06-19 02:41:37 2020-04-08 14:50:56+00:00 2018-06-25 16:11:54 2018-04-20 02:31:56 2018-10-26 04:44:54 2018-10-26 04:32:02 2020-04-07 16:26:22+00:00 2020-07-06 14:05:51+00:00 2020-07-11 10:54:45+00:00 2020-04-07 17:07:57+00:00 2020-10-29 07:53:52+00:00 2020-10-22 02:03:34+00:00 2020-10-27 07:12:10+00:00 2020-10-22 09:53:11+00:00 2020-06-05 23:55:37+00:00 2020-06-01 03:43:03+00:00 2019-10-02 08:25:08 2018-10-31 01:32:36
org Legal People Legal People Legal People Legal People Legal People CGC Recruitment CGC Recruitment CGC Recruitment ENGINEERJOBS.com.au ENGINEERJOBS.com.au ENGINEERJOBS.com.au Madison Recruitment Ltd StructuralJobs.co.nz ENGINEERJOBS.com.au StructuralJobs.co.nz ENGINEERJOBS.com.au CivilJobs.co.nz AccountantJobs.com.au Harper Smith Recruitment AccountantJobs.com.au ENGINEERJOBS.com.au StructuralJobs.co.nz Bayside Personnel Northbridge Recruitment Aurec ... Lucky You Found Me Lucky You Found Me Mitchell Shire Council University of New South Wales CGC Recruitment CGC Recruitment Building Personnel Department of Health and Human Services McKkr's Training & Internships Mars Recruitment University of New South Wales Mitchell Shire Council Mitchell Shire Council Davidson Davidson Davidson Davidson Davidson Davidson Davidson Davidson Davidson Davidson Health Support Services YMCA Victoria
salary_raw Call Sharon Henderson: 9098-8776 Call Sharon Henderson: 9098-8776 Call Sharon Henderson: 9098-8776 Call Sharon Henderson: 9098-8776 Call Rosie at Legal People on 9098-8775 $110K-$104K package depending on experience $110K-$104K package depending on experience $110K-$104K package depending on experience $120,000 - $110,000 $177,000-$162,000 $149,000 to $136,000 $55 - $50 per hour $157,000 - $142,000 $138,000 - $122,000 $147,000 - $129,000 $87,000 - $76,000 $167,000 - $144,000 $84,000 - $72,000 $120,000 - $100,000 plus vehicle $87,000 - $72,000 $124,000 - $102,000 $187,000 - $152,000 $100 - $60 p.h. + Brisbane Based + perks L/T CONTRACT, Excellent Rates, 9-5 hrs, Melb CBD Good Rates + Great Manager + 9-5 hrs ... PLEASE CONTACT YULIUS ON 9283-0777 TO DISCUSS PLEASE CONTACT YULIUS ON 9283-0777 TO DISCUSS Salary $78.3K to $85.2K  (Band 6) + 9.5% Super $83.6K-$89.2K plus 17% superannuation $1k - $1.5k per day + Super $1k - $1.5k per day + Super $90k - $125 plus Super $98,679 - $113.572 $112,000 - $123 plus other allowances $120,000 - $130-000 + super + bonus $91,755K - $99,306 plus 17% super & leave loading Minimum $43k to $46.5K Minimum $43k to $46.5K $100,790 - $108.540 + super $100,790 - $108.540 + super $100,790 - $108.540 + super $100,790 - $108.540 + super $100,790 - $108.540 + super $100,790 - $108.540 + super $100,790 - $108.540 + super $100,790 - $108.540 + super $100,790 - $108.540 + super $100,790 - $108.540 + super HSO Level G4 $74,768 - $80.027 p.a. Children's Services Award Victoria 2010 3.1-3.4
salary_min 9098 9098 9098 9098 9098 110000 110000 110000 120000 177000 149000 55 157000 138000 147000 87000 167000 84000 120000 87000 124000 187000 100 9 9 ... 9283 9283 3000 6000 1000 1000 90000 98679 112000 120000 9.1755e+07 43000 43000 100790 100790 100790 100790 100790 100790 100790 100790 100790 100790 74768 20103.1
salary_max 8776 8776 8776 8776 8775 104000 104000 104000 110000 162000 136000 50 142000 122000 129000 76000 144000 72000 100000 72000 102000 152000 60 5 5 ... 777 777 85.2 89.2 1.5 1.5 125 113.572 123 130 99306 46.5 46.5 108.54 108.54 108.54 108.54 108.54 108.54 108.54 108.54 108.54 108.54 80.027 3.4
salary_hours NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 NaN NaN ... NaN NaN NaN NaN 8 8 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2000 NaN
location_raw Melbourne, CBD & Inner Suburbs, AU Melbourne, CBD & Inner Suburbs, AU Melbourne, CBD & Inner Suburbs, AU Melbourne, CBD & Inner Suburbs, AU Melbourne, Victoria, Australia Cairns, QLD Other, AU Cairns, QLD Other, AU Cairns, QLD Other, AU Brisbane, Northern Suburbs, AU Brisbane, CBD & Inner Suburbs, AU Brisbane, CBD & Inner Suburbs, AU Auckland, Auckland Central, NZ Auckland, Auckland Central, NZ Blue Mountains & Central West, AU Auckland, Auckland Central, NZ Gold Coast, AU Auckland, Auckland Central, NZ Melbourne, Eastern Suburbs, AU Bay of Plenty, New Zealand, New zealand Melbourne, CBD & Inner Suburbs, AU Melbourne, CBD & Inner Suburbs, AU Auckland, Auckland Central, NZ Brisbane, AU Melbourne, CBD & Inner Suburbs, AU Sydney, New South Wales, Australia ... Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, CBD, Inner West & Eastern Suburbs, AU , Melbourne, Victoria, Australia Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, AU Sydney, AU Melbourne, CBD & Inner Suburbs, AU Melbourne, Northern Suburbs, AU boxhillsouth, Melbourne, Victoria, Australia Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Melbourne, Northern Suburbs, AU Melbourne, Northern Suburbs, AU Gunnedah, AU Gunnedah, AU Gunnedah, AU Gunnedah, AU Gunnedah, AU Gunnedah, AU Gunnedah, AU Gunnedah, AU Gunnedah, AU Gunnedah, AU Perth, Western Australia, Australia Melbourne, Northern Suburbs, AU
loc_id 8.57823e+07 8.57823e+07 8.57823e+07 8.57823e+07 1.01933e+08 1.02049e+08 1.02049e+08 1.02049e+08 1.01934e+08 8.57823e+07 8.57823e+07 8.57824e+07 8.57824e+07 1.0205e+08 8.57824e+07 1.02049e+08 8.57824e+07 1.01933e+08 8.56872e+07 8.57823e+07 8.57823e+07 8.57824e+07 1.01934e+08 8.57823e+07 1.01932e+08 ... 8.57823e+07 8.57823e+07 1.01933e+08 8.57823e+07 1.01932e+08 1.01932e+08 8.57823e+07 1.01933e+08 1.01933e+08 8.57823e+07 8.57823e+07 1.01933e+08 1.01933e+08 1.02049e+08 1.02049e+08 1.02049e+08 1.02049e+08 1.02049e+08 1.02049e+08 1.02049e+08 1.02049e+08 1.02049e+08 1.02049e+08 1.01938e+08 1.01933e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania ... Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania
loc_country Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia New Zealand New Zealand Australia New Zealand Australia New Zealand Australia New Zealand Australia Australia New Zealand Australia Australia Australia ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_county Melbourne Melbourne Melbourne Melbourne Melbourne Cairns Cairns Cairns Brisbane Melbourne Melbourne Auckland Auckland Blue Mountains Auckland Gold Coast Auckland Melbourne None Melbourne Melbourne Auckland Brisbane Melbourne Sydney ... Melbourne Melbourne Melbourne Melbourne Sydney Sydney Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Gunnedah Gunnedah Gunnedah Gunnedah Gunnedah Gunnedah Gunnedah Gunnedah Gunnedah Gunnedah Perth Melbourne
loc_empire Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None None Australia None Australia None Australia None Australia Australia None Australia Australia Australia ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_localadmin Melbourne Melbourne Melbourne Melbourne Melbourne None None None Brisbane City Melbourne Melbourne None None None None None None Melbourne None Melbourne Melbourne None Brisbane City Melbourne Sydney ... Melbourne Melbourne Melbourne Melbourne Sydney Sydney Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne None None None None None None None None None None Perth Melbourne
loc_locality Melbourne Melbourne Melbourne Melbourne Melbourne None None None Brisbane City Melbourne Melbourne None None None None None None Melbourne None Melbourne Melbourne None Brisbane City Melbourne Sydney ... Melbourne Melbourne Melbourne Melbourne Sydney Sydney Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne None None None None None None None None None None Perth Melbourne
loc_macrocounty Melbourne Melbourne Melbourne Melbourne Melbourne None None None Brisbane Melbourne Melbourne None None None None Gold Coast None Melbourne None Melbourne Melbourne None Brisbane Melbourne Sydney ... Melbourne Melbourne Melbourne Melbourne Sydney Sydney Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne None None None None None None None None None None Perth Melbourne
loc_region Victoria Victoria Victoria Victoria Victoria Queensland Queensland Queensland Queensland Victoria Victoria Auckland Region Auckland Region New South Wales Auckland Region Queensland Auckland Region Victoria Bay of Plenty Region Victoria Victoria Auckland Region Queensland Victoria New South Wales ... Victoria Victoria Victoria Victoria New South Wales New South Wales Victoria Victoria Victoria Victoria Victoria Victoria Victoria New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales Western Australia Victoria
processor kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest cgcrecruitment cgcrecruitment cgcrecruitment kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest ... kaggle_promptcloud_listings kaggle_promptcloud_listings seek kaggle_promptcloud_listings cgcrecruitment cgcrecruitment kaggle_promptcloud_listings kaggle_promptcloud_listings seek kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp kaggle_promptcloud_latest kaggle_promptcloud_listings
source seekau seekau seekau seekau seekau_2019q3 CC-MAIN-2020-29 CC-MAIN-2020-40 CC-MAIN-2020-16 seekau seekau seekau seekau seekau seekau seekau seekau seekau seekau seekau_2019q3 seekau seekau seekau seekau seekau seekau_2019q3 ... seekau seekau CC-MAIN-2020-50 seekau CC-MAIN-2020-45 CC-MAIN-2020-24 seekau seekau CC-MAIN-2020-16 seekau seekau seekau seekau CC-MAIN-2020-16 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-16 CC-MAIN-2020-45 CC-MAIN-2020-45 CC-MAIN-2020-45 CC-MAIN-2020-45 CC-MAIN-2020-24 CC-MAIN-2020-24 seekau_2019q3 seekau
loc_neighbourhood Melbourne CBD Melbourne CBD Melbourne CBD Melbourne CBD None NaN NaN NaN None Melbourne CBD Melbourne CBD Auckland City Centre Auckland City Centre None Auckland City Centre None Auckland City Centre None None Melbourne CBD Melbourne CBD Auckland City Centre None Melbourne CBD None ... Melbourne CBD Melbourne CBD None Melbourne CBD NaN NaN Melbourne CBD None None Melbourne CBD Melbourne CBD None None None None None None None None None None None None None None
annual False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False True False
weekly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
daily False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False True True False False False False False False False False False False False False False False False False False False False
hourly False False False False False False False False False False False True False False False False False False False False False False True False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
salary_low 9098 9098 9098 9098 9098 110000 110000 110000 120000 177000 149000 55 157000 138000 147000 87000 167000 84000 120000 87000 124000 187000 100 9 9 ... 9283 9283 3000 6000 1000 1000 90000 98679 112000 120000 9.1755e+07 43000 43000 100790 100790 100790 100790 100790 100790 100790 100790 100790 100790 74768 20103.1
salary_hi 8776 8776 8776 8776 8775 104000 104000 104000 110000 162000 136000 50 142000 122000 129000 76000 144000 72000 100000 72000 102000 152000 60 5 5 ... 777 777 85.2 89.2 1.5 1.5 125 113.572 123 130 99306 46.5 46.5 108.54 108.54 108.54 108.54 108.54 108.54 108.54 108.54 108.54 108.54 80.027 3.4
salary_valid True True True True True True True True True True True True True True True True True True True True True True True True True ... True True True True True True True True True True True True True True True True True True True True True True True True True
pct_salary_range -0.03603 -0.03603 -0.03603 -0.03603 -0.0361439 -0.0560748 -0.0560748 -0.0560748 -0.0869565 -0.0884956 -0.0912281 -0.0952381 -0.100334 -0.123077 -0.130435 -0.134969 -0.14791 -0.153846 -0.181818 -0.188679 -0.19469 -0.20649 -0.5 -0.571429 -0.571429 ... -1.69105 -1.69105 -1.88954 -1.9414 -1.99401 -1.99401 -1.99445 -1.9954 -1.99561 -1.99567 -1.99568 -1.99568 -1.99568 -1.9957 -1.9957 -1.9957 -1.9957 -1.9957 -1.9957 -1.9957 -1.9957 -1.9957 -1.9957 -1.99572 -1.99932

30 rows × 60 columns

df.loc[df.pct_salary_range < 0, "salary_valid"] = False

A lot of crazy ranges, up to ~1.5 actually occur in the data, espeically for sales roles with variable income (it’s safe to say the real income is at the bottom of the range). The rest are data/parsing errors.

Most of these ranges are pretty useless.

df[df.pct_salary_range > .7].sort_values('pct_salary_range').T
68903 68838 23201 57159 18179 3563 667 11682 5911 24127 5592 3981 32572 35961 37972 59537 4148 5894 34767 35652 26830 8252 33312 9413 3915 ... 61633 60054 55842 53156 65538 53526 53388 1127 8267 10301 17097 14226 52432 66166 12027 18705 20657 19078 20613 20646 19511 19059 20630 20584 53816
title Financial Advice & Sales Financial Advice & Sales Real Estate Sales Agent/Assistant Auto Electrician - Heavy Earthmoving Equipment Experience OHW Engineers (Engineer, Senior & Principal) Chief Executive Officer - City of Melbourne Project Manager - Contract OHW Engineers (Engineer, Senior & Principal) Project Manager - Contract EXPERIENCED & CORDIAL FUNCTION WAIT STAFF Sales Manager - Gold Coast Sales Manager - Gold Coast window Server consultant window Server consultant Customer Service | Entry level Mid Level Drupal Developer (Contract) Android Developer- NAB Android Developer- NAB Business Development Manager - NSW, ACT & QLD Business Development Manager - NSW, ACT & QLD Professional PERMANENT and TEMPORARY job opportunities! Administrator Business Development Manager - NSW, ACT & QLD Business Improvement Manager Business Improvement Manager ... Acountant - Business Services Manager - $145 - $120K Add value to your Career Construction Litigation Associate Senior Accountant Business Services Senior Accountant Senior Accountant Business Services Assistant Manager Business Services Manager Business Analyst Business Analyst Business Analyst Senior Civil Drafter Senior Civil Drafter Director - Childcare Centre Manager - Early Childhood Crew Leader Senior Tunnel Engineer Senior Tunnel Engineer Lead Practitioner Children & Family Services Counsellor – Crime Victims & General Counsellor & Parent Educator Domestic & Family Violence Counsellor Industrial Officer Case Manager Family & Community Wellbeing Case Manager Community Mental Health Union Organiser Baker/Pastry Chef
description About the business   A well-established agency for over 30 years is looking for a motivated residential salesperson who is self motivated and is e... CGC are working with a highly professional, world leading design and engineering consultancy. They have a highly enviable reputation and offer fle... The City of Melbourne is a capital city council with ambitious plans for a fast-growing Melbourne.\nReporting to a highly engaged Lord Mayor and C... About the Company\nLeading university looking for a project manager to start immediately – 6 month contract\nAbout the Role\n\n6 month contract wi... CGC are working with a highly professional, world leading design and engineering consultancy. They have a highly enviable reputation and offer fle... About the Company\nLeading university looking for a project manager to start immediately – 6 month contract\nAbout the Role\n\n6 month contract wi... What's in it for you?Top hourly rates from $26.03 per hour paid weekly.Work at reputable establishments all over Canberra from Stadiums to Hotels ... About the Company\nDavidson are recruiting to a Sales Professional – Home and land sale packages for our Client who are a successful, growing busi... About the Company\nDavidson are recruiting to a Sales Professional – Home and land sale packages for our Client who are a successful, growing busi... Your role is to migration legacy applications running on legacy servers Microsoft Server.\nYou will need the following skills\n\nAdvanced Windows ... Your role is to migration legacy applications running on legacy servers Microsoft Server.\nYou will need the following skills\n\nAdvanced Windows ... Entry Level | Customer Service\nIf you have no corporate experience and wish to enter the NSW government space, these roles are not to be missed! ... About the Company\nThis business is a true household name across Austalia. They are a well renowned, located in the CBD and they have an outstandi... About the Company\nThis business is a true household name across Austalia. They are a well renowned, located in the CBD and they have an outstandi... Our Client\nOur client has over 100K employees globally and provides a range of well-respected power management solutions, including UPS. They off... Our Client\nOur client has over 100K employees globally and provides a range of well-respected power management solutions, including UPS. They off... Personnel Resources / Temp Resources Ltd have been in the local market for over 20 years! With offices in Rotorua, Tauranga, and Whakatane we are ... About the Company\nOur client is one of Australia's largest Financial Institutions, they provide a comprehensive and integrated range of Financial... Our Client\nOur client has over 100K employees globally and provides a range of well-respected power management solutions, including UPS. They off... About the Company\nOur client is one of Australians leading, independent coal producers. For more information regarding the client, please contact... About the Company\nOur client is one of Australians leading, independent coal producers. For more information regarding the client, please contact... ... About the Company\nDavidson have proudly partnered with a market leading supplier of mining and construction goods and services. With their organi... About the Company\nDavidson have proudly partnered with a market leading supplier of mining and construction goods and services. With their organi... About the Company\nDavidson have proudly partnered with a market leading supplier of mining and construction goods and services. With their organi... About the company:\n\nOur client is a global multi-discipline consultancy, with a solid reputation, offering an opportunity for an experienced Sen... About the company:\n\nOur client is a global multi-discipline consultancy, with a solid reputation, offering an opportunity for an experienced Sen... The centre A modern purpose built centre that is conveniently located in a residential area and caters for children from aged 0-5 years old. The c... The Company\nWith offices across the globe, this top tier engineering design consultancy are at the forefront of design. They have an outstanding... The Company\nWith offices across the globe, this top tier engineering design consultancy are at the forefront of design. They have an outstanding... About the role\nWe have a newly created position for a Lead Practitioner to join our Berrimah team within CatholicCare NT. This position plays a k... About the role\n\nSCHADS Award Level 6 – $89,850 trp (including salary $81,059)\nSalary Packaging Option (up to an additional $15,909.00 p/a)\nFul... About the role\n\nSCHADS Award Level 6 – $89,850 (including salary $81,059)\nSalary Packing Option (up to an additional $15,909 p/a)\nFull Time Po... About the role\n\nSCHADS Award Level 6 – $92,547 trp (including salary $83,492)\nSalary Packaging Option (up to an additional $15,895 p/a)\nFull T... About the role\n\nLevel 6 – $94,409 to $103,497 / Level 7- $107,134 to $118,283\nAdditional 17% employer superannuation\nRewarding career with a p... About the role\n\nSCHADS Award Level 5 – $82,510 trp (including salary $74,437)\nSalary Packaging Option (up to an additional $15,909.00 p/a)\nFul... About the role\n\nSCHADS Award Level 5 – $84,989 trp (including salary $76,673 per annum)\nSalary Packaging Option (up to an additional $15,909.00... About the role\n\nLevel 5 – $85,295 to $92,219 / Level 6- $96,297 to $105,567\nAdditional 17% employer superannuation\nRewarding career with a pro... Kiss Kiss Pastizzi is the one and only pastizzi handcrafted in WA! Discover our passionately made Pastizzi produced only with dedication and commi...
uri https://www.seek.co.nz/job/36424224 https://www.seek.co.nz/job/36424192 https://www.seek.com.au/job/39865277 https://www.seek.com.au/job/37345189 https://www.cgcrecruitment.com/job/ohw-engineers-engineer-senior-and-principal/ https://www.davidsonwp.com/job/100562133240635/chief-executive-officer-1/ https://www.davidsonwp.com/job/100562133321419/project-manager-temp/ https://www.cgcrecruitment.com/job/ohw-engineers-engineer-senior-and-principal/ https://www.davidsonwp.com/job/100562133321419/project-manager-temp/ https://www.seek.com.au/job/39968796 https://www.davidsonwp.com/job/100562133295720/sales-manager-gold-coast-2/ https://www.davidsonwp.com/job/100562133295720/sales-manager-gold-coast-2/ https://jobs.launchrecruitment.com.au/job/100602033393926/window-server-consultant/ https://jobs.launchrecruitment.com.au/job/100602033393926/window-server-consultant/ https://www.seek.com.au/job/50821248?type=standard https://www.seek.com.au/job/36553878 https://www.davidsonwp.com/job/100562133321048/android-developer-nab/ https://www.davidsonwp.com/job/100562133321048/android-developer-nab/ https://jobs.launchrecruitment.com.au/job/100602033339088/business-development-manager-nsw-act-and-qld/ https://jobs.launchrecruitment.com.au/job/100602033339088/business-development-manager-nsw-act-and-qld/ https://www.seek.co.nz/job/40247000 https://www.davidsonwp.com/job/administrator-1/ https://jobs.launchrecruitment.com.au/job/100602033339088/business-development-manager-nsw-act-and-qld/ https://www.davidsonwp.com/job/100562133286230/business-development-manager-8/ https://www.davidsonwp.com/job/100562133286230/business-development-manager-8/ ... https://www.seek.com.au/job/36498235 https://www.seek.com.au/job/36553569 https://www.seek.com.au/job/37058079 https://www.seek.com.au/job/37115998 https://www.seek.com.au/job/37209910 https://www.seek.com.au/job/37115997 https://www.seek.com.au/job/37115969 https://www.davidsonwp.com/job/business-analyst-68/ https://www.davidsonwp.com/job/business-analyst-68/ https://www.davidsonwp.com/job/business-analyst-68/ https://www.cgcrecruitment.com/job/senior-civil-drafter-4/ https://www.cgcrecruitment.com/job/senior-civil-drafter-4/ https://www.seek.com.au/job/36211314 https://www.seek.com.au/job/37213523 https://www.cgcrecruitment.com/job/senior-tunnel-engineer/ https://www.cgcrecruitment.com/job/senior-tunnel-engineer/ https://probonoaustralia.com.au/jobs/2019/09/lead-practitioner-children-family-services/ https://probonoaustralia.com.au/jobs/2019/04/counsellor-crime-victims-general/ https://probonoaustralia.com.au/jobs/2019/06/counsellor-parent-educator-2/ https://probonoaustralia.com.au/jobs/2019/09/domestic-family-violence-counsellor-3/ https://probonoaustralia.com.au/jobs/2020/05/industrial-officer-11/ https://probonoaustralia.com.au/jobs/2019/04/case-manager-family-community-wellbeing/ https://probonoaustralia.com.au/jobs/2019/09/case-manager-community-mental-health-2/ https://probonoaustralia.com.au/jobs/2020/09/union-organiser-2/ https://www.seek.com.au/job/36225945
view_date 2018-06-08 07:25:15 2018-06-08 07:23:55 2019-09-05 06:53:19 2018-09-29 02:49:04 2020-10-27 22:17:51+00:00 2020-04-02 23:59:07+00:00 2020-06-06 22:21:20+00:00 2020-06-05 03:27:31+00:00 2020-09-24 13:26:16+00:00 2019-09-18 09:50:23 2020-09-25 04:34:42+00:00 2020-04-06 05:39:33+00:00 2020-05-26 06:37:27+00:00 2020-09-28 23:55:30+00:00 2020-11-24 21:14:47+00:00 2018-06-25 16:28:10 2020-03-28 10:54:37+00:00 2020-09-27 04:24:57+00:00 2020-03-29 23:24:56+00:00 2020-09-24 04:57:34+00:00 2019-10-25 08:25:04 2020-08-11 23:46:22+00:00 2020-07-07 15:28:15+00:00 2020-10-22 01:25:53+00:00 2020-04-07 16:24:45+00:00 ... 2018-06-19 02:05:35 2018-06-25 16:46:44 2018-08-27 01:23:29 2018-09-02 00:30:39 2018-09-13 01:27:52 2018-09-02 00:31:54 2018-09-02 00:47:44 2020-05-31 00:58:14+00:00 2020-08-12 06:06:33+00:00 2020-10-30 03:30:30+00:00 2020-08-07 05:00:32+00:00 2020-12-04 06:10:02+00:00 2018-05-14 01:30:19 2018-09-13 00:41:52 2020-06-05 16:21:23+00:00 2020-10-27 22:21:39+00:00 2020-08-07 16:45:47+00:00 2020-05-25 19:32:26+00:00 2020-08-12 02:53:00+00:00 2020-08-07 16:52:21+00:00 2020-05-28 12:15:44+00:00 2020-05-31 19:13:33+00:00 2020-08-07 17:23:14+00:00 2020-09-21 03:05:15+00:00 2018-05-16 03:40:33
org Haven Advisers Haven Advisers Private Advertiser GO2 Recruitment CGC Recruitment Davidson Davidson CGC Recruitment Davidson Frontline Hospitality Temps ACT & Southern NSW Davidson Davidson Launch Recruitment Launch Recruitment Randstad - Business Support Opus Recruitment Solutions Davidson Davidson Launch Recruitment Launch Recruitment Personnel Resources/Temp Resources Davidson Launch Recruitment Davidson Davidson ... AccountantJobs.com.au LAWJOBS.com.au - PERSONNEL CONCEPT AccountantJobs.com.au AccountantJobs.com.au AccountantJobs.com.au AccountantJobs.com.au AccountantJobs.com.au Davidson Davidson Davidson CGC Recruitment CGC Recruitment Randstad - Education YMCA Victoria CGC Recruitment CGC Recruitment CatholicCare NT via BigSplash CatholicCare NT via BigSplash CatholicCare NT via BigSplash CatholicCare NT via BigSplash National Tertiary Education Union (NTEU) via Big Splash CatholicCare NT via BigSplash CatholicCare NT via BigSplash The National Tertiary Education Union (NTEU) via Big Splash Kiss Kiss Pastizzi
salary_raw Year 1 OTE: $70,000 - $150,000+ Year 1 OTE: $70,000 - $150,000+ $55,000 - $120,000 wages and commission $43 - $96.25 p.h. + Plus accommodation & Meals $80,000 - $180,000 + Benefits $200000 - $450000 per annum $80000 - $180000 per annum $80,000 - $180,000 + Benefits $80000 - $180000 per annum $26 - $59 p.h. $65700 - $150000 per annum $65700 - $150000 per annum $300 - $700 per day $300 - $700 per day $27.5 - $65 p.a. + super on top $250 - $600 per day $350 - $850 per annum $350 - $850 per annum $80000 - $200000 per annum, Benefits: Base + car allowance + super + coms $80000 - $200000 per annum, Benefits: Base + car allowance + super + coms $40,000 - $100,000 AU$100 - AU$250 per day + training,commission $80000 - $200000 per annum, Benefits: Base + car allowance + super + coms $800 - $2000 per day $800 - $2000 per day ... $145 - $120K call/TXT Daniel Lyon 0409 125 722 138-115K $105-88K. Call/SMS Mariam 0424522052 $89-77K Mariam@ AccountantJobs.com.au $100-88K. Call/SMS Amy 0438 722 264 $107-95K Mariam@AccountantJobs.com.au $141 - 127K AU$95 - AU$95000 per annum AU$95 - AU$95000 per annum AU$95 - AU$95000 per annum $110 - $110K $110 - $110K $70 - $70k p.h. + career progression leading child S/S Grade 8 - $68,622 p.a. + super $12-140k $12-140k SCHADS Award Level 7 - $99,897 trp (including salary $90,123) Salary Packaging Option (up to an additional $15,895 p/a) SCHADS Award Level 6 - $89,850 trp (including salary $81,059) SCHADS Award Level 6 - $89,850 (including salary $81,059) SCHADS Award Level 6 - $92,547 trp (including salary $83,492) Level 6 - $94,409 to $103,497 / Level 7- $107,134 to $118,283 SCHADS Award Level 5 - $82,510 trp (including salary $74,437) SCHADS Award Level 5 - $84,989 trp (including salary $76,673 per annum) Level 5 - $85,295 to $92,219 / Level 6- $96,297 to $105,567 $45-54,999k
salary_min 70000 70000 55000 43 80000 200000 80000 80000 80000 26 65700 65700 300 300 27.5 250 350 350 80000 80000 40000 100 80000 800 800 ... 145 138 105 89 100 107 141 95 95 95 110 110 70 8 12 12 7 6 6 6 6 5 5 5 45
salary_max 150000 150000 120000 96.25 180000 450000 180000 180000 180000 59 150000 150000 700 700 65 600 850 850 200000 200000 100000 250 200000 2000 2000 ... 120000 115000 88000 77000 88000 95000 127000 95000 95000 95000 110000 110000 70000 68622 140000 140000 99897 89850 89850 92547 94409 82510 84989 85295 5.4999e+07
salary_hours 2000 2000 NaN 1 NaN 2000 2000 NaN 2000 1 2000 2000 8 8 2000 8 2000 2000 2000 2000 NaN 8 2000 8 8 ... NaN NaN NaN NaN NaN NaN NaN 2000 2000 2000 NaN NaN 1 2000 NaN NaN 2000 NaN NaN NaN NaN NaN 2000 NaN NaN
location_raw Canterbury, Christchurch, NZ Auckland, Papakura & Franklin, NZ Sydney, New South Wales, Australia Gladstone & Central QLD, AU Sydney, AU Melbourne, AU Melbourne, AU Sydney, AU Melbourne, AU ACT, Australian Capital Territory, Australia Gold Coast Mc, AU Gold Coast Mc, AU Perth, AU Perth, AU parramatta, Sydney, New South Wales, Australia Melbourne, CBD & Inner Suburbs, AU Melbourne, AU Melbourne, AU Sydney, AU Sydney, AU Bay of Plenty, New Zealand, New zealand Sydney, New South Wales, AU Sydney, AU Gunnedah, AU Gunnedah, AU ... Melbourne, CBD & Inner Suburbs, AU Perth, CBD, Inner & Western Suburbs, AU ACT, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Melbourne, CBD & Inner Suburbs, AU Brisbane, Queensland, AU Brisbane, Queensland, AU Brisbane, Queensland, AU Sydney, AU Sydney, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Melbourne, AU Melbourne, AU Melbourne, AU Darwin(Berrimah ) Northern Territory(Alice Springs) Northern Territory(Alice Springs) Darwin(Berrimah) Perth(Subiaco) Northern Territory(Malak) Darwin(Malak) Perth(Subiaco) Perth, Eastern Suburbs, AU
loc_id 1.01915e+08 1.01915e+08 1.01932e+08 1.02049e+08 1.01932e+08 1.01933e+08 1.01933e+08 1.01932e+08 1.01933e+08 8.56815e+07 1.02048e+08 1.02048e+08 1.01938e+08 1.01938e+08 1.0205e+08 8.57823e+07 1.01933e+08 1.01933e+08 1.01932e+08 1.01932e+08 8.56872e+07 1.01932e+08 1.01932e+08 1.02049e+08 1.02049e+08 ... 8.57823e+07 8.57823e+07 8.56815e+07 8.57823e+07 8.57823e+07 8.57823e+07 8.57823e+07 1.01934e+08 1.01934e+08 1.01934e+08 1.01932e+08 1.01932e+08 8.57823e+07 1.01933e+08 1.01933e+08 1.01933e+08 1.01938e+08 1.01938e+08 1.01938e+08 1.01938e+08 1.02049e+08 1.01939e+08 1.01939e+08 1.02049e+08 1.01938e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania ... Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania
loc_country New Zealand New Zealand Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia New Zealand Australia Australia Australia Australia ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_county Christchurch City Auckland Sydney Gladstone Sydney Melbourne Melbourne Sydney Melbourne None Mitchell Mitchell Perth Perth Parramatta Melbourne Melbourne Melbourne Sydney Sydney None Sydney Sydney Gunnedah Gunnedah ... Melbourne Perth None Melbourne Melbourne Melbourne Melbourne Brisbane Brisbane Brisbane Sydney Sydney Melbourne Melbourne Melbourne Melbourne None Alice Springs Alice Springs None Subiaco Darwin Darwin Subiaco Perth
loc_empire None None Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None Australia Australia Australia Australia ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_localadmin None None Sydney None Sydney Melbourne Melbourne Sydney Melbourne None None None Perth Perth None Melbourne Melbourne Melbourne Sydney Sydney None Sydney Sydney None None ... Melbourne Perth None Melbourne Melbourne Melbourne Melbourne Brisbane City Brisbane City Brisbane City Sydney Sydney Melbourne Melbourne Melbourne Melbourne Berrimah Alice Springs Alice Springs Berrimah None None None None Perth
loc_locality Christchurch Papakura Sydney None Sydney Melbourne Melbourne Sydney Melbourne None None None Perth Perth None Melbourne Melbourne Melbourne Sydney Sydney None Sydney Sydney None None ... Melbourne Perth None Melbourne Melbourne Melbourne Melbourne Brisbane City Brisbane City Brisbane City Sydney Sydney Melbourne Melbourne Melbourne Melbourne Berrimah Alice Springs Alice Springs Berrimah None Malak Malak None Perth
loc_macrocounty None None Sydney None Sydney Melbourne Melbourne Sydney Melbourne None None None Perth Perth Sydney Melbourne Melbourne Melbourne Sydney Sydney None Sydney Sydney None None ... Melbourne Perth None Melbourne Melbourne Melbourne Melbourne Brisbane Brisbane Brisbane Sydney Sydney Melbourne Melbourne Melbourne Melbourne None Alice Springs Alice Springs None Perth Darwin Darwin Perth Perth
loc_region Canterbury Region Auckland Region New South Wales Queensland New South Wales Victoria Victoria New South Wales Victoria Australian Capital Territory Victoria Victoria Western Australia Western Australia New South Wales Victoria Victoria Victoria New South Wales New South Wales Bay of Plenty Region New South Wales New South Wales New South Wales New South Wales ... Victoria Western Australia Australian Capital Territory Victoria Victoria Victoria Victoria Queensland Queensland Queensland New South Wales New South Wales Victoria Victoria Victoria Victoria Northern Territory Northern Territory Northern Territory Northern Territory Western Australia Northern Territory Northern Territory Western Australia Western Australia
processor kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest kaggle_promptcloud_listings cgcrecruitment davidsonwp davidsonwp cgcrecruitment davidsonwp kaggle_promptcloud_latest davidsonwp davidsonwp launchrecruitment launchrecruitment seek kaggle_promptcloud_listings davidsonwp davidsonwp launchrecruitment launchrecruitment kaggle_promptcloud_latest davidsonwp launchrecruitment davidsonwp davidsonwp ... kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings davidsonwp davidsonwp davidsonwp cgcrecruitment cgcrecruitment kaggle_promptcloud_listings kaggle_promptcloud_listings cgcrecruitment cgcrecruitment probono probono probono probono probono probono probono probono kaggle_promptcloud_listings
source seekau seekau seekau_2019q3 seekau CC-MAIN-2020-45 CC-MAIN-2020-16 CC-MAIN-2020-24 CC-MAIN-2020-24 CC-MAIN-2020-40 seekau_2019q3 CC-MAIN-2020-40 CC-MAIN-2020-16 CC-MAIN-2020-24 CC-MAIN-2020-40 CC-MAIN-2020-50 seekau CC-MAIN-2020-16 CC-MAIN-2020-40 CC-MAIN-2020-16 CC-MAIN-2020-40 seekau_2019q3 CC-MAIN-2020-34 CC-MAIN-2020-29 CC-MAIN-2020-45 CC-MAIN-2020-16 ... seekau seekau seekau seekau seekau seekau seekau CC-MAIN-2020-24 CC-MAIN-2020-34 CC-MAIN-2020-45 CC-MAIN-2020-34 CC-MAIN-2020-50 seekau seekau CC-MAIN-2020-24 CC-MAIN-2020-45 CC-MAIN-2020-34 CC-MAIN-2020-24 CC-MAIN-2020-34 CC-MAIN-2020-34 CC-MAIN-2020-24 CC-MAIN-2020-24 CC-MAIN-2020-34 CC-MAIN-2020-40 seekau
loc_neighbourhood None None None None NaN None None NaN None None None None None None None Melbourne CBD None None None None None None None None None ... Melbourne CBD Perth CBD None Melbourne CBD Melbourne CBD Melbourne CBD Melbourne CBD None None None NaN NaN Melbourne CBD None NaN NaN None None None None None None None None None
annual True True False False False True True False True False True True False False True False True True True True False False True False False ... False False False False False False False True True True False False False True False False True False False False False False True False False
weekly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
daily False False False False False False False False False False False False True True False True False False False False False True False True True ... False False False False False False False False False False False False False False False False False False False False False False False False False
hourly False False False True False False False False False True False False False False False False False False False False False False False False False ... False False False False False False False False False False False False True False False False False False False False False False False False False
salary_low 70000 70000 55000 43 80000 200000 80000 80000 80000 26 65700 65700 300 300 27.5 250 350 350 80000 80000 40000 100 80000 800 800 ... 145 138 105 89 100 107 141 95 95 95 110 110 70 8 12 12 7 6 6 6 6 5 5 5 45
salary_hi 150000 150000 120000 96.25 180000 450000 180000 180000 180000 59 150000 150000 700 700 65 600 850 850 200000 200000 100000 250 200000 2000 2000 ... 120000 115000 88000 77000 88000 95000 127000 95000 95000 95000 110000 110000 70000 68622 140000 140000 99897 89850 89850 92547 94409 82510 84989 85295 5.4999e+07
salary_valid True True True True True True True True True True True True True True True True True True True True True True True True True ... True True True True True True True True True True True True True True True True True True True True True True True True True
pct_salary_range 0.727273 0.727273 0.742857 0.764811 0.769231 0.769231 0.769231 0.769231 0.769231 0.776471 0.781641 0.781641 0.8 0.8 0.810811 0.823529 0.833333 0.833333 0.857143 0.857143 0.857143 0.857143 0.857143 0.857143 0.857143 ... 1.99517 1.99521 1.99523 1.99538 1.99546 1.9955 1.99556 1.996 1.996 1.996 1.996 1.996 1.996 1.99953 1.99966 1.99966 1.99972 1.99973 1.99973 1.99974 1.99975 1.99976 1.99976 1.99977 2

30 rows × 172 columns

df.loc[df.pct_salary_range > 1.5, "salary_valid"] = False

Overall Minimum Salary

%time sns.displot(df, x="salary_low", log_scale=True, kde=True)
CPU times: user 350 ms, sys: 103 ms, total: 452 ms
Wall time: 326 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bf1c00fa0>

%time sns.displot(df, x="salary_hi", log_scale=True, kde=True)
CPU times: user 379 ms, sys: 65.8 ms, total: 445 ms
Wall time: 319 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bcbecbbb0>

Above about 500k it gets suss

df[df.salary_low > 500_000].sort_values("salary_low").T
34383 32963 36900 6001 5873 4212 4138 39504 5599 3990 13992 12789 3827 380 9323 32722 34105 127 3315 4491 9064 330 3678 1657 17909 ... 60805 60404 58749 66306 61941 57673 61590 61461 61308 63620 69190 30719 22825 60435 64851 67031 56031 68308 55116 55205 54382 55609 54317 60277 56599
title Receptionist POC Receptionist POC Draftsperson UX/UI Designer Front End Developer UX/UI Designer Front End Developer Marketing and Events Coordinator Document Controller Document Controller Office Manager / Accountant Office Manager / Accountant Senior Android Engineer Senior Android Engineer Senior Android Engineer Full Stack Developer Full Stack Developer Signallers Senior Quantity Surveyor Senior Quantity Surveyor Lead Commissioning Engineer Lead Commissioning Engineer Lead Commissioning Engineer Lead Commissioning Engineer General Foreman ... Principal Structure Engineer - Up to $211K. Accelerate your Career? 12d Designer $108-85K. Great time to choose Registered Surveyors $161-128K Multiple Choices Business Services Manager $130-105K Contracts Administrator - Commercial Contracts Administrator - Construction Estimator (QS) - Commercial Construction Projects over $40M Contracts Administrator - Commercial Estimator (QS) - Commercial Construction Projects over $40M Outbound Sales Consultant - Join a Market Leader - Legal Tech Company Debt Collection Officer Corporate/Commercial Counsel 2-5 PAE- 3 month contract - Large IT Company!! Inhouse Corporate Legal Counsel (4 year PAE +) - National Property Advisory Firm Business Services Accountants. SYDNEY ROLES CT Radiographer - Regional NSW MRI Technician / MRI Radiographer Rookie GP Representative - Eastern Suburbs - multiple positions Employment and IR 2-5Yrs PQE Temporary Conveyancing Paralegal Required Estimator Civil Project Manager Contract Administrator Project Engineer Structural Drafter REVIT - Immediate Start! Maintenance Planner - HME
description Our client, a multi-service IT provider is currently seeking an experienced Receptionist for a permanent full time position. In this diverse role ... Our client, a multi-service IT provider is currently seeking an experienced Receptionist for a permanent full time position. In this diverse role ... Your new company\nHays are currently working with a reputable company based in the Canberra region. This particular company work on large scale co... My client is a large corporation with operations across the world. They have their headquarters based in Brisbane, giving you access to global pro... My client is a large corporation with operations across the world. They are currently expanding their team due to increased project work. They are... My client is a large corporation with operations across the world. They have their headquarters based in Brisbane, giving you access to global pro... My client is a large corporation with operations across the world. They are currently expanding their team due to increased project work. They are... Northern Territory PHN leads the development and coordination of an equitable, comprehensive primary health care system and an engaged health work... About the Company\nDavidson are currently working with one of the world’s largest names in wind energy. This company manufactures, installs and se... About the Company\nDavidson are currently working with one of the world’s largest names in wind energy. This company manufactures, installs and se... The Company\nProject Management Consultancy who specialise in a range of project sectors valued up to $120 Million, have an exciting and extremely... The Company\nProject Management Consultancy who specialise in a range of project sectors valued up to $120 Million, have an exciting and extremely... One of Melbourne's most desirable start-ups are looking to hire a Senior Android Developer to join their team of high performing developers.\nBein... One of Melbourne's most desirable start-ups are looking to hire a Senior Android Developer to join their team of high performing developers.\nBein... One of Melbourne's most desirable start-ups are looking to hire a Senior Android Developer to join their team of high performing developers.\nBein... Great opportunity working for a unique company, who roll out solutions across Australia before scaling globally.\n\nJoin a rapid growing organisat... Great opportunity working for a unique company, who roll out solutions across Australia before scaling globally.\n\nJoin a rapid growing organisat... Davidson is excited to be partnering with Metro Trains Melbourne to appoint four Signallers for their Network Signalling division in Melbourne.\nM... Company:\nOur Client is a multiple award winning, Australian owned, premier QS practice that is currently seeking the capabilities of an passionat... Company:\nOur Client is a multiple award winning, Australian owned, premier QS practice that is currently seeking the capabilities of an passionat... About the Company\nFounded in Urumqi, China, Goldwind is one of the world's leading wind power companies. The largest player in the wind industry ... About the Company\nFounded in Urumqi, China, Goldwind is one of the world's leading wind power companies. The largest player in the wind industry ... About the Company\nFounded in Urumqi, China, Goldwind is one of the world's leading wind power companies. The largest player in the wind industry ... About the Company\nFounded in Urumqi, China, Goldwind is one of the world's leading wind power companies. The largest player in the wind industry ... The Company\nOur client is known local Sydney builder who partners with prestigious developers delivering multi million-dollar projects across the... ... Our client is a long established successful debt recovery law firm. The firm is looking for a Debt Collection Officer to join the firm and build o... The Opportunity Our client is one of Australia’s major IT service providers who partner with large global corporations such as Microsoft, Cisco, A... The Opportunity Work with one of the largest independent professional property services firms in Australia for over 40 years. This company has wi... 18th May - 1st June Competitive hourly rate Bundall location Our client is a centrally located law firm specialising in commercial and property ma... The Opportunity This contractor have been thriving in the local market for close to forty years, in thanks to their dedication to providing outsta... The Opportunity  Dynamic. Fresh. Vivacious. Outside Ideas encapsulate ambition and spirit, from their early beginnings to their current impressive... The Opportunity With a long history in the Australian market, our client continues to grow and evolve. A quintessential Australian builder, they b... We are interested in speaking with all levels of Civil Project Engineers to work with a number of our clients on major projects here across the co...
uri https://jobs.launchrecruitment.com.au/job/100602033258906/receptionist-poc-1/ https://jobs.launchrecruitment.com.au/job/100602033258906/receptionist-poc-1/ https://www.seek.com.au/job/41362846?type=standard https://www.davidsonwp.com/job/100562133327232/ux-slash-ui-designer/ https://www.davidsonwp.com/job/100562133319740/front-end-developer-8/ https://www.davidsonwp.com/job/100562133327232/ux-slash-ui-designer/ https://www.davidsonwp.com/job/100562133319740/front-end-developer-8/ https://www.seek.com.au/job/41204953?type=standout https://www.davidsonwp.com/job/100562133297159/document-controller/ https://www.davidsonwp.com/job/100562133297159/document-controller/ https://www.cgcrecruitment.com/job/office-manager-slash-accountant-2/ https://www.cgcrecruitment.com/job/office-manager-slash-accountant-2/ https://www.davidsonwp.com/job/100562133270808/senior-android-engineer/ https://www.davidsonwp.com/job/100562133272648/senior-android-engineer-1/ https://www.davidsonwp.com/job/100562133270808/senior-android-engineer/ https://jobs.launchrecruitment.com.au/job/100602033189052/full-stack-developer/ https://jobs.launchrecruitment.com.au/job/100602033189052/full-stack-developer/ https://www.davidsonwp.com/job/100562133248138/signallers-1/ https://www.davidsonwp.com/job/100562133361033/senior-quantity-surveyor-5/ https://www.davidsonwp.com/job/100562133361033/senior-quantity-surveyor-5/ https://www.davidsonwp.com/job/100562133254581/lead-commissioning-engineer/ https://www.davidsonwp.com/job/100562133267469/lead-commissioning-engineer-1/ https://www.davidsonwp.com/job/100562133254581/lead-commissioning-engineer/ https://www.davidsonwp.com/job/100562133254581/lead-commissioning-engineer/ https://www.cgcrecruitment.com/job/general-foreman-3/ ... https://www.seek.com.au/job/36553908 https://www.seek.com.au/job/36554083 https://www.seek.com.au/job/37763876 https://www.seek.com.au/job/37210212 https://www.seek.com.au/job/36499847 https://www.seek.com.au/job/36672624 https://www.seek.com.au/job/36500052 https://www.seek.com.au/job/36499848 https://www.seek.com.au/job/36500051 https://www.seek.com.au/job/37437418 https://www.seek.com.au/job/36167378 https://www.seek.com.au/job/40102757 https://www.seek.com.au/job/40055145 https://www.seek.com.au/job/36554031 https://www.seek.com.au/job/37438072 https://www.seek.com.au/job/37596581 https://www.seek.com.au/job/37060303 https://www.seek.com.au/job/37596615 https://www.seek.com.au/job/36034602 https://www.seek.com.au/job/36029408 https://www.seek.com.au/job/36034147 https://www.seek.com.au/job/36029376 https://www.seek.com.au/job/36030406 https://www.seek.com.au/job/36554164 https://www.seek.com.au/job/36741495
view_date 2020-04-08 20:49:20+00:00 2020-07-02 01:53:50+00:00 2020-05-31 08:52:15+00:00 2020-09-18 00:45:40+00:00 2020-09-28 22:26:46+00:00 2020-04-03 12:22:01+00:00 2020-03-29 11:13:38+00:00 2020-03-28 18:53:37+00:00 2020-09-28 20:28:34+00:00 2020-03-31 20:21:49+00:00 2020-11-27 23:43:35+00:00 2020-07-13 10:52:05+00:00 2020-04-07 16:04:01+00:00 2020-06-05 08:54:21+00:00 2020-10-22 01:04:53+00:00 2020-07-03 03:29:56+00:00 2020-04-05 23:10:42+00:00 2020-05-30 21:03:15+00:00 2020-11-23 16:23:14+00:00 2020-03-28 09:43:42+00:00 2020-10-28 17:50:29+00:00 2020-05-30 20:34:13+00:00 2020-04-02 23:46:43+00:00 2020-07-14 15:46:51+00:00 2020-10-21 05:57:39+00:00 ... 2018-06-25 16:27:19 2018-06-25 16:29:02 2018-11-21 02:16:18 2018-09-13 01:28:16 2018-06-19 01:38:56 2018-07-11 04:42:55 2018-06-19 01:50:58 2018-06-19 01:52:42 2018-06-19 01:46:04 2018-10-11 01:13:02 2018-05-09 04:33:15 2019-10-07 06:55:20 2019-09-30 10:17:41 2018-06-25 16:14:43 2018-10-11 00:57:28 2018-10-31 02:56:57 2018-08-27 00:40:28 2018-10-31 02:58:30 2018-04-20 02:07:00 2018-04-20 03:39:42 2018-04-20 02:19:21 2018-04-20 03:31:50 2018-04-20 03:22:50 2018-06-25 16:14:14 2018-07-19 06:02:35
org Launch Recruitment Launch Recruitment Hays Architecture Davidson Davidson Davidson Davidson Northern Territory PHN Davidson Davidson CGC Recruitment CGC Recruitment Davidson Davidson Davidson Launch Recruitment Launch Recruitment Davidson Davidson Davidson Davidson Davidson Davidson Davidson CGC Recruitment ... ENGINEERJOBS.com.au ENGINEERJOBS.com.au SurveyorJobs.com.au AccountantJobs.com.au Gough Property & Real Estate Recruiters Gough Property & Real Estate Recruiters Gough Property & Real Estate Recruiters Gough Property & Real Estate Recruiters Gough Property & Real Estate Recruiters Gatehouse Legal Recruitment Gatehouse Legal Recruitment Gatehouse Legal Recruitment Gatehouse Legal Recruitment AccountantJobs.com.au Sigma Resourcing Pty Ltd Sigma Resourcing Pty Ltd EvansPetersen Healthcare Pty Ltd Ablethorpe Recruitment legal eagles Anna Roussos Recruitment + Advisory Anna Roussos Recruitment + Advisory Anna Roussos Recruitment + Advisory Hudson Constructive Recruitment Pty Ltd Alchemy Recruitment Consulting Pty Ltd
salary_raw $0 - $650000 per annum $0 - $650000 per annum $70,0000 - $100,000 + Superannuation $700000 per annum $700000 per annum $700000 per annum $700000 per annum $72,6640 - $80,715 pro-rata + super $750000 per annum $750000 per annum $85,0000 - $110,000 depending on experience. $85,0000 - $110,000 depending on experience. $1000000 - $1400000 per annum $1000000 - $1400000 per annum $1000000 - $1400000 per annum $0 - $1000000 per annum $0 - $1000000 per annum $1100000 per annum $1200000 per annum $1200000 per annum $1250000 per annum $1250000 per annum $1250000 per annum $1250000 per annum $130,0000 - $160,000 ... Or call/txt Roger 0418494245 in confidence Confidentially call / text Roger on 0418494245 Or Call/SMS Pieter on 0419 490 660 in Confidence Confidentially call/txt mariam Awad 0424522052 Call GREG WILL 0432 498 770 Call GREG WILL 0432 498 770 Call GREG WILL 0432 498 770 Call GREG WILL 0432 498 770 Call GREG WILL 0432 498 770 Contact Louise Hvala on 0433 332 276 Contact Meg Bennett on 0436 001 675 Call Ravi on 0437 028 897 Contact Ravi on 0437 028 897 $$ Neg + bonuses. Dial/SMS Amy 0438 722 264 ilias@sigmaresourcing.com.au 0452 525 359 ilias@sigmaresourcing.com.au 0452 525 359 Call Cathy 0477029802 to discuss 0490 832 177 Contact Jo Williams on 07 3231 1209 Contact Anna on 08 7073 6872 for further details Please call Anthony on 08 7073 6872 Please call 08 7073 6872 for further information Call Alex Jeffries 08 8223 9908 Call Jana on 08 9287 5000 for more information Call Nick - 1300 895 388
salary_min 0 0 700000 700000 700000 700000 700000 726640 750000 750000 850000 850000 1e+06 1e+06 1e+06 0 0 1.1e+06 1.2e+06 1.2e+06 1.25e+06 1.25e+06 1.25e+06 1.25e+06 1.3e+06 ... 4.18494e+08 4.18494e+08 4.19491e+08 4.24522e+08 4.32499e+08 4.32499e+08 4.32499e+08 4.32499e+08 4.32499e+08 4.33332e+08 4.36002e+08 4.37029e+08 4.37029e+08 4.38722e+08 4.52525e+08 4.52525e+08 4.7703e+08 4.90832e+08 7.32311e+08 8.70737e+08 8.70737e+08 8.70737e+08 8.8224e+08 8.92875e+08 1.3009e+09
salary_max 650000 650000 100000 NaN NaN NaN NaN 80715 NaN NaN 110000 110000 1.4e+06 1.4e+06 1.4e+06 1e+06 1e+06 NaN NaN NaN NaN NaN NaN NaN 160000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
salary_hours 2000 2000 NaN 2000 2000 2000 2000 NaN 2000 2000 NaN NaN 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
location_raw Sydney, AU Sydney, AU canberra, ACT, Australian Capital Territory, Australia Brisbane, AU Brisbane, AU Brisbane, AU Brisbane, AU darwin, Darwin, Northern Territories, Australia Canberra, AU Canberra, AU Sydney, AU Sydney, AU Melbourne, AU Melbourne, AU Melbourne, AU Sydney, AU Sydney, AU Melbourne, AU Melbourne, AU Melbourne, AU Sydney, AU Melbourne, AU Sydney, AU Sydney, AU Sydney, AU ... Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Brisbane, AU Brisbane, AU Sunshine Coast, AU Gold Coast, AU Gold Coast, AU Melbourne, CBD & Inner Suburbs, AU Melbourne, CBD & Inner Suburbs, AU Melbourne, Victoria, Australia Melbourne, Victoria, Australia Sydney, CBD, Inner West & Eastern Suburbs, AU Tamworth & North West NSW, AU Perth, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Melbourne, CBD & Inner Suburbs, AU Gold Coast, AU Adelaide, AU Adelaide, AU Adelaide, AU Adelaide, AU Adelaide, AU Mackay & Coalfields, AU
loc_id 1.01932e+08 1.01932e+08 1.37695e+09 1.01934e+08 1.01934e+08 1.01934e+08 1.01934e+08 NaN 8.56815e+07 8.56815e+07 1.01932e+08 1.01932e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01932e+08 1.01932e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01932e+08 1.01933e+08 1.01932e+08 1.01932e+08 1.01932e+08 ... 8.57823e+07 8.57823e+07 8.57823e+07 8.57823e+07 1.01934e+08 1.01934e+08 1.02049e+08 1.02049e+08 1.02049e+08 8.57823e+07 8.57823e+07 1.01933e+08 1.01933e+08 8.57823e+07 1.01932e+08 1.01938e+08 8.57823e+07 8.57823e+07 1.02049e+08 1.01936e+08 1.01936e+08 1.01936e+08 1.01936e+08 1.01936e+08 1.01935e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania Oceania None Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania ... Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania
loc_country Australia Australia Australia Australia Australia Australia Australia None Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_county Sydney Sydney None Brisbane Brisbane Brisbane Brisbane None None None Sydney Sydney Melbourne Melbourne Melbourne Sydney Sydney Melbourne Melbourne Melbourne Sydney Melbourne Sydney Sydney Sydney ... Melbourne Melbourne Melbourne Melbourne Brisbane Brisbane Sunshine Coast Gold Coast Gold Coast Melbourne Melbourne Melbourne Melbourne Melbourne Tamworth Regional Perth Melbourne Melbourne Gold Coast Adelaide Adelaide Adelaide Adelaide Adelaide Mackay
loc_empire Australia Australia Australia Australia Australia Australia Australia None Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_localadmin Sydney Sydney None Brisbane City Brisbane City Brisbane City Brisbane City None None None Sydney Sydney Melbourne Melbourne Melbourne Sydney Sydney Melbourne Melbourne Melbourne Sydney Melbourne Sydney Sydney Sydney ... Melbourne Melbourne Melbourne Melbourne Brisbane City Brisbane City None None None Melbourne Melbourne Melbourne Melbourne Melbourne Tamworth Perth Melbourne Melbourne None Adelaide Adelaide Adelaide Adelaide Adelaide Mackay
loc_locality Sydney Sydney None Brisbane City Brisbane City Brisbane City Brisbane City None None None Sydney Sydney Melbourne Melbourne Melbourne Sydney Sydney Melbourne Melbourne Melbourne Sydney Melbourne Sydney Sydney Sydney ... Melbourne Melbourne Melbourne Melbourne Brisbane City Brisbane City None None None Melbourne Melbourne Melbourne Melbourne Melbourne Tamworth Perth Melbourne Melbourne None Adelaide Adelaide Adelaide Adelaide Adelaide Mackay
loc_macrocounty Sydney Sydney Canberra Brisbane Brisbane Brisbane Brisbane None None None Sydney Sydney Melbourne Melbourne Melbourne Sydney Sydney Melbourne Melbourne Melbourne Sydney Melbourne Sydney Sydney Sydney ... Melbourne Melbourne Melbourne Melbourne Brisbane Brisbane Sunshine Coast Gold Coast Gold Coast Melbourne Melbourne Melbourne Melbourne Melbourne None Perth Melbourne Melbourne Gold Coast Adelaide Adelaide Adelaide Adelaide Adelaide None
loc_region New South Wales New South Wales Australian Capital Territory Queensland Queensland Queensland Queensland None Australian Capital Territory Australian Capital Territory New South Wales New South Wales Victoria Victoria Victoria New South Wales New South Wales Victoria Victoria Victoria New South Wales Victoria New South Wales New South Wales New South Wales ... Victoria Victoria Victoria Victoria Queensland Queensland Queensland Queensland Queensland Victoria Victoria Victoria Victoria Victoria New South Wales Western Australia Victoria Victoria Queensland South Australia South Australia South Australia South Australia South Australia Queensland
processor launchrecruitment launchrecruitment seek davidsonwp davidsonwp davidsonwp davidsonwp seek davidsonwp davidsonwp cgcrecruitment cgcrecruitment davidsonwp davidsonwp davidsonwp launchrecruitment launchrecruitment davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp cgcrecruitment ... kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest kaggle_promptcloud_latest kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings
source CC-MAIN-2020-16 CC-MAIN-2020-29 CC-MAIN-2020-24 CC-MAIN-2020-40 CC-MAIN-2020-40 CC-MAIN-2020-16 CC-MAIN-2020-16 CC-MAIN-2020-16 CC-MAIN-2020-40 CC-MAIN-2020-16 CC-MAIN-2020-50 CC-MAIN-2020-29 CC-MAIN-2020-16 CC-MAIN-2020-24 CC-MAIN-2020-45 CC-MAIN-2020-29 CC-MAIN-2020-16 CC-MAIN-2020-24 CC-MAIN-2020-50 CC-MAIN-2020-16 CC-MAIN-2020-45 CC-MAIN-2020-24 CC-MAIN-2020-16 CC-MAIN-2020-29 CC-MAIN-2020-45 ... seekau seekau seekau seekau seekau seekau seekau seekau seekau seekau seekau seekau_2019q3 seekau_2019q3 seekau seekau seekau seekau seekau seekau seekau seekau seekau seekau seekau seekau
loc_neighbourhood None None None None None None None None None None NaN NaN None None None None None None None None None None None None NaN ... Melbourne CBD Melbourne CBD Melbourne CBD Melbourne CBD None None None None None Melbourne CBD Melbourne CBD None None Melbourne CBD None None Melbourne CBD Melbourne CBD None None None None None None None
annual True True False True True True True False True True False False True True True True True True True True True True True True False ... False False False False False False False False False False False False False False False False False False False False False False False False False
weekly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
daily False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
hourly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
salary_low 650000 650000 700000 700000 700000 700000 700000 726640 750000 750000 850000 850000 1e+06 1e+06 1e+06 1e+06 1e+06 1.1e+06 1.2e+06 1.2e+06 1.25e+06 1.25e+06 1.25e+06 1.25e+06 1.3e+06 ... 4.18494e+08 4.18494e+08 4.19491e+08 4.24522e+08 4.32499e+08 4.32499e+08 4.32499e+08 4.32499e+08 4.32499e+08 4.33332e+08 4.36002e+08 4.37029e+08 4.37029e+08 4.38722e+08 4.52525e+08 4.52525e+08 4.7703e+08 4.90832e+08 7.32311e+08 8.70737e+08 8.70737e+08 8.70737e+08 8.8224e+08 8.92875e+08 1.3009e+09
salary_hi NaN NaN 100000 NaN NaN NaN NaN 80715 NaN NaN 110000 110000 1.4e+06 1.4e+06 1.4e+06 NaN NaN NaN NaN NaN NaN NaN NaN NaN 160000 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
salary_valid True True False True True True True False True True False False True True True True True True True True True True True True False ... True True True True True True True True True True True True True True True True True True True True True True True True True
pct_salary_range NaN NaN -1.5 NaN NaN NaN NaN -1.6001 NaN NaN -1.54167 -1.54167 0.333333 0.333333 0.333333 NaN NaN NaN NaN NaN NaN NaN NaN NaN -1.56164 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

30 rows × 169 columns

Below 15 it’s mostly garbage

df[df.salary_low < 15].sort_values("salary_low", ascending=False).T
22495 70099 33446 56590 4756 35215 34908 70436 34342 27168 35941 40049 33740 32932 60928 60179 18705 12027 10360 34056 35491 58947 40428 54330 36064 ... 21332 32918 34321 21477 38223 53332 20340 60406 73404 62523 55618 71605 72094 72335 20251 60471 30895 53743 57695 65419 65418 64792 59921 60391 36538
title Fundraising and Support Officer Apprentice Gardener Lifecycle Marketing Manager Project Engineer - Substations C# .NET Software Developer Direct Product Manager - Insurance Lifecycle Marketing Manager Junior Java Software Developer Executive Manager of Product and Services Senior Test Analyst - 12m Fixed Term Direct Product Manager - Insurance Business Operations Manager Direct Product Manager - Insurance Executive Manager of Product and Services Diplomatic Safety Assurance and Audit Leader Sponsorship & Events Producer Senior Tunnel Engineer Senior Tunnel Engineer C# .NET Software Developer Test post from idibu Test post from idibu Customer Support Team Leader Refrigeration Apprenticeship Looking for a 1st or 2nd year Landscape Apprentice Fulfillment Centre Operations Manager - Night Shifts ... Looking for female cleaner and cook SAP Customer Management SAP Customer Management Graduate Accountant Trainee Internship 3 months Behaviour Support Practitioner Senior ServiceNow Technical Consultant / Developer Living Skills Support Worker Senior Occupational Therapist - General Medicine and Surgery Executive Director - People & Performance Air Track Driller - Contract role Light Vehicle Fitter - Mt Morgans Chief Engineer - Department of Planning, Transport and Infrastructure Chief Engineer - Department of Planning, Transport and Infrastructure Chief Engineer - Department of Planning, Transport and Infrastructure DFV Residential Support Worker Senior Manager - Product Communications Cadet Program 2020 - Information Technology Stream, Sydney Construction Lawyer Business Analyst Project Lawyer Project Lawyer VR GP - Melbourne ServiceNow Professional? Looking For a New Role? Hospital Physiotherapist - Rural Generalist - permanent - July/August start date Animal Attendant
description About Canteen We help young people cope with cancer in their family. Through CanTeen, they learn to explore and deal with their feelings about can... Our Client\nBased in the CBD, our client is a global eCommerce provider and a household name for consumers to sell and purchase online. They provi... My client is looking for experienced .NET Developers to join their agile environment working on multiple complex systems.\nWork on high traffic, p... Direct Product Manager required to work on a large Insurance integration. This role requires a Product Manager with Insurance experience to drive,... Our Client\nBased in the CBD, our client is a global eCommerce provider and a household name for consumers to sell and purchase online. They provi... A national Telco company has a senior position available for an Executive Manager to lead the end to end product management of their key products ... H2R Technology has an amazing opportunity for a Senior Test Analyst to join a dynamic team responsible for providing testing solutions for everyth... Direct Product Manager required to work on a large Insurance integration. This role requires a Product Manager with Insurance experience to drive,... ​​​​​​ About Us\nWebcentral Group is Australia’s largest full-service digital services partner for small and medium businesses. We’ve supported th... Direct Product Manager required to work on a large Insurance integration. This role requires a Product Manager with Insurance experience to drive,... A national Telco company has a senior position available for an Executive Manager to lead the end to end product management of their key products ... The Company\nWith offices across the globe, this top tier engineering design consultancy are at the forefront of design. They have an outstanding... The Company\nWith offices across the globe, this top tier engineering design consultancy are at the forefront of design. They have an outstanding... My client is looking for experienced .NET Developers to join their agile environment working on multiple complex systems.\nWork on high traffic, p... This is a test post from idibu\n\nThis is a test post from idibu\nThis is a test post from idibu\nThis is a test post from idibu\nThis is a test p... This is a test post from idibu\n\nThis is a test post from idibu\nThis is a test post from idibu\nThis is a test post from idibu\nThis is a test p... Ford and Doonan Air Conditioning Bunbury are seeking a full time apprentice refrigeration mechanic to add to our team.\nPrinciple Duties/ Responsi... -Our company specializes in all aspects of Residential landscaping projects. -You will be required to have your drivers license and vehicle. -Yo... My client is seeking an experienced, Operations Manager to join our Customer Fulfillment team in Dandenong\nKey points of interest:\n\nNight shift... ... We are busy couple. Looking for someone female from Bangladeshi India Nepal or Pakistani to clean our unit 3 days every week and helping cooking I... SAP Customer Management – SAP CRM – SAP IS-U – 12-month initial contract\nThis is a key role is a large SAP implementation and Business Transforma... SAP Customer Management – SAP CRM – SAP IS-U – 12-month initial contract\nThis is a key role is a large SAP implementation and Business Transforma... We are a Bookkeeping practice assist small and medium clients around Australia who use could accounting software such as Xero, MYOB and QBO. Due t... We believe : Everyone belongs\nAbout us\nFor almost 30 years, Interchange has supported West Australians with disability to achieve their goals th... About the role\n\nCasual positions available\n\nSutherland Shire Location\n\nSCHCADS Level 2.1 – $34.17 hourly rate inclusive of casual loading\n\... Opportunity to work with a diverse and talented team to set and deliver the people agenda\nOngoing, full-time role\nFlexible NSW location\nTRP fro... Macmahon is a leading Australian contract mining company with projects throughout Australia and South East Asia. Delivering a comprehensive range ... Deliver Expert Advice | Major Infrastructure Projects | F/T or P/T\nOur client, the Department of Planning, Transport and Infrastructure plays a c... Deliver Expert Advice | Major Infrastructure Projects | F/T or P/T\nOur client, the Department of Planning, Transport and Infrastructure plays a c... Deliver Expert Advice | Major Infrastructure Projects | F/T or P/T\nOur client, the Department of Planning, Transport and Infrastructure plays a c... About the role\nThe Opportunity\nWe currently have a part-time opportunity for 12 months for a DFV Residential Support Worker to provide crisis re... Applications are now open for our 2020 Cadet Program! Are you ready to grow your career and take on new challenges?  Join us!  Right now we’re del... The Firm This is one of the largest firms Australia-wide in terms of size, yet they continue to experience unprecedented growth. You will be invol... The Royal Society for Prevention of Cruelty to Animals (RSPCA) NSW is Australia's pre-eminent animal welfare organisation. We provide a strong voi...
uri https://www.seek.com.au/job/39856340 https://www.seek.com.au/job/37563482 https://jobs.launchrecruitment.com.au/job/100602033360111/lifecycle-marketing-manager/ https://www.seek.com.au/job/36740858 https://www.davidsonwp.com/job/c-number-net-software-developer-1/ https://jobs.launchrecruitment.com.au/job/100602033391109/direct-product-manager-insurance/ https://jobs.launchrecruitment.com.au/job/100602033360111/lifecycle-marketing-manager/ https://www.seek.com.au/job/37563519 https://jobs.launchrecruitment.com.au/job/100602033250174/executive-manager-of-product-and-services/ https://www.seek.co.nz/job/40236720 https://jobs.launchrecruitment.com.au/job/100602033391109/direct-product-manager-insurance/ https://www.seek.com.au/job/50224723?type=standout https://jobs.launchrecruitment.com.au/job/100602033391109/direct-product-manager-insurance/ https://jobs.launchrecruitment.com.au/job/100602033250174/executive-manager-of-product-and-services/ https://www.seek.com.au/job/36500995 https://www.seek.com.au/job/36554264 https://www.cgcrecruitment.com/job/senior-tunnel-engineer/ https://www.cgcrecruitment.com/job/senior-tunnel-engineer/ https://www.davidsonwp.com/job/c-number-net-software-developer-1/ https://jobs.launchrecruitment.com.au/job/test-post-from-idibu/ https://jobs.launchrecruitment.com.au/job/test-post-from-idibu/ https://www.seek.com.au/job/37751145 https://www.seek.com.au/job/50696090?type=standard https://www.seek.com.au/job/36031584 https://jobs.launchrecruitment.com.au/job/fulfillment-centre-operations-manager-night-shifts/ ... https://www.gumtree.com.au/s-ad/lakemba/other/looking-for-female-cleaner-and-cook/1248628669 https://jobs.launchrecruitment.com.au/job/100602033243699/sap-customer-management/ https://jobs.launchrecruitment.com.au/job/100602033243699/sap-customer-management/ https://www.gumtree.com.au/s-ad/hebersham/bookkeeping-small-practice-accounting/graduate-accountant-trainee-internship-3-months/1259904626 https://www.seek.com.au/job/50951351?type=standout https://www.seek.com.au/job/37116326 https://probonoaustralia.com.au/jobs/2020/03/living-skills-support-worker/ https://www.seek.com.au/job/36552442 https://iworkfor.nsw.gov.au/job/executive-director-people-performance-200494 https://www.seek.com.au/job/36789249 https://www.seek.com.au/job/36029884 https://www.engineeringjobs.com.au/job/chief-engineer-department-of-planning-transport-and-infrastructure/ https://www.engineeringjobs.com.au/job/chief-engineer-department-of-planning-transport-and-infrastructure/ https://www.engineeringjobs.com.au/job/chief-engineer-department-of-planning-transport-and-infrastructure/ https://probonoaustralia.com.au/jobs/2020/02/dfv-residential-support-worker/ https://www.seek.com.au/job/36554586 https://www.seek.com.au/job/40092108 https://www.seek.com.au/job/36226243 https://www.seek.com.au/job/36673983 https://www.seek.com.au/job/36749366 https://www.seek.com.au/job/36749353 https://www.seek.com.au/job/37438675 https://www.seek.com.au/job/36551707 https://www.seek.com.au/job/36551261 https://www.seek.com.au/job/41348948?type=standout
view_date 2019-09-04 08:19:23 2018-10-26 04:32:05 2020-07-16 05:44:09+00:00 2018-07-19 06:10:01 2020-04-02 23:30:16+00:00 2020-04-05 23:32:21+00:00 2020-04-09 15:42:31+00:00 2018-10-26 04:46:59 2020-04-07 00:39:07+00:00 2019-10-26 11:33:44 2020-09-29 17:32:37+00:00 2020-08-05 22:08:45+00:00 2020-07-08 12:44:57+00:00 2020-07-05 17:07:59+00:00 2018-06-19 01:36:16 2018-06-25 16:07:24 2020-10-27 22:21:39+00:00 2020-06-05 16:21:23+00:00 2020-10-24 00:31:19+00:00 2020-07-05 17:04:34+00:00 2020-04-07 00:35:49+00:00 2018-11-21 02:14:29 2020-10-24 09:29:22+00:00 2018-04-20 02:55:48 2020-09-29 01:24:17+00:00 ... 2020-05-24 23:19:10+00:00 2020-07-05 06:05:36+00:00 2020-04-04 06:30:27+00:00 2020-12-03 08:58:08+00:00 2020-11-29 06:17:59+00:00 2018-09-02 00:33:45 2020-03-31 05:13:59+00:00 2018-06-25 17:14:28 2020-07-04 09:05:56+00:00 2018-07-24 08:35:06 2018-04-20 03:27:20 2020-07-05 20:47:04+00:00 2020-03-30 09:12:28+00:00 2020-09-26 22:02:48+00:00 2020-03-29 07:41:19+00:00 2018-06-25 16:26:41 2019-10-06 06:56:57 2018-05-16 03:39:19 2018-07-11 04:06:23 2018-07-19 02:03:59 2018-07-19 02:25:19 2018-10-11 00:57:01 2018-06-25 17:36:01 2018-06-25 17:31:21 2020-06-01 16:02:47+00:00
org CanTeen Treetops garden maintenance Launch Recruitment Metro Trains Melbourne Davidson Launch Recruitment Launch Recruitment The Citadel Group Launch Recruitment H2R Consulting Launch Recruitment Webcentral Group Launch Recruitment Launch Recruitment Safety Australia Group Screenwest Australia Limited CGC Recruitment CGC Recruitment Davidson Launch Recruitment Launch Recruitment Johns Lyng Group Ford and Doonan Air Conditioning Bunbury BDW Landscapes Launch Recruitment ... None Launch Recruitment Launch Recruitment None Interchange Inc. GMT People St Vincent De Paul Society Alfred Health People Performance & Culture Taurus Recruitment Macmahon Contractors Stillwell Management Consultants Stillwell Management Consultants Stillwell Management Consultants Open Support GM Holden Transport for NSW Naiman Clarke Michael Page Technology Naiman Clarke Naiman Clarke Global Medics Australia Washington Frank Allied Health RSPCA NSW
salary_raw Salary + Super | Full time contract til 13 Dec 19 $12.75 P/H 12 month contract 12 month, fixed-term contract 12 Mth Fixed Term - Salary Based 12 month contract 12 month contract Excellent rates!\n12 month contract 12-Month Contract 12 Month Fixed Term Contract 12 month contract Competitive Package + 12-month cover 12 month contract 12-Month Contract Attractive Rate - 12 month contract and may extend 12 month fixed term contract $12-140k $12-140k 12 Mth Fixed Term - Salary Based $11 - $111 per annum $11 - $111 per annum 11 Month Contract with Career Growth Opportunities $10 - $14.99 per hour $10 - $14.99 per hour Hourly rate, 4 day weeks, Shifts 9.5 hours per day ... 3 Or 4 Hours 3 year Transformation Project 3 year Transformation Project After completion of 3 months SCHADS award Level 3-4 3 months initially CHCADS Level 2.1 - $34.17 hourly rate inclusive of casual loading Occupational Therapist Grade 2 or 3 PSSE Band 2 Short term contract approx 2 months. Mt Morgans Gold Mine Project; 2:1 Roster SAES 1 Level SAES 1 Level SAES 1 Level SCHADS Level 1 1 RDO a month. On-site Gym. Discount vehicles Transport Grade 1 $51,666 p.a. + super (prorata) Tier 1 team! Growth role! 1-1 Tier 1 training + relocation package Tier 1 training + relocation package Up to $1 p.a. Up to $1 p.a. Grade 1 or Grade 2 Grade 1
salary_min 13 12.75 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 11 11 11 10 10 9.5 ... 3 3 3 3 3 3 2.1 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1
salary_max NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 140000 140000 NaN 111 111 NaN 14.99 14.99 NaN ... NaN NaN NaN NaN 4 NaN 34.17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN NaN
salary_hours NaN 1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2000 2000 NaN 1 1 1 ... NaN 2000 2000 NaN NaN NaN 1 NaN NaN NaN NaN NaN NaN NaN NaN NaN 2000 NaN NaN NaN NaN 2000 2000 NaN NaN
location_raw Sydney, New South Wales, Australia Sydney, North West & Hills District, AU Sydney, AU Melbourne, Bayside & South Eastern Suburbs, AU Melbourne CBD, Victoria, AU Sydney, AU Sydney, AU ACT, AU North Sydney, AU Wellington, New Zealand, New zealand Sydney, AU melbourne, Melbourne, Victoria, Australia Sydney, AU North Sydney, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Perth, CBD, Inner & Western Suburbs, AU Melbourne, AU Melbourne, AU Melbourne CBD, Victoria, AU Sydney, Nova Scotia, CA Sydney, Nova Scotia, CA Sydney, Parramatta & Western Suburbs, AU bunbury, Bunbury & South West, Western Australia, Australia Melbourne, CBD & Inner Suburbs, AU Melbourne, AU ... Lakemba, Lakemba New South Wales, Australia Sydney, AU Sydney, AU 54 Stevenage rd hebersham perth, Perth, Western Australia, Australia Melbourne, CBD & Inner Suburbs, AU NSW Regional(Sutherland ) Melbourne, Eastern Suburbs, AU Statewide Lismore & Far North Coast, AU Kalgoorlie, Goldfields & Esperance, AU Adelaide, AU Adelaide, AU Adelaide, AU Sydney(South West Sydney) Melbourne, CBD & Inner Suburbs, AU Sydney, New South Wales, Australia Sydney, CBD, Inner West & Eastern Suburbs, AU Melbourne, Eastern Suburbs, AU Perth, CBD, Inner & Western Suburbs, AU Brisbane, CBD & Inner Suburbs, AU Melbourne, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Melbourne, CBD & Inner Suburbs, AU yagoona, Sydney, New South Wales, Australia
loc_id 1.01932e+08 1.01932e+08 1.01932e+08 1.01933e+08 8.57823e+07 1.01932e+08 1.01932e+08 8.56815e+07 1.02049e+08 8.56872e+07 1.01932e+08 1.01933e+08 1.01932e+08 1.02049e+08 8.57823e+07 8.57823e+07 1.01933e+08 1.01933e+08 8.57823e+07 NaN NaN 1.01932e+08 1.01937e+08 8.57823e+07 1.01933e+08 ... 1.01931e+08 1.01932e+08 1.01932e+08 1.01931e+08 1.01938e+08 8.57823e+07 NaN 1.01933e+08 8.56815e+07 1.02079e+08 1.02049e+08 1.01936e+08 1.01936e+08 1.01936e+08 1.01932e+08 8.57823e+07 1.01932e+08 8.57823e+07 1.01933e+08 8.57823e+07 8.57823e+07 1.01933e+08 8.57823e+07 8.57823e+07 1.01932e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania None None Oceania Oceania Oceania Oceania ... Oceania Oceania Oceania Oceania Oceania Oceania None Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania
loc_country Australia Australia Australia Australia Australia Australia Australia Australia Australia New Zealand Australia Australia Australia Australia Australia Australia Australia Australia Australia None None Australia Australia Australia Australia ... Australia Australia Australia Australia Australia Australia None Australia Australia New Zealand Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_county Sydney Sydney Sydney Melbourne Melbourne Sydney Sydney None North Sydney None Sydney Melbourne Sydney North Sydney Melbourne Perth Melbourne Melbourne Melbourne None None Sydney Bunbury Melbourne Melbourne ... Canterbury Sydney Sydney Blacktown Perth Melbourne None Melbourne None Far North District Esperance Adelaide Adelaide Adelaide Sydney Melbourne Sydney Melbourne Melbourne Perth Melbourne Melbourne Melbourne Melbourne Bankstown
loc_empire Australia Australia Australia Australia Australia Australia Australia Australia Australia None Australia Australia Australia Australia Australia Australia Australia Australia Australia None None Australia Australia Australia Australia ... Australia Australia Australia Australia Australia Australia None Australia Australia None Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_localadmin Sydney Sydney Sydney Melbourne Melbourne Sydney Sydney None None None Sydney Melbourne Sydney None Melbourne Perth Melbourne Melbourne Melbourne None None Sydney Bunbury Melbourne Melbourne ... Lakemba Sydney Sydney Hebersham Perth Melbourne None Melbourne None None None Adelaide Adelaide Adelaide Sydney Melbourne Sydney Melbourne Melbourne Perth Melbourne Melbourne Melbourne Melbourne Yagoona
loc_locality Sydney Sydney Sydney Melbourne Melbourne Sydney Sydney None None None Sydney Melbourne Sydney None Melbourne Perth Melbourne Melbourne Melbourne None None Sydney Bunbury Melbourne Melbourne ... Lakemba Sydney Sydney Hebersham Perth Melbourne None Melbourne None None None Adelaide Adelaide Adelaide Sydney Melbourne Sydney Melbourne Melbourne Perth Melbourne Melbourne Melbourne Melbourne Yagoona
loc_macrocounty Sydney Sydney Sydney Melbourne Melbourne Sydney Sydney None Sydney None Sydney Melbourne Sydney Sydney Melbourne Perth Melbourne Melbourne Melbourne None None Sydney Bunbury Melbourne Melbourne ... Sydney Sydney Sydney Sydney Perth Melbourne None Melbourne None None None Adelaide Adelaide Adelaide Sydney Melbourne Sydney Melbourne Melbourne Perth Melbourne Melbourne Melbourne Melbourne Sydney
loc_region New South Wales New South Wales New South Wales Victoria Victoria New South Wales New South Wales Australian Capital Territory New South Wales Wellington Region New South Wales Victoria New South Wales New South Wales Victoria Western Australia Victoria Victoria Victoria None None New South Wales Western Australia Victoria Victoria ... New South Wales New South Wales New South Wales New South Wales Western Australia Victoria None Victoria New South Wales Northland Region Western Australia South Australia South Australia South Australia New South Wales Victoria New South Wales Victoria Victoria Western Australia Victoria Victoria Victoria Victoria New South Wales
processor kaggle_promptcloud_latest kaggle_promptcloud_listings launchrecruitment kaggle_promptcloud_listings davidsonwp launchrecruitment launchrecruitment kaggle_promptcloud_listings launchrecruitment kaggle_promptcloud_latest launchrecruitment seek launchrecruitment launchrecruitment kaggle_promptcloud_listings kaggle_promptcloud_listings cgcrecruitment cgcrecruitment davidsonwp launchrecruitment launchrecruitment kaggle_promptcloud_listings seek kaggle_promptcloud_listings launchrecruitment ... gumtree launchrecruitment launchrecruitment gumtree seek kaggle_promptcloud_listings probono kaggle_promptcloud_listings iworkfornsw kaggle_promptcloud_listings kaggle_promptcloud_listings engineeringjobs engineeringjobs engineeringjobs probono kaggle_promptcloud_listings kaggle_promptcloud_latest kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings seek
source seekau_2019q3 seekau CC-MAIN-2020-29 seekau CC-MAIN-2020-16 CC-MAIN-2020-16 CC-MAIN-2020-16 seekau CC-MAIN-2020-16 seekau_2019q3 CC-MAIN-2020-40 CC-MAIN-2020-34 CC-MAIN-2020-29 CC-MAIN-2020-29 seekau seekau CC-MAIN-2020-45 CC-MAIN-2020-24 CC-MAIN-2020-45 CC-MAIN-2020-29 CC-MAIN-2020-16 seekau CC-MAIN-2020-45 seekau CC-MAIN-2020-40 ... CC-MAIN-2020-24 CC-MAIN-2020-29 CC-MAIN-2020-16 CC-MAIN-2020-50 CC-MAIN-2020-50 seekau CC-MAIN-2020-16 seekau CC-MAIN-2020-29 seekau seekau CC-MAIN-2020-29 CC-MAIN-2020-16 CC-MAIN-2020-40 CC-MAIN-2020-16 seekau seekau_2019q3 seekau seekau seekau seekau seekau seekau seekau CC-MAIN-2020-24
loc_neighbourhood None None None None Melbourne CBD None None None None None None None None None Melbourne CBD Perth CBD NaN NaN Melbourne CBD None None None None Melbourne CBD None ... None None None None None Melbourne CBD None None NaN None None None None None None Melbourne CBD None Melbourne CBD None Perth CBD Melbourne CBD None Melbourne CBD Melbourne CBD None
annual False False False False False False False False False False False False False False False False False False False True True False False False False ... False True True False False False False False False False False False False False False False True False False False False True True False False
weekly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
daily False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
hourly False True False False False False False False False False False False False False False False False False False False False False True True True ... False False False False False False True False False False False False False False False False False False False False False False False False False
salary_low 13 12.75 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 11 11 11 10 10 9.5 ... 3 3 3 3 3 3 2.1 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1
salary_hi NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 140000 140000 NaN 111 111 NaN 14.99 14.99 NaN ... NaN NaN NaN NaN 4 NaN 34.17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN NaN
salary_valid True True True True True True True True True True True True True True True True False False True False False True True True True ... True True True True True True False True True True True True True True True True True True True True True True True True True
pct_salary_range NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1.99966 1.99966 NaN 1.63934 1.63934 NaN 0.39936 0.39936 NaN ... NaN NaN NaN NaN 0.285714 NaN 1.7684 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 NaN NaN NaN NaN NaN NaN

30 rows × 127 columns

SALARY_MIN_AUD = 15
SALARY_MAX_AUD = 500_000
df.loc[df.salary_low < SALARY_MIN_AUD, "salary_valid"] = False
df.loc[df.salary_low > SALARY_MAX_AUD, "salary_valid"] = False

Yearly

%time sns.displot(df[df.annual], x="salary_low", log_scale=True, kde=True)
CPU times: user 629 ms, sys: 69.1 ms, total: 698 ms
Wall time: 593 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bc9f14ac0>

Most of these are data mistakes

SALARY_ANNUAL_MIN_AUD = 20000
df[(df.salary_low < SALARY_ANNUAL_MIN_AUD) & df.annual].sort_values("salary_low", ascending=False).T
10461 8542 10890 62274 3696 1673 9121 7153 6617 26908 6616 6561 4555 2269 10082 6553 979 61982 9210 19168 20004 4493 947 10047 10017 ... 70814 66290 24791 31959 69580 62304 56684 34056 35491 66166 20657 32237 20630 54428 20658 68051 68537 54476 61120 20837 32918 34321 59921 64792 30895
title Director of Client Services / Financial Controller Safety Systems Engineer Safety Systems Engineer Digital Success Consultant - Education & Online Learning Senior Project Manager - Developer, Construction Senior Project Manager - Developer, Construction Senior Project Manager - Developer, Construction Installation Supervisor (5months) Technical Project Manager 4 Assurance Mgrs- 6 Month Max Term contracts - $125k package Manager, Executive Services (Chief of Staff) Executive Manager Manager, Executive Services (Chief of Staff) Manager, Executive Services (Chief of Staff) Manager, Executive Services (Chief of Staff) Executive Manager Manager, Executive Services (Chief of Staff) Systems / DevOps Engineer - MS Azure skills required PMO Analyst Clinical Educator Solicitor for NSW and Tasmania BI Specialist BI Specialist BI Specialist BI Specialist ... Customer Care Representative Customer Servce Officer EOI - General Laborers Required Electrical Trade Assistant Experienced Civil Workers Machine op / Forklift driver Traffic Controllers Test post from idibu Test post from idibu Crew Leader Lead Practitioner Children & Family Services Registered Nurse Case Manager Community Mental Health Lead .Net Developer Men’s Behaviour Change Program Facilitators x 2 Tyre Fitting Traineeship - Hawthorn Tyre Fitting Traineeship - Chadstone 2nd or 3rd Year Carpentry Apprenticeship Gas Supply Apprenticeships - Melb Lawyer – Aboriginal Families Practice Team SAP Customer Management SAP Customer Management ServiceNow Professional? Looking For a New Role? VR GP - Melbourne Cadet Program 2020 - Information Technology Stream, Sydney
description About the Company\nMy client is a bespoke outsourced finance function for small to medium enterprises which includes reporting, virtual CFO functi... About the Company\nDavidson Technology have partnered with a multi-national defence, security and aerospace company who are building one of the wo... About the Company\nDavidson Technology have partnered with a multi-national defence, security and aerospace company who are building one of the wo... About the Company\n\nIndustrial developer which develops and manages real estate on behalf of key clients\nPublicly listed, highly regarded global... About the Company\n\nIndustrial developer which develops and manages real estate on behalf of key clients\nPublicly listed, highly regarded global... About the Company\n\nIndustrial developer which develops and manages real estate on behalf of key clients\nPublicly listed, highly regarded global... The Company\nDavidson is delighted to be partnering with Goldwind, one of the world's leading wind power companies in their search for an Installa... About the Company\nOur client is a multinational construction and infrastructure company they help people, clients, and communities do great thing... This leading bank is seeking 4 Assurance professionals with excellent stakeholder management skills to join their Line 2 Assurance team on 6 month... A unique and rewarding opportunity has become available to join a growing, evolving and well-respected Not for Profit organisation. You will step ... A unique and rewarding opportunity has become available to join a growing, evolving and well-respected Not for Profit organisation. You will step ... A unique and rewarding opportunity has become available to join a growing, evolving and well-respected Not for Profit organisation. You will step ... A unique and rewarding opportunity has become available to join a growing, evolving and well-respected Not for Profit organisation. You will step ... A unique and rewarding opportunity has become available to join a growing, evolving and well-respected Not for Profit organisation. You will step ... A unique and rewarding opportunity has become available to join a growing, evolving and well-respected Not for Profit organisation. You will step ... A unique and rewarding opportunity has become available to join a growing, evolving and well-respected Not for Profit organisation. You will step ... About the Company\nOne of Ausrtalia's largest professional membership organisations.\nAbout the Role\nThis role has two aspects to it...\n\nTo hel... About the role\n\nNFP Salary Packaging options available\nLeading mental health organisation\nParkville location with onsite parking + close to pu... About the role\nSUMMARY\n\nMust have or soon will have at least 3 years post-admission experience within Australia. Experience in New South Wale a... Our client have their headquarters based in Brisbane, giving you access to global professional development and career opportunities!\nFantastic op... Our client have their headquarters based in Brisbane, giving you access to global professional development and career opportunities!\nFantastic op... Our client have their headquarters based in Brisbane, giving you access to global professional development and career opportunities!\nFantastic op... Our client have their headquarters based in Brisbane, giving you access to global professional development and career opportunities!\nFantastic op... ... Our clients are based in Brisbane Southern Suburbs /Logan Area. We are looking for labourers to work on on-call, on-going and adhoc roles. Candida... Electrical Trade Assistant Amazing opportunity to work with a fast-growing New Zealand companyGain valuable skills in a company who puts an emphas... Civil Construction / Drainage Workers Wanted Urgently We are looking for experienced civil construction workers of all levels to join one of New Z... This is a test post from idibu\n\nThis is a test post from idibu\nThis is a test post from idibu\nThis is a test post from idibu\nThis is a test p... This is a test post from idibu\n\nThis is a test post from idibu\nThis is a test post from idibu\nThis is a test post from idibu\nThis is a test p... About the role\nWe have a newly created position for a Lead Practitioner to join our Berrimah team within CatholicCare NT. This position plays a k... No Night Shifts!  A full paid 6 week induction and training program Be part of our community (Free Gym onsite, monthly BBQ and more)   Are you loo... About the role\n\nSCHADS Award Level 5 – $84,989 trp (including salary $76,673 per annum)\nSalary Packaging Option (up to an additional $15,909.00... The Job As a key member of our Trading Solutions function at Sportsbet, you will be responsible for leading a small team of high performing engine... About the role\n\n2 x Casual positions, up to 10 hours per week\n\nWe have an exciting opportunity for two Men’s Behaviour Change Program Facilita... About the Company MEGT is an organisation that uses the group training model. As your employer, we will manage your apprenticeship, provide you wi... About the role\nOverview\nTo provide high quality legal services, including information, advice, representation, casework, negotiation and dispute... SAP Customer Management – SAP CRM – SAP IS-U – 12-month initial contract\nThis is a key role is a large SAP implementation and Business Transforma... SAP Customer Management – SAP CRM – SAP IS-U – 12-month initial contract\nThis is a key role is a large SAP implementation and Business Transforma... Applications are now open for our 2020 Cadet Program! Are you ready to grow your career and take on new challenges?  Join us!  Right now we’re del...
uri https://www.davidsonwp.com/job/director-of-client-services-slash-financial-controller/ https://www.davidsonwp.com/job/safety-systems-engineer/ https://www.davidsonwp.com/job/safety-systems-engineer/ https://www.seek.com.au/job/36500923 https://www.davidsonwp.com/job/100562133257277/senior-project-manager-developer-construction/ https://www.davidsonwp.com/job/100562133257277/senior-project-manager-developer-construction/ https://www.davidsonwp.com/job/100562133257277/senior-project-manager-developer-construction/ https://www.davidsonwp.com/job/installation-supervisor-5months/ https://www.davidsonwp.com/job/100562133367068/technical-project-manager-1/ https://www.seek.com.au/job/39894794 https://www.davidsonwp.com/job/100562133367048/manager-executive-services-chief-of-staff-1/ https://www.davidsonwp.com/job/100562133364046/executive-manager-1/ https://www.davidsonwp.com/job/100562133367025/manager-executive-services-chief-of-staff/ https://www.davidsonwp.com/job/100562133367025/manager-executive-services-chief-of-staff/ https://www.davidsonwp.com/job/100562133367025/manager-executive-services-chief-of-staff/ https://www.davidsonwp.com/job/100562133363681/executive-manager/ https://www.davidsonwp.com/job/100562133367048/manager-executive-services-chief-of-staff-1/ https://www.seek.com.au/job/36500248 https://www.davidsonwp.com/job/100562133263296/pmo-analyst/ https://probonoaustralia.com.au/jobs/2019/09/clinical-educator/ https://probonoaustralia.com.au/jobs/2020/10/solicitor-for-nsw-and-tasmania/ https://www.davidsonwp.com/job/100562133360565/bi-specialist-2/ https://www.davidsonwp.com/job/100562133361996/bi-specialist-3/ https://www.davidsonwp.com/job/100562133361996/bi-specialist-3/ https://www.davidsonwp.com/job/100562133360565/bi-specialist-2/ ... https://www.seek.com.au/job/37563347 https://www.seek.com.au/job/37211622 https://www.seek.com.au/job/40042253 https://www.seek.co.nz/job/40273289 https://www.seek.co.nz/job/35911503 https://www.seek.com.au/job/36499986 https://www.seek.co.nz/job/37343370 https://jobs.launchrecruitment.com.au/job/test-post-from-idibu/ https://jobs.launchrecruitment.com.au/job/test-post-from-idibu/ https://www.seek.com.au/job/37213523 https://probonoaustralia.com.au/jobs/2019/09/lead-practitioner-children-family-services/ https://www.seek.com.au/job/40146581 https://probonoaustralia.com.au/jobs/2019/09/case-manager-community-mental-health-2/ https://www.seek.com.au/job/36033974 https://probonoaustralia.com.au/jobs/2019/09/mens-behaviour-change-program-facilitators-x-2/ https://www.seek.com.au/job/37598516 https://www.seek.com.au/job/37598531 https://www.seek.com.au/job/36029790 https://www.seek.com.au/job/36496918 https://probonoaustralia.com.au/jobs/2020/01/lawyer-aboriginal-families-practice-team/ https://jobs.launchrecruitment.com.au/job/100602033243699/sap-customer-management/ https://jobs.launchrecruitment.com.au/job/100602033243699/sap-customer-management/ https://www.seek.com.au/job/36551707 https://www.seek.com.au/job/37438675 https://www.seek.com.au/job/40092108
view_date 2020-10-30 12:10:24+00:00 2020-08-08 07:23:54+00:00 2020-10-25 05:17:32+00:00 2018-06-19 01:13:09 2020-04-05 09:29:40+00:00 2020-07-12 08:56:32+00:00 2020-10-22 06:37:25+00:00 2020-09-27 09:23:33+00:00 2020-09-27 18:44:42+00:00 2019-09-09 09:56:47 2020-09-29 02:36:37+00:00 2020-09-23 13:26:54+00:00 2020-04-05 09:56:10+00:00 2020-07-10 18:54:50+00:00 2020-10-29 03:08:18+00:00 2020-09-27 04:32:33+00:00 2020-05-30 10:16:55+00:00 2018-06-19 01:43:39 2020-10-22 23:28:02+00:00 2020-05-29 10:07:49+00:00 2020-12-04 03:48:55+00:00 2020-03-30 03:19:37+00:00 2020-05-29 02:34:13+00:00 2020-10-25 10:40:59+00:00 2020-10-20 10:07:22+00:00 ... 2018-10-26 04:37:05 2018-09-13 01:09:35 2019-09-27 07:27:25 2019-10-30 08:58:41 2018-04-06 08:08:16 2018-06-19 02:02:22 2018-09-29 03:10:45 2020-07-05 17:04:34+00:00 2020-04-07 00:35:49+00:00 2018-09-13 00:41:52 2020-08-07 16:45:47+00:00 2019-10-13 09:52:59 2020-08-07 17:23:14+00:00 2018-04-20 02:23:17 2020-08-07 17:32:56+00:00 2018-10-31 01:51:48 2018-10-31 01:52:55 2018-04-20 03:29:48 2018-06-19 02:39:25 2020-08-09 06:45:09+00:00 2020-07-05 06:05:36+00:00 2020-04-04 06:30:27+00:00 2018-06-25 17:36:01 2018-10-11 00:57:01 2019-10-06 06:56:57
org Davidson Davidson Davidson BMS Sales Performance Davidson Davidson Davidson Davidson Davidson Bluefin Resources Pty Limited Davidson Davidson Davidson Davidson Davidson Davidson Davidson Spark Recruitment Davidson Orygen, The National Centre of Excellence in Youth Mental Health Youth Law Australia Davidson Davidson Davidson Davidson ... people2people Page Personnel Adecco Tech 5 - Recruiting for the Built Environment Franklin Smith Ltd Frontline Human Resources OneStaff Palmerston North Launch Recruitment Launch Recruitment YMCA Victoria CatholicCare NT via BigSplash International SOS (Australasia) P/L CatholicCare NT via BigSplash sportsbet.com.au CatholicCare NT via BigSplash MEGT MEGT MEGT MEGT Victorian Aboriginal Legal Service Launch Recruitment Launch Recruitment Washington Frank Global Medics Australia Transport for NSW
salary_raw AU$18000 - AU$150000 per annum + Plus Super AU$18000 - AU$200000 per annum + training,commission AU$18000 - AU$200000 per annum + training,commission Up to $100000.00 p.a. + Car + $15 - $20k Commissio $14000 - $165000 per annum $14000 - $165000 per annum $14000 - $165000 per annum AU$13000 - AU$140000 per annum $12000 - $16000 per annum $11500.00 - $140000.00 p.a. + super $10000 - $120000 per annum $10000 - $120000 per annum $10000 - $120000 per annum $10000 - $120000 per annum $10000 - $120000 per annum $10000 - $120000 per annum $10000 - $120000 per annum $10000.00 - $110k p.a. $10000 - $120000 per annum $95,00 - $110,000 per annum (pro rata) (commensurate with skills and experience). $90,00 - $105,000 p.a. (pro rata), negotiable + 9.5% Superannuation + Leave Loading + FBT Salary Packaging available. $7500 - $98550 per annum $7500 - $98550 per annum $7500 - $98550 per annum $7500 - $98550 per annum ... $25 - $30 per annum, Bens: $28.00 + Super $25 - $26 p.a. $24 - $30 p.a. NZD23 - NZD26 per annum $20 - $30 p.h. + 8% Annual leave paid out weekly $19 - $21 p.a. Up to $17 p.a. $11 - $111 per annum $11 - $111 per annum S/S Grade 8 - $68,622 p.a. + super SCHADS Award Level 7 - $99,897 trp (including salary $90,123) Salary Packaging Option (up to an additional $15,895 p/a) Base salary + Super + 6 weeks annual leave SCHADS Award Level 5 - $84,989 trp (including salary $76,673 per annum) 5 weeks annual leave + Company bonus SCHADS Award Level 5 - $48.50 per hour, Salary Packaging Option (up to an additional $15,895 p/a) super, 4 weeks annual leave, sick leave, super, 4 weeks annual leave, sick leave, super, 4 weeks annual leave, sick leave, super, 4 weeks annual leave, sick leave, LO Level 3 (year depending on experience) / SCHADS Level 4 3 year Transformation Project 3 year Transformation Project Up to $1 p.a. Up to $1 p.a. Transport Grade 1 $51,666 p.a. + super (prorata)
salary_min 18000 18000 18000 15000 14000 14000 14000 13000 12000 11500 10000 10000 10000 10000 10000 10000 10000 10000 10000 9500 9000 7500 7500 7500 7500 ... 25 25 24 23 20 19 17 11 11 8 7 6 5 5 5 4 4 4 4 3 3 3 1 1 1
salary_max 150000 200000 200000 20000 165000 165000 165000 140000 16000 140000 120000 120000 120000 120000 120000 120000 120000 110000 120000 110000 105000 98550 98550 98550 98550 ... 30 26 30 26 30 21 NaN 111 111 68622 99897 NaN 84989 NaN 48.5 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
salary_hours 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 ... 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000
location_raw Brisbane, Queensland, AU Melbourne CBD, Victoria, AU Melbourne CBD, Victoria, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Melbourne, AU Melbourne, AU Melbourne, AU Goulburn, New South Wales, AU Melbourne, AU Sydney, New South Wales, Australia Brisbane Adelaide Street, AU Brisbane Adelaide Street, AU Brisbane Adelaide Street, AU Brisbane Adelaide Street, AU Brisbane Adelaide Street, AU Brisbane Adelaide Street, AU Brisbane Adelaide Street, AU Sydney, North Shore & Northern Beaches, AU East Melbourne, AU Melbourne(Parkville) Hobart, Sydney, TAS Regional Brisbane, AU Brisbane, AU Brisbane, AU Brisbane, AU ... Sydney, Parramatta & Western Suburbs, AU Perth, Northern Suburbs & Joondalup, AU Brisbane, Queensland, Australia Auckland, New Zealand, New zealand Auckland, NZ Melbourne, Eastern Suburbs, AU Manawatu, Palmerston North, NZ Sydney, Nova Scotia, CA Sydney, Nova Scotia, CA Melbourne, AU Darwin(Berrimah ) Sydney, New South Wales, Australia Darwin(Malak) Melbourne, CBD & Inner Suburbs, AU Darwin(Berrimah ) Melbourne, Eastern Suburbs, AU Melbourne, Bayside & South Eastern Suburbs, AU Melbourne, AU Melbourne, CBD & Inner Suburbs, AU Melbourne(Preston) Sydney, AU Sydney, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Melbourne, AU Sydney, New South Wales, Australia
loc_id 1.01934e+08 8.57823e+07 8.57823e+07 8.57823e+07 1.01933e+08 1.01933e+08 1.01933e+08 1.0193e+08 1.01933e+08 1.01932e+08 1.01936e+08 1.01936e+08 1.01936e+08 1.01936e+08 1.01936e+08 1.01936e+08 1.01936e+08 NaN 1.01933e+08 1.01933e+08 NaN 1.01934e+08 1.01934e+08 1.01934e+08 1.01934e+08 ... 1.01932e+08 1.01938e+08 1.01934e+08 1.01914e+08 1.01914e+08 1.01933e+08 1.01914e+08 NaN NaN 1.01933e+08 1.01938e+08 1.01932e+08 1.01939e+08 8.57823e+07 1.01938e+08 1.01933e+08 1.01933e+08 1.01933e+08 8.57823e+07 1.01933e+08 1.01932e+08 1.01932e+08 8.57823e+07 1.01933e+08 1.01932e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania None Oceania Oceania None Oceania Oceania Oceania Oceania ... Oceania Oceania Oceania Oceania Oceania Oceania Oceania None None Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania
loc_country Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None Australia Australia None Australia Australia Australia Australia ... Australia Australia Australia New Zealand New Zealand Australia New Zealand None None Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_county Brisbane Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Goulburn Mulwaree Melbourne Sydney Adelaide Adelaide Adelaide Adelaide Adelaide Adelaide Adelaide None Melbourne Melbourne None Brisbane Brisbane Brisbane Brisbane ... Sydney Perth Brisbane Auckland Auckland Melbourne Palmerston North City None None Melbourne None Sydney Darwin Melbourne None Melbourne Melbourne Melbourne Melbourne Darebin Sydney Sydney Melbourne Melbourne Sydney
loc_empire Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None Australia Australia None Australia Australia Australia Australia ... Australia Australia Australia None None Australia None None None Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_localadmin Brisbane City Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Goulburn Melbourne Sydney Adelaide Adelaide Adelaide Adelaide Adelaide Adelaide Adelaide None East Melbourne Parkville None Brisbane City Brisbane City Brisbane City Brisbane City ... Sydney Perth Brisbane City None None Melbourne None None None Melbourne Berrimah Sydney None Melbourne Berrimah Melbourne Melbourne Melbourne Melbourne Preston Sydney Sydney Melbourne Melbourne Sydney
loc_locality Brisbane City Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Goulburn Melbourne Sydney Adelaide Adelaide Adelaide Adelaide Adelaide Adelaide Adelaide None East Melbourne Parkville None Brisbane City Brisbane City Brisbane City Brisbane City ... Sydney Perth Brisbane City Auckland Auckland Melbourne Palmerston North None None Melbourne Berrimah Sydney Malak Melbourne Berrimah Melbourne Melbourne Melbourne Melbourne Preston Sydney Sydney Melbourne Melbourne Sydney
loc_macrocounty Brisbane Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne None Melbourne Sydney Adelaide Adelaide Adelaide Adelaide Adelaide Adelaide Adelaide None Melbourne Melbourne None Brisbane Brisbane Brisbane Brisbane ... Sydney Perth Brisbane None None Melbourne None None None Melbourne None Sydney Darwin Melbourne None Melbourne Melbourne Melbourne Melbourne Melbourne Sydney Sydney Melbourne Melbourne Sydney
loc_region Queensland Victoria Victoria Victoria Victoria Victoria Victoria New South Wales Victoria New South Wales South Australia South Australia South Australia South Australia South Australia South Australia South Australia None Victoria Victoria None Queensland Queensland Queensland Queensland ... New South Wales Western Australia Queensland Auckland Region Auckland Region Victoria Manawatu-Wanganui Region None None Victoria Northern Territory New South Wales Northern Territory Victoria Northern Territory Victoria Victoria Victoria Victoria Victoria New South Wales New South Wales Victoria Victoria New South Wales
processor davidsonwp davidsonwp davidsonwp kaggle_promptcloud_listings davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp kaggle_promptcloud_latest davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp kaggle_promptcloud_listings davidsonwp probono probono davidsonwp davidsonwp davidsonwp davidsonwp ... kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest kaggle_promptcloud_latest kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings launchrecruitment launchrecruitment kaggle_promptcloud_listings probono kaggle_promptcloud_latest probono kaggle_promptcloud_listings probono kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings probono launchrecruitment launchrecruitment kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest
source CC-MAIN-2020-45 CC-MAIN-2020-34 CC-MAIN-2020-45 seekau CC-MAIN-2020-16 CC-MAIN-2020-29 CC-MAIN-2020-45 CC-MAIN-2020-40 CC-MAIN-2020-40 seekau_2019q3 CC-MAIN-2020-40 CC-MAIN-2020-40 CC-MAIN-2020-16 CC-MAIN-2020-29 CC-MAIN-2020-45 CC-MAIN-2020-40 CC-MAIN-2020-24 seekau CC-MAIN-2020-45 CC-MAIN-2020-24 CC-MAIN-2020-50 CC-MAIN-2020-16 CC-MAIN-2020-24 CC-MAIN-2020-45 CC-MAIN-2020-45 ... seekau seekau seekau_2019q3 seekau_2019q3 seekau seekau seekau CC-MAIN-2020-29 CC-MAIN-2020-16 seekau CC-MAIN-2020-34 seekau_2019q3 CC-MAIN-2020-34 seekau CC-MAIN-2020-34 seekau seekau seekau seekau CC-MAIN-2020-34 CC-MAIN-2020-29 CC-MAIN-2020-16 seekau seekau seekau_2019q3
loc_neighbourhood None Melbourne CBD Melbourne CBD Melbourne CBD None None None None None None None None None None None None None None None None None None None None None ... None None None None None None None None None None None None None Melbourne CBD None None None None Melbourne CBD None None None Melbourne CBD None None
annual True True True True True True True True True True True True True True True True True True True True True True True True True ... True True True True True True True True True True True True True True True True True True True True True True True True True
weekly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
daily False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
hourly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
salary_low 18000 18000 18000 15000 14000 14000 14000 13000 12000 11500 10000 10000 10000 10000 10000 10000 10000 10000 10000 9500 9000 7500 7500 7500 7500 ... 25 25 24 23 20 19 17 11 11 8 7 6 5 5 5 4 4 4 4 3 3 3 1 1 1
salary_hi 150000 200000 200000 20000 165000 165000 165000 140000 16000 140000 120000 120000 120000 120000 120000 120000 120000 110000 120000 110000 105000 98550 98550 98550 98550 ... 30 26 30 26 30 21 NaN 111 111 68622 99897 NaN 84989 NaN 48.5 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
salary_valid False False False True False False False False True False False False False False False False False False False False False False False False False ... True True True True True True True False False False False False False False False False False False False False False False False False False
pct_salary_range 1.57143 1.66972 1.66972 0.285714 1.68715 1.68715 1.68715 1.66013 0.285714 1.69637 1.69231 1.69231 1.69231 1.69231 1.69231 1.69231 1.69231 1.66667 1.69231 1.68201 1.68421 1.71711 1.71711 1.71711 1.71711 ... 0.181818 0.0392157 0.222222 0.122449 0.4 0.1 NaN 1.63934 1.63934 1.99953 1.99972 NaN 1.99976 NaN 1.62617 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

30 rows × 431 columns

df.loc[(df.salary_low < SALARY_ANNUAL_MIN_AUD) & df.annual, "salary_valid"] = False
%time sns.displot(df[(df.salary_hours==2000) & (df.salary_valid)], x="salary_low", log_scale=True, kde=True)
CPU times: user 438 ms, sys: 61.2 ms, total: 500 ms
Wall time: 397 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bc471f6a0>

Weekly

%time sns.displot(df[df.weekly], x="salary_low", kde=True, log_scale=True)
CPU times: user 523 ms, sys: 89.7 ms, total: 613 ms
Wall time: 522 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bc4701d00>

These are mainly bad parsing; could tighen up parsing here

SALARY_WEEKLY_MAX_AUD = 5000
df[df.weekly & (df.salary_low > SALARY_WEEKLY_MAX_AUD)].sort_values("salary_low").T
21565 40654 62250 25836 68789 19335 20444 19957 59419 59863 60712
title Become a taxi driver Social Media Marketing Assistant (Part Time 3 days per week) Store Manager - Melbourne Talent Resourcer Run-Off Manager for Dairy Support Office Manager – Community Colleges Australia Registered Psychologist HR Advisor Election Managers Election Managers Election Manager
description Need full driving victorian australian licence at least 1 year old . National police check and australian victorian driving license is must.\nIf a... About us\nWe are a dynamic and integrated creative marketing and brand agency, offering thoughtful creative design, strategic marketing and manage... In this fast paced role, you'll work in a team of 3 Recruiters handling all office and call centre recruitment for our Sydney branch, along with p... About the role\nCommunity Colleges Australia (CCA: www.cca.edu.au), the peak national body that represents community-owned, not-for-profit educati... About the role\n\nAre you passionate about improving the health and wellbeing of Aboriginal people?\nJoin an influential and supportive Not-For-Pr... About the role\nCHOICE is one of Australia’s leading independent online media organisations; one that plays a unique role in the Australian consum...
uri https://www.gumtree.com.au/s-ad/the-basin/other-jobs/become-a-taxi-driver/1258503131 https://www.seek.com.au/job/50730953?type=standard https://www.seek.com.au/job/36497803 https://www.seek.com.au/job/40179061 https://www.seek.co.nz/job/36421441 https://probonoaustralia.com.au/jobs/2019/10/office-manager-community-colleges-australia/ https://probonoaustralia.com.au/jobs/2020/08/registered-psychologist/ https://probonoaustralia.com.au/jobs/2020/07/hr-advisor/ https://www.seek.com.au/job/36554346 https://www.seek.com.au/job/36554233 https://www.seek.com.au/job/36554178
view_date 2020-11-27 09:14:12+00:00 2020-10-28 20:38:22+00:00 2018-06-19 02:23:09 2019-10-17 09:07:41 2018-06-08 07:23:50 2020-05-29 10:49:54+00:00 2020-09-26 11:40:24+00:00 2020-11-26 22:39:23+00:00 2018-06-25 16:11:41 2018-06-25 16:29:12 2018-06-25 16:31:15
org None Lunchbox Agency Hospoworld Resourcing 2evolve Pty Ltd Rural People Ltd Community Colleges Australia Biripi Aboriginal Corporation Medical Centre CHOICE Hudson Hudson Hudson
salary_raw $30000 plus if working 4 shifts a week $45,000 base (pro rata 3 days/week $27,000) $60-65k + super + bonuses + 40 hours per week To $65K (37.5hr Week) $70,400 including a house. Rent $200 pw up to $80,000 on a full-time equivalent basis (pro rata for days/hours worked: 3.5 to 4 days/week) $83,000-$100,000. Flexible PT role (24hrs/week)! $100,000 FTE Package including Superannuation (12 months fixed | 3 days per week) $3500 - $4000k p.w. $3500 - $4000k p.w. $3500 - $4000k p.w.
salary_min 30000 45000 60000 65000 70400 80000 83000 100000 3.5e+06 3.5e+06 3.5e+06
salary_max NaN NaN 65000 NaN NaN NaN 100000 NaN 4e+06 4e+06 4e+06
salary_hours 40 40 40 40 40 40 40 40 40 40 40
location_raw The Basin, VIC melbourne, Melbourne, Victoria, Australia Melbourne, CBD & Inner Suburbs, AU Sydney, New South Wales, Australia Canterbury, North Canterbury, NZ Sydney(Sydney CBD) NSW Regional(Taree) Sydney(Marrickville) Wollongong, Illawarra & South Coast, AU Sydney, AU Lismore & Far North Coast, AU
loc_id 1.01934e+08 1.01933e+08 8.57823e+07 1.01932e+08 8.56872e+07 1.01932e+08 NaN 1.02049e+08 1.01932e+08 1.01932e+08 1.02079e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania None Oceania Oceania Oceania Oceania
loc_country Australia Australia Australia Australia New Zealand Australia None Australia Australia Australia New Zealand
loc_county Knox Melbourne Melbourne Sydney None Sydney None Marrickville Wollongong Sydney Far North District
loc_empire Australia Australia Australia Australia None Australia None Australia Australia Australia None
loc_localadmin The Basin Melbourne Melbourne Sydney None Sydney None None Wollongong Sydney None
loc_locality The Basin Melbourne Melbourne Sydney None Sydney None None Wollongong Sydney None
loc_macrocounty Melbourne Melbourne Melbourne Sydney None Sydney None Sydney None Sydney None
loc_region Victoria Victoria Victoria New South Wales Canterbury Region New South Wales None New South Wales New South Wales New South Wales Northland Region
processor gumtree seek kaggle_promptcloud_listings kaggle_promptcloud_latest kaggle_promptcloud_listings probono probono probono kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings
source CC-MAIN-2020-50 CC-MAIN-2020-45 seekau seekau_2019q3 seekau CC-MAIN-2020-24 CC-MAIN-2020-40 CC-MAIN-2020-50 seekau seekau seekau
loc_neighbourhood None None Melbourne CBD None None None None None None None None
annual False False False False False False False False False False False
weekly True True True True True True True True True True True
daily False False False False False False False False False False False
hourly False False False False False False False False False False False
salary_low 30000 45000 60000 65000 70400 80000 83000 100000 3.5e+06 3.5e+06 3.5e+06
salary_hi NaN NaN 65000 NaN NaN NaN 100000 NaN 4e+06 4e+06 4e+06
salary_valid True True True True True True True True False False False
pct_salary_range NaN NaN 0.08 NaN NaN NaN 0.185792 NaN 0.133333 0.133333 0.133333

A mix of bad parsing and bad data

SALARY_WEEKLY_MIN_AUD = 300
df[df.weekly & (df.salary_low < SALARY_WEEKLY_MIN_AUD)].sort_values("salary_low", ascending=False).T
21392 21814 59948 64898 26218 41154 37066 27951 24477 31541
title Need a car for on-demand delivery and Uber? Drivers Wanted Apply Now | Weekend work available Communication and Media Manager Credit Application Assessor Warehouse Administrative Assistant Data Entry | Casual In-house Customer Workshop Assistant RF Scanners/Voice Pickers Labourer/ Truck Driver Confident Brand Ambassadors
description How does Splend work?\nWe provide eco-friendly and affordable cars so drivers can focus on earning an income.\nOur weekly Rent plans give ultimate... How does Splend work?\nWe provide eco-friendly and affordable cars so drivers can focus on earning an income.\nOur weekly Rent plans give ultimate... Fantastic opportunity for an Administrative Assistant to join the Warehouse team in this newly created role! Our Operations team have recently int... About the business\nOur client has been providing manufacturing and related services to the Authentication, Payment and Secure Access sector since... Our client is a National Distributor and 3PL Supply Chain provider located in Mile End (SA). They proudly boast solid partnerships with their clie... Our clients are looking for experienced RF Scanners and/or Voice pickers to work in Southern and South Eastern Suburbs casually on either day or a... Perth based scrap metal recycling company is seeking a casual person to assist in both yard operations and product pick-ups. To be considered for ... Our client Acquire Direct is in search of 5 outgoing personalities who thrive on a fast-paced environment and are looking for a challenge. Special...
uri https://www.gumtree.com.au/s-ad/north-adelaide/other/need-a-car-for-on-demand-delivery-and-uber-/1226531757 https://www.gumtree.com.au/s-ad/brunswick/other/drivers-wanted-apply-now-weekend-work-available/1226530424 https://www.seek.com.au/job/36554632 https://www.seek.co.nz/job/37438784 https://www.seek.com.au/job/39936999 https://www.seek.com.au/job/50759000?type=standard https://www.seek.com.au/job/41366535?type=standout https://www.seek.com.au/job/40002217 https://www.seek.com.au/job/39870184 https://www.seek.com.au/job/39887756
view_date 2020-07-04 17:30:54+00:00 2020-10-27 15:58:15+00:00 2018-06-25 16:32:50 2018-10-11 01:47:47 2019-09-13 06:49:34 2020-10-24 09:14:45+00:00 2020-05-25 11:47:54+00:00 2019-09-23 07:08:05 2019-09-05 08:42:40 2019-09-07 07:33:18
org None None Corin Forest Mountain Retreat Madison Recruitment Ltd Boardriders ProQuest Recruitment - Dandenong Jobwire ProQuest Recruitment - Dandenong Wolfram Metal Recyclers Wow Recruitment
salary_raw Prices from $199&#47;week Rent from $199&#47;week $30 - $40 per hourUp to 38hrs p/week Competitive salary for 30 hours/ week 28 hours/week across Monday to Friday $27 - $28 p.w. Up to $26 p.w. $25 - $36 p.w. $20 - $29.99 per hour30-38 hours a week $20.00-$24.00/hourOTE $1000 + /week
salary_min 199 199 30 30 28 27 26 25 20 20
salary_max None NaN 40 NaN NaN 28 NaN 36 29.99 24
salary_hours 40 40 40 40 40 40 40 40 40 40
location_raw North Adelaide SA Brunswick VIC ACT, AU Auckland, Manukau & East Auckland, NZ South West Coast VIC, Victoria, Australia dandenongsouth, Melbourne, Victoria, Australia mileend, Adelaide, South Australia, Australia Melbourne, Victoria, Australia Perth, Western Australia, Australia Sydney, New South Wales, Australia
loc_id 1.01936e+08 1.01933e+08 8.56815e+07 1.12598e+09 8.56815e+07 1.01933e+08 1.01936e+08 1.01933e+08 1.01938e+08 1.01932e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania
loc_country Australia Australia Australia New Zealand Australia Australia Australia Australia Australia Australia
loc_county Adelaide Moreland None Auckland None Melbourne Adelaide Melbourne Perth Sydney
loc_empire Australia Australia Australia None Australia Australia Australia Australia Australia Australia
loc_localadmin North Adelaide Brunswick None None None Melbourne Adelaide Melbourne Perth Sydney
loc_locality North Adelaide Brunswick None Manukau City None Melbourne Adelaide Melbourne Perth Sydney
loc_macrocounty Adelaide Melbourne None None None Melbourne Adelaide Melbourne Perth Sydney
loc_region South Australia Victoria Australian Capital Territory Auckland Region Victoria Victoria South Australia Victoria Western Australia New South Wales
processor gumtree gumtree kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest seek seek kaggle_promptcloud_latest kaggle_promptcloud_latest kaggle_promptcloud_latest
source CC-MAIN-2020-29 CC-MAIN-2020-45 seekau seekau seekau_2019q3 CC-MAIN-2020-45 CC-MAIN-2020-24 seekau_2019q3 seekau_2019q3 seekau_2019q3
loc_neighbourhood NaN NaN None None None None None None None None
annual False False False False False False False False False False
weekly True True True True True True True True True True
daily False False False False False False False False False False
hourly False False False False False False False False False False
salary_low 199 199 30 30 28 27 26 25 20 20
salary_hi NaN NaN 40 NaN NaN 28 NaN 36 29.99 24
salary_valid True True True True True True True True True True
pct_salary_range NaN NaN 0.285714 NaN NaN 0.0363636 NaN 0.360656 0.39968 0.181818

We could mark these as annual… slight bias to exclude them, but small in number

df.loc[df.weekly & (df.salary_low < SALARY_WEEKLY_MIN_AUD), "salary_valid"] = False
df.loc[df.weekly & (df.salary_low > SALARY_WEEKLY_MAX_AUD), "salary_valid"] = False
%time sns.displot(df[df.weekly & df.salary_valid], x="salary_low", kde=True, log_scale=True)
CPU times: user 323 ms, sys: 50.6 ms, total: 374 ms
Wall time: 269 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bc47b0d30>

Daily

%time sns.displot(df[df.daily], x="salary_low", kde=True, log_scale=True)
CPU times: user 593 ms, sys: 58.6 ms, total: 651 ms
Wall time: 550 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bc44949d0>

Mix of bad data and parsing

df[df.daily & (df.salary_low > 3000)].sort_values('salary_low').T
73423 29338 32448 35501
title Aboriginal Identified - Clerk General Scale - Cadetship Program - Various Locations - Temporary Management Accountant - 9 day fortnight Data Dev and Gov Analyst Data Dev and Gov Analyst
description ABOUT LEGAL AID NSW\nLegal Aid NSW is the largest legal aid agency in Australia, comprising of a Central Sydney office and 26 regional offices in ... Our client is a high profile public-sector organisation located in the inner Bayside / Georges River Council suburban area within easy access of t... Government agency looking for a to be a strong player in the implementation of a green field Big Data environment whilst cross-skilling with other... Government agency looking for a to be a strong player in the implementation of a green field Big Data environment whilst cross-skilling with other...
uri https://iworkfor.nsw.gov.au/job/aboriginal-identified-clerk-general-scale-cadetship-program-various-locations-temporary-212912 https://www.seek.com.au/job/39843065 https://jobs.launchrecruitment.com.au/job/100602033311507/data-dev-and-gov-analyst/ https://jobs.launchrecruitment.com.au/job/100602033311507/data-dev-and-gov-analyst/
view_date 2020-10-21 22:35:08+00:00 2019-09-02 10:54:58 2020-05-26 20:13:28+00:00 2020-09-29 13:50:58+00:00
org Legal Aid Commission, Office of the Pacific Search Partners Launch Recruitment Launch Recruitment
salary_raw • Salary package of up to $27,700 including study and book allowances for a 60-day placement Circa $100K + super for a 9 day/fortnight $150000 - $180000 per day $150000 - $180000 per day
salary_min 27700 100000 150000 150000
salary_max NaN NaN 180000 180000
salary_hours 8 8 8 8
location_raw Sydney Region Sydney, New South Wales, Australia Parramatta, AU Parramatta, AU
loc_id 1.01932e+08 1.01932e+08 1.0205e+08 1.0205e+08
loc_continent Oceania Oceania Oceania Oceania
loc_country Australia Australia Australia Australia
loc_county Sydney Sydney Parramatta Parramatta
loc_empire Australia Australia Australia Australia
loc_localadmin Sydney Sydney None None
loc_locality Sydney Sydney None None
loc_macrocounty Sydney Sydney Sydney Sydney
loc_region New South Wales New South Wales New South Wales New South Wales
processor iworkfornsw kaggle_promptcloud_latest launchrecruitment launchrecruitment
source CC-MAIN-2020-45 seekau_2019q3 CC-MAIN-2020-24 CC-MAIN-2020-40
loc_neighbourhood NaN None None None
annual False False False False
weekly False False False False
daily True True True True
hourly False False False False
salary_low 27700 100000 150000 150000
salary_hi NaN NaN 180000 180000
salary_valid True True True True
pct_salary_range NaN NaN 0.181818 0.181818

Many of these seem suss..

df[df.daily & (df.salary_min < 100)].sort_values('salary_min', ascending=False).T
62595 71103 29321 35628 33287 34739 26735 32806 35832 32513 38755 34213 38782 65932 9808 35074 7886 33609 35842 28062 37935 64256 31186 31221 63834 ... 33639 33475 33466 33462 33450 33424 33413 33502 33509 33560 33568 33573 33574 33578 33590 33591 33594 33598 33612 33615 33625 33628 33630 33635 34612
title PHP Developer Development Services Officer Child Protection Assessment Officer Training Coordinator Training Coordinator Training Coordinator Records and Scanning Administration Officers (work with a Qld Government dept) Team Leader - Speak Out Program Call Centre Operator Call Centre Operator Production Assistant Team Leader - Speak Out Program Warehouse Staff Needed Customer Service Representative (Inbound) Contact Centre Consultant| HR Advice|Payroll|Casual Pool Receptionist Contact Centre Consultant| HR Advice|Payroll|Casual Pool Receptionist Receptionist Warehouse Operators Assistant Educator Forklift Driver - Day Shift Packing Staff - Dairy Industry - Day and Afternoon Shift Container Unloaders/General Labourers Class 1 Driver - $20.50 per hour ... Scrum Master Senior Release / Deployment Manager Web Automation Test Specialist Team Assistant Team Assistant MYSQL Architect Personal Assistant .Net developer System Access Administrator Front End developer- Angular IT recruiter Full Stack developer Solution Architect Back end developer Field Supervisor Network Design role iOS Developer AWS Architect Citrix SME Splunk Architect Scrum Master Technology Analyst IT support role Test Analyst (Salesforce & Insurance Experience) Recruitment Coodinator Lead
description BENEFITSDarlinghurst location 8 Month Temporary AssignmentChild protection THE COMPANYpeople2people are collaborating with the NSW Government who ... Fantastic opportunity to work for a leading government agency who specialise in health and safety. Our client is undergoing a large scale transfor... Fantastic opportunity to work for a leading government agency who specialise in health and safety. Our client is undergoing a large scale transfor... Fantastic opportunity to work for a leading government agency who specialise in health and safety. Our client is undergoing a large scale transfor... We are urgently seeking Records and Scanning Administration Officers with strong attention to detail to join our temporary team working with a pro... Weave is seeking an experienced Team Leader to join the team.\nProviding leadership, support and coordination of Weave’s Speak Out Dual Diagnosis ... Opportunity to work with a leading reputable government agency who are building a new online platform. This role will be shift work - 5 days per d... Opportunity to work with a leading reputable government agency who are building a new online platform. This role will be shift work - 5 days per d... We have a great opportunity for experienced Production Assistants to join a reputable printing organisation located in Craigieburn.\nOur client, l... Weave is seeking an experienced Team Leader to join the team.\nProviding leadership, support and coordination of Weave’s Speak Out Dual Diagnosis ... Labourforce has potions available for suitable candidates with our valued client based in Acacia Ridge due to increased work load, they are an ind... About the company:\nOur client is a leading national organisation with a fantastic reputation for providing a valuable service to its customers an... Join an exciting Receptionist role for one of our IT clients based in North Sydney for an initial 6 months contract with a view to extend. You wil... About the company:\nOur client is a leading national organisation with a fantastic reputation for providing a valuable service to its customers an... Join an exciting Receptionist role for one of our IT clients based in North Sydney for an initial 6 months contract with a view to extend. You wil... Join an exciting Receptionist role for one of our IT clients based in North Sydney for an initial 6 months contract with a view to extend. You wil... Warehouse Operators needed for ALDI Prestons Do you like a physically challenging role? About the company:Aldi have been operating in Australia si... About Story House Early Learning:\nStory House Early Learning is an emerging early childhood provider with services in QLD, NSW and VIC. We strive... Immediate Start Day Shift 5am - 3pm Afternoon Shift 2pm - 12am Ongoing Casual Shifts Mon - Friday Production and Warehouse work experience essenti... Randstad is currently recruiting for casual container unloaders/general hands. As it is approaching closer to the silly season, our clients are ge... ... Join one of the largest IT clients based in Melbourne CBD for an initial 6 months contract for a Scrum Master role.\nMandatory skills needed:\n\nH... Senior Release / Deployment Manager - Perth - Day Rate = $772.72 inc. Super\nScope:\n\nTracked and implemented deliverables against the scope and ... Web Automation Test Specialist | 6 month contract | Circa - $750 inc. super per day\nThe Company:\nThis is a quintessential Australian household n... A leading Telecommunications organisation is seeking an experienced Team Assistant to provide support to a number of General Managers and execs.\n... Our client is a leading telecommunications organisation who are seeking a Team Assistant who will be supporting General Managers with regards to f... Join an exciting MySql Architect role for a 1 month contract based in South Melbourne. The role is initially for 4 weeks but can extend further.\n... Join an exciting PA role for one of the largest Telco companies based in Sydney CBD.You will be supporting administration and general EA duties wi... Our client is a global professional services consultant who are looking for strong .Net developers for a 12 months contract.\nThis client has a ma... Join an exciting System Access Administrator role for a 6 months contract for one of the largest Telco companies based in CBD.You will be responsi... Our client based in Melbourne CBD is looking for a front-end developer for a short-term contract based in Melbourne CBD.Its a contract till end of... Join one of the largest IT corporates based in Canberra for IT Recruiter role for an initial 6 months contract.\nThe skills looking for this role ... Join an exciting Full Stack developer role for an initial 6 months contract based in Brisbane for one of our clients.\nMandatory skills for the ro... Join an exciting Solutions Architect role based in Melbourne for an initial 6 months contract.\nYou will be responsible for:\n\nMaintaining the ST... Join an exciting Back end developer(Java) with one of largest Telco clients based in Melbourne CBD for an initial 3 months contract that might ext... Join one of the largest Telco companies based in North and East metro and some coutry area for a field Supervisor role for an initial 6 months con... Join one of our IT clients based in Brisbane for a Site Network Study role for an initial 6 months contract.\nYou will be performing Site Audit fo... Join one of the largest IT companies based in Melbourne CBD for an iOS developer role for an initial 6 months contract.\nYou will gave the followi... Join one of the largest IT clients based in CBD for an AWS Architect role for an initial 6 months contract.\nYou responsibilities and experience w... Join an exciting Citrix SME role for one of our largest clients based in Melbourne CBD.Its an initial 6 months contract with the possibility of ex... Join an exciting Splunk Developer role for a 6 months contract position based in Melbourne CBD for one of our clients.The role requires someone wh... Join one of the largest IT companies as a Scrum Master for an initial 6 months contract based in CBD.\nMandatory skills needed:\n\nHands-on experi... Join one of the largest IT clients based in Melbourne CBD for a Technology Analyst role. The role is an initial 6 months contract role.\nMandatory... Join one of the largest IT clients for an initial 2 years contract based in Adelaide.\nTechnical Support & Execution\n\nEnsure IT & OT Systems inc... Test & Quality Analyst - 12 Month Day Rate Contract - $680 Inc Super a Day\nSALESFORCE & previous INSURANCE experience required. \nThe Company:\nT... An exciting opportunity to join a leading digital company based in Melbourne CBD for a Recruitment coodinator role.The role is a 6 months contract...
uri https://www.seek.com.au/job/36789537 https://www.seek.com.au/job/37565087 https://www.seek.com.au/job/40208499 https://jobs.launchrecruitment.com.au/job/100602033335650/training-coordinator-2/ https://jobs.launchrecruitment.com.au/job/100602033335650/training-coordinator-2/ https://jobs.launchrecruitment.com.au/job/100602033335650/training-coordinator-2/ https://www.seek.com.au/job/39934310 https://jobs.launchrecruitment.com.au/job/100602033217942/team-leader-speak-out-program/ https://jobs.launchrecruitment.com.au/job/100602033372517/call-centre-operator-1/ https://jobs.launchrecruitment.com.au/job/100602033372517/call-centre-operator-1/ https://www.seek.com.au/job/50994456?type=standard https://jobs.launchrecruitment.com.au/job/100602033217942/team-leader-speak-out-program/ https://www.seek.com.au/job/50995587?type=standard https://www.seek.com.au/job/37203654 https://www.davidsonwp.com/job/100562133333296/contact-centre-consultant-hr-advice-payroll-casual-pool/ https://jobs.launchrecruitment.com.au/job/100602033373812/receptionist-9/ https://www.davidsonwp.com/job/100562133333296/contact-centre-consultant-hr-advice-payroll-casual-pool/ https://jobs.launchrecruitment.com.au/job/100602033373812/receptionist-9/ https://jobs.launchrecruitment.com.au/job/100602033373812/receptionist-9/ https://www.seek.com.au/job/40269764 https://www.seek.com.au/job/50783642?cid=SKL-CareerGuide https://www.seek.com.au/job/37439153 https://www.seek.com.au/job/39950345 https://www.seek.com.au/job/40162654 https://www.seek.co.nz/job/37434117 ... https://jobs.launchrecruitment.com.au/job/100602033376518/scrum-master-4/ https://jobs.launchrecruitment.com.au/job/100602033362452/senior-release-slash-deployment-manager/ https://jobs.launchrecruitment.com.au/job/100602033361046/web-automation-test-specialist/ https://jobs.launchrecruitment.com.au/job/100602033361906/team-assistant-28/ https://jobs.launchrecruitment.com.au/job/100602033360118/team-assistant-26/ https://jobs.launchrecruitment.com.au/job/100602033356253/mysql-developer/ https://jobs.launchrecruitment.com.au/job/100602033355763/personal-assistant-7/ https://jobs.launchrecruitment.com.au/job/100602033364943/dot-net-developer-11/ https://jobs.launchrecruitment.com.au/job/100602033365315/system-access-administrator-2/ https://jobs.launchrecruitment.com.au/job/100602033370133/front-end-developer-angular/ https://jobs.launchrecruitment.com.au/job/100602033371423/it-recruiter/ https://jobs.launchrecruitment.com.au/job/100602033371767/full-stack-developer-4/ https://jobs.launchrecruitment.com.au/job/100602033371863/solution-architect-15/ https://jobs.launchrecruitment.com.au/job/100602033372136/back-end-developer-1/ https://jobs.launchrecruitment.com.au/job/100602033372610/field-supervisor-1/ https://jobs.launchrecruitment.com.au/job/100602033373023/site-network-study/ https://jobs.launchrecruitment.com.au/job/100602033373743/ios-developer-3/ https://jobs.launchrecruitment.com.au/job/100602033373452/aws-architect/ https://jobs.launchrecruitment.com.au/job/100602033375052/citrix-sme/ https://jobs.launchrecruitment.com.au/job/100602033375051/splunk-architect/ https://jobs.launchrecruitment.com.au/job/100602033376480/scrum-master-3/ https://jobs.launchrecruitment.com.au/job/100602033375320/technology-analyst/ https://jobs.launchrecruitment.com.au/job/100602033376491/it-support-role/ https://jobs.launchrecruitment.com.au/job/100602033377291/test-analyst-salesforce-and-insurance-experience/ https://jobs.launchrecruitment.com.au/job/100602033319244/recruitment-coodinator-1/
view_date 2018-07-24 08:36:19 2018-10-26 04:21:31 2019-10-21 08:22:12 2020-09-24 03:55:28+00:00 2020-07-07 14:34:53+00:00 2020-03-29 22:32:56+00:00 2019-09-13 05:47:40 2020-07-05 07:01:30+00:00 2020-09-29 13:37:04+00:00 2020-05-29 16:02:55+00:00 2020-12-03 21:24:56+00:00 2020-04-04 07:15:18+00:00 2020-12-02 01:03:33+00:00 2018-09-13 00:55:45 2020-10-20 20:16:51+00:00 2020-03-29 23:10:58+00:00 2020-08-08 10:27:12+00:00 2020-07-14 22:43:41+00:00 2020-09-25 19:11:59+00:00 2019-10-29 05:31:44 2020-11-27 18:14:20+00:00 2018-10-11 00:40:16 2019-09-16 05:38:03 2019-10-15 07:52:12 2018-10-11 01:56:36 ... 2020-07-07 15:40:26+00:00 2020-07-03 03:06:52+00:00 2020-07-05 22:55:47+00:00 2020-07-08 22:37:45+00:00 2020-07-09 03:22:19+00:00 2020-07-09 08:11:48+00:00 2020-07-07 01:36:56+00:00 2020-07-11 08:19:54+00:00 2020-07-11 06:55:37+00:00 2020-07-02 08:24:49+00:00 2020-07-02 12:04:10+00:00 2020-07-11 08:43:27+00:00 2020-07-14 23:23:06+00:00 2020-07-05 22:00:15+00:00 2020-07-08 22:46:10+00:00 2020-07-14 22:08:25+00:00 2020-07-14 12:11:47+00:00 2020-07-08 23:44:49+00:00 2020-07-11 08:00:08+00:00 2020-07-14 12:30:51+00:00 2020-07-06 00:03:35+00:00 2020-07-14 23:53:51+00:00 2020-07-14 23:21:54+00:00 2020-07-03 04:13:09+00:00 2020-04-09 04:49:08+00:00
org Chandler Macleod Group Smalls, GWS & JHA trading as Spinifex Recruiting people2people Launch Recruitment Launch Recruitment Launch Recruitment Recruitment@Top Launch Recruitment Launch Recruitment Launch Recruitment Staff Australia Recruitment Services P/L Launch Recruitment Labourforce Kelly Services Davidson Launch Recruitment Davidson Launch Recruitment Launch Recruitment IPA Story House Early Learning HORNER Recruitment Dekro Recruitment Randstad - Industrial Adecco Transport & Logistics ... Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment Launch Recruitment
salary_raw $60 - $70 p.d. + Super $50 - $60 p.d. + Super $45.00 per day $35 - $38 per day $35 - $38 per day $35 - $38 per day Casual $30.19(day shift)- $33.81(afternoon shift) * Part Time - 9 day fortnight (until 30 June 2019) $30 - $32 per day $30 - $32 per day $30 - $32 p.d. * Part Time - 9 day fortnight (until 30 June 2019) $27.17 DAY $29.30 ARVO $28.06 p.d. + Super $28 per day $28 - $30 per day $28 per day $28 - $30 per day $28 - $30 per day $27.33 - $28.33 p.d. $27.21 - $28.03 + super + uniform + PD $26 - $27 per day Day Shift $25.07 Afternoon Shift $28.83+ Super $25 - $30 p.d. $20 - $21 p.d. + Over time ... $0 - $700 per day $0 - $772.72 per day $0 - $760 per day $0 - $300 per day $0 - $460 per day $0 - $800 per day $0 - $450 per day $0 - $732 per day $0 - $525 per day $0 - $600 per day $0 - $400 per day $0 - $500 per day $0 - $800 per day $0 - $800 per day $0 - $700 per day $0 - $450 per day $0 - $700 per day $0 - $700 per day $0 - $500 per day $0 - $500 per day $0 - $700 per day $0 - $500 per day $0 - $500 per day $0 - $680 per day, Benefits: 12 Month Day Rate Contract $0 - $330 per day
salary_min 60 50 45 35 35 35 30.19 30 30 30 30 30 29.3 28.06 28 28 28 28 28 27.33 27.21 26 25.07 25 20 ... 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
salary_max 70 60 NaN 38 38 38 NaN NaN 32 32 32 NaN NaN NaN NaN 30 NaN 30 30 28.33 28.03 27 NaN 30 21 ... 700 772.72 760 300 460 800 450 732 525 600 400 500 800 800 700 450 700 700 500 500 700 500 500 680 330
salary_hours 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 ... 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8
location_raw Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, Parramatta & Western Suburbs, AU Sydney, New South Wales, Australia Melbourne, AU Melbourne, AU Melbourne, AU Brisbane, Queensland, Australia Sydney, AU Geelong, AU Geelong, AU craigieburn, Melbourne, Victoria, Australia Sydney, AU acaciaridge, Brisbane, Queensland, Australia Sydney, South West & M5 Corridor, AU Brisbane, AU Melbourne, AU Brisbane, AU Melbourne, AU Melbourne, AU Sydney, New South Wales, Australia mascot, Sydney, New South Wales, Australia Melbourne, Bayside & South Eastern Suburbs, AU Melbourne, Victoria, Australia Melbourne, Victoria, Australia Auckland, Manukau & East Auckland, NZ ... Melbourne, AU Perth, AU Sydney, AU Sydney, AU Melbourne, AU Melbourne, AU Sydney, AU Melbourne, AU Melbourne, AU Melbourne, AU Canberra, AU Brisbane, AU Melbourne, AU Melbourne, AU Melbourne, AU Brisbane, AU Melbourne, AU Melbourne, AU Melbourne, AU Melbourne, AU Melbourne, AU Melbourne, AU Adelaide, AU Sydney, AU Melbourne, AU
loc_id 8.57823e+07 1.01932e+08 1.01932e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01934e+08 1.01932e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01932e+08 1.01934e+08 8.57744e+07 1.01934e+08 1.01933e+08 1.01934e+08 1.01933e+08 1.01933e+08 1.01932e+08 1.01931e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.12598e+09 ... 1.01933e+08 1.01938e+08 1.01932e+08 1.01932e+08 1.01933e+08 1.01933e+08 1.01932e+08 1.01933e+08 1.01933e+08 1.01933e+08 8.56815e+07 1.01934e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01934e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01936e+08 1.01932e+08 1.01933e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania ... Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania
loc_country Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia New Zealand ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_county Melbourne Sydney Sydney Melbourne Melbourne Melbourne Brisbane Sydney Greater Geelong Greater Geelong Hume Sydney Brisbane Sydney Brisbane Melbourne Brisbane Melbourne Melbourne Sydney Botany Bay Melbourne Melbourne Melbourne Auckland ... Melbourne Perth Sydney Sydney Melbourne Melbourne Sydney Melbourne Melbourne Melbourne None Brisbane Melbourne Melbourne Melbourne Brisbane Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Adelaide Sydney Melbourne
loc_empire Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia
loc_localadmin Melbourne Sydney Sydney Melbourne Melbourne Melbourne Brisbane City Sydney Geelong Geelong Craigieburn Sydney Brisbane City Sydney Brisbane City Melbourne Brisbane City Melbourne Melbourne Sydney Mascot Melbourne Melbourne Melbourne None ... Melbourne Perth Sydney Sydney Melbourne Melbourne Sydney Melbourne Melbourne Melbourne None Brisbane City Melbourne Melbourne Melbourne Brisbane City Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Adelaide Sydney Melbourne
loc_locality Melbourne Sydney Sydney Melbourne Melbourne Melbourne Brisbane City Sydney Geelong Geelong Craigieburn Sydney Brisbane City Sydney Brisbane City Melbourne Brisbane City Melbourne Melbourne Sydney Mascot Melbourne Melbourne Melbourne Manukau City ... Melbourne Perth Sydney Sydney Melbourne Melbourne Sydney Melbourne Melbourne Melbourne None Brisbane City Melbourne Melbourne Melbourne Brisbane City Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Adelaide Sydney Melbourne
loc_macrocounty Melbourne Sydney Sydney Melbourne Melbourne Melbourne Brisbane Sydney Geelong Geelong Melbourne Sydney Brisbane Sydney Brisbane Melbourne Brisbane Melbourne Melbourne Sydney Sydney Melbourne Melbourne Melbourne None ... Melbourne Perth Sydney Sydney Melbourne Melbourne Sydney Melbourne Melbourne Melbourne None Brisbane Melbourne Melbourne Melbourne Brisbane Melbourne Melbourne Melbourne Melbourne Melbourne Melbourne Adelaide Sydney Melbourne
loc_region Victoria New South Wales New South Wales Victoria Victoria Victoria Queensland New South Wales Victoria Victoria Victoria New South Wales Queensland New South Wales Queensland Victoria Queensland Victoria Victoria New South Wales New South Wales Victoria Victoria Victoria Auckland Region ... Victoria Western Australia New South Wales New South Wales Victoria Victoria New South Wales Victoria Victoria Victoria Australian Capital Territory Queensland Victoria Victoria Victoria Queensland Victoria Victoria Victoria Victoria Victoria Victoria South Australia New South Wales Victoria
processor kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest launchrecruitment launchrecruitment launchrecruitment kaggle_promptcloud_latest launchrecruitment launchrecruitment launchrecruitment seek launchrecruitment seek kaggle_promptcloud_listings davidsonwp launchrecruitment davidsonwp launchrecruitment launchrecruitment kaggle_promptcloud_latest seek kaggle_promptcloud_listings kaggle_promptcloud_latest kaggle_promptcloud_latest kaggle_promptcloud_listings ... launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment launchrecruitment
source seekau seekau seekau_2019q3 CC-MAIN-2020-40 CC-MAIN-2020-29 CC-MAIN-2020-16 seekau_2019q3 CC-MAIN-2020-29 CC-MAIN-2020-40 CC-MAIN-2020-24 CC-MAIN-2020-50 CC-MAIN-2020-16 CC-MAIN-2020-50 seekau CC-MAIN-2020-45 CC-MAIN-2020-16 CC-MAIN-2020-34 CC-MAIN-2020-29 CC-MAIN-2020-40 seekau_2019q3 CC-MAIN-2020-50 seekau seekau_2019q3 seekau_2019q3 seekau ... CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-29 CC-MAIN-2020-16
loc_neighbourhood Melbourne CBD None None None None None None None None None None None None Sydney South None None None None None None None None None None None ... None None None None None None None None None None None None None None None None None None None None None None None None None
annual False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
weekly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
daily True True True True True True True True True True True True True True True True True True True True True True True True True ... True True True True True True True True True True True True True True True True True True True True True True True True True
hourly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
salary_low 60 50 45 35 35 35 30.19 30 30 30 30 30 29.3 28.06 28 28 28 28 28 27.33 27.21 26 25.07 25 20 ... 700 772.72 760 300 460 800 450 732 525 600 400 500 800 800 700 450 700 700 500 500 700 500 500 680 330
salary_hi 70 60 NaN 38 38 38 NaN NaN 32 32 32 NaN NaN NaN NaN 30 NaN 30 30 28.33 28.03 27 NaN 30 21 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
salary_valid True True True True True True True True True True True True True True True True True True True True True True True True True ... True True True True True True True True True True True True True True True True True True True True True True True True True
pct_salary_range 0.153846 0.181818 NaN 0.0821918 0.0821918 0.0821918 NaN NaN 0.0645161 0.0645161 0.0645161 NaN NaN NaN NaN 0.0689655 NaN 0.0689655 0.0689655 0.0359324 0.0296886 0.0377358 NaN 0.181818 0.0487805 ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

30 rows × 295 columns

SALARY_DAILY_MAX_AUD = 3000
SALARY_DAILY_MIN_AUD = 100
df.loc[df.daily & (df.salary_low < SALARY_DAILY_MIN_AUD), "salary_valid"] = False
df.loc[df.daily & (df.salary_low > SALARY_DAILY_MAX_AUD), "salary_valid"] = False
%time sns.displot(df[df.salary_valid & df.daily], x="salary_low", kde=True, log_scale=True)
CPU times: user 374 ms, sys: 69.6 ms, total: 444 ms
Wall time: 343 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bc41a92b0>

Hourly

%time sns.displot(df[df.hourly], x="salary_low", kde=True, log_scale=True)
CPU times: user 954 ms, sys: 60.7 ms, total: 1.01 s
Wall time: 897 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bc9ef1190>

Bad parsing and bad data

df[df.hourly & (df.salary_low > 250)].sort_values("salary_low").T
5238 8787 70468 212 9041 9107 51798 30332 30199 27985 24474 24053 19691 69134 26038 53100 53139 19659 65741 40904 70924
title Strategic Innovation Manager - National Initiatives and Performance Strategic Innovation Manager - National Initiatives and Performance PERSONAL CARE ASSISTANT Senior Business Implementation Consultant Business Implementation Consultant Senior Business Implementation Consultant Children's Services Officer - Room Leader Retail Assistants Wanted - Sales & Promotions! Hospitality Workers - Promotion People Wanted! Customer Service And Marketing Consultants Wanted! Immediate Starts Available! Campaign Managers Wanted! New Summer Sales Campaigns About To Begin! Retail Assistants Wanted - Promotion Sales! Financial Counsellor (Integrated Services Project) Spray Painter- Kitchens Mid-Level Finished Artist Radiographers (Shift) - Medical Imaging Department, Cairns Radiographers (Shift) - Medical Imaging Department, Cairns Community Lawyer (Integrated Services Project) Leading Hand F45 Head Coach / Trainer Senior Contract Administrator
description About the Role\nThe main purpose of this role is to manage the implementation of the Catalyst Lab Innovation Program which aims to support the ide... About the Role\nThe main purpose of this role is to manage the implementation of the Catalyst Lab Innovation Program which aims to support the ide... Our client is a major insurance organisation that is well recognized in the industry. They provide innovative, competitive and flexible solutions ... Our client is a major insurance organisation that is well recognized in the industry. They provide innovative, competitive and flexible solutions ... Our client is a major insurance organisation that is well recognized in the industry. They provide innovative, competitive and flexible solutions ... Full Time Scone The Role: Council is seeking an energetic and enthusiastic individual to undertake the above position.  The successful candidate w... Our client, HQ Direct are looking for individuals who have huge personalities to employ their skills to the fast paced and highly social face to f... Our client, HQ Direct are looking for individuals who have huge personalities to employ their skills to the fast paced and highly social face to f... Wow Recruitment is on the hunt for social and bubbly guys and girls to join our client’s team. HQ Direct are launching some brand-new promotional ... POP Advertising is looking for the next wave of campaign managers and sales agents to kickstart our new summer campaigns. We are looking for indiv... Our client, HQ Direct are looking for individuals who have huge personalities to employ their skills to the fast paced and highly social face to f... About the role\n18 hours per week – 12 month fixed term, based in Fitzroy, Victoria\nSocial Security Rights Victoria and the Financial and Consume... Spray Painter Required. Our family run property services business, based on the North Side of Brisbane is currently looking for a experienced 2 Pa... At the Y, we believe in the power of inspired young people. A community not-for-profit organisation with 17 million participations annually across... About the role\n30.4 hours per week – 12 month fixed term, based in Fitzroy, Victoria\nSocial Security Rights Victoria and the Financial and Consu... JOIN SYDNEY’S PREMIER F45 STUDIO!\nApply for this role at www.bit.ly/F45job\nDo you get freakin' excited and pride yourself on providing fun, fres...
uri https://www.davidsonwp.com/job/100562133239422/strategic-innovation-manager-national-initiatives-and-performance-1/ https://www.davidsonwp.com/job/100562133239422/strategic-innovation-manager-national-initiatives-and-performance/ https://www.seek.com.au/job/37565380 https://www.davidsonwp.com/job/100562133256145/senior-business-implementation-consultant-1/ https://www.davidsonwp.com/job/100562133253698/business-implementation-consultant/ https://www.davidsonwp.com/job/100562133256145/senior-business-implementation-consultant-1/ https://www.seek.com.au/job/36025488 https://www.seek.com.au/job/40047761 https://www.seek.com.au/job/39944385 https://www.seek.com.au/job/39835797 https://www.seek.com.au/job/40101847 https://www.seek.com.au/job/40201201 https://probonoaustralia.com.au/jobs/2019/11/financial-counsellor-integrated-services-project/ https://www.seek.com.au/job/36166736 https://www.seek.com.au/job/40071743 https://www.seek.com.au/job/37116531 https://www.seek.com.au/job/37116530 https://probonoaustralia.com.au/jobs/2019/11/community-lawyer-integrated-services-project/ https://www.seek.com.au/job/37209437 https://www.seek.com.au/job/50749266?type=promoted https://www.seek.com.au/job/37565417
view_date 2020-09-18 15:51:42+00:00 2020-10-19 05:08:00+00:00 2018-10-26 04:23:32 2020-05-27 20:05:51+00:00 2020-10-19 05:03:28+00:00 2020-10-22 04:58:01+00:00 2018-04-20 04:32:01 2019-09-28 08:41:44 2019-09-15 09:15:28 2019-09-01 07:04:43 2019-10-05 11:57:46 2019-10-19 07:56:47 2020-07-13 21:58:47+00:00 2018-05-09 04:42:46 2019-10-02 09:35:09 2018-09-02 00:36:35 2018-09-02 00:38:14 2020-07-13 21:35:19+00:00 2018-09-13 01:53:15 2020-10-30 20:01:37+00:00 2018-10-26 04:06:21
org Davidson Davidson Upper Hunter Shire Council Davidson Davidson Davidson Upper Hunter Shire Council Wow Recruitment Wow Recruitment Wow Recruitment Wow Recruitment Wow Recruitment Social Security Rights Victoria Regen Resurfacing PTY LTD YMCA Victoria Cairns & Hinterland Hospital and Health Service Cairns & Hinterland Hospital and Health Service Social Security Rights Victoria Design & Build F45 Training Artarmon Hays Construction
salary_raw $500 per day, Benefits: 7 hour day, 35 hour week with State Government. $500 per day, Benefits: 7 hour day, 35 hour week with State Government. $781.40 - $830.50 per 38 hour week $800 - $1000 per hour $800 - $1000 per hour $800 - $1000 per hour $972.10 - $1088.80 per 38 hour week Hourly rate + Super + Bonuses OTE $1000 - $1800 Hourly rate + Super + Bonuses OTE $1000 - $1800 Hourly rate + Super + Bonuses OTE $1000 - $1800 $24.37/hour + Super + Bonuses OTE $1000 - $1800 PW Hourly rate + Super + Bonuses OTE $1000 - $1800 $36,000-$38,500 (for 18 hour week) $50,000 - $54,999 plus super + Vehicle & Mobile Ph $62,936 - $70,682 per hour + super $64287 - $97438 p.h. $64287 - $97438 p.h. $67,000-$70,000 for 30.4 hour week $80 - $100k or hourly rate Competitive hourly rate plus commission (OTE 90k) $130000.00 - $150000.00 p.h. + +Super
salary_min 500 500 781.4 800 800 800 972.1 1000 1000 1000 1000 1000 36000 50000 62936 64287 64287 67000 80000 90000 130000
salary_max NaN NaN 830.5 1000 1000 1000 1088.8 1800 1800 1800 1800 1800 38500 54999 70682 97438 97438 70000 100000 NaN 150000
salary_hours 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
location_raw Parramatta, AU Parramatta, AU Newcastle, Maitland & Hunter, AU Melbourne, AU Melbourne, AU Melbourne, AU Newcastle, Maitland & Hunter, AU Melbourne, Victoria, Australia Melbourne, Victoria, Australia Melbourne, Victoria, Australia Sydney, New South Wales, Australia Melbourne, Victoria, Australia Melbourne(Fitzroy) Brisbane, CBD & Inner Suburbs, AU Melbourne, Victoria, Australia Cairns & Far North, AU Cairns & Far North, AU Melbourne(Fitzroy) Melbourne, CBD & Inner Suburbs, AU lanecovenorth, Sydney, New South Wales, Australia Newcastle, Maitland & Hunter, AU
loc_id 1.0205e+08 1.0205e+08 4.04539e+08 1.01933e+08 1.01933e+08 1.01933e+08 4.04539e+08 1.01933e+08 1.01933e+08 1.01933e+08 1.01932e+08 1.01933e+08 1.01933e+08 8.57823e+07 1.01933e+08 1.02079e+08 1.02079e+08 1.01933e+08 8.57823e+07 1.01932e+08 4.04539e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania
loc_country Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia New Zealand New Zealand Australia Australia Australia Australia
loc_county Parramatta Parramatta Greater Bendigo Melbourne Melbourne Melbourne Greater Bendigo Melbourne Melbourne Melbourne Sydney Melbourne Yarra Melbourne Melbourne Far North District Far North District Yarra Melbourne Sydney Greater Bendigo
loc_empire Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None None Australia Australia Australia Australia
loc_localadmin None None Hunter Melbourne Melbourne Melbourne Hunter Melbourne Melbourne Melbourne Sydney Melbourne Fitzroy Melbourne Melbourne None None Fitzroy Melbourne Sydney Hunter
loc_locality None None None Melbourne Melbourne Melbourne None Melbourne Melbourne Melbourne Sydney Melbourne Fitzroy Melbourne Melbourne None None Fitzroy Melbourne Sydney None
loc_macrocounty Sydney Sydney None Melbourne Melbourne Melbourne None Melbourne Melbourne Melbourne Sydney Melbourne Melbourne Melbourne Melbourne None None Melbourne Melbourne Sydney None
loc_region New South Wales New South Wales Victoria Victoria Victoria Victoria Victoria Victoria Victoria Victoria New South Wales Victoria Victoria Victoria Victoria Northland Region Northland Region Victoria Victoria New South Wales Victoria
processor davidsonwp davidsonwp kaggle_promptcloud_listings davidsonwp davidsonwp davidsonwp kaggle_promptcloud_listings kaggle_promptcloud_latest kaggle_promptcloud_latest kaggle_promptcloud_latest kaggle_promptcloud_latest kaggle_promptcloud_latest probono kaggle_promptcloud_listings kaggle_promptcloud_latest kaggle_promptcloud_listings kaggle_promptcloud_listings probono kaggle_promptcloud_listings seek kaggle_promptcloud_listings
source CC-MAIN-2020-40 CC-MAIN-2020-45 seekau CC-MAIN-2020-24 CC-MAIN-2020-45 CC-MAIN-2020-45 seekau seekau_2019q3 seekau_2019q3 seekau_2019q3 seekau_2019q3 seekau_2019q3 CC-MAIN-2020-29 seekau seekau_2019q3 seekau seekau CC-MAIN-2020-29 seekau CC-MAIN-2020-45 seekau
loc_neighbourhood None None None None None None None None None None None None None Melbourne CBD None None None None Melbourne CBD None None
annual False False False False False False False False False False False False False False False False False False False False False
weekly False False False False False False False False False False False False False False False False False False False False False
daily False False False False False False False False False False False False False False False False False False False False False
hourly True True True True True True True True True True True True True True True True True True True True True
salary_low 500 500 781.4 800 800 800 972.1 1000 1000 1000 1000 1000 36000 50000 62936 64287 64287 67000 80000 90000 130000
salary_hi NaN NaN 830.5 1000 1000 1000 1088.8 1800 1800 1800 1800 1800 38500 54999 70682 97438 97438 70000 100000 NaN 150000
salary_valid True True True True True True True True True True True True True True True True True True True True True
pct_salary_range NaN NaN 0.0609219 0.222222 0.222222 0.222222 0.113251 0.571429 0.571429 0.571429 0.571429 0.571429 0.0671141 0.09522 0.115942 0.409968 0.409968 0.0437956 0.222222 NaN 0.142857
SALARY_HOURLY_MAX_AUD = 300
df.loc[df.hourly & (df.salary_low > SALARY_HOURLY_MAX_AUD), "salary_valid"] = False
%time sns.displot(df[df.hourly & df.salary_valid], x="salary_low", kde=True, log_scale=True)
CPU times: user 347 ms, sys: 49.8 ms, total: 397 ms
Wall time: 295 ms
<seaborn.axisgrid.FacetGrid at 0x7f2bc42190a0>

Inferring Period

It’s easy to separate annual from everything else

Weekly is pretty rare.

There’s some overlap between hourly and daily.

SALARY_MIN_AUD, SALARY_HOURLY_MAX_AUD, SALARY_MIN_AUD*2000, SALARY_HOURLY_MAX_AUD*2000
(15, 300, 30000, 600000)
SALARY_DAILY_MIN_AUD, SALARY_DAILY_MAX_AUD, SALARY_DAILY_MIN_AUD*250, SALARY_DAILY_MAX_AUD*250
(100, 3000, 25000, 750000)
SALARY_WEEKLY_MIN_AUD, SALARY_WEEKLY_MAX_AUD, SALARY_WEEKLY_MIN_AUD*50, SALARY_WEEKLY_MAX_AUD*50
(300, 5000, 15000, 250000)
SALARY_ANNUAL_MIN_AUD, SALARY_MAX_AUD
(20000, 500000)
df[df.salary_valid].groupby("salary_hours").agg(min=('salary_low', 'min'), max=('salary_low', 'max'), n=('salary_low', 'count'))
min max n
salary_hours
1.0 15.0 200.0 4390
8.0 100.0 2200.0 1945
40.0 300.0 3500.0 60
2000.0 20000.0 455245.0 5777
len(df[df.salary_low.between(100, 200) & df.salary_valid & (~df.hourly) & (~df.daily)])
17
ANNUAL_HOURS = 2000
WEEKLY_HOURS = 40
DAILY_HOURS = 8
HOURLY_HOURS = 1

salary_periods = {
    (SALARY_ANNUAL_MIN_AUD, SALARY_MAX_AUD): ANNUAL_HOURS,
    # Exclude as is quite rare
    #(SALARY_WEEKLY_MIN_AUD, SALARY_WEEKLY_MAX_AUD): WEEKLY_HOURS,
    (SALARY_DAILY_MIN_AUD, SALARY_DAILY_MAX_AUD): DAILY_HOURS,
    (SALARY_MIN_AUD, SALARY_HOURLY_MAX_AUD): HOURLY_HOURS,
}
def infer_salary_hours(salary):
    possible_periods = [(low, hi) for (low, hi) in salary_periods if low < salary < hi]
    if len(possible_periods) == 1:
        return salary_periods[possible_periods[0]]
    # Ambiguous or no match

Too high

infer_salary_hours(500_000)

Annual

infer_salary_hours(20_000)

Between annual and daily

infer_salary_hours(3_000)

Daily

infer_salary_hours(300)
8

Ambiguous: Could between hourly and daily

infer_salary_hours(200)

Hourly

infer_salary_hours(100)
1
df['inferred_salary_hours'] = np.nan
df.loc[df.salary_valid, 'inferred_salary_hours'] = df.salary_hours
df.loc[df.salary_valid & df.inferred_salary_hours.isna(), 'inferred_salary_hours'] = df.salary_min.apply(infer_salary_hours)
sum(~df.salary_hours.isna()), sum(~df.inferred_salary_hours.isna())
(13808, 21308)
df.inferred_salary_hours.value_counts().to_frame()
inferred_salary_hours
2000.0 14596
1.0 4606
8.0 2046
40.0 60
df['annual_salary'] = (df['salary_low'] * 2000/df['inferred_salary_hours']).astype('float64')
df[~df.annual_salary.isna()].sort_values('annual_salary').T
21604 63681 63662 63827 63833 63693 64234 64706 63502 64235 23120 21684 20546 31633 67952 63864 63333 33858 35338 30703 56429 30197 6373 66502 40723 ... 6672 6676 16060 14936 11470 36846 36849 56183 4418 6361 55340 63354 60979 10005 51930 57456 8061 2312 6733 10168 8222 66680 19652 54603 61876
title Sales Specialists | Earner Exceed $AUD 2000 weekly | Apply Now! 2019 Aboriginal and Torres Strait Islander Children’s Services Traineeship 2019 Children’s Services Traineeship for Person’s with a Disability 2019 Business Administration Traineeships 2019 Children’s Services Traineeship 2019 Children’s Services Traineeship 2019 Information Technology Traineeships for Person’s with a Disability 2019 Business Administration Traineeships for Person’s with a Disability 2019 Business Administration Traineeships for Person’s with a Disability 2019 Business Administration Traineeships IT Support Technician Traineeship Aupair required Mosman Full-time hours $400 per week Non Executive Director Apprentice Plumber Graphic Designer - Fixed Term Travel & Tourism Tutor Senior Hair Stylist Amazing Job 7 expired Amazing Job 7 expired Full-Time Legal Receptionist & Conveyancing Assistant Air-Conditioning Trade Assistant Junior Warehouse 2 x Java Developers Test Analyst Part Time Sports Coach ... Corporate Services Executive Strategy & Performance Executive Fire Safety SME - Transport Fire Safety SME - Transport Fire Safety SME - Transport Visiting Medical Officer - Anaesthetics or Intensive Care Unit Visiting Medical Officer - Anaesthetics or Intensive Care Unit Senior Staff Specialist or Staff Specialist (Psychiatrist) (Bundaberg) Chief Executive Officer - WorkSafe Victoria Chief Executive Officer - WorkSafe Victoria Senior Project Manager Senior Solutions Architect - Brand New Role - Up to $400K PKG Executive Director of Medical Services (Bundaberg) Health Service Chief Executive Receptionist Emergency Medicine Specialists, CMOs or Registrars Health Service Chief Executive Group Executive, Strategy, Planning & Transformation Group Executive, Strategy, Planning & Transformation Group Executive, Strategy, Planning & Transformation Group Executive, Strategy, Planning & Transformation GP SMO - Remote Reliever Co-opted Board member Career Medical Officer Locum SA Radiographer
description A great business opportunity, with UNLIMITED COMMISSIONS,UNCAPPED!\nIf you’ve got the skills and you’re ready to work with agrowing, dynamic compa... Xenontech is the Premier IT Support Company for NSW Schools. Xenontech is offering an exciting opportunity for any aspiring Desktop/Network Suppor... Mother’s help/ au pair required for two girls 2 and 4.\nFull-time hours required.\nCall or text Amy\n6981 + click to reveal\nREVEAL_DETAILS\n About the role\nWorkways Australia Ltd is seeking applications from suitably qualified people with a passion for making a positive social impact i... QBuild invites applications for plumbing apprenticeship positions in the following locations to commence in March 2020: Apprentice Plumber - Rockh... This Amazing Job will change your life.\nTe labores probatus vis, equidem offendit ius ex. Ea latine rationibus eos, at modus vocent ullamcorper m... This Amazing Job will change your life.\nTe labores probatus vis, equidem offendit ius ex. Ea latine rationibus eos, at modus vocent ullamcorper m... Applications are invited for the position of a full-time Legal Receptionist and Conveyancing Assistant. (Monday - Friday 8.15 am - 4.45 pm) Candi... About the business Contract coffee roasting business located in Clayton.  About the role Enthusiastic, friendly, reliable, trustworthy person w... About the Company\nJ oin a global company putting technology at their forefront! They’re looking to grow out they’re Brisbane team and give you th... Due to increased demands in our sporting and educational programs we are seeking up to three permanent-part time Sports Coach for 2021 (up to 20 h... ... Brisbane Catholic Education is committed to learning outcomes for over 72,000 young people in 141 Schools across the South East Queensland. Ingrai... Brisbane Catholic Education is committed to learning outcomes for over 72,000 young people in 141 Schools across south-east Queensland. Ingrained ... Fire Safety Engineering SME required to work on iconic rail / tunnelling projects in Sydney.\nScope of engagement:\nAct as an SME for all Fire Lif... Fire Safety Engineering SME required to work on iconic rail / tunnelling projects in Sydney.\nScope of engagement:\nAct as an SME for all Fire Lif... Fire Safety Engineering SME required to work on iconic rail / tunnelling projects in Sydney.\nScope of engagement:\nAct as an SME for all Fire Lif... Metro North Hospital and Health Service is seeking applications from Visiting Medical Officers for a range of positions in multiple locations acro... Metro North Hospital and Health Service is seeking applications from Visiting Medical Officers for a range of positions in multiple locations acro... High Profile Executive Opportunity\nGeelong Location – Up to a 5 Year Contract\n\nWorkSafe Victoria plays a critical role in the lives of all Vict... High Profile Executive Opportunity\nGeelong Location – Up to a 5 Year Contract\n\nWorkSafe Victoria plays a critical role in the lives of all Vict... This role is accountable for the delivery and management of large scale complex multiple projects within a program of work within clearly defined ... About the Company\nMetro South Health is Australia's first digital health service and the first in Australia to be recognised for excellence in pe... The Company Our client are a well-established organisation continuing to grow its book of business by providing interior styling services to the r... About the Company\nMetro South Health is Australia's first digital health service and the first in Australia to be recognised for excellence in pe... About the Company\nQueensland Rail owns and operates the regional and passenger rail network which provides public, passenger, tourism and freight... About the Company\nQueensland Rail owns and operates the regional and passenger rail network which provides public, passenger, tourism and freight... About the Company\nQueensland Rail owns and operates the regional and passenger rail network which provides public, passenger, tourism and freight... About the Company\nQueensland Rail owns and operates the regional and passenger rail network which provides public, passenger, tourism and freight... About the role\nBirchip Cropping Group (BCG) invites Expressions of Interest from individuals for appointment to the Board as a co-opted specialis... The Role: we are seeking an CMO GP/ED to work within this small regional hospital in South Australia from the May 2018 to December 2018 on a ongoi...
uri https://www.gumtree.com.au/s-ad/baulkham-hills/sales-representative-consultant/sales-specialists-earner-exceed-aud-2000-weekly-apply-now-/1244428014 https://www.seek.com.au/job/37437336 https://www.seek.com.au/job/37437344 https://www.seek.com.au/job/37437339 https://www.seek.com.au/job/37437330 https://www.seek.com.au/job/37437331 https://www.seek.com.au/job/37437327 https://www.seek.com.au/job/37437343 https://www.seek.com.au/job/37437342 https://www.seek.com.au/job/37437340 https://www.seek.com.au/job/39840663 https://www.gumtree.com.au/s-ad/mosman/other-jobs/aupair-required-mosman-full-time-hours-400-per-week/1244452123 https://probonoaustralia.com.au/jobs/2020/09/non-executive-director-34/ https://www.seek.com.au/job/40243255 https://www.seek.com.au/job/37599086 https://www.seek.co.nz/job/37440179 https://www.seek.com.au/job/36787285 https://jobs.launchrecruitment.com.au/job/amazing-job-7-expired/ https://jobs.launchrecruitment.com.au/job/amazing-job-7-expired/ https://www.seek.com.au/job/39889007 https://www.seek.com.au/job/37059460 https://www.seek.com.au/job/39943669 https://www.davidsonwp.com/job/100562133352287/2-x-java-developers/ https://www.seek.com.au/job/37212638 https://www.seek.com.au/job/50736893?type=standard ... https://www.davidsonwp.com/job/100562133369806/corporate-services-executive/ https://www.davidsonwp.com/job/100562133369810/strategy-and-performance-executive/ https://www.cgcrecruitment.com/job/fire-safety-engineer-transport/ https://www.cgcrecruitment.com/job/fire-safety-engineer-transport/ https://www.cgcrecruitment.com/job/fire-safety-engineer-transport/ https://www.seek.com.au/job/41361503?type=standard https://www.seek.com.au/job/41361504?type=standard https://www.seek.com.au/job/37060115 https://www.davidsonwp.com/job/100562133350088/chief-executive-officer-worksafe-victoria/ https://www.davidsonwp.com/job/100562133350088/chief-executive-officer-worksafe-victoria/ https://www.seek.com.au/job/36033456 https://www.seek.com.au/job/36788582 https://www.seek.com.au/job/36501041 https://www.davidsonwp.com/job/100562133358757/health-service-chief-executive/ https://www.seek.com.au/job/36027262 https://www.seek.com.au/job/36675014 https://www.davidsonwp.com/job/100562133358757/health-service-chief-executive/ https://www.davidsonwp.com/job/100562133376105/group-executive-strategy-planning-and-transformation/ https://www.davidsonwp.com/job/100562133376105/group-executive-strategy-planning-and-transformation/ https://www.davidsonwp.com/job/100562133377335/group-executive-strategy-planning-and-transformation-1/ https://www.davidsonwp.com/job/100562133377335/group-executive-strategy-planning-and-transformation-1/ https://www.seek.com.au/job/37209374 https://probonoaustralia.com.au/jobs/2019/11/co-opted-board-member/ https://www.seek.com.au/job/36032526 https://www.seek.com.au/job/36500843
view_date 2020-04-08 03:30:21+00:00 2018-10-11 01:14:20 2018-10-11 01:18:23 2018-10-11 01:15:54 2018-10-11 01:08:39 2018-10-11 01:11:00 2018-10-11 01:17:36 2018-10-11 01:18:50 2018-10-11 01:17:15 2018-10-11 01:08:55 2019-09-02 07:11:03 2020-04-10 03:55:43+00:00 2020-09-26 11:22:30+00:00 2019-10-25 09:40:41 2018-10-31 01:50:48 2018-10-11 01:48:31 2018-07-24 09:18:48 2020-07-03 02:26:44+00:00 2020-04-05 21:13:10+00:00 2019-09-07 10:11:37 2018-08-27 00:59:16 2019-09-14 09:18:47 2020-09-30 10:43:31+00:00 2018-09-13 01:10:18 2020-10-30 20:36:11+00:00 ... 2020-09-19 19:13:22+00:00 2020-10-01 12:08:55+00:00 2020-09-27 16:09:16+00:00 2020-03-28 15:43:03+00:00 2020-06-01 21:47:27+00:00 2020-05-27 06:35:33+00:00 2020-05-27 05:34:00+00:00 2018-08-27 00:40:47 2020-04-06 05:07:08+00:00 2020-09-25 03:53:28+00:00 2018-04-20 02:36:11 2018-07-24 09:06:27 2018-06-19 01:34:07 2020-10-28 20:03:13+00:00 2018-04-20 03:59:49 2018-07-11 04:03:13 2020-08-10 19:58:59+00:00 2020-07-06 01:46:19+00:00 2020-09-30 05:23:39+00:00 2020-10-29 18:08:02+00:00 2020-08-06 18:22:08+00:00 2018-09-13 01:47:17 2020-07-13 21:37:49+00:00 2018-04-20 02:48:38 2018-06-19 01:29:23
org None Penrith City Council Penrith City Council Penrith City Council Penrith City Council Penrith City Council Penrith City Council Penrith City Council Penrith City Council Penrith City Council Xenontech Pty Ltd None Workways Australia Ltd Department of Housing & Public Works Shoalhaven City Council International Travel College of New Zealand White Gold Boutique Launch Recruitment Launch Recruitment Dean Kath Kohler Solicitors Freeflow Air conditioning Services Bennetti Coffee Roasters Davidson Talent – Winner ‘Seek Large Recruitment Agency of the Year’ 3 consecutive years! Central Coast Sports College ... Davidson Davidson CGC Recruitment CGC Recruitment CGC Recruitment Metro North Hospital & Health Service Metro North Hospital & Health Service Wide Bay Hospital and Health Service Davidson Davidson The Recruitment Company TRS - IT & Communications Wide Bay Hospital and Health Service Davidson Kennedy Reid Sugarman Australia Davidson Davidson Davidson Davidson Davidson Global Medics Australia Birchip Cropping Group Cornerstone Medical Recruitment Metro South Health
salary_raw $300-$2000 weekly $323.10 – $657.30 per week $323.10 – $657.30 per week $323.10 – $657.30 per week $323.10 – $657.30 per week $323.10 – $657.30 per week $323.10 – $657.30 per week $323.10 – $657.30 per week $323.10 – $657.30 per week $323.10 – $657.30 per week $332.80 - $677.00 per week (plus Super) $400 per week plus full board $20,000 pa $22,076 - $40,472 per annum $22,601.67 to $25,428.71 p.a. plus 9.5% Super $25,000 - $39,999 $25,000 - $39,999 £25,000 - £30,000 + car &amp; benefits £25,000 - £30,000 + car &amp; benefits $25,000 - $39,999 $25,000 - $39,999 $25,000 - $34,999 $500 - $800 per week $100.00 per day $25,000 - $39,999 ... $340000 - $380000 per annum $340000 - $380000 per annum $1400 - $1500 + p/d - negotiable $1400 - $1500 + p/d - negotiable $1400 - $1500 + p/d - negotiable $176 - $209 per hour $176 - $209 per hour Remuneration value up to $392,483 p.a. $400000 - $500000 per annum $400000 - $500000 per annum $200 - $245 p.h + super DOE up to $400k pkg Remuneration value up to $436,955 p.a. $450000 - $500000 per annum $45,0000 + Superannuation $1800 - $2800 p.d. + accom + travel $450000 - $500000 per annum $455245 per annum $455245 per annum $455245 per annum $455245 per annum $2k p.d. $2000 $2,200 Per Day $2464.10 &#8211; $3621.70 per fortnight
salary_min 300 323.1 323.1 323.1 323.1 323.1 323.1 323.1 323.1 323.1 332.8 400 20000 22076 22601.7 25000 25000 25000 25000 25000 25000 25000 500 100 25000 ... 340000 340000 1400 1400 1400 176 176 392483 400000 400000 200 400000 436955 450000 450000 1800 450000 455245 455245 455245 455245 2000 2000 2200 2464.1
salary_max 2000 NaN NaN NaN NaN NaN NaN NaN NaN NaN 677 NaN NaN 40472 25428.7 39999 39999 30000 30000 39999 39999 34999 800 NaN 39999 ... 380000 380000 1500 1500 1500 209 209 NaN 500000 500000 245 NaN NaN 500000 NaN 2800 500000 NaN NaN NaN NaN NaN NaN NaN NaN
salary_hours 40 40 40 40 40 40 40 40 40 40 40 40 2000 2000 2000 NaN NaN NaN NaN NaN NaN NaN 40 8 NaN ... 2000 2000 8 8 8 1 1 2000 2000 2000 1 NaN 2000 2000 NaN 8 2000 2000 2000 2000 2000 8 NaN 8 NaN
location_raw 303 Windsor Rd, Baulkham Hills NSW 2153 Sydney, Parramatta & Western Suburbs, AU Sydney, Parramatta & Western Suburbs, AU Sydney, Parramatta & Western Suburbs, AU Sydney, Parramatta & Western Suburbs, AU Sydney, Parramatta & Western Suburbs, AU Sydney, Parramatta & Western Suburbs, AU Sydney, Parramatta & Western Suburbs, AU Sydney, Parramatta & Western Suburbs, AU Sydney, Parramatta & Western Suburbs, AU Sydney, New South Wales, Australia Mosman NSW Brisbane, Canberra, NSW Regional, QLD Regional, VIC Regional Brisbane, Queensland, Australia Wollongong, Illawarra & South Coast, AU Canterbury, Christchurch, NZ Brisbane, CBD & Inner Suburbs, AU Manhester, AU Manhester, AU Toowoomba & Darling Downs, Queensland, Australia Perth, Northern Suburbs & Joondalup, AU Melbourne, Victoria, Australia Brisbane, AU ACT, AU kariong, Gosford & Central Coast, New South Wales, Australia ... Brisbane, AU Brisbane, AU Sydney, AU Sydney, AU Sydney, AU , Brisbane, Queensland, Australia , Brisbane, Queensland, Australia Bundaberg & Wide Bay Burnett, AU Geelong, AU Geelong, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Sydney, AU Bundaberg & Wide Bay Burnett, AU Brisbane, AU Sydney, CBD, Inner West & Eastern Suburbs, AU Perth, AU Brisbane, AU Brisbane, AU Brisbane, AU Brisbane, AU Brisbane, AU Western QLD, AU VIC Regional(Birchip) Adelaide, AU Brisbane, AU
loc_id 1.0193e+08 1.01932e+08 1.01932e+08 1.01932e+08 1.01932e+08 1.01932e+08 1.01932e+08 1.01932e+08 1.01932e+08 1.01932e+08 1.01932e+08 1.02049e+08 NaN 1.01934e+08 1.01932e+08 1.01915e+08 8.57823e+07 8.56328e+07 8.56328e+07 1.02049e+08 1.01938e+08 1.01933e+08 1.01934e+08 8.56815e+07 1.0193e+08 ... 1.01934e+08 1.01934e+08 1.01932e+08 1.01932e+08 1.01932e+08 1.01934e+08 1.01934e+08 1.02049e+08 1.01933e+08 1.01933e+08 8.57823e+07 1.01932e+08 1.02049e+08 1.01934e+08 8.57823e+07 1.01938e+08 1.01934e+08 1.01934e+08 1.01934e+08 1.01934e+08 1.01934e+08 8.56815e+07 NaN 1.01936e+08 1.01934e+08
loc_continent Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania None Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania ... Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania Oceania None Oceania Oceania
loc_country Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None Australia Australia New Zealand Australia Australia Australia Australia Australia Australia Australia Australia Australia ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None Australia Australia
loc_county The Hills Shire Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Mosman None Brisbane Wollongong Christchurch City Melbourne None None Toowoomba Perth Melbourne Brisbane None Gosford ... Brisbane Brisbane Sydney Sydney Sydney Brisbane Brisbane Bundaberg Greater Geelong Greater Geelong Melbourne Sydney Bundaberg Brisbane Melbourne Perth Brisbane Brisbane Brisbane Brisbane Brisbane None None Adelaide Brisbane
loc_empire Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None Australia Australia None Australia Australia Australia Australia Australia Australia Australia Australia Australia ... Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia Australia None Australia Australia
loc_localadmin Baulkham Hills Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney None None Brisbane City Wollongong None Melbourne None None None Perth Melbourne Brisbane City None Gosford ... Brisbane City Brisbane City Sydney Sydney Sydney Brisbane City Brisbane City None Geelong Geelong Melbourne Sydney None Brisbane City Melbourne Perth Brisbane City Brisbane City Brisbane City Brisbane City Brisbane City None None Adelaide Brisbane City
loc_locality Baulkham Hills Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney None None Brisbane City Wollongong Christchurch Melbourne None None None Perth Melbourne Brisbane City None Gosford ... Brisbane City Brisbane City Sydney Sydney Sydney Brisbane City Brisbane City None Geelong Geelong Melbourne Sydney None Brisbane City Melbourne Perth Brisbane City Brisbane City Brisbane City Brisbane City Brisbane City None None Adelaide Brisbane City
loc_macrocounty Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney None Brisbane None None Melbourne None None None Perth Melbourne Brisbane None None ... Brisbane Brisbane Sydney Sydney Sydney Brisbane Brisbane None Geelong Geelong Melbourne Sydney None Brisbane Melbourne Perth Brisbane Brisbane Brisbane Brisbane Brisbane None None Adelaide Brisbane
loc_region New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales None Queensland New South Wales Canterbury Region Victoria None None Queensland Western Australia Victoria Queensland Australian Capital Territory New South Wales ... Queensland Queensland New South Wales New South Wales New South Wales Queensland Queensland Queensland Victoria Victoria Victoria New South Wales Queensland Queensland Victoria Western Australia Queensland Queensland Queensland Queensland Queensland Queensland None South Australia Queensland
processor gumtree kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_latest gumtree probono kaggle_promptcloud_latest kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings launchrecruitment launchrecruitment kaggle_promptcloud_latest kaggle_promptcloud_listings kaggle_promptcloud_latest davidsonwp kaggle_promptcloud_listings seek ... davidsonwp davidsonwp cgcrecruitment cgcrecruitment cgcrecruitment seek seek kaggle_promptcloud_listings davidsonwp davidsonwp kaggle_promptcloud_listings kaggle_promptcloud_listings kaggle_promptcloud_listings davidsonwp kaggle_promptcloud_listings kaggle_promptcloud_listings davidsonwp davidsonwp davidsonwp davidsonwp davidsonwp kaggle_promptcloud_listings probono kaggle_promptcloud_listings kaggle_promptcloud_listings
source CC-MAIN-2020-16 seekau seekau seekau seekau seekau seekau seekau seekau seekau seekau_2019q3 CC-MAIN-2020-16 CC-MAIN-2020-40 seekau_2019q3 seekau seekau seekau CC-MAIN-2020-29 CC-MAIN-2020-16 seekau_2019q3 seekau seekau_2019q3 CC-MAIN-2020-40 seekau CC-MAIN-2020-45 ... CC-MAIN-2020-40 CC-MAIN-2020-40 CC-MAIN-2020-40 CC-MAIN-2020-16 CC-MAIN-2020-24 CC-MAIN-2020-24 CC-MAIN-2020-24 seekau CC-MAIN-2020-16 CC-MAIN-2020-40 seekau seekau seekau CC-MAIN-2020-45 seekau seekau CC-MAIN-2020-34 CC-MAIN-2020-29 CC-MAIN-2020-40 CC-MAIN-2020-45 CC-MAIN-2020-34 seekau CC-MAIN-2020-29 seekau seekau
loc_neighbourhood None None None None None None None None None None None None None None None None Melbourne CBD None None None None None None None None ... None None NaN NaN NaN None None None None None Melbourne CBD None None None Melbourne CBD None None None None None None None None None None
annual False False False False False False False False False False False False True True True False False False False False False False False False False ... True True False False False False False True True True False False True True False False True True True True True False False False False
weekly True True True True True True True True True True True True False False False False False False False False False False True False False ... False False False False False False False False False False False False False False False False False False False False False False False False False
daily False False False False False False False False False False False False False False False False False False False False False False False True False ... False False True True True False False False False False False False False False False True False False False False False True False True False
hourly False False False False False False False False False False False False False False False False False False False False False False False False False ... False False False False False True True False False False True False False False False False False False False False False False False False False
salary_low 300 323.1 323.1 323.1 323.1 323.1 323.1 323.1 323.1 323.1 332.8 400 20000 22076 22601.7 25000 25000 25000 25000 25000 25000 25000 500 100 25000 ... 340000 340000 1400 1400 1400 176 176 392483 400000 400000 200 400000 436955 450000 450000 1800 450000 455245 455245 455245 455245 2000 2000 2200 2464.1
salary_hi 2000 NaN NaN NaN NaN NaN NaN NaN NaN NaN 677 NaN NaN 40472 25428.7 39999 39999 30000 30000 39999 39999 34999 800 NaN 39999 ... 380000 380000 1500 1500 1500 209 209 NaN 500000 500000 245 NaN NaN 500000 NaN 2800 500000 NaN NaN NaN NaN NaN NaN NaN NaN
salary_valid True True True True True True True True True True True True True True True True True True True True True True True True True ... True True True True True True True True True True True True True True True True True True True True True True True True True
pct_salary_range 1.47826 NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.681719 NaN NaN 0.58822 0.117719 0.461515 0.461515 0.181818 0.181818 0.461515 0.461515 0.333306 0.461538 NaN 0.461515 ... 0.111111 0.111111 0.0689655 0.0689655 0.0689655 0.171429 0.171429 NaN 0.222222 0.222222 0.202247 NaN NaN 0.105263 NaN 0.434783 0.105263 NaN NaN NaN NaN NaN NaN NaN NaN
inferred_salary_hours 40 40 40 40 40 40 40 40 40 40 40 40 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 40 8 2000 ... 2000 2000 8 8 8 1 1 2000 2000 2000 1 2000 2000 2000 2000 8 2000 2000 2000 2000 2000 8 8 8 8
annual_salary 15000 16155 16155 16155 16155 16155 16155 16155 16155 16155 16640 20000 20000 22076 22601.7 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 ... 340000 340000 350000 350000 350000 352000 352000 392483 400000 400000 400000 400000 436955 450000 450000 450000 450000 455245 455245 455245 455245 500000 500000 550000 616025

32 rows × 21308 columns

sns.displot(df, x='annual_salary', log_scale=True)
<seaborn.axisgrid.FacetGrid at 0x7f2bc44d9310>