在df上迭代以比较值

import pandas as pd

# 创建一个示例DataFrame
data = {
    'A': [1, 2, 3],
    'B': [4, 5, 6]
}
df = pd.DataFrame(data)

# 按行迭代并比较值
for index, row in df.iterrows():
    if row['A'] > row['B']:
        print(f"Row {index}: A > B")
    else:
        print(f"Row {index}: A <= B")

# 按列迭代并比较值
for column in df.columns:
    if df[column].dtype == 'int64':  # 检查列的数据类型
        print(f"Column {column} is of type int64")

# 使用向量化操作进行比较
result = df['A'] > df['B']
print(result)

# 使用apply()函数进行比较
def compare_rows(row):
    if row['A'] > row['B']:
        return "A > B"
    else:
        return "A <= B"

df['Comparison'] = df.apply(compare_rows, axis=1)
print(df)

# 确保数据类型一致
df['A'] = df['A'].astype(float)
df['B'] = df['B'].astype(float)