Return values from nested lists into PandasDataFrame

Question

I have a list containing 2 lists that looks as the follows:

[[0.0, 0.0, 0.0], [0.0, 0.0, 0.0]]

What I need to have at the end of the day, is to have 2 columns in a PandasDataFrame, the first column should hold the values found in the first list, and the second column should hold the values in the second list.

I want to iterate over each of these lists and return every single value in it into a separate column in PandasDataFrame. Where col0 in PandasDataFrame should hold the values in the first list, and the col1 in PandasDataFrame should hold values in the second list.

I am expecting output like this:

Is there a compact way to do so?

Thanks.

Can u add some sample input & expected ouput to get a precise solution — sushanth
– sushanth, Commented Jun 24, 2020 at 12:30

Sahaj Adlakha · Accepted Answer · 2020-06-24 12:52:46Z

1

A simple way to do this is by converting the list into a dictionary and then creating a Data Frame from that dictionary as explained below:

l =[[0.0, 0.0, 0.0], [0.0, 0.0, 0.0]]

# Creating a dictionary using dictionary comprehension
d = {'col'+str(i) : l[i] for i in range(len(l))}

df = pd.DataFrame(d)

answered Jun 24, 2020 at 12:52

Sahaj Adlakha

1563 bronze badges

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

Comments

BossaNova · Accepted Answer · 2020-06-24 12:52:26Z

0

As your lists are arranged rather for rows than columns, I would first build the data frame as is and then transpose it:

data = [[0, 0, 0, 0,], [1, 1, 1, 1,]]
columns = ['a', 'b', 'c', 'd']
df = pd.DataFrame(data, columns=columns)
df = df.transpose()

answered Jun 24, 2020 at 12:52

BossaNova

1,5281 gold badge14 silver badges17 bronze badges

Comments

Terry · Accepted Answer · 2020-06-24 13:16:30Z

0

one way to do this is using transpose:

df = pd.DataFrame(yourList).T

If you want to change the columns names you can add

df = df.add_prefix('col')

edited Jun 24, 2020 at 13:16

answered Jun 24, 2020 at 13:11

Terry

2,8212 gold badges16 silver badges30 bronze badges

Collectives™ on Stack Overflow

Return values from nested lists into PandasDataFrame

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related