Convert list to pandas framework

Question

I am trying to convert my output to a pandas data frame, and I'm afraid. I have this list

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

I want to create a pandas data frame that will have 3 columns and three rows. I'm trying to use

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

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

Answer 1

You need to convert list to numpy array and then reshape :

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