From c8a1ade50065aa5790088994b3c42d2cc67b845a Mon Sep 17 00:00:00 2001 From: Christian Cleberg Date: Tue, 2 Jul 2024 22:20:18 -0500 Subject: udpate salary visualization --- .gitignore | 2 +- salary_visualization.py | 8 ++++++-- static/salary.csv | 11 +++++++++++ 3 files changed, 18 insertions(+), 3 deletions(-) create mode 100644 static/salary.csv diff --git a/.gitignore b/.gitignore index e4fea4e..1b03a0f 100644 --- a/.gitignore +++ b/.gitignore @@ -1,3 +1,3 @@ .DS_Store .vscode -public \ No newline at end of file +public diff --git a/salary_visualization.py b/salary_visualization.py index 25d2134..99b29fc 100644 --- a/salary_visualization.py +++ b/salary_visualization.py @@ -1,4 +1,4 @@ -# %pip install plotly pandas +%pip install plotly pandas import pandas as pd import plotly.graph_objs as go @@ -6,7 +6,11 @@ import locale locale.setlocale(locale.LC_ALL, 'en_US.UTF-8') -df = pd.read_csv('~/Downloads/salary.csv') +df = pd.read_csv('~/git/cleberg.net/static/salary.csv') + +# Function to format salary as US currency +def format_currency(value): + return f"${value:,.2f}" # Reverse the order of the DataFrame df = df.iloc[::-1].reset_index(drop=True) diff --git a/static/salary.csv b/static/salary.csv new file mode 100644 index 0000000..12143d9 --- /dev/null +++ b/static/salary.csv @@ -0,0 +1,11 @@ +Title,Company,Location,Start,End,Salary +Senior Associate - Technology Assurance - Audit,KPMG,Omaha(NE),2023-10,2024-10,116700 +Senior Associate - Technology Assurance - Audit,KPMG,Omaha(NE),2022-06,2023-10,110000 +Senior Technology Risk Consultant,Ernst & Young,Des Moines(IA),2021-09,2022-06,89500 +Senior IT Auditor,Ameritas,Lincoln(NE),2021-05,2021-09,72000 +IT Auditor,Ameritas,Lincoln(NE),2020-04,2021-05,65000 +IS Auditor II,Nelnet,Lincoln(NE),2019-12,2020-04,58000 +IS Auditor I,Nelnet,Lincoln(NE),2019-06,2019-12,41600 +Internal Audit Intern,Ameritas,Lincoln(NE),2018-02,2019-06,33280 +Teaching Assistant,University of Nebraska,Lincoln(NE),2017-08,2018-05,14560 +Community Management Intern,Walgreens,Lincoln(NE),2017-06,2018-02,29120 -- cgit v1.2.3-70-g09d2