diff options
| author | Christian Cleberg <hello@cleberg.net> | 2024-07-02 22:20:18 -0500 |
|---|---|---|
| committer | Christian Cleberg <hello@cleberg.net> | 2024-07-02 22:20:18 -0500 |
| commit | c8a1ade50065aa5790088994b3c42d2cc67b845a (patch) | |
| tree | cfb80d62ac884ca8ea9faa795cc62fe71d5373e2 | |
| parent | 62bb6961fcd3111e0f074c016d2fdd864f3d0b38 (diff) | |
| download | cleberg.net-c8a1ade50065aa5790088994b3c42d2cc67b845a.tar.gz cleberg.net-c8a1ade50065aa5790088994b3c42d2cc67b845a.tar.bz2 cleberg.net-c8a1ade50065aa5790088994b3c42d2cc67b845a.zip | |
udpate salary visualization
| -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 |