How to extract tuple values in pandas dataframe for use of matplotlib?
Here is how to unpack your tuples using zip
. The *
unpacks the argument list of each column.
df['A.x'], df['A.y'] = zip(*df.A)df['B.x'], df['B.y'] = zip(*df.B)>>> df.head() A B A.x A.y B.x B.ya (0, 6) (0, 0) 0 6 0 0a (1, 8) (1, 4) 1 8 1 4a (2, 8) (2, 5) 2 8 2 5a (3, 5) (3, 2) 3 5 3 2a (4, 2) (4, 4) 4 2 4 4
I think you can use indexing with str only:
df['a1'], df['a2'] = df['A'].str[0], df['A'].str[1]df['b1'], df['b2'] = df['B'].str[0], df['B'].str[1]print (df) A B a1 a2 b1 b2a (0, 5) (0, 1) 0 5 0 1a (1, 0) (1, 5) 1 0 1 5a (2, 3) (2, 9) 2 3 2 9a (3, 3) (3, 8) 3 3 3 8a (4, 7) (4, 9) 4 7 4 9a (5, 9) (5, 4) 5 9 5 4a (6, 3) (6, 3) 6 3 6 3a (7, 5) (7, 0) 7 5 7 0a (8, 2) (8, 3) 8 2 8 3a (9, 4) (9, 5) 9 4 9 5b (0, 7) (0, 0) 0 7 0 0b (1, 6) (1, 2) 1 6 1 2b (2, 8) (2, 3) 2 8 2 3b (3, 8) (3, 8) 3 8 3 8b (4, 10) (4, 1) 4 10 4 1b (5, 1) (5, 3) 5 1 5 3b (6, 6) (6, 3) 6 6 6 3b (7, 7) (7, 3) 7 7 7 3b (8, 7) (8, 7) 8 7 8 7b (9, 8) (9, 0) 9 8 9 0