<jupyter_start><jupyter_text>The majority of the employees are earning between 40K and 50K<jupyter_code>titles = titles.loc[:,["emp_no","title"]]
salary = salary.loc[:,["emp_no","salary"]]
employee = employee.merge(salary, how="inner",on="emp_no")
employee = employee.merge(titles, how="inner",on="emp_no")
avg_salary = employee.loc[:,["salary","title"]].groupby(by="title").mean()
avg_salary = avg_salary.sort_values(by="salary",ascending=True)
avg_salary["salary"] = avg_salary["salary"].round(2)
#avg_salary["salary"] = avg_salary["salary"].map('${:,.2f}'.format)
#display(avg_salary)
ax = avg_salary.plot(kind="barh", title="AVG Salary (US) per Position", figsize=(8,8))
plt.xlabel("Salary")
plt.xlim(0,80000)
plt.ylabel("")
ax.get_legend().set_bbox_to_anchor((1, 0.1))

#Add data labels to graph
for i, value in enumerate(avg_salary["salary"]):
    ax.text(value + 500, i - 0.1, str("${:,.2f}".format(value)), color='grey', fontsize=10, fontweight='bold')
    
plt.show()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.2117296222664016, 'fraction_numerical': 0.02485089463220676, 'mean_word_length': 8.411214953271028, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '412366', 'license': 'ADSL', 'n_tokens_mistral': 417, 'n_tokens_neox': 397, 'n_words': 61, 'path': 'EmployeeSQL/Employee_Notebook.ipynb', 'repo_name': 'palolo02/sql-challenge', 'size': '1006'}