如何在使用google cloud v2转换数据框列后替换字典

from google.cloud import bigquery
import pandas as pd

client = bigquery.Client(project='your-project-id')

def replace_column_with_dict(df, column_name, dictionary):
    df[column_name] = df[column_name].map(dictionary)
    return df

# 加载数据框
query = """
SELECT *
FROM `your-project-id.your-dataset.your-table`
"""
df = client.query(query).to_dataframe()

# 准备要替换的字典
dictionary = {
    'value1': 'replacement1',
    'value2': 'replacement2',
    'value3': 'replacement3'
}

df = replace_column_with_dict(df, 'column_name', dictionary)

# 将修改后的数据框保存到BigQuery表中
table_ref = client.dataset('your-dataset').table('your-table')
client.load_table_from_dataframe(df, table_ref).result()