diff options
| -rw-r--r-- | .gitignore | 2 | ||||
| -rw-r--r-- | salary_visualization.py | 8 | ||||
| -rw-r--r-- | static/salary.csv | 11 |
3 files changed, 18 insertions, 3 deletions
@@ -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 |