mobility.py
97ba8536edf0master

mobility.py
View Options

			import pandas as pd
			import json
			from functions import *

			def run_mobility_emission(input_file, emission_factor_path="C:/Users/cruz/Desktop/Projects/emission_factor.xlsx", factor_to_entity_path=r"C:\Users\cruz\Desktop\Projects\Mobilité\voyage\Mobility\scripts\factor_to_entity.json"):
			df = pd.read_excel(input_file, skiprows=6)
			factor_df = pd.read_excel(emission_factor_path)
			Metadata = {}
			Metadata["factor"] = {}
			with open(factor_to_entity_path, encoding="utf-8") as f:
			emission_join = json.load(f)

			CO2_col = "GWP [kg CO2eq]"

			Diesel_km = df[df["l'entraînement"]=="Diesel"]["KM conduit"].sum()
			Electro_km = df[df["l'entraînement"]=="Electro"]["KM conduit"].sum()
			Benzin_km = df[df["l'entraînement"]=="Benzin"]["KM conduit"].sum()
			Sonstige_km = df[df["l'entraînement"]=="Sonstige"]["KM conduit"].sum()

			df_emission = pd.Series(dtype=float)
			Diesel_factor = emission_factor(emission_join,factor_df, "Diesel")
			Electro_factor = emission_factor(emission_join,factor_df, "Electro")
			Benzin_factor = emission_factor(emission_join,factor_df, "Benzin")
			Sonstige_factor = emission_factor(emission_join,factor_df, "Sonstige")

			df_emission["Diesel"] = Diesel_km*Diesel_factor
			df_emission["Electro"] = Electro_km*Electro_factor
			df_emission["Benzin"] = Benzin_km*Benzin_factor
			df_emission["Sonstige"] = Sonstige_km*Sonstige_factor

			df_emission["Total_CO2"] = df_emission.sum()
			return df_emission["Total_CO2"].squeeze()