Pandas填充多列的mean和groupby中的for

import pandas as pd

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

# 计算每列的均值
mean_values = df.mean()

# 填充缺失值为均值
df_filled = df.fillna(mean_values)

print(df_filled)

     A    B    C
0  1.0  3.5  1.0
1  2.0  2.0  2.0
2  3.0  3.0  3.0
3  4.0  4.0  2.75
4  5.0  5.0  5.0

import pandas as pd

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

# 按Category列进行分组
grouped = df.groupby('Category')

# 遍历每个分组
for name, group in grouped:
    print(f"Category: {name}")
    print(group)
    print()

Category: A
  Category  Value
0        A      1
2        A      3
4        A      5

Category: B
  Category  Value
1        B      2
3        B      4