If using all scalar values, you must pass an index

Data[5].choice是对从excel表读出的dataframe某一列的切片，目标是用它们组成新的dataframe并按某一列排序，构建新dataframe的过程中遇到如下报错

data={'choice':Data[5].choice,
      'total':Data[5].total}
df=pd.DataFrame(data)

报错

Traceback (most recent call last):

  File "<ipython-input-19-1ffabaf30766>", line 3, in <module>
    df=pd.DataFrame(data)

  File "D:\program\anaconda\lib\site-packages\pandas\core\frame.py", line 529, in __init__
    mgr = init_dict(data, index, columns, dtype=dtype)

  File "D:\program\anaconda\lib\site-packages\pandas\core\internals\construction.py", line 287, in init_dict
    return arrays_to_mgr(arrays, data_names, index, columns, dtype=dtype)

  File "D:\program\anaconda\lib\site-packages\pandas\core\internals\construction.py", line 80, in arrays_to_mgr
    index = extract_index(arrays)

  File "D:\program\anaconda\lib\site-packages\pandas\core\internals\construction.py", line 391, in extract_index
    raise ValueError("If using all scalar values, you must pass an index")

ValueError: If using all scalar values, you must pass an index

解决：加中括号

data={'choice':[Data[5].choice],
      'total':[Data[5].total]}

df=pd.DataFrame(data)

这样做是不报错，但是我的Data[5].choice本身就是dataframe，这么转了后结果不太对，数据看着很奇怪

最后找到的解决方案是先把Data[5].choice转成list, 再重新构建dataframe

dc=Data[5].choice
dc=dc.values.tolist()
dt=Data[5].total
dt=dt.values.tolist()

data={'choice':dc,
      'total':dt}
df=pd.DataFrame(data)