基于其他列python的特定值的每列的唯一值计数

import pandas as pd

data = {'Column1': [1, 2, 3, 4, 5],
        'Column2': ['A', 'B', 'A', 'B', 'C'],
        'Column3': ['X', 'Y', 'X', 'Y', 'Z']}
df = pd.DataFrame(data)

def count_unique_values(df, target_column, other_columns):
    unique_values = df[other_columns].drop_duplicates()
    result = {}
    for index, row in unique_values.iterrows():
        filter_condition = ''
        for column, value in row.iteritems():
            filter_condition += f"{column} == '{value}' and "
        filter_condition = filter_condition[:-5]
        filtered_df = df.query(filter_condition)
        unique_count = filtered_df[target_column].nunique()
        result[row.to_string(index=False)] = unique_count
    return result

target_column = 'Column1'
other_columns = ['Column2', 'Column3']
result = count_unique_values(df, target_column, other_columns)
print(result)

{'A X': 1, 'B Y': 1, 'C Z': 1}