pip install pandas brightway2

import pandas as pd
import bw2data as bd

def match_and_export(excel_file_path, db_name, match_column_name, match_condition):
    # 讀取Excel文件
    df = pd.read_excel(excel_file_path)
    # 獲取匹配列的數據
    match_values = df[match_column_name].tolist()

    # 加載Brightway2數據庫
    bd.projects.set_current('your_project_name')  # 設置當前項目名稱，需要替換為實際的項目名稱
    db = bd.Database(db_name)

    # 用于存儲匹配成功的數據
    matched_data = []

    # 遍歷Excel中的匹配值
    for value in match_values:
        # 根據匹配條件進行匹配
        for activity in db:
            if match_condition(activity, value):
                # 這里可以根據需要抓取更多的信息
                data = {
                    'excel_value': value,
                    'activity_name': activity['name'],
                    'activity_code': activity['code']
                }
                matched_data.append(data)

    # 將匹配成功的數據轉換為DataFrame
    result_df = pd.DataFrame(matched_data)

    # 導出為新的Excel文件
    result_df.to_excel('matched_data.xlsx', index=False)
    print("匹配數據已導出到 matched_data.xlsx")

# 示例匹配條件函數
def example_match_condition(activity, value):
    # 這里假設根據活動名稱進行匹配，你可以根據實際需求修改
    return activity['name'] == value

# 示例調用
if __name__ == "__main__":
    excel_file_path = 'your_excel_file.xlsx'  # 替換為實際的Excel文件路徑
    db_name = 'your_database_name'  # 替換為實際的數據庫名稱
    match_column_name = 'your_column_name'  # 替換為實際的匹配列名稱

    match_and_export(excel_file_path, db_name, match_column_name, example_match_condition)