capitalizing my words

app.py

@@ -72,6 +72,23 @@ st.text('Overall Future Edits: Figure out what to do with positions with 1 emplo
 st.text('Chart A Future Edits: Order bars by mean YTD Gross, Make all position titles readable, add title')
 
 
+
+
+#im just going to relaod the data frame in to clean up the text on the bottomo charts
+df_j = pd.read_csv('State_Employee_Pay.csv')
+
+df_jcopy = df_j.copy()
+df['Period Pay Rate'] = df['Period Pay Rate'].str.replace(",", "")
+df['YTD Gross'] = df['YTD Gross'].str.replace(",", "")
+df['Period Pay Rate'] = df['Period Pay Rate'].astype(int)
+df['YTD Gross'] = df['YTD Gross'].astype(int)
+df = df.dropna()
+df = df[df['YTD Gross']!= 0]
+# df['Agency'] = df['Agency'].str.lower()
+# df['Agency Division'] = df['Agency Division'].str.lower()
+# df['Employee Name'] = df['Employee Name'].str.lower()
+# df['Position Title'] = df['Position Title'].str.lower()
+
 import altair as alt
 import pandas as pd
 
@@ -119,11 +136,11 @@ select_bar = alt.selection_point(
 
 
 bar_chart = (
-    alt.Chart(df_small)
+    alt.Chart(df_jcopy)
     .mark_bar()
     .encode(
         y=alt.Y("Agency:N", sort="-x"),
-        x=alt.X("mean(YTD Gross):Q", title="Total Personale Expense"),  # <-- take the mean
+        x=alt.X("mean(YTD Gross):Q", title="Total Personale Expense"), 
         tooltip=[
             "Agency:N",
             alt.Tooltip("mean(YTD Gross):Q", title="Avg YTD Gross", format="$,.0f")
@@ -160,7 +177,7 @@ bar_chart = (
 
 
 strip = (
-    alt.Chart(df)
+    alt.Chart(df_jcopy)
     .mark_circle(size=60, opacity=0.6)
     .encode(
         x=alt.X("YTD Gross:Q", title="YTD Gross"),