Update appp.py

app.py

@@ -26,7 +26,7 @@ st.set_page_config(page_title="Rapport FDV",
 df = pd.read_excel(
     io="suivi.xlsx",
     engine="openpyxl",
-    sheet_name=["AGADIR","QUALI NV"],
+    sheet_name=["TANGER","QUALI NV"],
     #skiprows=8,
     usecols="A:AC",
     #nrows=163,
@@ -42,13 +42,13 @@ if uploaded_file is not None:
     df = pd.read_excel(uploaded_file,
                                 
                                 engine="openpyxl",
-                                sheet_name=["AGADIR","QUALI NV"],     
+                                sheet_name=["TANGER","QUALI NV"],     
                                 usecols="A:AC",
                                 nrows=163,
 
     )
     
-quantitatif_df=df.get("AGADIR")
+quantitatif_df=df.get("TANGER")
 qualitatif_df=df.get("QUALI NV")
 
     # st.write(bytes_data)
@@ -86,7 +86,7 @@ df_select_qualitatif = qualitatif_df.query(
 
 if show_all_fdv:
     df_selection_quantitatif = quantitatif_df.query(
-        "Famille==@famille & Vendeur!='SOUATI NOUREDDINE'  & Vendeur!='CDZ AGADIR GROS' &Vendeur!='CHAKIB ELFIL' & Vendeur!='CDZ AGADIR DET2'& Vendeur!='VIDE' ", 
+        "Famille==@famille & Vendeur!='KHLALIL HMER LGROUN'  & Vendeur!='CDZ TANGER GROS' &Vendeur!='BAALAKI YOUSSEF' & Vendeur!='CDZ TANGER DET2'& Vendeur!='VIDE' ", 
     )
 df_selection_quantitatif = df_selection_quantitatif.astype({
     "REAL": "int",