Update Data.py

Data.py

@@ -1,5 +1,28 @@
 import streamlit as st
 import pandas as pd
+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 = "/data.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
 
 liste_vaccin = ['YELLOW FEVER', 'Penta', 'VPO', 'VPI', 'nOPV2', 'TD','Mosquirix', 'PCV13', 'MEASLES', 'BCG', 'Janssen', 'Rota', 'MENINGO', 'HPV', 'Mencevax']
 
@@ -48,7 +71,7 @@ def remove_one_columns_values(data):
 
 # importation et previsualisation des donnees
 if st.session_state['data_file'] is None:
-    data_file = "DATA.xlsx"
+    data_file = download_file_from_dropbox()
     st.session_state['data_file'] = data_file
 else:
     data_file = st.session_state['data_file']