unpack list in pandas dataframe python

Question

I have a dataframe having column a,b,c. And column c has data in list datatype. So I want to unwind/unpacked/explode the each element of list as new row.

so, our input is like below.

   a  b             c
0  1  2          [1, {'k': 1}, 2]
1  3  2          [{'m': 2}, {'k': 2}, 2]

And our output should be like below.

   a  b          c
0  1  2          1
1  1  2          {'k': 1}
2  1  2          2
3  3  2          {'m': 2}
4  3  2          {'k': 2}
5  3  2          2

Sp, as you can in output, each element of list is in row and other column a and b values are repeating corresponding to list element

@YakymPirozhenko , we can create new column acc. to size of list in column c — Tarun Khaneja, Jun 04 '18 at 09:53
Something like this: `df.set_index(['a','b'])['c'].apply(pd.Series).stack().reset_index().drop('level_2', 1).rename(columns={0:'c'})` — Anton vBR, Jun 04 '18 at 09:56
@TarunKhaneja A dupe is a common word used for a question that is a duplicate of something. I identified this question as already answered and made a search. — Anton vBR, Jun 04 '18 at 09:57

score 1 · Answer 1 · answered Dec 05 '21 at 00:23

1

The solutions from the questions linked in the comments are outdated. These days you can just:

df.explode('c')

answered Dec 05 '21 at 00:23

rudolfovic

3,163
2
14
38

unpack list in pandas dataframe python

1 Answers1