Python中range动态值使用及Excel空白填充N/A失效问题排查

你替换后填充失效的核心原因是：range(max_num_actors, variable)里的variable被赋值为max_num_actors，而Python的range(start, end)仅在start < end时才会生成可迭代对象，当两者相等时，这个循环直接跳过，根本不会执行填充逻辑。原代码里用固定值100，是因为100始终大于实际演员数量max_num_actors，所以循环能正常生成填充列。

你需要明确：动态值应该是最终要保留的总列组数量（每组对应Cast X/Char X/Role X三列），而不是等于现有演员数量。以下是两种实用的修正方式：

方式1：让函数接收目标列组数量参数 #

直接把需要填充到的列组总数作为参数传入，灵活控制填充范围：

def reshape_data(actor_data, target_groups):
    data_dict = {}
    max_num_actors = len(actor_data)

    # 填充已有演员的对应列
    for i in range(max_num_actors):
        col_num = i + 1
        data_dict[f'Cast {col_num}'] = [actor_data[i][0]]
        data_dict[f'Char {col_num}'] = [actor_data[i][1]]
        data_dict[f'Role {col_num}'] = [actor_data[i][2]]

    # 仅当目标数量大于现有演员数时，填充N/A列
    if target_groups > max_num_actors:
        for i in range(max_num_actors, target_groups):
            col_num = i + 1
            data_dict[f'Cast {col_num}'] = ['N/A']
            data_dict[f'Char {col_num}'] = ['N/A']
            data_dict[f'Role {col_num}'] = ['N/A']

    actors_df = pd.DataFrame(data_dict)
    return actors_df

# 调用示例：需要填充到120个列组
result_df = reshape_data(your_actor_data_list, 120)

方式2：基于参考表动态对齐列数 #

如果需要和其他Excel表的列数保持一致，可以通过参考表计算目标列组数量：

def reshape_data(actor_data, reference_df):
    data_dict = {}
    max_num_actors = len(actor_data)
    # 计算参考表的列组总数（每组3列）
    target_groups = len(reference_df.columns) // 3

    # 填充已有演员数据
    for i in range(max_num_actors):
        col_num = i + 1
        data_dict[f'Cast {col_num}'] = [actor_data[i][0]]
        data_dict[f'Char {col_num}'] = [actor_data[i][1]]
        data_dict[f'Role {col_num}'] = [actor_data[i][2]]

    # 填充N/A列以匹配参考表列数
    for i in range(max_num_actors, target_groups):
        col_num = i + 1
        data_dict[f'Cast {col_num}'] = ['N/A']
        data_dict[f'Char {col_num}'] = ['N/A']
        data_dict[f'Role {col_num}'] = ['N/A']

    actors_df = pd.DataFrame(data_dict)
    return actors_df

补充：如果需求是行空白填充 #

原描述提到"行存在空白时填充N/A"，但你的代码是在处理列。如果是行的空白填充，生成DataFrame后直接用fillna更高效：

actors_df = pd.DataFrame(data_dict).fillna('N/A')

内容的提问来源于stack exchange，提问作者Malandi