Update Visualisation.py

Visualisation.py

@@ -7,6 +7,29 @@ from streamlit_echarts import st_echarts
 from pyecharts.charts import Bar
 from pyecharts.charts import Pie
 from pyecharts import options as opts
+import requests
+
+# Token d'accès Dropbox (⚠️ Ne pas partager publiquement)
+ACCESS_TOKEN = 'sl.u.AFp7cEspxNgudf1yznA8QFE1qoqwdF-v1FBippme8XCEEWAHMMfjWTjBCN0occiulnUeLYzharc5KgtdtrlLrycEbtDupW2nH4T6bsmdqwep5Gj_zsjH07kAyqYg0axSFivz4FBHYKXInRFNO4siRnHkY64wqHcACHHH8pCcz3ao0TAoZNS3DwrrwMYhFVFI3cmziEeEkhMEqRPuAbbncJfFmPoCKscz2J4M4HjgSLjoBCtfVf39Dqbg4cfmE46zFhyFHwAAv0nj-2iz7B3InVBRpeIHMLys9we42ojSO9WD3vDuhf806WCve_Hs-zDeIP-McJz5IkCvyVukhLRKsRyXdVOqotYD2ZKhb-tJho6Zqf_8H64p1hcaIZTXby8ENo-7qXJ3IMJiWBO2BlR1FmNr4LvPlYy4YBcfEAgL1BRNM5cgtMJ1MUkudTE1RO_8PVL0TqG2qw3JAXV3lUdT4AQC2b-8T3_y8myME7thuQGqMjt7IZZ-oBNmlw7NP6UBOF3RvM1w6ZPoa4fChpKECcfZQsBUKxuwtwjEcaKUlL_8_duK9RI5Y2FUXISc8VuFrz-_LabYdWWYzXdjb-SWolR32Frl6qnScmM9JkphGj4lT1kRaq35aCWce60EH8NIEtADoRTCkVqrh3IUZ8LaN40X6IO9rRzTJ5KVPiTSKvv8aBx8EzoRcUhLbswEh9VMKMhW5wFoWBYDaEi7H8i609frsvchZv002NfrmV80p9vgjCcMQX17Z100CcB68bcqiD8lOE9p97viVh_h_m2LcK5us9WJqqcDq-Jm57nwT42hnHjXGzunGC-i9opEp8IW7FbvrPjwnO8DE9Smm-ymA3fL2O4oE6TR9lTdYIXQhyrOOey9dyXEcXADC9S6ul_7gBmU9LqxTrnP0YVVEyr-hTwqFy5mBjtRu_VulVh6DJ7ERnmaI8Z7czBXPhs1Mr2meGhOA3Q-Bcmd9nsYue4AEKcMReeoL-w-LN53Zq43Gfe_u-TLES68KU-zALeHlFa1Fy2FstdSRZvc4dF65dUMAnpp4uK7M_4Kuwywz7wARLSdRdXThnJGUHMS2RfEKbnIFpWlQerQ90CQhcN_OF3_STUANBfo5yqJUvodNc2Z7hUH-CzKN-FtoEHyYcorIJpIepZYfwNo2OHtOOJzwIl6FrXaytiBsnkVmyaI7Zw7HMLuEQeyiSb8YVD0Ra_c-ASbZI_PKjrGDmTDOupyyXp7HtLJGaVKeX8FYiDHloZnN_oezg0USWQRIPprqu6KAm-gEDzRzPwKZO4m57gkOG-QOCFUHikNADib9sg5MVpkXeTZEqR8YubmkxGTX6ORF11INEato_LJIeGEFoHXGDc48GTLHyqVVjEieF9CzKRSqw2e2ym21f5jFNWGNgTiywdrjzml2doHqM-JzMfId7TrvTiV6hKqZ5asAOp0ng9yO__ZsK0D34DB56tFi027OeMX3POC69XVFKenI_4T7lYcyBlX'
+FILE_PATH = "/data2.xlsx"  # Chemin du fichier dans Dropbox
+
+# Fonction pour télécharger le fichier Dropbox
+def download_file_from_dropbox():
+    headers = {
+        "Authorization": f"Bearer {ACCESS_TOKEN}",
+        "Dropbox-API-Arg": f'{{"path": "{FILE_PATH}"}}'
+    }
+    url = "https://content.dropboxapi.com/2/files/download"
+    response = requests.post(url, headers=headers, stream=True)
+    
+    if response.status_code == 200:
+        with open("data.xlsx", "wb") as file:
+            for chunk in response.iter_content(chunk_size=8192):
+                file.write(chunk)
+        return "data.xlsx"
+    else:
+        st.error(f"Erreur de téléchargement Dropbox : {response.status_code}")
+        return None
 
 region_district = {
                 "ADAMAOUA" : ["Bankim","Banyo","Belel","Dang","Djohong","Meiganga","Ngaoundal","Ngaoundere Rural","Ngaoundere Urbain","Tibati","Tignere"],
@@ -153,7 +176,7 @@ else :
         expander_2 = st.expander("District silentieux ", expanded=True)
         with expander_2:
             if st.session_state['data_file_2'] is None:
-                data_file_2 = "data2.xlsx"
+                data_file_2 = download_file_from_dropbox()
                 st.session_state['data_file_2'] = data_file_2
             else:
                 data_file_2 = st.session_state['data_file_2']