Update app.py

app.py

@@ -228,4 +228,27 @@ chart = alt.Chart(df_long).mark_bar(
     height=400
 )
 
-st.altair_chart(chart, use_container_width=True)
+st.altair_chart(chart, use_container_width=True)
+
+
+
+
+
+#jacobs line chart salary over time
+dfot=pd.read_csv('State_Employee_Pay_hired_after_1.1.2011_20251210.csv')
+
+# Clean the salary column in case it has $ or commas
+dfot['YTD Gross'] = df['YTD Gross'].replace('[\$,]', '', regex=True).astype(float)
+
+# Compute average salary per agency division per year
+avg_salary = dfot.groupby(['Year', 'Agency Division'], as_index=False)['YTD Gross'].mean()
+
+# Create the line chart
+lines = alt.Chart(avg_salary).mark_line(point=True).encode(
+    x=alt.X('Year:O', title='Year'),            # treat Year as ordinal
+    y=alt.Y('YTD Gross:Q', title='Average Salary'),
+    color=alt.Color('Agency Division:N', title='Division'),
+    tooltip=['Year', 'Agency Division', 'YTD Gross']
+).interactive()  # enables zooming and panning
+
+lines