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.

1 Answer

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