填充pandas数据帧中缺少的行值作为上一行和下一行的平均值

import pandas as pd

df = pd.DataFrame({'A': [1, 2, None, 4, None, 6], 'B': [None, 2, 3, None, 5, None]})

missing_rows = df.isna().any(axis=1)

df.fillna((df.shift() + df.shift(-1)) / 2, inplace=True)

import pandas as pd

# 创建数据帧
df = pd.DataFrame({'A': [1, 2, None, 4, None, 6], 'B': [None, 2, 3, None, 5, None]})

# 找出缺失值的行
missing_rows = df.isna().any(axis=1)

# 填充缺失值
df.fillna((df.shift() + df.shift(-1)) / 2, inplace=True)

print(df)