List to Pandas DataFrame - Python 3.x

Question

All,

I have a list output as below and i would like to convert it to a DF.

attrb = [['nn', 'xx', 'yy'], ['aa', 'vv', 'bb'], ['cc', 'gg', 'hh'], ['jj', 'kk', 'uu'], ['ee', 'ww', 'qq'], ['tt', 'mm', 'ss'], ['tt', 'gg', 'll'], ['aa', 'qq', 'tt']]

as below

0    1    2  3   4   5   6   7  
nn   aa   cc jj  ee  tt  tt  aa     
xx   vv   gg  kk  ww  mm gg  qq
yy   bb   hh  uu  qq  ss  ll  tt

i have tried the below but this makes it a 3x8 matrix

 cf = pd.DataFrame(attrb)
 print(cf)

pd.DataFrame(attrb).T?

user2285236
– user2285236

2017-01-16 17:35:16 +00:00
Commented Jan 16, 2017 at 17:35 — user2285236
– user2285236, Commented Jan 16, 2017 at 17:35

jezrael · Accepted Answer · 2017-01-16 17:35:20Z

2

The simpliest is transpose by T:

df = pd.DataFrame(attrb).T
print (df)
    0   1   2   3   4   5   6   7
0  nn  aa  cc  jj  ee  tt  tt  aa
1  xx  vv  gg  kk  ww  mm  gg  qq
2  yy  bb  hh  uu  qq  ss  ll  tt

answered Jan 16, 2017 at 17:35

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

List to Pandas DataFrame - Python 3.x

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related