How to convert dataframe columns with list of values into rows in Pandas DataFrame [duplicate]

Question

i have a dataframe like this"

   A       B        C
0  [X]     [1]  [aa, bb, cc]
1  [Y]     [2]  [xx, yy]

i want to change it to:

   A       B        C
0  X       1        aa
1  X       1        bb
2  X       1        cc
3  Y       2        xx
4  Y       2        yy

the explode method is the answer df.explode(df.columns.to_list()) — 99_m4n
– 99_m4n, Commented Aug 2, 2022 at 9:25

Sreeram TP · Accepted Answer · 2022-08-02 09:37:21Z

2

You can use explode method chained like this,

df.explode('A').explode('B').explode('C').reset_index(drop=True)


   A  B   C
0  X  1  aa
1  X  1  bb
2  X  1  cc
3  Y  2  xx
4  Y  2  yy

Alternatively, you can apply pd.Series.explode on the dataframe like this,

df.apply(pd.Series.explode).reset_index(drop=True)

In pandas 1.3+ you can use a list of columns to explode on,

So the code will look like,

df.explode(['A', 'B', 'C']).reset_index(drop=True)

answered Aug 2, 2022 at 9:30

Sreeram TP

12k8 gold badges65 silver badges121 bronze badges

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

1 Comment

Thanks Sreeram. Appreciate your quick help.

99_m4n · Accepted Answer · 2022-08-02 09:31:40Z

1

try:

df.explode(df.columns.to_list())

answered Aug 2, 2022 at 9:31

99_m4n

1,2655 silver badges18 bronze badges

ArrowRise · Accepted Answer · 2022-08-02 09:32:41Z

0

df.explode('C').explode(['A', 'B'])

answered Aug 2, 2022 at 9:32

ArrowRise

6483 silver badges8 bronze badges

David Molina · Accepted Answer · 2022-08-02 09:33:31Z

0

df.apply(pd.Series.explode).reset_index()

answered Aug 2, 2022 at 9:33

David Molina

1611 silver badge7 bronze badges