在给定一个数据帧的情况下，如何检查列的值是否按递增顺序排列，并且没有任何丢失的数字？

import pandas as pd

# 创建一个示例数据帧
data = {
    'A': [1, 2, 3, 5, 6],
    'B': [10, 20, 30, 40, 50]
}
df = pd.DataFrame(data)

# 检查列'A'是否按递增顺序排列且没有丢失的数字
def check_increasing_and_no_missing_values(df, column):
    # 检查是否按递增顺序排列
    is_increasing = df[column].is_monotonic_increasing
    
    # 检查是否有丢失的数字
    expected_values = pd.Series(range(df[column].min(), df[column].max() + 1))
    missing_values = expected_values[~expected_values.isin(df[column])]
    
    return is_increasing, missing_values

# 检查列'A'
is_increasing_A, missing_values_A = check_increasing_and_no_missing_values(df, 'A')
print(f"Column 'A' is increasing: {is_increasing_A}")
print(f"Missing values in column 'A': {missing_values_A}")

# 检查列'B'
is_increasing_B, missing_values_B = check_increasing_and_no_missing_values(df, 'B')
print(f"Column 'B' is increasing: {is_increasing_B}")
print(f"Missing values in column 'B': {missing_values_B}")