删除双引号:
id,scores 1, [1,2,3,4] 2, [1,2] 3, [0,2,4]
并且您应该能够执行以下操作:
query = [[1, [1,2,3,4]], [2, [1,2]], [3, [0,2,4]]] df = pandas.DataFrame(query, columns=['id', 'scores']) print df