将列表转换为 pandas 数据框 [英] Convert list into a pandas data frame

问题描述

我正在尝试将输出转换为熊猫数据框，但我一直在努力.我有这个清单

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

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

我想创建一个具有3列和3行的pandas数据框.我尝试使用

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

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

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

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

推荐答案

您需要先将list转换为numpy array，然后再转换

You need convert list to numpy array and then 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

这篇关于将列表转换为 pandas 数据框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！