Pandas/BigQuery - TypeError：'str‘和'int’的实例之间不支持'<‘

import pandas as pd

df1 = pd.DataFrame({'A': [1, 2, 3]})
df2 = pd.DataFrame({'B': ['1', '2', '3']})

# 确保数据类型一致
df2['B'] = df2['B'].astype(int)

# 现在可以比较
result = df1['A'] < df2['B']

import pandas as pd

df = pd.DataFrame({'A': ['1', '2', 'three']})

# 将列'A'转换为数值类型，非数值字符将被转换为NaN
df['A'] = pd.to_numeric(df['A'], errors='coerce')

# 现在可以比较
result = df['A'] < 2

SELECT CAST(column_name AS INT64) AS int_column
FROM your_table

print(df1.dtypes)
print(df1.head())
print(df2.dtypes)
print(df2.head())