LaurentTRIPIED's picture
Pytorch V0.7
b9b1499
raw
history blame
2.29 kB
import streamlit as st
import pandas as pd
import requests
import folium
from streamlit_folium import folium_static
def get_data():
url = "https://opendata.bordeaux-metropole.fr/api/records/1.0/search/?dataset=met_etablissement_rse&q=&rows=100"
response = requests.get(url)
if response.status_code == 200:
data = response.json()
records = data["records"]
cleaned_data = []
for record in records:
fields = record["fields"]
geoloc = fields.get('geolocalisation')
if geoloc and len(geoloc) == 2:
# Ajoutez latitude et longitude directement aux champs pour faciliter l'accès
fields['latitude'] = geoloc[0]
fields['longitude'] = geoloc[1]
cleaned_data.append(fields)
return cleaned_data
else:
return []
def display_organisations_engagees(data):
st.markdown("## OPEN DATA RSE")
st.markdown("### Découvrez les organisations engagées RSE de la métropole de Bordeaux")
df = pd.DataFrame(data)
if not df.empty:
df = df.rename(columns={
"nom_courant_denomination": "Nom",
"commune": "Commune",
"libelle_section_naf": "Section NAF",
"tranche_effectif_entreprise": "Effectif",
"action_rse": "Action RSE"
})
df = df[["Nom", "Commune", "Section NAF", "Effectif", "Action RSE"]]
st.dataframe(df)
def display_map(data):
m = folium.Map(location=[44.837789, -0.57918], zoom_start=12)
for item in data:
if 'latitude' in item and 'longitude' in item:
folium.Marker(
[item['latitude'], item['longitude']],
icon=folium.Icon(color="green", icon="leaf"),
popup=item.get('nom_courant_denomination', 'Sans nom'),
).add_to(m)
folium_static(m)
def main():
st.sidebar.title("Navigation")
app_mode = st.sidebar.radio("Choisissez l'onglet", ["Organisations engagées", "Localisation des Entreprises"])
data = get_data()
if app_mode == "Organisations engagées":
display_organisations_engagees(data)
elif app_mode == "Localisation des Entreprises":
display_map(data)
if __name__ == "__main__":
main()