Pandas Multiple Columns explode [duplicate]

Question

I have a dataframe with one row like below:

col1	col2	col3
[a,b,c]	[i,ii,iii]	[1,2,3]

Now I need to transfer it into -

I have tried to use explode. But select clause allowed only one explode function which is very logical.

Can anyone help me with this?

There's an existing question about this for Pandas. But I'm not sure what you mean by "select clause" and I see comments about Pyspark. If the linked question isn't helpful, make a minimal reproducible example and LMK. For specifics, see How to make good reproducible pandas examples. — wjandrea
– wjandrea, Commented Jul 4, 2024 at 2:18
I was looking for a solution with pyspark actually. But solved it with pandas. Someone asked me to change the question. So did it. I am still looking for the solution with pyspark. — Saddaf Afrin Khan
– Saddaf Afrin Khan, Commented Jul 4, 2024 at 8:05

SomeDude · Accepted Answer · 2024-07-03 20:43:20Z

1

You can do this:

pd.DataFrame(dict(zip(df.columns, df.to_numpy().flatten())))

I think it is more efficient than apply/explode.

answered Jul 3, 2024 at 20:34

SomeDude

14.3k5 gold badges26 silver badges49 bronze badges

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

Comments

PaulS · Accepted Answer · 2024-07-03 21:52:34Z

1

Another possible solution (assuming that, by row, all lists have the same length):

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

Output:

  col1 col2 col3
0    a    i    1
0    b   ii    2
0    c  iii    3

answered Jul 3, 2024 at 21:37

PaulS

27.1k3 gold badges18 silver badges40 bronze badges

L Tyrone · Accepted Answer · 2024-07-04 02:05:15Z

0

So the solution is:

df.apply(pd.Series.explode)

L Tyrone

8,36123 gold badges34 silver badges47 bronze badges

answered Jul 3, 2024 at 18:34

Saddaf Afrin Khan

211 silver badge11 bronze badges