用不完整数据构建方差分析F表，Pandas报长度不匹配错误求解法

Let's start by unpacking why you're running into this error. Your DataFrame has 3 rows (Between, Total, Within), but some of your data arrays are shorter than 3 elements—like the F value, which is just a single number. Pandas can't automatically align a 1-element list to a 3-row column, hence the mismatch error.

Instead of filling empty spots with 0, here are two clean, Pythonic approaches to only populate existing data and leave the rest as empty values (pandas will use NaN for this, which is standard for missing statistical data):

Approach 1: Build Rows with Dictionaries (Most Readable) #

This method lets you explicitly define exactly which values belong to each row, and pandas will handle missing fields automatically:

import pandas as pd

# Assume these variables are already calculated from your ANOVA
ssBetween = 100
ssWithin = 200
ssTotal = 300
dfbetween = 2
dfwithin = 15
dftotal = 17
msBetween = 50
msWithin = 13.33
F_stat = 3.75

# Create a list of dictionaries, one per table row
anova_rows = [
    {
        'SS': ssBetween,
        'df': dfbetween,
        'MS': msBetween,
        'F': F_stat
    },
    {
        'SS': ssTotal,
        'df': dftotal
    },
    {
        'SS': ssWithin,
        'df': dfwithin,
        'MS': msWithin
    }
]

# Initialize DataFrame with your custom index
anova_table = pd.DataFrame(anova_rows, index=['Between', 'Total', 'Within'])
# Reorder columns to match your original layout
anova_table = anova_table[['SS', 'df', 'MS', 'F']]

This makes your code self-documenting—anyone reading it can immediately see which stats belong to which row, and empty cells stay as NaN instead of misleading 0s.

Approach 2: Use Series for Index-Aligned Assignment #

If you want to keep your original data structure, use pandas Series to map values directly to the rows they belong to:

import pandas as pd

# Your existing data structure (values pre-calculated)
data = [
    [ssBetween, ssWithin, ssTotal],
    [dfbetween, dfwithin, dftotal],
    [msBetween, msWithin],
    [F_stat]
]
index = ['Between', 'Total', 'Within']
columns = ['SS', 'df', 'MS', 'F']

anova_table = pd.DataFrame(index=index, columns=columns)

# Assign full-length columns normally
anova_table['SS'] = data[0]
anova_table['df'] = data[1]

# Use Series to assign values only to specific rows
anova_table['MS'] = pd.Series(data[2], index=['Between', 'Within'])
anova_table['F'] = pd.Series(data[3], index=['Between'])

Here, we leverage pandas' core feature of index alignment: the Series tells pandas exactly which rows to populate, and any rows not listed get left as NaN.

Both methods avoid manual value padding and follow pandas best practices for handling missing data in statistical tables.

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