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.

2

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
3

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

David Miller

David Miller

Executive Financial & Market Analyst

David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.

Share this article
Twitter Facebook Pinterest