create list nest from each column of pandas dataframe in python

Question

Here is simple of my dataframe

                  A    B     C    D    
Date                                                                         
1                 A1   B1    C1   D1 
2                 A2   B2    C2   D2 
3                 A3   B3    C3   D3 
4                 A4   B4    C4   D4

so i want to create nest list like [[A1,A2,A3,A4],[B1,B2,B3,B4],....]

i use command like mylist = dataframe.value.tolist()

but it return [[A1,B1,C1,D1],[A2,B2,C2,D2]] instead

so is there a way to get nest list as i want?

#i use python 3.8.5 and pandas dataframe import data from yfinance

halfer · Accepted Answer · 2020-12-30 12:14:02Z

2

Just transpose and then call values:

df.T.values.tolist()

[['A1', 'A2', 'A3', 'A4'],
 ['B1', 'B2', 'B3', 'B4'],
 ['C1', 'C2', 'C3', 'C4'],
 ['D1', 'D2', 'D3', 'D4']]

edited Dec 30, 2020 at 12:14

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Dec 30, 2020 at 9:23

Umar.H

23.1k7 gold badges50 silver badges94 bronze badges

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

Comments

AverageHomosapien · Accepted Answer · 2020-12-30 09:19:31Z

0

You could loop through columns and append

li = []
for col in dataframe:
    li.append(dataframe[col])

answered Dec 30, 2020 at 9:19

AverageHomosapien

7081 gold badge8 silver badges18 bronze badges

Comments

Alex Serra Marrugat · Accepted Answer · 2020-12-30 09:29:44Z

0

Here is a possible solutions for your problem:

l=[]
for e in df.columns:
    column = df[e].values.tolist()
    l.append(column)

The idea is taking every column as a list, and iterate it for all de columns.

answered Dec 30, 2020 at 9:29

Alex Serra Marrugat

2,0421 gold badge6 silver badges15 bronze badges

Collectives™ on Stack Overflow

create list nest from each column of pandas dataframe in python

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