Python 将列表转换为熊猫数据框

Convert list into a pandas data frame

提问by Kay

I am trying to convert my output into a pandas data frame and I am struggling. I have this list

我正在尝试将我的输出转换为 Pandas 数据框，但我正在挣扎。我有这个清单

my_list = [1,2,3,4,5,6,7,8,9]

I want to create a pandas data frame that would have 3 columns and three rows. I try using

我想创建一个有 3 列和 3 行的 Pandas 数据框。我尝试使用

df = pd.DataFrame(my_list, columns = list("abc"))

but it doesn't seem to be working for me. Any help would be appreciated.

但它似乎对我不起作用。任何帮助，将不胜感激。

回答by jezrael

You need convert listto numpy arrayand then reshape:

您需要转换list为numpy array然后reshape：

df = pd.DataFrame(np.array(my_list).reshape(3,3), columns = list("abc"))
print (df)
   a  b  c
0  1  2  3
1  4  5  6
2  7  8  9