Getting a list of arrays into a Pandas dataframe

Question

So I have a list of arrays in Python: [[0, 1, 0, 1], [1, 0, 1, 1], [0, 1, 1, 1]]. I would like to make this list of arrays into a Pandas dataframe, with each array being a row. Is there a way to do this quickly and easily in Python? I tried values = np.split(values, len(values)) to split the list of arrays into multiple arrays (well, I tried). And then tried to create a dataframe with df = pd.DataFrame(values). But this is where my error came from. I got a "must pass 2-d input" error message. Any idea what I'm doing wrong and how to fix it? Or an easier way to go about this? Thanks!

Did df = pd.DataFrame([[0, 1, 0, 1], [1, 0, 1, 1], [0, 1, 1, 1]]) not work? — cs95
– cs95, Commented Jul 25, 2017 at 19:07
Are you sure you have imported in correctly ? ie import pandas as pd? pd.DataFrame() should work — J.k
– J.k, Commented Jul 25, 2017 at 19:11

willeM_ Van Onsem · Accepted Answer · 2017-07-25 19:10:13Z

5

No need to do all that splitting, etc. If you have it as a list of lists that is two dimensional (meaning all rows have the same number of elements), you can simply pass it to the DataFrame constructor:

data = [[0, 1, 0, 1], [1, 0, 1, 1], [0, 1, 1, 1]]
pd.DataFrame(data)

generating the expected:

>>> pd.DataFrame(data)
   0  1  2  3
0  0  1  0  1
1  1  0  1  1
2  0  1  1  1

edited Jul 25, 2017 at 19:10

answered Jul 25, 2017 at 19:08

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting a list of arrays into a Pandas dataframe

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related