用不完整的数据来填充熊猫 DataFrame

Question

我正在为方差分析测试创建一个F表。我已经有了这样的价值观：

data = [[ssBetween,ssWithin,ssTotal],[dfbetween,dfwithin,dftotal], [msBetween,msWithin],[F]]
index = ['Between','Total','Within']
columns = ['SS','df','MS','F']
df = pd.DataFrame(index=index,columns=columns)
df['SS'] = data[0]
df['df'] = data[1]
df['MS'] = data[2]
df['F'] = data[3]

运行时出现以下错误：

ValueError:值的长度与索引的长度不匹配

我知道我可以用零或其他东西来填充缺失的值，但我想学习一种更为python的方法。我只想用我拥有的值填充这个表，并将表中其余的空格保留为空值。你知道吗

Answer 1

只需添加数据

pd.DataFrame(data = data,index = columns,columns = index).T
Out[149]: 
                SS         df         MS     F
Between  ssBetween  dfbetween  msBetween     F
Total     ssWithin   dfwithin   msWithin  None
Within     ssTotal    dftotal       None  None