Combine multiple rows of lists into one big list using pandas

Question

I have a pandas data frame with multiple lists. Is there any way to combine all of the lists from all rows ( there could be 100 rows ) into one big list?

     fruits
0    [apple, banana, orange]
1    [berry, lemon]
2    [apple, tomato]
3    [lime, orange, banana]

Expected Output

[ 'apple', 'banana', 'orange', 'berry', 'lemon', 'apple', 'tomato', 'lime', 'orange', 'banana' ]

deadshot · Accepted Answer · 2022-06-11 10:10:26Z

7

use df.explode()

lst = df['fruits'].explode().to_list()

answered Jun 11, 2022 at 10:10

deadshot

9,0774 gold badges23 silver badges40 bronze badges

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

Comments

Mark Wang · Accepted Answer · 2022-06-11 10:10:38Z

4

Try:

df["fruits"].sum()

answered Jun 11, 2022 at 10:10

Mark Wang

2,7579 silver badges18 bronze badges

Comments

Hadi Rahjoo · Accepted Answer · 2022-06-11 10:08:40Z

2

Try extend :

result = []
for row in fruits :
    result.extend(row)

answered Jun 11, 2022 at 10:08

Hadi Rahjoo

1859 bronze badges

Collectives™ on Stack Overflow

Combine multiple rows of lists into one big list using pandas

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related