Python list of lists to pandas DataFrame

Question

I have this sample code below that turns a Python list of lists into a pandas DataFrame, but I need to DataFrame orientation to be inversed, any idea how to achieve this?

import numpy as np
import pandas as pd
from IPython.display import display, HTML

i = np.zeros(10)
i.fill(40)

j = np.zeros(10)
j.fill(60)

df = pd.DataFrame([i, j])

display(df)

The output of this is a structure like this:

	0	1	2	3	4	5	6	7	8	9
0	40	40	40	40	40	40	40	40	40	40
1	60	60	60	60	60	60	60	60	60	60

But, what I want is to get a structure like this, how can I turn a list of lists into such format?

0	1
40	60
40	60
40	60
40	60
40	60
40	60
40	60
40	60
40	60

How about : df.T

Mahdi F.
– Mahdi F.

2022-08-31 14:22:28 +00:00
Commented Aug 31, 2022 at 14:22 — Mahdi F.
– Mahdi F., Commented Aug 31, 2022 at 14:22

Ynjxsjmh · Accepted Answer · 2022-08-31 14:25:30Z

2

Let's try to create a two columns dataframe directly

df = pd.DataFrame(zip(i, j))
# or specify the column header
df = pd.DataFrame(zip(i, j), columns=['a', 'b'])

print(df)

      0     1
0  40.0  60.0
1  40.0  60.0
2  40.0  60.0
3  40.0  60.0
4  40.0  60.0
5  40.0  60.0
6  40.0  60.0
7  40.0  60.0
8  40.0  60.0
9  40.0  60.0

answered Aug 31, 2022 at 14:25

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges

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

Comments

eshirvana · Accepted Answer · 2022-08-31 14:35:01Z

2

just transpose the dataframe :

df = df.T

or prepare your df the way you want at the first place:

df = pd.DataFrame({0: i, 1: j})

output:

>>
      0     1
0  40.0  60.0
1  40.0  60.0
2  40.0  60.0
3  40.0  60.0
4  40.0  60.0
5  40.0  60.0
6  40.0  60.0
7  40.0  60.0
8  40.0  60.0
9  40.0  60.0

edited Aug 31, 2022 at 14:35

answered Aug 31, 2022 at 14:22

eshirvana

24.7k3 gold badges28 silver badges43 bronze badges

Comments

alphamu · Accepted Answer · 2022-08-31 14:24:02Z

1

Suggest trying

df.transpose()

for the purpose.

answered Aug 31, 2022 at 14:24

alphamu

3831 gold badge3 silver badges9 bronze badges

Comments

Mahdi F. · Accepted Answer · 2022-08-31 14:26:14Z

0

If you want to correct this before creating your dataframe, you can use numpy.column_stack and then create the dataframe.

inp_arr = np.column_stack((i,j))
df = pd.DataFrame(inp_arr)

answered Aug 31, 2022 at 14:26

Mahdi F.

24.1k5 gold badges25 silver badges32 bronze badges

Collectives™ on Stack Overflow

Python list of lists to pandas DataFrame

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related