'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]
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.
Solution 1:[1]
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
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | jezrael |