【解決方法】複数の操作からのデータフレームの変更された行を単一のリストに連結する

[ad_1]

データフレームの列の値をユーザーが選択した値に置き換える関数を作成しました。コードは複数の入力を受け入れます。

郵便配達員ペイロードによる入力の例-

Python

{"Filepath":"C:/Users/shootings.csv","Operand":[{"OperationName":"replaceColumnValue","Details":[{"ColumnName":"armed","ExistingValue":"gun","ReplacingValue":"Not knooooooooooooooooown"},{"ColumnName":"manner_of_death","ExistingValue":"shot","ReplacingValue":6666666666666666666666666666666666666666666666666666666666}]}]}

私が試したこと：

私のコード:

# Replacing the value of a column
def replace_fun(df, replace_inputs):
    try:
        col_name = replace_inputs["ColumnName"]
        col_value = str(replace_inputs["ExistingValue"])
        replace_value = str(replace_inputs["ReplacingValue"])
        
        # Check if column name exists in the dataframe
        if col_name not in df.columns:
            raise HTTPException(status_code=400, detail=f"Column {col_name} doesn't exist in the dataset")
        
        # Check if column value exists in the dataframe
        if col_value not in df[col_name].astype(str).values:
            raise HTTPException(status_code=400, detail=f"Column value {col_value} doesn't exist in the column {col_name}")
        
        modified_rows = df[col_name].astype(str) == col_value
        df.loc[modified_rows, col_name] = replace_value
        modified_data = df[modified_rows].to_dict(orient='records')
        
        for record in modified_data:
            for key, value in record.items():
                if isinstance(value, float):
                    record[key] = str(value)
        
        return modified_data
    
    except HTTPException as e:
        logging.error(f"An error occurred while performing the operation: {str(e)}")
        raise e
    

def cleaning_and_analysis(filepath, operation=None, raw_data=None):
csv_dataframe = pd.read_csv(filepath, encoding='utf-8')

result = {}