Source code for pm4py.algo.merging.case_relations.variants.pandas

'''
    PM4Py – A Process Mining Library for Python
Copyright (C) 2024 Process Intelligence Solutions UG (haftungsbeschränkt)

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU Affero General Public License as
published by the Free Software Foundation, either version 3 of the
License, or any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU Affero General Public License for more details.

You should have received a copy of the GNU Affero General Public License
along with this program.  If not, see this software project's root or
visit <https://www.gnu.org/licenses/>.

Website: https://processintelligence.solutions
Contact: info@processintelligence.solutions
'''
import pandas as pd
from pm4py.util import exec_utils, constants, xes_constants, pandas_utils
from enum import Enum
from typing import Optional, Dict, Any


[docs] class Parameters(Enum): TIMESTAMP_KEY = constants.PARAMETER_CONSTANT_TIMESTAMP_KEY CASE_ID_KEY = constants.PARAMETER_CONSTANT_CASEID_KEY LEFT_SUFFIX = "left_suffix" RIGHT_SUFFIX = "right_suffix"
[docs] def apply( dataframe1: pd.DataFrame, dataframe2: pd.DataFrame, case_relations: pd.DataFrame, parameters: Optional[Dict[Any, Any]] = None, ) -> pd.DataFrame: """ Merges the two dataframes (dataframe1 and dataframe2), inserting the events of the second dataframe inside the cases of the first dataframe. This is done using a background knowledge provided in the case_relations dataframe, where the cases of the two dataframes are put in relations. E.g., if in dataframe1 and dataframe2 there are two case ID columns (case:concept:name), they are put in relations by case_relations having two columns case:concept:name_LEFT and case:concept:name_RIGHT Parameters ----------------- dataframe1 Reference dataframe (in which the events of the other dataframe are inserted) dataframe2 Second dataframe (to insert in the cases of the first) case_relations Case relations dataframe parameters Parameters of the algorithm, including: - Parameters.TIMESTAMP_KEY => the timestamp key to use (default: time:timestamp) - Parameters.CASE_ID_KEY => the case identifier to use (default: case:concept:name) - Parameters.LEFT_SUFFIX => the suffix to the case identifier column of the first dataframe - Parameters.RIGHT_SUFFIX => the suffix to the case identifier column of the second dataframe Returns ---------------- merged_dataframe Merged dataframe """ if parameters is None: parameters = {} timestamp_key = exec_utils.get_param_value( Parameters.TIMESTAMP_KEY, parameters, xes_constants.DEFAULT_TIMESTAMP_KEY, ) left_suffix = exec_utils.get_param_value( Parameters.LEFT_SUFFIX, parameters, "_LEFT" ) right_suffix = exec_utils.get_param_value( Parameters.RIGHT_SUFFIX, parameters, "_RIGHT" ) case_id_key = exec_utils.get_param_value( Parameters.CASE_ID_KEY, parameters, constants.CASE_CONCEPT_NAME ) dataframe2 = dataframe2.merge( case_relations, left_on=case_id_key, right_on=case_id_key + right_suffix, ) dataframe2[case_id_key] = dataframe2[case_id_key + left_suffix] dataframe1 = pandas_utils.concat([dataframe1, dataframe2]) dataframe1 = dataframe1.sort_values([case_id_key, timestamp_key]) return dataframe1