Python Pandas Dataframe to Nested Tuples

Question

I have a simple Pandas data frame (df), structured like this:

   a   b   c   d
0  WW  XX  YY  ZZ
1  AA  BB  CC  DD
2  EE  FF  GG  HH
3       ...

I'd like to get this into a nested tuple structure inside of a list that looks like this:

[ ((WW, XX), YY, ZZ), ((AA, BB), CC, DD), ((EE, FF), GG, HH) ... ]

I'm just starting Python/Pandas, so I'm not really sure how to go about this.

this works for your dataset but is this really your dataset though as it's not dynamic: [((l[0], l[1]), l[2], l[3]) for l in df.values.tolist()] — EdChum
– EdChum, Commented Jan 9, 2015 at 14:30
Yeah, that's the format of the dataset at least. The actual values are larger than what I said here, but the format is the same. Thanks! — TheOriginalBMan
– TheOriginalBMan, Commented Jan 9, 2015 at 14:37

Mike · Accepted Answer · 2015-01-09 14:29:57Z

3

If you have a dataframe like this:

You can get the raw values into a list form like this:

>>> t = df.values.tolist()
>>> t
[[1, 2, 3], [4, 5, 6], [6, 7, 8]]

from there you can transform it into your tuples like so:

>>> tt= tuple(((a,b), c) for a,b,c in t)
>>> tt
(((1, 2), 3), ((4, 5), 6), ((6, 7), 8))

answered Jan 9, 2015 at 14:29

Mike

7,2634 gold badges31 silver badges51 bronze badges

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

1 Answer 1